MADANG
테이블 (3)
DEPT
- DEPTNO — NUMBER(2) — 기본 키 — NOT NULL
- DNAME (NAME) — VARCHAR2(14BYTE))
- LOC (ADDRESS) — VARCHAR2(13BYTE)
- Field (PHONE)
EMP
- EMPNO — NUMBER(4) — 기본 키 — NOT NULL
- ENAME (SALEPRICE) — VARCHAR2(10BYTE)
- JOB (ORDERDATE) — DATE
- HIREDATE (BOOKID) — DATE — 외래 키 → 도서.Key — NOT NULL
- SAL — NUMBER(7,2)
- COMM — NUMBER(7,2)
- Field
- DEPTNO — NUMBER(2) — 외래 키 → DEPT.DEPTNO — NOT NULL
도서 (BOOK)
- Key (BOOKID) — NUMBER(2) — 기본 키 — NOT NULL
- Field (BOOKNAME) — VARCHAR2(40)
- (PUBLISHER) — VARCHAR2(40)
- (PRICE)