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)