helloworldlabs

Tables (13)

attendance_records

  • id — BIGINT — Primary key — NOT NULL
  • offering_id — BIGINT — Foreign key → offerings.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • section_id — BIGINT — Foreign key → program_sections.id — NOT NULL — 구 curriculum_id
  • status — VARCHAR(20) — NOT NULL — PRESENT, LATE, LEAVE, ABSENT
  • check_method — VARCHAR(20) — NOT NULL — QR, MANUAL, SYSTEM
  • exception_reason — TEXT — 수동 변경 시 필수 입력 사유
  • checked_at — DATETIME — NOT NULL
  • updated_by — BIGINT — Foreign key → users.id — 수동 변경한 관리자 ID

completion_records

  • id — BIGINT — Primary key — NOT NULL
  • offering_id — BIGINT — Foreign key → offerings.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • status — VARCHAR(20) — NOT NULL — PASS, FAIL
  • judged_at — DATETIME — NOT NULL
  • judged_by — BIGINT — 판단한 관리자 ID
  • snapshot_data — JSON — 수료증 발급용 고정 데이터(과정명, 기간 등)

institution_members

  • id — BIGINT — Primary key — NOT NULL
  • institution_id — BIGINT — Foreign key → institutions.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • role — VARCHAR(20) — NOT NULL — MANAGER, INSTRUCTOR, STUDENT
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL

institutions

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL — 기관명
  • status — VARCHAR(20) — NOT NULL — Active/Inactive/Suspended
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

instructor_profiles

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • bio — TEXT — 약력 소개
  • expertise — VARCHAR(255) — 전문 분야
  • updated_at — DATETIME — NOT NULL

offering_members

  • id — BIGINT — Primary key — NOT NULL
  • offering_id — BIGINT — Foreign key → offerings.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • role — VARCHAR(20) — NOT NULL — STUDENT, INSTRUCTOR
  • joined_at — DATETIME — NOT NULL

offerings

  • id — BIGINT — Primary key — NOT NULL
  • institution_id — BIGINT — Foreign key → institutions.id — NOT NULL — 운영 주체 기관
  • program_id — BIGINT — Foreign key → programs.id — NOT NULL — 기반 프로그램
  • type — VARCHAR(20) — NOT NULL — PRIMARY(단독), SECONDARY(하도급)
  • status — VARCHAR(20) — NOT NULL — READY, RUNNING, DONE, CLOSED
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • created_at — DATETIME — NOT NULL

operation_logs

  • id — BIGINT — Primary key — NOT NULL
  • offering_id — BIGINT — Foreign key → offerings.id — NOT NULL
  • type — VARCHAR(20) — NOT NULL — ISSUE, CONSULTATION, RESULT
  • status — VARCHAR(20) — NOT NULL — DRAFT, CONFIRMED, ARCHIVED
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT
  • attachments — JSON — 첨부파일 메타데이터 배열
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT — Foreign key → users.id — NOT NULL

program_sections

  • id — BIGINT — Primary key — NOT NULL
  • program_id — BIGINT — Foreign key → programs.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • type — VARCHAR(20) — NOT NULL — VIDEO, PDF, QUIZ
  • external_link — VARCHAR(500) — Vimeo/S3 Link
  • sequence_order — INT — NOT NULL

programs

  • id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • is_template — TINYINT(1) — 템플릿 여부
  • created_at — DATETIME — NOT NULL

qr_logs

  • id — BIGINT — Primary key — NOT NULL
  • offering_id — BIGINT — Foreign key → offerings.id — NOT NULL
  • input_name — VARCHAR(100) — NOT NULL — 사용자 입력 이름
  • scanned_at — DATETIME — NOT NULL
  • match_status — VARCHAR(20) — NOT NULL — MATCHED, UNMATCHED

settlement_records

  • id — BIGINT — Primary key — NOT NULL
  • offering_id — BIGINT — Foreign key → offerings.id — NOT NULL
  • item_name — VARCHAR(200) — NOT NULL
  • amount — DECIMAL(15, 2) — NOT NULL
  • vat — DECIMAL(15, 2) — NOT NULL
  • status — VARCHAR(20) — NOT NULL — DRAFT, SHARED, ISSUED
  • created_at — DATETIME — NOT NULL

users

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL — 로그인 ID
  • name — VARCHAR(100) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • global_role — VARCHAR(20) — NOT NULL — SYS_ADMIN, USER (플랫폼 전체 권한)
  • is_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL