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