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)