sql

Tables (3)

book

  • id (Key) — NOT NULL — Foreign key → rental.id — NOT NULL
  • title (Field) — NOT NULL
  • author (Field2) — NULL
  • publisher (Field3)
  • date_received (Field4)

rental (Untitled3)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • book_id (Field) — NOT NULL
  • user_id (Field2) — NOT NULL
  • rental_begin_date (Field3)
  • rental_end_date (Field4)

user (Untitled2)

  • id (Key2) — NOT NULL — Foreign key → rental.id — NOT NULL
  • name (Field) — NOT NULL
  • email (Field2)
  • phone (Field3)
  • address (Field4)