연습용
테이블 (5)
books
- book_id — INT — 기본 키 — NOT NULL
- title — VARCHAR(255) — NOT NULL
- author — VARCHAR(255) — NOT NULL
- publisher — VARCHAR(255)
- price — DECIMAL(10,2)
- category_id — INT — NOT NULL
categories
- category_id — INT — 기본 키 — NOT NULL
- category_name — VARCHAR(255) — NOT NULL
- position — INT
departments
- department_id — INT — 기본 키 — NOT NULL
- department_name — VARCHAR(255) — NOT NULL
loans
- loan_id — INT — 기본 키 — NOT NULL
- loan_date — DATETIME — NOT NULL
- return_date — DATETIME — NOT NULL
- student_id — INT — NOT NULL
- book_id — INT — NOT NULL
students
- student_id — INT — 기본 키 — NOT NULL
- name — VARCHAR(255)
- address — VARCHAR(255)
- phone — VARCHAR(50)
- department_id — INT — NOT NULL
- department_id (department_id2) — INT — 외래 키 → departments.department_id — NOT NULL