school
Tables (4)
BOOK
- book_id — INT — Primary key — NOT NULL
- book_title — VARCHAR(200) — NOT NULL
- author — VARCHAR(100) — NOT NULL
- publisher — VARCHAR(100) — NOT NULL
- category — VARCHAR(50) — NOT NULL
- total_count — INT — NOT NULL
- available_count — INT — NOT NULL
LOAN
- loan_id — INT — Primary key — NOT NULL
- book_id — INT — Foreign key → BOOK.book_id — NOT NULL
- member_id — INT — Foreign key → MEMBER.member_id — NOT NULL
- loan_date — DATE — NOT NULL
- due_date — DATE — NOT NULL
- loan_status — VARCHAR(20) — NOT NULL
MEMBER
- member_id — INT — Primary key — NOT NULL
- member_name — VARCHAR(50) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- join_date — DATE — NOT NULL
- member_status — VARCHAR(20) — NOT NULL
RETURN
- return_id — INT — Primary key — NOT NULL
- loan_id — INT — Foreign key → LOAN.loan_id — NOT NULL
- return_date — DATE — NOT NULL
- overdue_days — INT — NOT NULL
- overdue_fee — INT — NOT NULL