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
- late_minutes — INT
- penalty_amount — INT — NOT NULL
- reason — VARCHAR(255)
- checked_in_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
cohort_members
- id — BIGINT
- cohort_id — BIGINT — Foreign key → cohorts.id — NOT NULL
- member_id — BIGINT — Foreign key → members.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 — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
cohorts
- id — BIGINT
- generation — INT — NOT NULL
- name — VARCHAR(50) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — 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
- amount — INT — NOT NULL
- balance_after — INT — NOT NULL
- description — VARCHAR(255)
- created_at — DATETIME — NOT NULL
members
- id — BIGINT
- login_id — VARCHAR(50) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- phone — VARCHAR(30)
- status — VARCHAR(20) — NOT NULL
- role — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
parts
- id — BIGINT
- cohort_id — BIGINT — Foreign key → cohorts.id — NOT NULL
- name — VARCHAR(30) — NOT NULL
qrcodes
- id — BIGINT
- session_id — BIGINT — Foreign key → sessions.id — NOT NULL
- hash_value — VARCHAR(64) — NOT NULL
- created_at — DATETIME — NOT NULL
- expires_at — DATETIME — NOT NULL
- revoked_at — DATETIME
sessions
- id — BIGINT
- cohort_id — BIGINT — Foreign key → cohorts.id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- session_date — DATE — NOT NULL
- session_time — TIME — NOT NULL
- location — VARCHAR(100)
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
teams
- id — BIGINT
- cohort_id — BIGINT — Foreign key → cohorts.id — NOT NULL
- name — VARCHAR(30) — NOT NULL