데베설기말
테이블 (7)
Book (책)
- id — INTEGER
- name — VARCHAR(255) — NOT NULL
- author — VARCHAR(255) — NOT NULL
- publisher — VARCHAR(255) — NOT NULL
- category_num — VARCHAR(50) — NOT NULL
- classification — VARCHAR(255) — NOT NULL
- publication_date — DATE — NOT NULL
- UNIQUE(category_num, — classification)
BookLog (로그)
- log_id — INTEGER
- book_id — INTEGER — NOT NULL
- member_id — INTEGER
- librarian_id — INTEGER
- log_date — TIMESTAMP
- previous_status — VARCHAR(50) — NOT NULL
- current_status — VARCHAR(50) — NOT NULL
BookStatus (책 상태)
- id — INTEGER
- book_id — INTEGER
- member_id — INTEGER
- librarian_id — INTEGER — NOT NULL
- status — ENUM('대출 중', '정리 중', '분실', '대출 가능') — NOT NULL
- date — TIMESTAMP
- due_date — TIMESTAMP
- extension — INTEGER
Category (분류)
- id — VARCHAR(50)
- description — VARCHAR(255) — NOT NULL
Librarian (사서)
- id — INTEGER
- email — VARCHAR(255) — NOT NULL
- pw — VARCHAR(10) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- birth — DATE — NOT NULL
- contact — VARCHAR(50) — NOT NULL
Member (회원)
- id — INTEGER
- email — VARCHAR(255) — NOT NULL
- pw — VARCHAR(10) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- birth — DATE — NOT NULL
- contact — VARCHAR(50) — NOT NULL
Reservation (예약)
- id — INTEGER
- book_id — INTEGER — NOT NULL
- member_id — INTEGER — NOT NULL
- reservation_date — TIMESTAMP