MADANG

테이블 (4)

고객정보 (CUSTOMER)

  • Key (CUSTID) — NUMBER(2,0) — 기본 키 — NOT NULL
  • Field (NAME) — VARCHAR2(40)
  • Field (ADDRESS) — VARCHAR2(50)
  • Field (PHONE) — VARCHAR2(20)

수입책정보 (IMPORTED_BOOK)

  • Field (BOOKID) — NUMBER
  • Field (BOOKNAME) — VARCHAR2(40)
  • Field (PUBLISHER) — VARCHAR2(40)
  • Field (PRICE) — NUMBER(2,0)

책 주문 정보 (ORDERS)

  • Key (ORDERID) — NUMBER(2,0) — 기본 키 — NOT NULL
  • (SALEPRICE) — NUMBER(2,0)
  • Field (ORDERDATE) — DATE
  • Key (BOOKID) — NUMBER(2,0) — 외래 키 → 책정보.Key — NOT NULL
  • Key (CUSTID) — NUMBER(2,0) — 외래 키 → 고객정보.Key — NOT NULL

책정보 (BOOK)

  • Key (BOOKID) — NUMBER(2,0) — 기본 키 — NOT NULL
  • Field (BOOKNAME) — VARCHAR2(40)
  • Field (PUBLISHER) — VARCHAR2(40)
  • Field (PRICE) — NUMBER(8,0)