feedback middle test

Tables (13)

author (Untitled3)

  • name (Key) — Primary key — NOT NULL
  • address (Field2)
  • masterpiece (Field3)

book (Untitled)

  • ISBN (Key) — Primary key — NOT NULL
  • title (Field)
  • publicationDATE (Field2)
  • pubID (Key2) — Foreign key → publisher.pubID — NOT NULL
  • edition (Field3)
  • price (Field4)
  • code (Key3) — Foreign key → kdc.code — NOT NULL

book-print (Untitled5)

  • contractid (Key3) — Primary key — NOT NULL
  • volume (Field)
  • deadline (Field2)
  • impression (Field3)
  • ISBN (Key) — Foreign key → book.ISBN — NOT NULL
  • priID (Key2) — Foreign key → printing house.priID — NOT NULL

book_author (Untitled7)

  • name (Key) — Foreign key → author.name — NOT NULL
  • ISBN (Key2) — Foreign key → book.ISBN — NOT NULL
  • role (Field)

book_event (Untitled13)

  • ISBN (Key) — Foreign key → book.ISBN — NOT NULL
  • eventid (Key2) — Foreign key → event.eventid — NOT NULL

book_person (Untitled11)

  • ISBN (Key) — Foreign key → book.ISBN — NOT NULL
  • personid (Key2) — Foreign key → person.personid — NOT NULL

book_subject (Untitled10)

  • ISBN (Key) — Foreign key → book.ISBN — NOT NULL
  • subid (Key2) — Foreign key → subject.subid — NOT NULL

event (Untitled12)

  • eventid (Key) — Primary key — NOT NULL
  • name (Field)
  • description (Field2)

kdc (Untitled8)

  • code (Key) — Primary key — NOT NULL
  • name (Field)
  • description (Field2)

person (Untitled6)

  • personid (Key) — Primary key — NOT NULL
  • name (Field)
  • description (Field2)

printing house (Untitled4)

  • priID (Key) — Primary key — NOT NULL
  • name (Field)
  • address (Field2)

publisher (Untitled2)

  • pubID (Key) — Primary key — NOT NULL
  • name (Field)
  • address (Field2)

subject (Untitled9)

  • subid (Key) — Primary key — NOT NULL
  • subjectheading (Field)
  • description (Field2)