library
Tables (3)
Untitled (rental)
- Key (rental_id) — Primary key — NOT NULL
- Key (user_id) — Foreign key → users.Key — NOT NULL
- Key (book_id) — Foreign key → books.Key — NOT NULL
- Field (rental_date)
- Field (return_date)
books
- Key (book_id) — Primary key — NOT NULL
- Field (rental)
- Field (search)
- Field (delete)
- Field (return)
users
- Key (user_id) — Primary key — NOT NULL
- Field (name)
- Field2 (phonenumber)
- Field3 (password)