Overview Tables Views Indexes Constraints Triggers Procedures Functions Packages Sequences Index

OE

Constraints

Constraint Type Table
CUST_FNAME_NN Check CUSTOMERS
CUST_LNAME_NN Check CUSTOMERS
CUSTOMER_CREDIT_LIMIT_MAX Check CUSTOMERS
CUSTOMER_ID_MIN Check CUSTOMERS
CUSTOMERS_PK Primary Key CUSTOMERS
INVENTORIES_PRODUCT_ID_FK Referential INVENTORIES
INVENTORIES_WAREHOUSES_FK Referential INVENTORIES
INVENTORY_PK Primary Key INVENTORIES
INVENTORY_QOH_NN Check INVENTORIES
INVENTORY_WAREHOUSE_ID_NN Check INVENTORIES
ORDER_CUSTOMER_ID_NN Check ORDERS
ORDER_DATE_NN Check ORDERS
ORDER_ITEMS_ORDER_ID_FK Referential ORDER_ITEMS
ORDER_ITEMS_PK Primary Key ORDER_ITEMS
ORDER_ITEMS_PRODUCT_ID_FK Referential ORDER_ITEMS
ORDER_MODE_LOV Check ORDERS
ORDER_PK Primary Key ORDERS
ORDERS_CUSTOMER_ID_FK Referential ORDERS
ORDER_TOTAL_MIN Check ORDERS
PD_PRODUCT_ID_FK Referential PRODUCT_DESCRIPTIONS
PRODUCT_DESCRIPTIONS_PK Primary Key PRODUCT_DESCRIPTIONS
PRODUCT_INFORMATION_PK Primary Key PRODUCT_INFORMATION
PRODUCT_STATUS_LOV Check PRODUCT_INFORMATION
SYS_C002420 Check ORDER_ITEMS
SYS_C002421 Check ORDER_ITEMS
SYS_C002445 Primary Key CATEGORIES_TAB
SYS_C002446 Unique key CATEGORIES_TAB
SYS_C002447 Unique key CATEGORIES_TAB
SYS_C002448 Unique key CATEGORIES_TAB
TRANSLATED_DESC_NN Check PRODUCT_DESCRIPTIONS
TRANSLATED_NAME_NN Check PRODUCT_DESCRIPTIONS
WAREHOUSES_PK Primary Key WAREHOUSES

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