test
Tables (5)
book
- book_code — INT
- title — VARCHAR(200) — NOT NULL
- author — VARCHAR(100) — NOT NULL
- pub_id — INT — Foreign key → publisher.pub_id
- pub_year — YEAR
- stock — INT
- cat_code — CHAR(3) — Foreign key → category.cat_code
category
- cat_code — CHAR(3)
- cat_name — VARCHAR(50) — NOT NULL
loan
- loan_id — INT
- mem_id — INT — Foreign key → member.mem_id — NOT NULL
- book_code — INT — Foreign key → book.book_code — NOT NULL
- loan_date — DATE — NOT NULL
- due_date — DATE — NOT NULL
- return_date — DATE
member
- mem_id — INT
- mem_name — VARCHAR(50) — NOT NULL
- phone — VARCHAR(20)
- email — VARCHAR(100)
- join_date — DATE
publisher
- pub_id — INT
- pub_name — VARCHAR(100) — NOT NULL
- phone — VARCHAR(20)
- address — VARCHAR(200)