ex_6
Tables (6)
AUTHOR (Untitled2)
- ss number (Key) — char(13) — Primary key — NOT NULL
- ss namae (Field) — char(30)
- address (Field2) — char(40)
B-A BRIDGE (Untitled3)
- BA number (Key) — char(10) — Primary key — NOT NULL
- isbn (Key2) — char(13) — Foreign key → BOOK.isbn — NOT NULL
- ss number (Key3) — char(13) — Foreign key → AUTHOR.ss number — NOT NULL
BOOK (Untitled)
- isbn (Key) — char(13) — Primary key — NOT NULL
- title (Field) — char(30)
- publication date (Field2) — date
CONTRACT (Untitled5)
- number of books (Field) — char(13) — Primary key
- printing deadline (Field2) — date
- book title (Key) — char(40) — NOT NULL
- publisher Id (Key2) — char(10) — Foreign key → PUBLISHER.publisher Id — NOT NULL
- printer Id (Key3) — char(10) — Foreign key → PRINTER.printer Id — NOT NULL
- isbn (Key22) — char(13) — Foreign key → PUBLISHER.isbn — NOT NULL
PRINTER (Untitled6)
- printer Id (Key) — char(10) — Primary key — NOT NULL
- printer name (Field) — char(30)
- printer address (Field2) — char(40)
PUBLISHER (Untitled4)
- publisher Id (Key) — char(10) — Primary key — NOT NULL
- isbn (Key2) — char(13) — Foreign key → BOOK.isbn — NOT NULL
- publisher name (Field) — char(30)
- publisher address (Field2) — char(40)