aa
Tables (6)
Appendix_Tbl
- Appendix_id — INT — Primary key — NOT NULL
- Book_code — INT — Foreign key → Book_Tbl.Book_code — NOT NULL
- Appendix_name — VARCHAR(45)
Book_Tbl
- Book_code — INT — Primary key — NOT NULL
- Classification_id — INT — Foreign key → Classification_Tbl.Classification_id — NOT NULL
- book_author — VARCHAR(45)
- book_name — VARCHAR(45)
- publisher — VARCHAR(45)
- isreserve — TINYINT
Classification_Tbl
- Classification_id — INT — Primary key — NOT NULL
- Classification_name — VARCHAR(45)
Member_Tbl
- Member_id — INT — Primary key — NOT NULL
- Member_name — VARCHAR(45)
- Member_identity — VARCHAR(45)
- Member_grade — VARCHAR(45)
- Member_addr — VARCHAR(45)
- Member_phone — VARCHAR(45)
Rental_Tbl
- Rental_id — INT — Primary key — NOT NULL
- Book_code — INT — Foreign key → Book_Tbl.Book_code — NOT NULL
- Member_id — INT — Foreign key → Member_Tbl.Member_id — NOT NULL
Reserve_Tbl
- Rental_id — INT — Foreign key → Rental_Tbl.Rental_id — NOT NULL
- Member_id — INT — Foreign key → Member_Tbl.Member_id — NOT NULL
- Reserve_order — VARCHAR(45)