2023_WebDB_ex6
Tables (6)
Untitled (BOOKS)
- Key (ISBN) — char(13) — Primary key — NOT NULL
- Field (booksTitle) — char(50)
- Field (pubishDate) — date
- Field (booksInfo) — text
Untitled (PUBLISHER)
- Key (publisherNo) — char(30) — Primary key — NOT NULL
- Field (publisherName) — char(30)
- Field (publisherAddress) — char(50)
Untitled (WRITING)
- Field (description) — text
Untitled (AUTHOR)
- Key (authorSsn) — char(13) — Primary key — NOT NULL
- Field (authorName) — char(30)
- Field (authorAddress) — char(50)
Untitled (CONTRACT)
- Key (contractNo) — char(30) — Primary key — NOT NULL
- Field (quantity) — int
- Field (duedate) — date
Untitled (PRINTER)
- Key (printerNo) — char(30) — Primary key — NOT NULL
- Field (printerName) — char(30)
- Field (printerAddress) — char(50)
- Field (capacity) — int