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)