OPTIM_ORDERS table

The OPTIM_ORDERS table contains information for orders, including order number, customer ID, and salesman.

The OPTIM_ORDERS table has the following columns:

ORDER_ID
DECIMAL; order ID number; cannot contain null.
CUST_ID
CHAR; customer ID number; up to 5 characters; cannot contain null.
ORDER_DATE
TIMESTAMP; date of order; cannot contain null; has default value.
ORDER_TIME
TIMESTAMP; time of day; cannot contain null; has default value.
FREIGHT_CHARGES
DECIMAL; dollar amount
ORDER_SALESMAN
CHAR; up to 6 characters
ORDER_POSTED_DATE
TIMESTAMP; cannot contain null; has default value.
ORDER_SHIP_DATE
CHAR; date when order is shipped; up to 8 characters; cannot contain null; has default value.

Primary keys

The ORDER_ID column is the primary key column.

Relationships to other tables

The OPTIM_ORDERS table is a parent of the OPTIM_DETAILS table, through a foreign key on column ORDER_ID.

The OPTIM_ORDERS table is a child of the OPTIM_CUSTOMERS table, through its foreign key on column CUST_ID.



Feedback