book
Tables (3)
Untitled (rental)
- Key (rental_id) — bigint — Primary key — NOT NULL
- Field (created_at) — date — NOT NULL
- Field (modified_at) — date — NOT NULL
- Field (due_date) — date — NOT NULL
- Field (is_returned) — bit(1) — NOT NULL
- Field (returned_date) — date — NOT NULL
- Key (member_id) — bigint — Foreign key → Untitled2.Key — NOT NULL
- Key (book_id) — bigint — Foreign key → book.Key — NOT NULL
Untitled2 (member)
- Key (member_id) — bigint — Primary key — NOT NULL
- Field (created_at) — datetime — NOT NULL
- Field (modified_at) — date — NOT NULL
- Field (address) — varchar — NOT NULL
- Field (gender) — varchar — NOT NULL
- Field (name) — varchar — NOT NULL
- Field (phone_nember) — varchar — NOT NULL
- Field (resident_registration_number) — varchar — NOT NULL
book
- Key (book_id) — bigint — Primary key — NOT NULL
- Field (language) — varchar — NOT NULL
- Field (publisher) — varchar — NOT NULL
- Field (title) — varchar(100) — NOT NULL
- Field (writer) — varchar — NOT NULL
- Field (created_at) — date — NOT NULL
- Field (modified_at) — date — NOT NULL
- Field (is_avaliable) — bit(1) — NOT NULL