XSpark

Tables (13)

t_auth

  • socialId — varchar(128) — Primary key — NOT NULL
  • userId — binary(16) — Foreign key → t_user.userId — NOT NULL
  • authType — enum('google','kakao','naver','guest') — NOT NULL
  • authToken — varchar(256) — NOT NULL
  • ip — binary(16) — NOT NULL
  • token — binary(16) — NOT NULL
  • createDate — timestamp(6) — NOT NULL

t_industry_preference

  • id — int — Primary key — NOT NULL
  • key — varchar(32) — NOT NULL
  • label — varchar(128) — NOT NULL
  • description — varchar(256)
  • sortOrder — int — NOT NULL
  • icon — varchar(8) — Emoji icon for display

t_live_composite

  • id — int — Primary key — NOT NULL
  • userId — binary(16) — Foreign key → t_user.userId — NOT NULL
  • personaId — bigint
  • modelImageUrl — text — NOT NULL
  • productImageUrl — text — NOT NULL
  • productCleanImageUrl — text
  • compositedImageUrl — text
  • taskId — varchar(128)
  • status — varchar(32) — NOT NULL
  • errorMessage — text
  • extra — json
  • isDeleted — tinyint — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL

t_model

  • id — int — Primary key — NOT NULL
  • userId — binary(16) — Foreign key → t_user.userId — NOT NULL
  • pricingType — varchar(32) — NOT NULL — 가격 정책: flat | share
  • name — varchar(128) — NOT NULL — 사용자 정의 모델명
  • contractPeriod — varchar(32) — NOT NULL — 계약 기간(개월 등 문자열)
  • basicScope — json — 기본 사용 범위 배열
  • highRiskScope — json — 고위험 사용 범위 배열
  • secondConfirm — tinyint(1) — NOT NULL — 2차 컨펌 여부
  • signatureUrl — varchar(512) — 전자서명 이미지 파일 URL
  • portfolioImages — json — NOT NULL — 포트폴리오 이미지 URL 배열
  • portfolioAudioUrls — json — NOT NULL — 포트폴리오 사운드(MP3) URL 배열
  • reviewStatus — enum('none', 'processing', 'trained', 'approved', 'rejected', 'inactive') — NOT NULL — 검수 상태: none | processing | trained | approved | rejected | inactive
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • isActive — tinyint(1) — NOT NULL — 운영 활성 상태
  • industry_preference — json — 산업 선호도 ID 배열
  • sensitive_industry — json — 민감 산업 ID 배열
  • usage_scope — json — 사용 범위 ID 배열
  • pricePerUse — int
  • headline — varchar(255) — 모델 헤드라인
  • description — text — 모델 상세 설명
  • instagramUrl — varchar(512) — SNS instagram URL
  • youtubeUrl — varchar(512) — SNS youtube URL
  • otherUrl — varchar(512) — Other reference URL
  • defaultPersonaId — bigint

t_model_persona

  • personaId — bigint — Primary key — NOT NULL
  • isPrimary — tinyint(1) — Primary key — NOT NULL
  • modelId — int — Foreign key → t_model.id — NOT NULL
  • userId — binary(16) — NOT NULL
  • name — varchar(128) — NOT NULL
  • visibility — enum('private','public') — NOT NULL
  • status — enum('draft','queued','training','ready','error','inactive') — NOT NULL
  • triggerWord — varchar(64)
  • imageDatasetUrls — json — NOT NULL
  • audioDatasetUrls — json — NOT NULL
  • trainingState — json — NOT NULL
  • voiceOptions — json
  • previewImageUrls — json
  • previewAudioUrls — json
  • voiceDurationSeconds — int
  • metadata — json
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • loraTaskId — varchar(128)
  • loraId — varchar(256)
  • voiceTaskId — varchar(128)
  • voiceId — varchar(256)
  • voiceTaskIdMinimax — varchar(128)
  • voiceIdMinimax — varchar(256)

