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