prac

Tables (11)

Untitled (BOOK)

  • Key (ISBN) — int(13) — Primary key — NOT NULL
  • Field (title) — char(50)
  • Field (publishDate) — date
  • Key (publisherID) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (kdc) — int(3) — Foreign key → Untitled.Key — NOT NULL

Untitled (PUBLISHER)

  • Key (publisherID) — char(10) — Primary key — NOT NULL
  • Field (publisherName) — char(50)
  • Field (publisherAddress) — char(100)

Untitled (AUTHOR)

  • Key (authorSsn) — char(14) — Primary key — NOT NULL
  • Field (authorName) — char(40)
  • Field (authorAddress) — char(100)

Untitled (WRITTEN_BY)

  • Key (ISBN) — int(13) — Foreign key → Untitled.Key — NOT NULL
  • Key (authorSsn) — int(14) — Foreign key → Untitled.Key — NOT NULL

Untitled (KDC)

  • Key (kdc) — int(3) — Primary key — NOT NULL
  • Field (description) — char(30)

Untitled (KEYWORD)

  • Key (keywordCode) — char(20) — Primary key — NOT NULL
  • Field (keywordName) — char(50)
  • Field (keywordDescription) — char(200)

Untitled (BOOK_KEYWORD)

  • Key (ISBN) — int(13) — Foreign key → Untitled.Key — NOT NULL
  • Key (keywordCode) — char(20) — Foreign key → Untitled.Key — NOT NULL

Untitled (PERSON)

  • Key (personSsn) — char(14) — Primary key — NOT NULL
  • Field (personName) — char(50)
  • Field (role) — char(20)

Untitled (EVENT)

  • Key (eventCode) — char(20) — Primary key — NOT NULL
  • Field (eventName) — char(50)
  • Field (eventDescription) — char(200)

Untitled (BOOK_PERSON)

  • Key (ISBN) — int(13) — Foreign key → Untitled.Key — NOT NULL
  • Key (personSsn) — char(14) — Foreign key → Untitled.Key — NOT NULL

Untitled (BOOK_EVENT)

  • Key (ISBN) — int(13) — Foreign key → Untitled.Key — NOT NULL
  • Key (eventCode) — char(20) — Foreign key → Untitled.Key — NOT NULL