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