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