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