book_rental
Tables (5)
Untitled (reservation)
- Key (resv_id) — BIGSERIAL — Primary key — NOT NULL
- Key (member_id) — bigint(20) — Foreign key → Untitled2.Key — NOT NULL
- book_id — bigint — Foreign key → books.book_id — NOT NULL
Untitled (book_info)
- Key (isbn) — BIGSERIAL — Primary key — NOT NULL
- Field (kdc) — varchar(10)
- Field2 (author) — varchar(5)
- Field3 (pub_date) — timestamp
- Field (title) — varchar(10)
- Field (publisher) — varchar(10)
Untitled2 (member)
- Key (member_id) — BIGSERIAL — Primary key — NOT NULL
- Field (name) — varchar(5)
- Field (email) — varchar(16)
- Field (password) — varchar(16)
- Field (role) — varchar(5)
- Field (address) — varchar(20) — NOT NULL
- Field (phone) — varchar(11) — NOT NULL
books (book)
- book_id — BIGSERIAL — Primary key — NOT NULL
- Field (resv) — boolean
- Key (isbn) — int — Foreign key → Untitled.Key — NOT NULL
rent_record
- Key (rent_id) — BIGSERIAL — Primary key — NOT NULL
- Field (rent_time) — timestamp — NOT NULL
- Field (return_time) — timestamp
- Key (member_id) — bigint(20) — Foreign key → Untitled2.Key — NOT NULL
- book_id — bigint(20) — Foreign key → books.book_id — NOT NULL