2023_0328_EX06
Tables (6)
Untitled (BOOKS)
- Key (bookIIsbn) — char(18) — Primary key — NOT NULL
- Field (booktitle) — char(30)
- Field (publicationDate) — date
- Field (description) — test
- Field (award) — test
Untitled (PUBLISHER)
- Key (publiId) — char(10) — Primary key — NOT NULL
- Key (bookIIsbn) — char(18) — Foreign key → Untitled.Key — NOT NULL
- Field (pusnliName) — char(30)
- Field (address) — char(30)
- Field (phone) — char(11)
Untitled (WRITER)
- Key (witerNo) — char(16) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (address) — char(30)
- Field (phone) — char(11)
- Field (birthDate) — char(8)
- Field (gender) — char(1)
- Field (award) — test
Untitled (PRINTER)
- Key (printerId) — int(1000) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (address) — char(30)
- Field (printDate) — date
- Key (publiId) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (bookIIsbn) — char(18) — Foreign key → Untitled.Key — NOT NULL
Untitled (ROLE)
- Key (roleId) — int(30) — Primary key — NOT NULL
- Key (bookIIsbn) — char(18) — Foreign key → Untitled.Key — NOT NULL
- Key (witerNo) — char(16) — Foreign key → Untitled.Key — NOT NULL
Untitled (SALES)
- Key (saleId) — int(30) — Primary key — NOT NULL
- Key (publiId) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (bookIIsbn) — char(18) — Foreign key → Untitled.Key — NOT NULL
- Key (witerNo) — char(16) — Foreign key → Untitled.Key — NOT NULL