객소공
테이블 (4)
직원 (EMPLOYEE)
- employee_id — VARCHAR(20) — 기본 키 — NOT NULL
- first_name — VARCHAR(50) — NOT NULL
- last_name — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- phone_number — VARCHAR(20)
- position — VARCHAR(100)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
학습동아리 (STUDY_CLUB)
- study_club_id — INT — 기본 키 — NOT NULL
- club_name — VARCHAR(100) — NOT NULL
- description — TEXT
- manager_id — VARCHAR(20) — NOT NULL
- max_members — INT
- is_active — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
학습동아리 구성원 (STUDY_CLUB_MEMBER)
- member_id — INT — 기본 키 — NOT NULL
- study_club_id — INT — 외래 키 → 학습동아리.study_club_id — NOT NULL
- employee_id — VARCHAR(20) — 외래 키 → 직원.employee_id — NOT NULL
- join_date — DATE — NOT NULL
- is_active — BOOLEAN
- role — ENUM('MEMBER', 'MODERATOR')
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
학습동아리 운영자 (STUDY_CLUB_MANAGER)
- manager_id — INT — 기본 키 — NOT NULL
- study_club_id — INT — 외래 키 → 학습동아리.study_club_id — NOT NULL
- employee_id — VARCHAR(20) — 외래 키 → 직원.employee_id — NOT NULL
- appointed_date — DATE — NOT NULL
- is_active — BOOLEAN
- manager_level — ENUM('MANAGER', 'ADMIN')
- created_at — TIMESTAMP
- updated_at — TIMESTAMP