PRODUCTS

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PRODUCT_ID NUMBER 0 "OT"."ISEQ$$_73015".nextval
INVENTORIES.PRODUCT_ID FK_INVENTORIES_PRODUCTSC
ORDER_ITEMS.PRODUCT_ID FK_ORDER_ITEMS_PRODUCTSC
PRODUCT_NAME VARCHAR2 255 null
DESCRIPTION VARCHAR2 2000 √ null
STANDARD_COST NUMBER 9,2 √ null
LIST_PRICE NUMBER 9,2 √ null
CATEGORY_ID NUMBER 0 null
PRODUCT_CATEGORIES.CATEGORY_ID FK_PRODUCTS_CATEGORIESC

Indexes

Constraint Name Type Sort Column(s)
SYS_C007574 Primary key Asc PRODUCT_ID

Relationships

Close relationships within degrees of separation