마당서점

테이블 (3)

Untitled (Book)

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

Untitled (Customer)

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

Untitled (Orders)

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