데이터베이스_기말_김은수

테이블 (4)

AUTHER (Untitled4)

  • autherID (Key) — int(10) — 기본 키 — NOT NULL
  • name (Field) — char(30)
  • authernativeName (Field2) — char(50)
  • majorWork (Field3) — char(30)

NOVEL_BOOK (Untitled2)

  • novelISBN (Key) — int(13) — 기본 키 — NOT NULL
  • title (Field) — char(50)
  • originalTitle (Field2) — char(50)
  • kdc_6th (Field3) — char(20)
  • pubYear (Field4) — int(4)
  • expression (Field5) — char(3)
  • auther (Field6) — char(30)
  • pubiisher (Field7) — char(50)
  • price (Field8) — int(30)
  • type (Field9) — char(10)
  • workID (Key2) — int(30) — 외래 키 → WORK.workID — NOT NULL

WORK (Untitled)

  • workID (Key) — int(30) — 기본 키 — NOT NULL
  • workTitle (Field) — chat(30)

WORK_AUTHER (Untitled3)

  • workID (Key) — int(30) — 외래 키 → WORK.workID — NOT NULL
  • autherID (Key2) — int(10) — 외래 키 → AUTHER.autherID — NOT NULL