Exe6- 006

Tables (4)

Untitled (책)

  • Key (책ID) — char(10) — Primary key — NOT NULL
  • Key (출판사ID) — char(20) — Foreign key → Untitled2.Key — NOT NULL
  • Field (서명) — char(10)
  • Field (가격) — char(10)
  • Field (출판일) — char(10)
  • Field

Untitled2 (출판사)

  • Key (출판사ID) — char(20) — Primary key — NOT NULL
  • Field (이름) — char(10)
  • Field (주소) — char(30)
  • Field (전화) — char(11)
  • Field

Untitled3 (저자)

  • Field (주민번호) — char(10)
  • Field (이름) — char(10)
  • Field (주소) — char(10)
  • Field (전화) — char(10)
  • Key (책ID) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (출판사ID) — char(20) — Foreign key → Untitled.Key — NOT NULL
  • Field

Untitled5 (인쇄소)

  • Key (인쇄소ID) — char(10) — Primary key — NOT NULL
  • Field (이름) — char(10)
  • Field (주소) — char(10)
  • Field (전화) — char(11)
  • Field
  • Key (책ID) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (출판사ID) — char(20) — Foreign key → Untitled.Key — NOT NULL