EX6
Tables (7)
AUTHOR (Untitled4)
- aId (Key) — char(20) — Primary key — NOT NULL
- aName (Field) — char(10)
- aAdress (Field2) — char(40)
BOOK (Untitled)
- isbn (Key) — char(20) — Primary key — NOT NULL
- pId (Key3) — char(20) — Foreign key → PUBLISHER.pId — NOT NULL
- Name (Field) — char(30)
- gId (Key2) — integer — Foreign key → Genre.gId — NOT NULL
- publicationDate (Field2) — date
BOOK_AUTHOR (Untitled5)
- aId (Key) — char(20) — Foreign key → AUTHOR.aId — NOT NULL
- isbn (Key2) — char(20) — Foreign key → BOOK.isbn — NOT NULL
- pId (Key3) — char(20) — Foreign key → BOOK.pId — NOT NULL
Genre (Untitled2)
- gId (Key) — integer — Primary key — NOT NULL
- gName (Field) — char(10)
PUBLISHER (Untitled3)
- pId (Key) — char(20) — Primary key — NOT NULL
- pName (Field) — char(10)
- pAdress (Field2)
Print_Contract (Untitled7)
- ContractId (Key3) — integer — Primary key — NOT NULL
- isbn (Key2) — char(20) — Foreign key → BOOK.isbn — NOT NULL
- number (Field) — integer
- EndDate (Field2) — date
- printId (Key) — char(20) — Foreign key → PrintingPress.printId — NOT NULL
- pId (Key32) — char(20) — Foreign key → BOOK.pId — NOT NULL
PrintingPress (Untitled6)
- printId (Key) — char(20) — Primary key — NOT NULL
- printAddress (Field) — char(40)
- printName (Field2) — char(20)