세투연
테이블 (6)
attendance_codes
- id — BIGINT — 기본 키 — NOT NULL
- event_id — BIGINT — 외래 키 → events.id — NOT NULL
- code — VARCHAR(20) — NOT NULL
- expires_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
attendances
- id — BIGINT — 기본 키 — NOT NULL
- event_id — BIGINT — 외래 키 → events.id — NOT NULL
- member_id — BIGINT — 외래 키 → members.id — NOT NULL
- application_id — BIGINT — 외래 키 → event_applications.id — NOT NULL
- checked_in_at — DATETIME — NOT NULL
event_applications
- id — BIGINT — 기본 키 — NOT NULL
- event_id — BIGINT — 외래 키 → events.id — NOT NULL
- member_id — BIGINT — 외래 키 → members.id — NOT NULL
- status — ENUM('PENDING', 'APPROVED', 'REJECTED', 'CANCELED') — NOT NULL
- applied_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
events
- id — BIGINT — 기본 키 — NOT NULL
- title — VARCHAR(100) — NOT NULL
- description — TEXT
- location — VARCHAR(100)
- capacity — INT — NOT NULL
- start_at — DATETIME — NOT NULL
- end_at — DATETIME — NOT NULL
- status — ENUM('DRAFT', 'OPEN', 'CLOSED', 'COMPLETED', 'CANCELED') — NOT NULL
- created_by — BIGINT — 외래 키 → members.id — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- Field
- Field2
feedbacks
- id — BIGINT — 기본 키 — NOT NULL
- event_id — BIGINT — 외래 키 → events.id — NOT NULL
- member_id — BIGINT — 외래 키 → members.id — NOT NULL
- rating — INT — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
members
- id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- role — ENUM('MEMBER', 'STAFF', 'ADMIN') — NOT NULL
- created_at — DATETIME — NOT NULL