04번 김도영Final Project

테이블 (9)

BOOK (Untitled)

  • isbn (Key) — char(13) — 기본 키 — NOT NULL
  • booktitle (Field) — char(50)
  • author (Field8) — char(50)
  • kor_6th (Field2) — char(20)
  • pubYear (Field3) — int(04)
  • type (Field4) — char(50)
  • expression (Field5) — char(3)
  • description (Field7) — char(100)
  • libraryID (Key2) — int(30) — 외래 키 → LIBRARY.libraryID — NOT NULL
  • workId (Key3) — int(30) — 외래 키 → WORK.workId — NOT NULL

CLASSIFICATION (Untitled9)

  • classificationId (Key) — int(10) — 기본 키 — NOT NULL
  • classificationTitle (Field) — char(30)

CLIENT (Untitled2)

  • clientId (Key) — int(100) — 기본 키 — NOT NULL
  • name (Field) — char(30)
  • phone (Field2) — int(30)
  • email (Field3) — char(30)
  • address (Field4) — char(30)

LIBRARY (Untitled5)

  • libraryID (Key) — int(30) — 기본 키 — NOT NULL
  • libraryname (Field) — char(30)

RENT (Untitled7)

  • rentId (Key) — int(100) — 기본 키 — NOT NULL
  • rentDate (Field) — date
  • returnDate (Field2) — date
  • isbn (Key2) — char(13) — 외래 키 → BOOK.isbn — NOT NULL
  • clientId (Key3) — int(100) — 외래 키 → CLIENT.clientId — NOT NULL

SCIENCEMUSEUM (Untitled6)

  • sciencemuseumId (Key) — int(30) — 기본 키 — NOT NULL
  • sciencemuseumName (Field) — char(50)

SCIENCEVIDEO (Untitled3)

  • videoId (Key) — int(10) — 기본 키 — NOT NULL
  • videotitle (Field) — char(50)
  • releasedYear (Field2) — int(4)
  • expression (Field3) — char(3)
  • url (Field6) — text
  • sciencemuseumId (Key2) — int(30) — 외래 키 → SCIENCEMUSEUM.sciencemuseumId — NOT NULL
  • workId (Key3) — int(30) — 외래 키 → WORK.workId — NOT NULL

WORK (Untitled4)

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

WORK_CLASSIFICATION (Untitled8)

  • workId (Key) — int(3) — 외래 키 → WORK.workId — NOT NULL
  • classificationId (Key2) — int(10) — 외래 키 → CLASSIFICATION.classificationId — NOT NULL