13
Tables (10)
AUTHORS (Untitled)
- AuthorID (Key) — int(10) — Primary key — NOT NULL
- name (Field) — char(10)
- representative (Field2) — char(10)
- Representative Work (Field3) — char(50)
BOOK
- ISBN (Key) — int(10) — Primary key — NOT NULL
- title (Field) — char(10)
- PublicationDate (Field2) — int(10)
- Publisher ID (Key2) — int(10) — Foreign key → PUBISHERS.Publisher ID — NOT NULL
Books_Authors (Untitled3)
- ISBN (Key) — int(10) — Foreign key → BOOK.ISBN — NOT NULL
- AuthorID (Key2) — int(10) — Foreign key → AUTHORS.AuthorID — NOT NULL
Books_Keywords (Untitled9)
- ISBN (Key) — int(10) — Foreign key → BOOK.ISBN — NOT NULL
- Keyword ID (Key2) — int(10) — Foreign key → KEYSWORD.Keyword ID — NOT NULL
Books_RelatedEntities (Untitled8)
- ISBN (Key) — int(10) — Foreign key → BOOK.ISBN — NOT NULL
- Entity ID (Key2) — int(10) — Foreign key → Related Entities.Entity ID — NOT NULL
CONTRACTS (Untitled5)
- contractsID (Key) — int(10) — Primary key — NOT NULL
- Print Quantity (Field) — int(10)
- Print Deadline (Field2) — int(10)
- Printing House ID (Key2) — int(10) — Foreign key → PRINTING HOUSES.Printing House ID — NOT NULL
- ISBN (Key3) — int(10) — Foreign key → BOOK.ISBN — NOT NULL
KEYSWORD (Untitled6)
- Keyword ID (Key) — int(10) — Primary key — NOT NULL
- Keyword Name (Field) — char(20)
- KDCNumber (Field2) — int(10)
PRINTING HOUSES (Untitled4)
- Printing House ID (Key) — int(10) — Primary key — NOT NULL
- name (Field2) — char(10)
- address (Field3) — char(20)
PUBISHERS (Untitled2)
- Publisher ID (Key) — int(10) — Primary key — NOT NULL
- name (Field) — char(10)
- address (Field2) — char(20)
Related Entities (Untitled7)
- Entity ID (Key) — int(10) — Primary key — NOT NULL
- type (Field) — char(10)
- description (Field2) — int(10)