ORDERS

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ORDER_ID NUMBER 0 "OT"."ISEQ$$_73024".nextval
ORDER_ITEMS.ORDER_ID FK_ORDER_ITEMS_ORDERSC
CUSTOMER_ID NUMBER 6 null
CUSTOMERS.CUSTOMER_ID FK_ORDERS_CUSTOMERSC
STATUS VARCHAR2 20 null
SALESMAN_ID NUMBER 6 √ null
EMPLOYEES.EMPLOYEE_ID FK_ORDERS_EMPLOYEESN
ORDER_DATE DATE 7 null

Indexes

Constraint Name Type Sort Column(s)
SYS_C007589 Primary key Asc ORDER_ID

Relationships

Close relationships within degrees of separation