ORD * P ORDID NUMBER (5) ORDERDATE DATE ORDREF VARCHAR2 (10) * F CUSTID NUMBER (6) COMMPLAN VARCHAR2 (1 BYTE) SHIPDATE DATE TOTAL NUMBER (8,2) ORD_PK (ORDID) ORD_ORDID_UN (ORDID) ORD_CUSTID_FK (CUSTID) U ORD_PK (ORDID) CUSTOMER * P CUSTOMER_ID NUMBER (6) NAME VARCHAR2 (45 BYTE) ADDRESS VARCHAR2 (40 BYTE) CITY VARCHAR2 (30 BYTE) STATE VARCHAR2 (2 BYTE) ZIP VARCHAR2 (9 BYTE) AREA NUMBER (3) PHONE VARCHAR2 (9) * F REPID NUMBER (4) CREDITLIMIT NUMBER (9,2) COMMENTS LONG CUSTOMER_PK (CUSTOMER_ID) CUSTOMER_REPID_FK (REPID) CUSTOMER_PK (CUSTOMER_ID) PRICE * PF PRODID NUMBER (6) STDPRICE NUMBER (8,2) MINPRICE NUMBER (8,2) * P STARTDATE DATE ENDDATE DATE PRICE_PK (PRODID, STARTDATE) PRICE_PRODID_FK (PRODID) U PRICE_PK (PRODID, STARTDATE) EMP * P EMPNO NUMBER (4) ENAME VARCHAR2 (10) JOB VARCHAR2 (9) * F MGR NUMBER (4) HIREDATE DATE SAL NUMBER (7,2) COMM NUMBER (7,2) * F DEPTNO NUMBER (2) EMP_PK (EMPNO) EMP_MGR_FK (MGR) EMP_DEPTNO_FK (DEPTNO) U EMP_PK (EMPNO) DEPT * P DEPTNO NUMBER (2) DNAME VARCHAR2 (14 BYTE) LOC VARCHAR2 (14 BYTE) DEPT_PK (DEPTNO) U DEPT_PK (DEPTNO) PRODUCT * P PRODID NUMBER (6) DESCRIP VARCHAR2 PRODUCT_PK (PRODID) PRODUCT_PK (PRODID) ITEM * PF ORDID NUMBER (5) * P ITEMID NUMBER (4) * F PRODID NUMBER (6) ACTUALPRICE NUMBER (8,2) QTY NUMBER (8) ITEMTOT NUMBER (8,2) ITEM_PK (ORDID, ITEMID) ITEM_ORDID_FK (ORDID) ITEM_PRODID_FK (PRODID) ITEM_PK (ORDID, ITEMID)