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