Library
Tables (4)
Book (Untitled)
- book_id (Key) — Primary key — NOT NULL
- book_name (Field)
- stock (Field2)
- category (Field3)
Rent (Untitled4)
- rent_id (Key) — Primary key — NOT NULL
- rent_date (Field)
- return_date (Field2)
- book_id (Key2) — Foreign key → Book.book_id — NOT NULL
- user_id (Key3) — Foreign key → User.user_id — NOT NULL
- extension_time (Field3)
Seat Table (Untitled3)
- seat_number (Key) — Primary key — NOT NULL
- return_time (Field)
- user_id (Key2) — Foreign key → User.user_id — NOT NULL
- extension_time (Field2)
User (Untitled2)
- user_id (Key) — Primary key — NOT NULL
- password (Field)
- total_pay (Field2)