DB기말과제_임미숙

테이블 (5)

AUTHOR (Untitled4)

  • authorID (Key) — char(20) — 기본 키 — NOT NULL
  • ISBN (Key2) — int(10) — 외래 키 → BOOK.ISBN — NOT NULL
  • name (Field) — char(20)
  • description (Field2) — text

BOOK (Untitled)

  • ISBN (Key) — int(10) — 기본 키 — NOT NULL
  • title (Field) — char(20)
  • author (Field2) — char(20)
  • pubYear (Field3) — int(4)
  • publisher (Field4) — char(10)
  • remark (Field5) — char(5)
  • bookstarNo (Key2) — int(10) — 외래 키 → BOOKSTAR.bookstarNo — NOT NULL

BOOKSTAR (Untitled2)

  • bookstarNo (Key) — int(10) — 기본 키 — NOT NULL
  • awardsTitle (Field) — char(5)
  • readingRecord (Field2) — int(5)

CLASS (Untitled5)

  • classCode (Key) — char(3) — 기본 키 — NOT NULL
  • schoolYear (Field) — char(5)
  • teachername (Field2) — char(5)

USER (Untitled3)

  • userID (Key) — char(10) — 기본 키 — NOT NULL
  • classCode (Key3) — char(3) — 외래 키 → CLASS.classCode — NOT NULL
  • name (Field) — char(10)
  • phone (Field2) — int(15)
  • class (Field3) — char(5)
  • readingRecord (Field4) — int(5)
  • bookstarNo (Key2) — int(10) — 외래 키 → BOOKSTAR.bookstarNo — NOT NULL