book
Tables (6)
book
- book_id — INT — Primary key — NOT NULL
- title — VARCHAR(100) — NOT NULL
- author — VARCHAR(50) — NOT NULL
- publisher — VARCHAR(50)
- is_available — BOOLEAN — NOT NULL
book_order
- order_id — INT — Primary key — NOT NULL
- customer_id — INT — Foreign key → customer.customer_id — NOT NULL
- book_id — INT — Foreign key → book.book_id — NOT NULL
- order_date — DATE — NOT NULL
customer
- customer_id — INT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- phone_number — VARCHAR(20) — NOT NULL
- address — VARCHAR(100)
extension
- extension_id — INT — Primary key — NOT NULL
- lending_id — INT — Foreign key → lending.lending_id — NOT NULL
- order_id — INT — Foreign key → lending.order_id — NOT NULL
- customer_id — INT — Foreign key → lending.customer_id — NOT NULL
- book_id — INT — Foreign key → lending.book_id — NOT NULL
- extended_date — DATE — NOT NULL
- fee — INT — NOT NULL
- count — INT
lending
- lending_id — INT — Primary key — NOT NULL
- order_id — INT — Foreign key → book_order.order_id — NOT NULL
- customer_id — INT — Foreign key → book_order.customer_id — NOT NULL
- book_id — INT — Foreign key → book_order.book_id — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
return
- return_id — INT — Primary key — NOT NULL
- lending_id — INT — Foreign key → lending.lending_id — NOT NULL
- order_id — INT — Foreign key → lending.order_id — NOT NULL
- customer_id — INT — Foreign key → lending.customer_id — NOT NULL
- book_id — INT — Foreign key → lending.book_id — NOT NULL
- return_date — DATE — NOT NULL
- status — VARCHAR(20)