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