Overview Tables Views Indexes Constraints Triggers Procedures Functions Packages Sequences Index

SH


Constraints

Constraint Type Table
CHAN_DESC_NN Check CHANNELS
CHAN_PK Primary Key CHANNELS
COSTS_PRODUCT_FK Referential COSTS
COSTS_PRODUCT_NN Check COSTS
COSTS_TIME_FK Referential COSTS
COSTS_TIME_NN Check COSTS
COSTS_UNIT_COST_NN Check COSTS
COSTS_UNIT_PRICE_NN Check COSTS
COUNTRY_COUNTRY_NAME_NN Check COUNTRIES
COUNTRY_PK Primary Key COUNTRIES
CUSTOMER_CITY_NN Check CUSTOMERS
CUSTOMER_COUNTRY_ID_NN Check CUSTOMERS
CUSTOMER_FNAME_NN Check CUSTOMERS
CUSTOMER_LNAME_NN Check CUSTOMERS
CUSTOMER_PCODE_NN Check CUSTOMERS
CUSTOMERS_COUNTRY_FK Referential CUSTOMERS
CUSTOMERS_PK Primary Key CUSTOMERS
CUSTOMER_ST_ADDR_NN Check CUSTOMERS
PRODUCTS_PK Primary Key PRODUCTS
PRODUCTS_PROD_CATD_NN Check PRODUCTS
PRODUCTS_PROD_CAT_NN Check PRODUCTS
PRODUCTS_PROD_DESC_NN Check PRODUCTS
PRODUCTS_PROD_LIST_PRICE_NN Check PRODUCTS
PRODUCTS_PROD_MIN_PRICE_NN Check PRODUCTS
PRODUCTS_PROD_NAME_NN Check PRODUCTS
PRODUCTS_PROD_STAT_NN Check PRODUCTS
PRODUCTS_PROD_SUBCATD_NN Check PRODUCTS
PRODUCTS_PROD_SUBCAT_NN Check PRODUCTS
PROMO_BEGIN_DATE_NN Check PROMOTIONS
PROMO_CAT_NN Check PROMOTIONS
PROMO_COST_NN Check PROMOTIONS
PROMO_END_DATE_NN Check PROMOTIONS
PROMO_NAME_NN Check PROMOTIONS
PROMO_PK Primary Key PROMOTIONS
PROMO_SUBCAT_NN Check PROMOTIONS
SALES_AMOUNT_NN Check SALES
SALES_CHANNEL_FK Referential SALES
SALES_CHANNEL_NN Check SALES
SALES_CUSTOMER_FK Referential SALES
SALES_CUSTOMER_NN Check SALES
SALES_PRODUCT_FK Referential SALES
SALES_PRODUCT_NN Check SALES
SALES_PROMO_FK Referential SALES
SALES_PROMO_NN Check SALES
SALES_QUANTITY_NN Check SALES
SALES_TIME_FK Referential SALES
SALES_TIME_NN Check SALES
SYS_C002532 Check MVIEW$_EXCEPTIONS
SYS_C002533 Check MVIEW$_EXCEPTIONS
SYS_C002534 Check MVIEW$_EXCEPTIONS
SYS_C002535 Check MVIEW$_EXCEPTIONS
SYS_C002536 Check MVIEW$_EXCEPTIONS
SYS_C002537 Check CAL_MONTH_SALES_MV
SYS_C002538 Check FWEEK_PSCAT_SALES_MV
SYS_C002539 Check FWEEK_PSCAT_SALES_MV
SYS_C002540 Check FWEEK_PSCAT_SALES_MV
SYS_C002541 Check FWEEK_PSCAT_SALES_MV
TIM_CAL_MONTH_DESC_NN Check TIMES
TIM_CAL_MONTH_NAME_NN Check TIMES
TIM_CAL_MONTH_NUMBER_NN Check TIMES
TIM_CAL_QUARTER_DESC_NN Check TIMES
TIM_CAL_QUARTER_NUMBER_NN Check TIMES
TIM_CAL_WEEK_NN Check TIMES
TIM_CAL_YEAR_NN Check TIMES
TIM_DAY_IN_MONTH_NN Check TIMES
TIM_DAY_IN_WEEK_NN Check TIMES
TIM_DAY_NAME_NN Check TIMES
TIM_DAYS_CAL_MONTH_NN Check TIMES
TIM_DAYS_CAL_QUARTER_NN Check TIMES
TIM_DAYS_CAL_YEAR_NN Check TIMES
TIM_DAYS_FIS_MONTH_NN Check TIMES
TIM_DAYS_FIS_QUARTER_NN Check TIMES
TIM_DAYS_FIS_YEAR_NN Check TIMES
TIM_END_OF_CAL_MONTH_NN Check TIMES
TIM_END_OF_CAL_QUARTER_NN Check TIMES
TIM_END_OF_CAL_YEAR_NN Check TIMES
TIM_END_OF_FIS_MONTH_NN Check TIMES
TIM_END_OF_FIS_QUARTER_NN Check TIMES
TIM_END_OF_FIS_YEAR_NN Check TIMES
TIME_PK Primary Key TIMES
TIM_FIS_MONTH_DESC_NN Check TIMES
TIM_FIS_MONTH_NAME_NN Check TIMES
TIM_FIS_MONTH_NUMBER_NN Check TIMES
TIM_FIS_QUARTER_DESC_NN Check TIMES
TIM_FIS_QUARTER_NUMBER_NN Check TIMES
TIM_FIS_WEEK_NN Check TIMES
TIM_FIS_YEAR_NN Check TIMES
TIM_WEEK_ENDING_DAY_NN Check TIMES


Generated by OraDoclet, Copyright © Oracle Corporation 2005      Last updated: 01.01.2005