기말과제

테이블 (7)

Author (Untitled3)

  • AuthorID (Key) — int(10) — 기본 키 — NOT NULL
  • name (Field) — char(30)
  • alternativeName (Field2) — char(30)
  • description (Field3) — text
  • majorWork (Field4) — text

Book (Untitled2)

  • ISBN (Key) — char(13) — 기본 키 — NOT NULL
  • title (Field) — char(50)
  • pubYear (Field2) — int(4)
  • type (Field3) — char(10)
  • expression (Field4) — char(3)
  • workID (Key2) — int(30) — 외래 키 → Work.workID — NOT NULL

Person (Untitled4)

  • personID (Key) — int(10) — 기본 키 — NOT NULL
  • name (Field) — char(30)
  • description (Field2) — text
  • nationality (Field3) — char(10)
  • repRole (Field4) — char(10)
  • majorWork (Field5) — text

Play (Untitled)

  • playID (Key) — int(10) — 기본 키 — NOT NULL
  • title (Field) — char(50)
  • originalTitle (Field2) — char(50)
  • releasedYear (Field3) — int(4)
  • expression (Field4) — char(3)
  • description (Field5) — text
  • runTime (Field6) — int(3)
  • workID (Key2) — int(30) — 외래 키 → Work.workID — NOT NULL

Play_Person (Untitled6)

  • role (Key) — char(10) — 기본 키 — NOT NULL
  • playID (Key2) — int(10) — 외래 키 → Play.playID — NOT NULL
  • personID (Key3) — int(10) — 외래 키 → Person.personID — NOT NULL

Work (Untitled5)

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

Work_Author (Untitled7)

  • workID (Key) — int(30) — 외래 키 → Work.workID — NOT NULL
  • AuthorID (Key2) — int(10) — 외래 키 → Author.AuthorID — NOT NULL