ai챗
테이블 (41)
ad_reward_config
- id — INT — 기본 키 — NOT NULL
- rewardAmount — INT — NOT NULL
- maxPerDay — INT — NOT NULL
- updatedAt — DATETIME — NOT NULL
ad_watch_logs
- id — VARCHAR(36) — 기본 키 — NOT NULL
- userId — VARCHAR(36) — 외래 키 → users.id — NOT NULL
- transactionId — VARCHAR(36) — 외래 키 → transactions.id
- watchedAt — DATETIME — NOT NULL
- adType — VARCHAR(20) — NOT NULL
- adUnitId — VARCHAR(255)
- createdAt — DATETIME — NOT NULL
ai_model_catalog
- modelId — VARCHAR(256) — 기본 키 — NOT NULL
- displayName — VARCHAR(256) — NOT NULL
- promptPricePerMtokUsd — DECIMAL(12,6) — NOT NULL
- completionPricePerMtokUsd — DECIMAL(12,6) — NOT NULL
- contextLength — INT
- scope — VARCHAR(8) — NOT NULL
- disableReasoning — BOOLEAN — NOT NULL
- permissiveSafety — BOOLEAN — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
app_logs
- id — VARCHAR(36) — 기본 키 — NOT NULL
- method — VARCHAR(20) — NOT NULL
- url — TEXT — NOT NULL
- statusCode — INT — NOT NULL
- duration — INT — NOT NULL
- ip — VARCHAR(128)
- userAgent — TEXT
- userId — VARCHAR(36)
- error — TEXT
- level — VARCHAR(20) — NOT NULL
- category — VARCHAR(50) — NOT NULL
- createdAt — DATETIME — NOT NULL
app_versions
- id — VARCHAR(36) — 기본 키 — NOT NULL
- platform — VARCHAR(20) — NOT NULL
- minVersion — VARCHAR(50) — NOT NULL
- latestVersion — VARCHAR(50) — NOT NULL
- updateType — VARCHAR(20) — NOT NULL
- rolloutPercent — INT — NOT NULL
- updateTitle — VARCHAR(255) — NOT NULL
- updateContent — TEXT — NOT NULL
- storeUrl — VARCHAR(2048) — NOT NULL
- isActive — BOOLEAN — NOT NULL
- testDevices — JSON
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
character_block
- id — INT — 기본 키 — NOT NULL
- userId — VARCHAR(36) — 외래 키 → users.id — NOT NULL
- characterId — VARCHAR(36) — 외래 키 → characters.id — NOT NULL
- source — VARCHAR(20) — NOT NULL
- createdAt — DATETIME — NOT NULL
character_chat_boosts
- id — VARCHAR(36) — 기본 키 — NOT NULL
- characterId — VARCHAR(36) — 외래 키 → characters.id — NOT NULL
- boostCount — INT — NOT NULL
- updatedAt — DATETIME — NOT NULL
character_likes
- id — INT — 기본 키 — NOT NULL
- characterId — VARCHAR(36) — 외래 키 → characters.id — NOT NULL
- userId — VARCHAR(36) — 외래 키 → users.id — NOT NULL
- createdAt — DATETIME — NOT NULL
character_rejection_messages
- id — VARCHAR(36) — 기본 키 — NOT NULL
- characterId — VARCHAR(36) — NOT NULL
- message — TEXT — NOT NULL
- isGenerated — BOOLEAN — NOT NULL
- createdAt — DATETIME — NOT NULL
character_report
- id — INT — 기본 키 — NOT NULL
- userId — VARCHAR(36) — 외래 키 → users.id — NOT NULL
- characterId — VARCHAR(36) — 외래 키 → characters.id — NOT NULL
- content — TEXT — NOT NULL
- createdAt — DATETIME — NOT NULL
character_views
- id — VARCHAR(36) — 기본 키 — NOT NULL
- userId — VARCHAR(36) — 외래 키 → users.id — NOT NULL
- characterId — VARCHAR(36) — 외래 키 → characters.id — NOT NULL
- viewedAt — DATETIME — NOT NULL
characters
- id — VARCHAR(36) — 기본 키 — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — TEXT — NOT NULL
- personaPrompt — TEXT — NOT NULL
- supremeDirective — TEXT
- systemPrompt — TEXT
- profileImageUrl — VARCHAR(2048)
- firstMessage — TEXT — NOT NULL
- introduction — TEXT
- rejectionMessages — JSON
- callsignAlias — TEXT
- ageGender — TEXT
- physicalDescription — TEXT
- roleTitle — TEXT
- hashtags — JSON
- coreTrait — TEXT
- lorePast — TEXT
- loreCurrent — TEXT
- loreRelationship — TEXT
- mainQuotes — JSON
- openingScenario — TEXT
- firstScriptItems — JSON
- backgroundSequences — JSON
- temperature — FLOAT
- topP — FLOAT
- isActive — BOOLEAN — NOT NULL
- is_public — BOOLEAN — NOT NULL
- language — VARCHAR(16) — NOT NULL
- user_id — VARCHAR(36) — 외래 키 → users.id
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
chat_bookmarks
- id — INT — 기본 키 — NOT NULL
- userId — VARCHAR(36) — 외래 키 → users.id — NOT NULL
- roomId — VARCHAR(36) — 외래 키 → chat_rooms.id — NOT NULL
- messageId — VARCHAR(36) — NOT NULL — consume/charge/ad_reward/refund
- content — TEXT — NOT NULL
- narration — TEXT
- createdAt — DATETIME — NOT NULL
chat_export_audits
- id — VARCHAR(36) — 기본 키 — NOT NULL
- adminUserId — VARCHAR(36) — NOT NULL
- roomId — VARCHAR(36) — NOT NULL
- targetUserEmail — VARCHAR(255)
- targetCharacterId — VARCHAR(36)
- targetCharacterName — VARCHAR(255)
- format — VARCHAR(10) — NOT NULL
- messageCount — INT — NOT NULL
- ip — VARCHAR(64) — NOT NULL
- userAgent — TEXT — NOT NULL
- createdAt — DATETIME — NOT NULL
chat_messages
- id — VARCHAR(36) — 기본 키 — NOT NULL
- roomId — VARCHAR(36) — 외래 키 → chat_rooms.id — NOT NULL
- role — VARCHAR(20) — NOT NULL — 원본 메시지 ID. 스냅샷 정책으로 FK 없음
- content — TEXT — NOT NULL
- messageType — VARCHAR(20) — NOT NULL
- isProactive — BOOLEAN — NOT NULL
- idempotencyKey — VARCHAR(36)
- regenGroupId — VARCHAR(36)
- variantIndex — INT — NOT NULL
- isActiveVariant — BOOLEAN — NOT NULL
- createdAt — DATETIME — NOT NULL
chat_room_read
- id — INT — 기본 키 — NOT NULL
- roomId — VARCHAR(36) — 외래 키 → chat_rooms.id — NOT NULL
- userId — VARCHAR(36) — 외래 키 → users.id — NOT NULL
- readAt — DATETIME — NOT NULL
chat_rooms
- id — VARCHAR(36) — 기본 키 — NOT NULL
- userId — VARCHAR(36) — 외래 키 → users.id — NOT NULL
- characterId — VARCHAR(36) — 외래 키 → characters.id — NOT NULL
- language — VARCHAR(16) — NOT NULL
- userPersonaId — VARCHAR(36) — 외래 키 → user_personas.id
- persona — TEXT
- userNote — TEXT
- modelId — VARCHAR(255) — NOT NULL
- summary — TEXT
- shortMemorySummary — TEXT
- midMemorySummary — TEXT
- longMemorySummary — TEXT
- longMemoryKeywords — JSON
- currentContext — JSON
- lastMessageAt — DATETIME
- endedAt — DATETIME
- deleted — BOOLEAN — NOT NULL
- notificationEnabled — BOOLEAN — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
creator_block
- id — INT — 기본 키 — NOT NULL
- userId — VARCHAR(36) — 외래 키 → users.id — NOT NULL
- blockedUserId — VARCHAR(36) — 외래 키 → users.id — NOT NULL
- createdAt — DATETIME — NOT NULL
device_tokens
- id — INT — 기본 키 — NOT NULL
- userId — VARCHAR(36) — 외래 키 → users.id — NOT NULL
- deviceId — VARCHAR(255) — NOT NULL
- playerId — VARCHAR(255) — NOT NULL
- deviceName — VARCHAR(200)
- isActive — BOOLEAN — NOT NULL
- createdAt — DATETIME — NOT NULL
faqs
- id — VARCHAR(36) — 기본 키 — NOT NULL
- question — TEXT — NOT NULL
- answer — TEXT — NOT NULL
- sequence — INT — NOT NULL
- createdAt — DATETIME — NOT NULL
in_app_purchases
- id — VARCHAR(36) — 기본 키 — NOT NULL
- userId — VARCHAR(36) — 외래 키 → users.id — NOT NULL
- platform — VARCHAR(10) — NOT NULL — users.id 스냅샷
- status — VARCHAR(20) — NOT NULL
- reason — TEXT
- refundedAt — DATETIME
- refundedByAdminId — VARCHAR(36) — chat_rooms.id 스냅샷
- refundReason — TEXT
- refundedPoints — INT
- storeIdempotencyKey — VARCHAR(255) — NOT NULL
- productId — VARCHAR(128) — NOT NULL
- quantity — INT — NOT NULL
- pointsCredited — INT
- storeCurrency — CHAR(3)
- storePriceMinorUnits — BIGINT
- rawPayload — JSON — NOT NULL
- ledgerTransactionId — VARCHAR(36) — 외래 키 → transactions.id
- storeEnvironment — VARCHAR(20)
- appleTransactionId — VARCHAR(128)
- appleOriginalTransactionId — VARCHAR(128)
- googlePackageName — VARCHAR(255)
- googlePurchaseToken — TEXT
- googleOrderId — VARCHAR(255)
- purchasedAt — DATETIME
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
legal_documents
- id — VARCHAR(36) — 기본 키 — NOT NULL
- content — TEXT — NOT NULL
- type — VARCHAR(50) — NOT NULL
- createdAt — DATETIME — NOT NULL
- isActive — BOOLEAN — NOT NULL
narrator_directives
- id — VARCHAR(36) — 기본 키 — NOT NULL
- directive_key — VARCHAR(128) — NOT NULL
- language — VARCHAR(16) — NOT NULL
- displayName — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- createdById — VARCHAR(36) — 외래 키 → users.id
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
notification_reads
- id — INT — 기본 키 — NOT NULL
- notificationId — INT — 외래 키 → notifications.id — NOT NULL
- userId — VARCHAR(36) — 외래 키 → users.id — NOT NULL
- readAt — DATETIME — NOT NULL
notifications
- id — INT — 기본 키 — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- link — VARCHAR(512)
- sentAt — DATETIME — NOT NULL
- recipientId — VARCHAR(36) — 외래 키 → users.id
- notificationType — VARCHAR(50) — NOT NULL
- broadcastAudience — VARCHAR(32)
- createdAt — DATETIME — NOT NULL
nsfw_keywords
- id — VARCHAR(36) — 기본 키 — NOT NULL
- keyword — VARCHAR(100) — NOT NULL
- createdById — VARCHAR(36) — 외래 키 → users.id
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
preset_directive_overrides
- presetId — VARCHAR(128) — 기본 키 — NOT NULL
- directiveKey — VARCHAR(128) — NOT NULL
proactive_message_config
- id — INT — 기본 키 — NOT NULL
- enabled — BOOLEAN — NOT NULL
- inactiveThresholdHours — INT — NOT NULL
- maxDailyMessagesPerRoom — INT — NOT NULL
- maxUnansweredStack — INT — NOT NULL
- quietHoursStart — INT — NOT NULL
- quietHoursEnd — INT — NOT NULL
- maxInactiveDays — INT — NOT NULL
- concurrency — INT — NOT NULL
- retryWaitMinutes — INT — NOT NULL
- updatedAt — DATETIME — NOT NULL
proactive_message_logs
- id — VARCHAR(36) — 기본 키 — NOT NULL
- roomId — VARCHAR(36) — 외래 키 → chat_rooms.id — NOT NULL
- messageId — VARCHAR(36) — 외래 키 → chat_messages.id
- sentDate — DATE — NOT NULL
- repliedAt — DATETIME
- isRecommendation — BOOLEAN — NOT NULL
- createdAt — DATETIME — NOT NULL
products
- id — INT — 기본 키 — NOT NULL
- productId — VARCHAR(128) — NOT NULL
- point — INT — NOT NULL
quiz_answers
- id — VARCHAR(36) — 기본 키 — NOT NULL
- userId — VARCHAR(36) — 외래 키 → users.id — NOT NULL
- quizId — VARCHAR(36) — 외래 키 → quizzes.id — NOT NULL
- selectedCharacterId — VARCHAR(36) — NOT NULL
- sparkAwarded — INT — NOT NULL
- answeredAt — DATETIME — NOT NULL
quizzes
- id — VARCHAR(36) — 기본 키 — NOT NULL
- questionText — TEXT — NOT NULL
- characterAId — VARCHAR(36) — 외래 키 → characters.id — NOT NULL
- characterBId — VARCHAR(36) — 외래 키 → characters.id — NOT NULL
- correctCharacterId — VARCHAR(36) — 외래 키 → characters.id — NOT NULL
- sparkReward — INT — NOT NULL
- isActive — BOOLEAN — NOT NULL
- startsAt — DATETIME — NOT NULL
- endsAt — DATETIME
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
ranking_cache
- id — VARCHAR(36) — 기본 키 — NOT NULL
- period — VARCHAR(20) — NOT NULL
- rankings — JSON — NOT NULL
- calculatedAt — DATETIME — NOT NULL
reply_nudge_logs
- id — VARCHAR(36) — 기본 키 — NOT NULL
- roomId — VARCHAR(36) — 외래 키 → chat_rooms.id — NOT NULL
- userId — VARCHAR(36) — 외래 키 → users.id — NOT NULL
- characterId — VARCHAR(36) — 외래 키 → characters.id — NOT NULL
- messageId — VARCHAR(36) — 외래 키 → chat_messages.id
- createdAt — DATETIME — NOT NULL
- nudgeSentAt — DATETIME
- firstNudgeSentAt — DATETIME
- secondNudgeSentAt — DATETIME
- repliedAt — DATETIME
selectable_models
- modelId — VARCHAR(256) — 기본 키 — NOT NULL
- displayOrder — INT — NOT NULL
- isDefault — BOOLEAN — NOT NULL
- createdAt — DATETIME — NOT NULL
test_characters
- id — VARCHAR(36) — 기본 키 — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — TEXT — NOT NULL
- personaPrompt — TEXT — NOT NULL
- supremeDirective — TEXT
- profileImageUrl — VARCHAR(2048)
- firstMessage — TEXT — NOT NULL
- introduction — TEXT
- rejectionMessages — JSON
- callsignAlias — TEXT
- ageGender — TEXT
- physicalDescription — TEXT
- roleTitle — TEXT
- hashtags — JSON
- coreTrait — TEXT
- lorePast — TEXT
- loreCurrent — TEXT
- loreRelationship — TEXT
- mainQuotes — JSON
- openingScenario — TEXT
- backgroundSequences — JSON
- firstScriptItems — JSON
- temperature — FLOAT
- topP — FLOAT
- isActive — BOOLEAN — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
test_chat_messages
- id — VARCHAR(36) — 기본 키 — NOT NULL
- roomId — VARCHAR(36) — 외래 키 → test_chat_rooms.id — NOT NULL
- role — VARCHAR(20) — NOT NULL
- content — TEXT — NOT NULL
- sceneContent — TEXT
- sceneModelId — VARCHAR(128)
- atmosphereModelId — VARCHAR(128)
- mainFinalModelId — VARCHAR(128)
- atmosphereContent — TEXT
- phase1Ms — INT
- phase2aMs — INT
- phase2Ms — INT
- totalMs — INT
- sceneCostUsd — DECIMAL(12,8)
- atmosphereCostUsd — DECIMAL(12,8)
- totalCostUsd — DECIMAL(12,8)
- totalCostKrw — DECIMAL(12,2)
- fallbackUsed — BOOLEAN — NOT NULL
- createdAt — DATETIME — NOT NULL
test_chat_rooms
- id — VARCHAR(36) — 기본 키 — NOT NULL
- testCharacterId — VARCHAR(36) — 외래 키 → test_characters.id — NOT NULL
- inviteId — VARCHAR(255) — NOT NULL
- lastSceneModelId — VARCHAR(128)
- lastAtmosphereModelId — VARCHAR(128)
- lastMainFinalModelId — VARCHAR(128)
- lastMessageAt — DATETIME
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
transactions
- id — VARCHAR(36) — 기본 키 — NOT NULL
- userId — VARCHAR(36) — 외래 키 → users.id — NOT NULL
- amount — INT — NOT NULL — FIFO 원본 charge transaction. 논리 self reference
- type — VARCHAR(20) — NOT NULL — 관리자 지급 시 users.id. 논리 관계
- description — VARCHAR(255)
- status — VARCHAR(20) — NOT NULL
- inAppPurchaseId — VARCHAR(36) — 외래 키 → in_app_purchases.id
- source — VARCHAR(20) — ios/android
- sourceTransactionId — VARCHAR(36) — 환불 처리 관리자 users.id. 논리 관계
- grantedByAdminId — VARCHAR(36) — characters.id 논리 관계
- createdAt — DATETIME — NOT NULL
user_personas
- id — VARCHAR(36) — 기본 키 — NOT NULL
- userId — VARCHAR(36) — 외래 키 → users.id — NOT NULL
- name — VARCHAR(255) — NOT NULL
- age — INT
- gender — VARCHAR(50)
- occupation — VARCHAR(255)
- description — TEXT
- isLastSelected — BOOLEAN — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
users
- id — VARCHAR(36) — 기본 키 — NOT NULL — 사용자 UUID
- email — VARCHAR(255) — NOT NULL — 로그인 이메일
- nickname — VARCHAR(255) — 닉네임
- provider — VARCHAR(50) — NOT NULL — email/google/kakao/apple/reviewer 등
- providerId — VARCHAR(255) — 소셜 로그인 제공자 ID
- password — VARCHAR(255) — 이메일 로그인 비밀번호 해시
- isEmailVerified — BOOLEAN — NOT NULL
- emailVerificationToken — VARCHAR(255)
- balance — INT — NOT NULL — 총 스파크 잔액
- freeBalance — INT — NOT NULL — 무료 스파크
- paidBalance — INT — NOT NULL — 유료 스파크
- role — VARCHAR(20) — NOT NULL
- suspendedUntil — DATETIME
- deletedAt — DATETIME
- proactiveMessageEnabled — BOOLEAN — NOT NULL
- marketingPushEnabled — BOOLEAN — NOT NULL
- profileImageUrl — VARCHAR(2048)
- isAgeVerified — BOOLEAN — NOT NULL
- ageVerifiedAt — DATETIME
- lastActiveAt — DATETIME
- isDummy — BOOLEAN — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL