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`