midterm

Tables (11)

Untitled (책)

  • Key (ISBN) — int(13) — Primary key — NOT NULL
  • Field (서명) — char(30)
  • Field (출판일자) — date
  • Field (가격) — int(10)
  • Key (출판사ID) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (kdc분류번호) — int(3) — Foreign key → Untitled.Key — NOT NULL

Untitled (출판사)

  • Key (출판사ID) — char(10) — Primary key — NOT NULL
  • Field (출판사명칭) — char(30)
  • Field (출판사주소) — char(200)

Untitled (저자)

  • Key (주민번호) — char(14) — Primary key — NOT NULL
  • Field (저자이름) — char(30)
  • Field (저자주소) — char(200)

Untitled (책_저자)

  • Key (ISBN) — int(13) — Foreign key → Untitled.Key — NOT NULL
  • Key (주민번호) — char(14) — Foreign key → Untitled.Key — NOT NULL

Untitled (KDC)

  • Key (kdc분류번호) — int(3) — Primary key — NOT NULL
  • Field (설명) — char(30)

Untitled (주제명)

  • Key (키워드code) — char(10) — Primary key — NOT NULL
  • Field (키워드이름) — char(30)
  • Field (키워드설명) — char(100)

Untitled (책_주제)

  • Key (ISBN) — int(13) — Foreign key → Untitled.Key — NOT NULL
  • Key (키워드code) — char(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (관련인물)

  • Key (인물코드) — char(14) — Primary key — NOT NULL
  • Field (인물이름) — char(40)

Untitled (관련사건)

  • Key (사건코드) — char(10) — Primary key — NOT NULL
  • Field (사건이름) — char(40)

Untitled (책_관련인물)

  • Key (ISBN) — int(13) — Foreign key → Untitled.Key — NOT NULL
  • Key (인물코드) — char(14) — Foreign key → Untitled.Key — NOT NULL

Untitled (책_관련사건)

  • Key (ISBN) — int(13) — Foreign key → Untitled.Key — NOT NULL
  • Key (사건코드) — char(10) — Foreign key → Untitled.Key — NOT NULL