DB기말과제_임미숙

테이블 (5)

AUTHOR (Untitled2)

  • authorId (Key) — char(20) — 기본 키 — NOT NULL
  • name (Field) — char(20)
  • e-mail (Field2) — char(20)
  • description (Field3) — text

BOOK (Untitled)

  • bookNo (Key) — char(10) — 기본 키 — NOT NULL
  • authorId (Key3) — char(20) — 외래 키 → AUTHOR.authorId — NOT NULL
  • booktitle (Field) — char(20)
  • author (Field2) — char(20)
  • pubYear (Field3) — int(4)
  • publisher (Field4) — char(10)
  • recommend (Field5) — char(3)
  • readingrecordID (Key2) — char(5) — 외래 키 → READINGRECORD.readingrecordID — NOT NULL

BOOKSTAR (Untitled6)

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

READINGRECORD (Untitled4)

  • readingrecordID (Key) — char(5) — 기본 키 — NOT NULL
  • recordQty (Field) — int(5)

USER (Untitled5)

  • userID (Key) — char(10) — 기본 키 — NOT NULL
  • bookstarNo (Key3) — char(10) — 외래 키 → BOOKSTAR.bookstarNo — NOT NULL
  • username (Field) — char(5)
  • phone (Field2) — int(15)
  • awardsTitle (Field3) — char(5)
  • recordQty (Field4) — int(5)
  • readingrecordID (Key2) — char(5) — 외래 키 → READINGRECORD.readingrecordID — NOT NULL