Test

Tables (4)

booklist

  • B_id (Key) — int — Primary key — NOT NULL
  • B_name — varchar(15)
  • B_date — date
  • writer — varchar(15)
  • publisher — varchar(15)

bookreport

  • Key (re_number) — int auto_increment — Primary key — NOT NULL
  • C_id — varchar(15) — Foreign key → customer.C_id — NOT NULL
  • Field (re_id) — varchar(15)
  • Field (re_bookid) — int
  • Field (report) — varchar(100)

borrowlist

  • BR_cid — varchar(15)
  • BR_bid — int
  • BR_date — date
  • BR_Rdate — date

customer

  • C_id — varchar(15) — Primary key — NOT NULL
  • C_name — varchar(15)
  • C_password — varchar(45)
  • tel — varchar(15)
  • age — int
  • gender — varchar(1)
  • point — int