도서대여관리 수정
테이블 (5)
activity_log
- log_id — INT — 기본 키 — NOT NULL
- employee_id — VARCHAR(10) — 외래 키 — NOT NULL
- activity_type — VARCHAR(255)
- activity_time — DATETIME
book
- book_id — VARCHAR(10) — 기본 키 — NOT NULL
- book_title — VARCHAR(255)
- publisher — VARCHAR(255)
- author — VARCHAR(255)
- genre — VARCHAR(255)
- rental_fee — INT
- rental_period — INT
- overdue_fee — INT
employee
- employee_id — VARCHAR(10) — 기본 키 — NOT NULL
- name — VARCHAR(255)
- phone — VARCHAR(20)
- address — VARCHAR(255)
- password — VARCHAR(255)
- is_admin — BOOLEAN
member
- member_id — VARCHAR(10) — 기본 키 — NOT NULL
- name — VARCHAR(255)
- phone — VARCHAR(20)
- address — VARCHAR(255)
- mileage — INT
- rental_books — VARCHAR(255)
- password — VARCHAR(255)
rental
- book_id — VARCHAR(10) — 외래 키 — NOT NULL
- member_id — VARCHAR(10) — 외래 키 — NOT NULL
- rental_date — DATE
- return_date — DATE
- rental_status — VARCHAR(20)