exe6
Tables (6)
Author (Untitled3)
- author ID (Key) — int — Primary key — NOT NULL
- author No (Field) — char(50)
- author name (Field2) — char(30)
- author add (Field3) — char(30)
Book (Untitled)
- ISBN (Key) — int — Primary key — NOT NULL
- title (Field) — char(30)
- publish date (Field2) — date
- publisher (Field3) — char(30)
Book author (Untitled6)
- book ID (Key) — int — Primary key — NOT NULL
- Author ID (Field) — char(30)
- author ID (Key2) — int — Foreign key → Author.author ID — NOT NULL
Contract (Untitled5)
- print No (Key) — int — Primary key — NOT NULL
- printing deadline date (Field) — date
- publisher ID (Key2) — int — Foreign key → Publisher.publisher ID — NOT NULL
Printer (Untitled4)
- printer ID (Key) — int — Primary key — NOT NULL
- printer name (Field) — char(20)
- printer add (Field2) — char(20)
- ISBN (Key2) — int — Foreign key → Book.ISBN — NOT NULL
- print No (Key4) — int — Foreign key → Contract.print No — NOT NULL
- publisher ID (Key3) — int — Foreign key → Publisher.publisher ID — NOT NULL
Publisher (Untitled2)
- publisher ID (Key) — int — Primary key — NOT NULL
- publisher name (Field) — char(50)
- publisher add (Field2) — char(30)
- ISBN (Key2) — int — Foreign key → Book.ISBN — NOT NULL
- author ID (Key3) — itn — Foreign key → Author.author ID — NOT NULL