prography
Tables (9)
attendances
- id — BIGINT
- session_id — BIGINT — Foreign key → sessions.id — NOT NULL
- member_id — BIGINT — Foreign key → members.id — NOT NULL
- qrcode_id — BIGINT — Foreign key → qrcodes.id
- status — VARCHAR(20) — NOT NULL — enum (예: PRESENT, LATE, ABSENT, ...)
- late_minutes — INT — NOT NULL
- penalty_amount — INT — NOT NULL
- reason — VARCHAR(500)
- checked_in_at — TIMESTAMP(3)
- created_at — TIMESTAMP(3) — NOT NULL
- updated_at — TIMESTAMP(3) — NOT NULL
cohort_members
- id — BIGINT
- member_id — BIGINT — Foreign key → members.id — NOT NULL
- cohort_id — BIGINT — Foreign key → cohorts.id — NOT NULL
- part_id — BIGINT — Foreign key → parts.id
- team_id — BIGINT — Foreign key → teams.id
- deposit — INT — NOT NULL
- excuse_count — INT — NOT NULL
- created_at — TIMESTAMP(3) — NOT NULL
- updated_at — TIMESTAMP(3) — NOT NULL
cohorts
- id — BIGINT
- generation — INT — NOT NULL
- name — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP(3) — NOT NULL
- updated_at — TIMESTAMP(3) — NOT NULL
deposit_histories
- id — BIGINT
- cohort_member_id — BIGINT — Foreign key → cohort_members.id — NOT NULL
- attendance_id — BIGINT — Foreign key → attendances.id
- type — VARCHAR(20) — NOT NULL — enum (예: DEPOSIT, WITHDRAW, PENALTY, ...)
- amount — INT — NOT NULL
- balance_after — INT — NOT NULL
- description — VARCHAR(500)
- created_at — TIMESTAMP(3) — NOT NULL
members
- id — BIGINT
- login_id — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- phone — VARCHAR(30)
- status — VARCHAR(20) — NOT NULL — enum (예: ACTIVE, INACTIVE, ...)
- role — VARCHAR(20) — NOT NULL — enum (예: ADMIN, MEMBER, ...)
- created_at — TIMESTAMP(3) — NOT NULL
- updated_at — TIMESTAMP(3) — NOT NULL
parts
- id — BIGINT
- cohort_id — BIGINT — Foreign key → cohorts.id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP(3) — NOT NULL
- updated_at — TIMESTAMP(3) — NOT NULL
qrcodes
- id — BIGINT
- session_id — BIGINT — Foreign key → sessions.id — NOT NULL
- hash_value — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP(3) — NOT NULL
- expires_at — TIMESTAMP(3) — NOT NULL
sessions
- id — BIGINT
- cohort_id — BIGINT — Foreign key → cohorts.id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- date — DATE — NOT NULL
- time — TIME — NOT NULL
- location — VARCHAR(200)
- status — VARCHAR(20) — NOT NULL — enum (예: OPEN, CLOSED, ...)
- created_at — TIMESTAMP(3) — NOT NULL
- updated_at — TIMESTAMP(3) — NOT NULL
teams
- id — BIGINT
- cohort_id — BIGINT — Foreign key → cohorts.id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP(3) — NOT NULL
- updated_at — TIMESTAMP(3) — NOT NULL