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)