ORDER_ITEMS

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ORDER_ID NUMBER 12 null
ORDERS.ORDER_ID FK_ORDER_ITEMS_ORDERSC
ITEM_ID NUMBER 12 null
PRODUCT_ID NUMBER 12 null
PRODUCTS.PRODUCT_ID FK_ORDER_ITEMS_PRODUCTSC
QUANTITY NUMBER 8,2 null
UNIT_PRICE NUMBER 8,2 null

Indexes

Constraint Name Type Sort Column(s)
PK_ORDER_ITEMS Primary key Asc/Asc ORDER_ID + ITEM_ID

Relationships

Close relationships within degrees of separation