ex6
Tables (5)
AUTHOR (Untitled3)
- authorName (Key) — Primary key — NOT NULL
- authorSecurityNumber (Field)
- authorAddress (Field3)
BOOK (Untitled)
- ISBN (Key) — Primary key — NOT NULL
- publisherId (Key3) — Foreign key → PUBLISHER.publisherId — NOT NULL
- bookTitle (Field)
- bookPublicationDate (Field2) — date
- bookInformation (Field3)
- authorName (Key2) — Foreign key → AUTHOR.authorName — NOT NULL
CONTRACT (Untitled5)
- contractInformation (Key6) — Primary key — NOT NULL
- printing book number (Field)
- printing deadline (Field2)
- ISBN (Key) — Foreign key → BOOK.ISBN — NOT NULL
- printerId (Key2) — Foreign key → PRINTER.printerId — NOT NULL
- publisherId (Key3) — Foreign key → BOOK.publisherId — NOT NULL
- printeerName (Key4) — Foreign key → PRINTER.printeerName — NOT NULL
- printerAddress (Key5) — Foreign key → PRINTER.printerAddress — NOT NULL
PRINTER (Untitled4)
- printerId (Key) — Primary key — NOT NULL
- printeerName (Key4) — Primary key — NOT NULL
- printerAddress (Key5) — Primary key — NOT NULL
- ISBN (Key2) — Foreign key → BOOK.ISBN — NOT NULL
- publisherId (Key3) — Foreign key → BOOK.publisherId — NOT NULL
PUBLISHER (Untitled2)
- publisherId (Key) — Primary key — NOT NULL
- publisherName (Field)
- publisherAddress (Field2)