2026CarpeDM_EXPO
Tables (12)
auth_identity
- identity_id — CHAR(36) — Primary key — NOT NULL — 인증수단 UUID
- user_id — CHAR(36) — Foreign key → user.user_id — NOT NULL
- provider — VARCHAR(20) — NOT NULL — local|kakao|naver|google|apple
- provider_uid — VARCHAR(191) — NOT NULL — local=이메일/유저키, 소셜=제공자 uid
- password_hash — VARCHAR(255) — local일 때만(bcrypt/argon2)
- created_at — DATETIME — NOT NULL
consent
- consent_id — CHAR(36) — Primary key — NOT NULL
- session_id — CHAR(36) — Foreign key → session.session_id — NOT NULL
- policy_version — VARCHAR(20) — NOT NULL — 동의문구 버전
- scope — JSON — 음성·영상·결과
- agreed_at — DATETIME — NOT NULL
org_invite
- invite_id — CHAR(36) — Primary key — NOT NULL
- org_id — CHAR(36) — Foreign key → organization.org_id — NOT NULL
- code — VARCHAR(64) — NOT NULL — 기관 발급 코드
- email — VARCHAR(255) — 특정인 지정 초대(선택)
- role — VARCHAR(20) — NOT NULL
- max_uses — INT — NOT NULL — 1=단일좌석, N=다좌석
- used_count — INT — NOT NULL
- expires_at — DATETIME
- created_by_user_id — CHAR(36) — Foreign key → user.user_id — 발급한 관리자
- created_at — DATETIME — NOT NULL
org_membership
- membership_id — CHAR(36) — Primary key — NOT NULL
- org_id — CHAR(36) — Foreign key → organization.org_id — NOT NULL
- user_id — CHAR(36) — Foreign key → user.user_id — NOT NULL
- role — VARCHAR(20) — NOT NULL — admin|member
- joined_at — DATETIME — NOT NULL
organization
- org_id — CHAR(36) — Primary key — NOT NULL
- name — VARCHAR(150) — NOT NULL
- plan — VARCHAR(30) — 요금제/라이선스
- seat_limit — INT — 허용 좌석 수
- is_active — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
report
- report_id — CHAR(36) — Primary key — NOT NULL
- session_id — CHAR(36) — Foreign key → session.session_id — NOT NULL — 세션과 1:1
- overall_score — INT — 0-100
- summary — JSON — 강약점·개선제안
- created_at — DATETIME — NOT NULL
scenario
- scenario_id — INT — Primary key — NOT NULL — 실DB: AUTO_INCREMENT
- title — VARCHAR(100) — NOT NULL
- situation_prompt — TEXT — NOT NULL
- formality_target — VARCHAR(20) — 합쇼체|해요체|반말
- directness_stance — VARCHAR(20) — 직접우선|완곡우선
- display_order — INT — NOT NULL
- is_active — TINYINT(1) — NOT NULL
score
- score_id — BIGINT — Primary key — NOT NULL — 실DB: AUTO_INCREMENT
- report_id — CHAR(36) — Foreign key → report.report_id — NOT NULL
- axis — VARCHAR(10) — NOT NULL — 응답|음성|표현|자세
- value — INT — NOT NULL — 0-100
- detail — JSON — 축별 세부지표(응답=맥락/목적/명확/관계, 음성=속도/성량/피치 등)
- comment — TEXT
serial_code
- code_id — CHAR(36) — Primary key — NOT NULL
- code — VARCHAR(64) — NOT NULL — 고엔트로피 발급 코드
- session_id — CHAR(36) — Foreign key → session.session_id — NOT NULL — 익명세션과 1:1
- claimed_by_user_id — CHAR(36) — Foreign key → user.user_id
- expires_at — DATETIME — NOT NULL — claim window: 발급 +7일
- consumed_at — DATETIME — 이관 후 1회 소비
- created_at — DATETIME — NOT NULL
session
- session_id — CHAR(36) — Primary key — NOT NULL — 코칭(연습) 세션 UUID
- scenario_id — INT — Foreign key → scenario.scenario_id — NOT NULL
- user_id — CHAR(36) — Foreign key → user.user_id — NULL=익명 전시세션(미이관 시 30일 후 파기)
- source — VARCHAR(20) — NOT NULL — expo_kiosk|web
- status — VARCHAR(20) — NOT NULL — completed|abandoned
- started_at — DATETIME — NOT NULL
- ended_at — DATETIME
turn
- turn_id — CHAR(36) — Primary key — NOT NULL
- session_id — CHAR(36) — Foreign key → session.session_id — NOT NULL
- turn_index — INT — NOT NULL
- speaker — VARCHAR(10) — NOT NULL — user|actor
- content — TEXT — NOT NULL — STT/생성 텍스트 (원본음성 미저장)
- created_at — DATETIME — NOT NULL
user
- user_id — CHAR(36) — Primary key — NOT NULL — 사용자 UUID
- email — VARCHAR(255) — 계정 이메일(소셜 전용은 NULL 가능)
- display_name — VARCHAR(100)
- is_active — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL