기말고사

테이블 (4)

LIBRARY (Untitled3)

  • libraryID (Key) — int(10) — 기본 키 — NOT NULL
  • libraryName (Field) — char(10)

PERSON (Untitled2)

  • personID (Key) — int(10) — 기본 키 — NOT NULL
  • name (Field) — char(5)
  • nationality (Field2) — char(10)
  • repRole (Field3) — char(10)
  • majorWorks (Field4) — text

PROGRAM (Untitled)

  • programID (Key) — int(10) — 기본 키 — NOT NULL
  • libraryID (Key2) — int(10) — 외래 키 → LIBRARY.libraryID — NOT NULL
  • title (Field) — char(20)
  • releasedYear (Field2) — int(4)
  • operationTime (Field3) — int(3)

PROGRAM_PERSON (Untitled4)

  • role (Key) — char(10) — 기본 키 — NOT NULL
  • programID (Key2) — int(10) — 외래 키 → PROGRAM.programID — NOT NULL
  • personID (Key3) — int(10) — 외래 키 → PERSON.personID — NOT NULL