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.