31
Tables (7)
Author (Untitled6)
- Author id (Key) — Primary key — NOT NULL
- Author Name (Field)
- Affiliation (Field2)
- Career (Field3)
- Register date (Field4)
Book (Untitled5)
- InfoNo (Key) — Primary key — NOT NULL
- OrdNo (Key2) — Foreign key → Order.OrdNo — NOT NULL
- ISBN (Field)
- title (Field2)
- edition (Field3)
- publisher (Field4)
- NumofPages (Field5)
- DeliveryDate (Field6)
- YearPublished (Field7)
- Category id (Key3) — Foreign key → Category.Category id — NOT NULL
- Author id (Key4) — Foreign key → Author.Author id — NOT NULL
Category (Untitled7)
- Category id (Key) — Primary key — NOT NULL
- CtgName (Field)
Order (Untitled2)
- OrdNo (Key) — Primary key — NOT NULL
- RegNo (Key2) — Foreign key → Request.RegNo — NOT NULL
- OrdDate (Field)
- Price (Field2)
- Field3
- Field4
People Type (Untitled3)
- People id (Key) — Primary key — NOT NULL
- People name (Field)
- Phone number (Field2)
- Rental status (Field3)
- People type (Field4)
- Field5
Rental (Untitled4)
- RentNo (Key) — Primary key — NOT NULL
- People id (Key3) — Foreign key → People Type.People id — NOT NULL
- InfoNo (Key4) — Foreign key → Book.InfoNo — NOT NULL
- RentStartDate (Field)
- Field2
- Field3
- Field4
- Field5
- InfoNo (Key2) — NOT NULL
Request (Untitled)
- RegNo (Key) — Primary key — NOT NULL
- MemNo (Key2) — Foreign key → People Type.People id — NOT NULL
- ISBN (Field)
- title (Field2)
- authors (Field3)
- publishers (Field4)
- Field5