Goyang
Tables (4)
Untitled (GoyangAuthor)
- Key (AuthorID) — int(12) — Primary key — NOT NULL
- Field (name) — char(20)
- Field (address) — char(50)
- Field (phoneNo) — int(11)
- Field (majorWorks) — text
Untitled (Book)
- Key (ISBN) — char(13) — Primary key — NOT NULL
- Field (title) — char(50)
- Field (pubYear) — int(4)
- Field (publisher) — char(20)
- Key (AuthorID) — int(12) — Foreign key → Untitled.Key — NOT NULL
Untitled (Library)
- Key (libraryID) — char(20) — Primary key — NOT NULL
- Field (libraryName) — char(30)
- Key (ISBN) — char(13) — Foreign key → Untitled.Key — NOT NULL
- Key (ISBN2) — char(13) — Foreign key → Untitled.Key — NOT NULL
Untitled (RecommembedBook)
- Key (ISBN) — char(13) — Primary key — NOT NULL
- Field (title) — char(50)
- Field (author) — char(30)
- Field (publisher) — char(20)
- Field (pubYear) — int(4)
- Key (AuthorID) — int(12) — Foreign key → Untitled.Key — NOT NULL