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)