2022913002ERD6

Tables (12)

AUTHOR

  • Key — char(30) — Primary key — NOT NULL
  • Field — char(30)
  • Field2 — int(12)
  • Field3 — char(30)
  • Field4 — char(12)
  • Field5 — char(30)

BOOK

  • Key — char(20) — Primary key — NOT NULL
  • Field — char(20)
  • Field2 — date
  • Field3 — char(30)
  • Key (Key3) — char(20) — Foreign key → PUBLISHER.Key — NOT NULL
  • Field4 — int(10)
  • Field5 — int(4)
  • Key (Key2) — char(12) — Foreign key → KDC.Key — NOT NULL

BOOK_AUTHOR

  • Key (Key2) — char(30) — Foreign key → AUTHOR.Key — NOT NULL
  • Key — char(20) — Foreign key → BOOK.Key — NOT NULL
  • Field — char(20)

BOOK_EVENT

  • Key — char(20) — Foreign key → BOOK.Key — NOT NULL
  • Key (Key2) — char(30) — Foreign key → EVENT.Key — NOT NULL

BOOK_PERSON

  • Key (Key2) — char(20) — Foreign key → BOOK.Key — NOT NULL
  • Key (Key3) — char(10) — Foreign key → PERSON.Key — NOT NULL

CONTRACT (CONSTRACT)

  • Key — char(20) — Primary key — NOT NULL
  • Field — int
  • Field2 — date
  • Key (Key2) — char(20) — Foreign key → BOOK.Key — NOT NULL
  • Key (Key3) — char(20) — Foreign key → PUBLICATION.Key — NOT NULL

EVENT

  • Key — char(30) — Primary key — NOT NULL
  • Field — char(20)
  • Field2 — text
  • Field3

KDC

  • Key — char(12) — Primary key — NOT NULL
  • Field — char(30)
  • Field2 — text

PERSON

  • Key — char(10) — Primary key — NOT NULL
  • Field — char(30)
  • Field2 — text

PUBLICATION

  • Key — char(20) — Primary key — NOT NULL
  • Field — char(30)
  • Field2 — char(30)
  • Field3 — char(12)
  • Field4 — char(30)

PUBLISHER

  • Key — char(20) — Primary key — NOT NULL
  • Field — char(30)
  • Field2 — char(30)
  • Field3 — char(12)
  • Field4 — char(30)

SUBJECT

  • Key — char(20) — Primary key — NOT NULL
  • Key (Key2) — char(20) — Foreign key → BOOK.Key — NOT NULL
  • Field — text
  • Field2 — char(30)