prography-erd
Tables (9)
attendances
- id — BIGINT — Primary key — NOT NULL
- session_id — BIGINT — Foreign key → sessions.id — NOT NULL
- cohort_member_id — BIGINT — Foreign key → cohort_members.id — NOT NULL
- qr_code_id — BIGINT — Foreign key → qr_codes.id
- status — VARCHAR(20) — NOT NULL
- late_minutes — INT
- penalty_amount — BIGINT — NOT NULL
- reason — VARCHAR(200)
- checked_in_at — DATETIME(6)
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
cohort_members
- id — BIGINT — Primary key — NOT NULL
- 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 — NOT NULL
- team_id — BIGINT — Foreign key → teams.id
- deposit_balance — BIGINT — NOT NULL
- excuse_count — BIGINT — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
cohorts
- id — BIGINT — Primary key — NOT NULL
- number — INT — NOT NULL
- current — BIT(1) — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
deposit_histories
- id — BIGINT — Primary key — NOT NULL
- cohort_member_id — BIGINT — Foreign key → cohort_members.id — NOT NULL
- type — VARCHAR(20) — NOT NULL
- amount — BIGINT — NOT NULL
- balance_after — BIGINT — NOT NULL
- attendance_id — BIGINT
- description — VARCHAR(200) — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
members
- id — BIGINT — Primary key — NOT NULL
- login_id — VARCHAR(50) — NOT NULL
- password — VARCHAR(200) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- role — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
parts
- id — BIGINT — Primary key — NOT NULL
- cohort_id — BIGINT — Foreign key → cohorts.id — NOT NULL
- part_type — VARCHAR(20) — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
qr_codes
- id — BIGINT — Primary key — NOT NULL
- session_id — BIGINT — Foreign key → sessions.id — NOT NULL
- hash_value — VARCHAR(100) — NOT NULL
- expires_at — DATETIME(6) — NOT NULL
- active — BIT(1) — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
sessions
- id — BIGINT — Primary key — NOT NULL
- cohort_id — BIGINT — Foreign key → cohorts.id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- date — DATE — NOT NULL
- time — TIME — NOT NULL
- location — VARCHAR(100) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
teams
- id — BIGINT — Primary key — NOT NULL
- cohort_id — BIGINT — Foreign key → cohorts.id — NOT NULL
- name — VARCHAR(50) — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)