final

Tables (6)

Library

  • Key (LibraryCode) — int — Primary key — NOT NULL
  • Key (ISBN) — Foreign key → Untitled.Key — NOT NULL
  • Field (LibraryName) — str
  • Field2 (LocationInfo)
  • Field3

Untitled (LendableBooks)

  • Key (BookID) — int — Primary key — NOT NULL
  • Key (LibraryCode) — int — Foreign key → Library.Key — NOT NULL
  • Key (ISBN) — Foreign key → Library.Key — NOT NULL
  • Field (Location)
  • Field2 (KDC)
  • Field3
  • Key (CurationInfo) — Foreign key → Untitled.Key — NOT NULL
  • Key (AwardID) — Foreign key → Untitled.Key — NOT NULL
  • Key (AuthorID) — Foreign key → Untitled.Key — NOT NULL

Untitled (Books)

  • Key (ISBN) — Primary key — NOT NULL
  • Field2 (Publisher)
  • Field3 (Title)
  • Key (AuthorID) — Foreign key → Untitled.Key — NOT NULL
  • Key (AuthorID2) — Foreign key — NOT NULL

Untitled (BookAward)

  • Key (AwardID) — Primary key — NOT NULL
  • Key (AuthorID) — Foreign key → Untitled.Key — NOT NULL
  • Field (AwardName)

Untitled (Awarded)

  • Key (AwardInfo) — Primary key — NOT NULL
  • Field (AuthorID)

Untitled (Curation)

  • Key (CurationInfo) — Primary key — NOT NULL
  • Key (AwardID) — Foreign key → Untitled.Key — NOT NULL
  • Key (AuthorID) — Foreign key → Untitled.Key — NOT NULL
  • Field (CurationType)