t_payments

  • id — bigint — Primary key — NOT NULL
  • confirmRequestId — bigint — Foreign key → t_task_confirm_requests.id
  • taskId — varchar(128) — NOT NULL
  • buyerUserId — varchar(64) — NOT NULL
  • creatorUserId — varchar(64) — NOT NULL
  • amount — int — NOT NULL
  • currency — char(3) — NOT NULL
  • status — enum('pending','paid','failed','refunded') — NOT NULL
  • method — varchar(32) — NOT NULL
  • detail — json
  • approvedAt — datetime
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL

t_sensitive_industry

  • id — int — Primary key — NOT NULL
  • code — varchar(64) — NOT NULL
  • label — varchar(128) — NOT NULL
  • category — varchar(64)
  • description — varchar(256)
  • sortOrder — int — NOT NULL
  • categoryLabel — varchar(128) — Display label for category
  • categoryDescription — varchar(256) — Description for category
  • categoryOrder — int — NOT NULL — Ordering of category

t_task_confirm_requests

  • id — bigint — Primary key — NOT NULL
  • taskId — varchar(128) — Foreign key → t_tasks.taskId — NOT NULL
  • buyerUserId — varchar(64) — NOT NULL
  • creatorUserId — varchar(64) — NOT NULL
  • personaId — bigint
  • modelId — int
  • amount — int — NOT NULL
  • currency — char(3) — NOT NULL
  • status — enum('pending','accepted','rejected','canceled') — NOT NULL
  • paymentId — bigint — Foreign key → t_payments.id
  • message — text
  • respondedAt — datetime
  • rejectReason — text
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL

t_task_licenses

  • id — bigint — Primary key — NOT NULL
  • taskId — varchar(128) — Foreign key → t_tasks.taskId — NOT NULL
  • buyerUserId — varchar(64) — NOT NULL
  • creatorUserId — varchar(64) — NOT NULL
  • confirmRequestId — bigint — Foreign key → t_task_confirm_requests.id — NOT NULL
  • status — enum('active','expired','revoked') — NOT NULL
  • startsAt — datetime — NOT NULL
  • expiresAt — datetime — NOT NULL
  • revokedReason — text
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL

t_tasks

  • taskId — varchar(128) — Primary key — NOT NULL
  • userId — varchar(64)
  • type — varchar(32)
  • status — varchar(32) — NOT NULL
  • progress — int — NOT NULL
  • step — varchar(128)
  • requestOriginal — json
  • result — json
  • error — text
  • logs — json
  • cancelRequested — tinyint(1) — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • promptTaskId — varchar(128)
  • isRemoved — tinyint(1) — NOT NULL
  • category — varchar(32)
  • heartbeatAt — datetime
  • licenseStatus — varchar(32) — NOT NULL
  • licenseExpiresAt — datetime

t_template

  • id — int — Primary key — NOT NULL
  • name — varchar(64) — NOT NULL
  • template — longtext
  • toneSpeeds — json
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL

t_usage_scope

  • id — int — Primary key — NOT NULL
  • code — varchar(64) — NOT NULL
  • label — varchar(128) — NOT NULL
  • section — varchar(64)
  • subsection — varchar(64)
  • sortOrder — int — NOT NULL
  • sectionLabel — varchar(128) — Display label for section
  • sectionOrder — int — NOT NULL — Ordering of section
  • subsectionLabel — varchar(128) — Display label for subsection
  • subsectionOrder — int — NOT NULL — Ordering of subsection

t_user

  • userId — binary(16) — Primary key — NOT NULL
  • nickName — varchar(128) — NOT NULL
  • point — decimal(10,1) — NOT NULL
  • image — varchar(256)
  • status — enum('normal','delete') — NOT NULL
  • signInDate — timestamp — NOT NULL
  • createDate — datetime(6) — NOT NULL
  • email — varchar(256)
  • role — enum('admin','user') — NOT NULL
  • preference — json