test
Tables (4)
Untitled (Book)
- Key (BookKey) — int — Primary key — NOT NULL
- Key (AuthorNo) — int — Foreign key → Untitled.Key — NOT NULL
- Field (BookSign) — char(10)
- Field (BookDay) — date
- Key (BookSubKdc) — int — Foreign key → Untitled.Key — NOT NULL
- Field (BookName) — text
Untitled (Publisher)
- Key (PubID) — int — Primary key — NOT NULL
- Key (BookKey) — int — Foreign key → Untitled.Key — NOT NULL
- Key (AuthorNo) — int — Foreign key → Untitled.Key — NOT NULL
- Field (PubName) — char(20)
- Field (PubAd) — char(50)
Untitled (Author)
- Key (AuthorNo) — int — Primary key — NOT NULL
- Field (AuthorName) — char(10)
- Field (AuthorAd) — char(50)
Untitled (BookSubject)
- Key (BookSubKdc) — int — Primary key — NOT NULL
- Field (BookSubKey) — char(10)