test
Tables (4)
Book
- Key — Primary key — NOT NULL
- book_id — BIGINT — Primary key
- title — VARCHAR(200) — NOT NULL
- author — VARCHAR(100) — NOT NULL
- isbn — VARCHAR(20)
- published_year — INT
- created_at — TIMESTAMP
Member
- Key — Primary key — NOT NULL
- member_id — BIGINT — Primary key
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(200) — NOT NULL
- phone — VARCHAR(30)
- created_at — TIMESTAMP
Rental
- Key — Primary key — NOT NULL
- rental_id — BIGINT — Primary key
- member_id — BIGINT — Primary key — NOT NULL
- Key (Key2) — Foreign key → Member.Key — NOT NULL
- member_id (member_id2) — BIGINT — Foreign key → Member.member_id
- book_id — BIGINT — NOT NULL
- rental_date — DATE — NOT NULL
- due_date — DATE — NOT NULL
- return_date — DATE
- status — VARCHAR(20) — NOT NULL
Untitled
- Key — Primary key — NOT NULL
- Key2 — Primary key — NOT NULL
- Field
- Field2
- Field3
- Field4