finalERD

Tables (10)

AUTHOR (저자)

  • authorID (Key) — char(10) — Primary key — NOT NULL
  • authorName (Field) — char(10)
  • authorAddress (Field2) — char(30)
  • showpieceISBN (Key2) — char(13) — Foreign key → BOOK.ISBN — NOT NULL

BOOK (책)

  • ISBN (Key) — char(13) — Primary key — NOT NULL
  • bookName (Field) — char()
  • publishedDate (Field2) — date()
  • pbID (Key2) — char(10) — Foreign key → PUBLISHER.pbID — NOT NULL
  • KDC (Field3) — char()

BOOK-RELATED (관련됨)

  • relatedID (Key) — char(30) — Foreign key → RELATED.relatedID — NOT NULL
  • ISBN (Key2) — char(13) — Foreign key → BOOK.ISBN — NOT NULL

BOOK-SUBJECT (주제로 함)

  • ISBN (Key) — char(13) — Foreign key → BOOK.ISBN — NOT NULL
  • subjID (Key2) — char(10) — Foreign key → SUBJECT.subjID — NOT NULL

CONTRACT (인쇄 계약)

  • pressID (Key) — char(10) — Foreign key → PRESS.pressID — NOT NULL
  • ISBN (Key2) — char(13) — Foreign key → BOOK.ISBN — NOT NULL
  • copies (Field) — int(7)
  • deadline (Field2) — date()

PRESS (인쇄소)

  • pressID (Key) — char(10) — Primary key — NOT NULL
  • pressName (Field) — char(10)
  • pressAddress (Field2) — char(30)

PUBLISHER (출판사)

  • pbID (Key) — char(10) — Primary key — NOT NULL
  • pbName (Field) — char(10)
  • pbAddress (Field2) — char(30)

RELATED (관련주기)

  • relatedID (Key) — char(30) — Primary key — NOT NULL
  • type (Field) — char(2)
  • description (Field2) — char(100)

SUBJECT (주제)

  • subjID (Key) — char(10) — Primary key — NOT NULL
  • keyword (Field) — char(5)

WROTE (저작함)

  • authorID (Key) — char(10) — Foreign key → AUTHOR.authorID — NOT NULL
  • ISBN (Key2) — char(13) — Foreign key → BOOK.ISBN — NOT NULL