book
Tables (6)
Untitled (BOOK)
- ISBN — char(10) — Primary key — NOT NULL
- signature — char(40)
- date of publication — date
- publication ID — char(10) — Foreign key → Untitled.publication ID — NOT NULL
Untitled (PUBLISHER)
- publication ID — char(10) — Primary key — NOT NULL
- name — char(30)
- address — char(60)
Untitled (AUTHOR)
- authorID — char(10) — Primary key — NOT NULL
- name — char(30)
- address — char(60)
- representative — char(100)
Untitled (BOOKAUTHOR)
- ISBN — char(10) — Foreign key → Untitled.ISBN — NOT NULL
- authorID — char(10) — Foreign key → Untitled.authorID — NOT NULL
Untitled (CONTRACT)
- ISBN — char(10) — Foreign key → Untitled.ISBN — NOT NULL
- printingID — char(10) — Foreign key → Untitled2.printingID — NOT NULL
- number — INT
- deadline — date
Untitled2 (PRINTINGHOUSE)
- printingID — char(10) — Primary key — NOT NULL
- name — char(10)
- address — char(100)