ERD

Tables (4)

Untitled (도서)

  • Key (도서번호) — INTEGER — Primary key — NOT NULL
  • Field (도서이름) — VARCHAR(100)
  • Field (도서단가) — INTEGER
  • Key (출판사이름) — VARCHAR(100) — Foreign key → Untitled.Key — NOT NULL

Untitled (출판사)

  • Key (출판사이름) — VARCHAR(100) — Primary key — NOT NULL
  • Field (담당자이름) — VARCHAR(50)
  • Field (전화번호) — VARCHAR(20)

Untitled (주문)

  • Key (주문번호) — INTEGER — Primary key — NOT NULL
  • Field (주문일자) — DATE — NOT NULL
  • Field (주문금액) — INTEGER — NOT NULL
  • Key (도서번호) — INTEGER — Foreign key → Untitled.Key — NOT NULL
  • Key (key) — INTEGER — Foreign key → Untitled.Key — NOT NULL

Untitled (고객)

  • Key (key) — INTEGER — Primary key — NOT NULL
  • Field (고객이름) — VARCHAR(50) — NOT NULL
  • Field (주소) — VARCHAR(100)
  • Field (전화번호) — VARCHAR(20)