asdf
Tables (7)
books
- book_id — serial
- title — varchar(255) — NOT NULL
- original_title — varchar(255)
- author — varchar(255) — NOT NULL
- publisher_id — integer — Foreign key → publishers.publisher_id
- location_id — integer — Foreign key → locations.location_id
- category_id — integer — Foreign key → categories.category_id
- isbn — varchar(20)
- published_year — date
- call_no — varchar(64)
- status — enum('AVAILABLE', 'LOANED', 'RESERVED', 'LOST')
- is_damaged — boolean — NOT NULL
- created_at — timestamp
categories
- category_id — serial
- category_name — varchar(100) — NOT NULL
loans
- loan_id — serial
- user_id — integer — Foreign key → users.user_id — NOT NULL
- book_id — integer — Foreign key → books.book_id — NOT NULL
- loan_date — date — NOT NULL
- due_date — date — NOT NULL
- return_date — date
- is_extended — boolean
locations
- location_id — serial
- location_name — varchar(255) — NOT NULL
publishers
- publisher_id — serial
- publisher_name — varchar(255) — NOT NULL
reservation
- reserved_id — serial
- user_id — integer — Foreign key → users.user_id — NOT NULL
- book_id — integer — Foreign key → books.book_id — NOT NULL
- reserved_at — timestamp
users
- user_id — serial
- name — varchar(100) — NOT NULL
- birth_date — date
- email — varchar(255) — NOT NULL
- password_hash — char(80) — NOT NULL
- phone — varchar(20)
- address — varchar(255)
- user_type — enum('정회원', '준회원') — NOT NULL
- loan_available_date — date
- loaned_book_count — integer