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