마당서점

테이블 (3)

Untitled (Book)

  • Key (bookid) — NUMBER — 기본 키 — NOT NULL
  • Field (bookname) — VARCHAR2(100) — NOT NULL
  • Field (publsher) — VARCHAR2(100) — NOT NULL
  • Field2 (price) — NUMBER — NOT NULL

Untitled2 (Customer)

  • Key (custid) — NUMBER — 기본 키 — NOT NULL
  • Field (name) — VARCHAR2(100) — NOT NULL
  • Field2 (address) — VARCHAR2(100) — NOT NULL
  • Field (phone) — VARCHAR2(100)

Untitled3 (Order)

  • Key (orderid) — NUMBER — 기본 키 — NOT NULL
  • Key (custid) — NUMBER — 외래 키 → Untitled2.Key — NOT NULL
  • Key (bookid) — NUMBER — 외래 키 → Untitled.Key — NOT NULL
  • Field (saleprice) — NUMBER — NOT NULL
  • Field (orderdate) — DATE — NOT NULL