li
Tables (3)
Customer (Untitled2)
- c_id (Key) — Primary key — NOT NULL
- c_name (Field)
- c_phone (Field2)
- b_id (Key2) — Foreign key → book.b_id — NOT NULL
book (Untitled)
- b_id (Key) — Primary key — NOT NULL
- b_name (Field)
- b_genre (Field2)
- b_publisher (Field3)
- b_state (Field4)
rent (Untitled3)
- r_id (Key3) — Primary key — NOT NULL
- r_startdate (Field)
- r_enddate (Field2)
- b_id (Key) — Foreign key → book.b_id — NOT NULL
- c_id (Key2) — Foreign key → Customer.c_id — NOT NULL