bb
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)
- INDEX — `fk_Appendix_Tbl_Book_Tbl1_idx`
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
- INDEX — `fk_Book_Tbl_Classification_Tbl1_idx`
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
- INDEX — `fk_Rental_Tbl_Book_Tbl_idx`
- INDEX — `fk_Rental_Tbl_Member_Tbl1_idx`
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)
- INDEX — `fk_Reserve_Tbl_Member_Tbl1_idx`