MyLittleChat
Tables (14)
Untitled (changed_character)
- Key (id) — Primary key — NOT NULL
- Key (room_id) — Foreign key → Untitled.Key — NOT NULL
- Key (character_id) — Foreign key → character.Key — NOT NULL
Untitled (room)
- Key (id) — Primary key — NOT NULL
- id (user_id) — Foreign key → user.id — NOT NULL
Untitled (UserEconomy)
- id (uid) — Foreign key → user.id — NOT NULL
- Field (subscription_type)
- Field2 (subscription_end_at)
- Field (used_money)
Untitled (UserRecord)
- id (uid) — Foreign key → user.id — NOT NULL
- Field (used_gold)
- Field4 (charged_gold)
- Field2 (played_session)
- Field3 (playtime)
- Field
Untitled (UserLimit)
- id (uid) — Foreign key → user.id — NOT NULL
- Field (free_gold)
- Field (ai_gm)
- Field (play_kit)
- Field (universe)
- Field (scenario)
- Field (character)
Untitled (UserSetting)
- id (uid) — Foreign key → user.id — NOT NULL
- Field (auto_tts)
- Field2 (auto_image_interval)
Untitled (UserAchivement)
- id (uid) — Foreign key → user.id — NOT NULL
- Field
- Field2
- Field3
- Field4
- Field5
- Field6
- Field7
- Field8
- Field9
- Field10
Untitled (Session)
- Key (id) — Primary key — NOT NULL
- Field (owner)
- Field2 (gm_id)
- Field3 (world_id)
- Field4 (scenario_id)
- Field5 (chapter)
- Field6
- Field7
character
- Key (id) — Primary key — NOT NULL
- Key (user_id) — Foreign key → user.id — NOT NULL
- Field (is_public) — NOT NULL
- Field (is_npc) — NOT NULL
- Field (name) — NOT NULL
- Field (desc) — NOT NULL
- Field (good_symbol) — NOT NULL
- Field (good_symbol_aspect) — NOT NULL
- Field (bad_symbol) — NOT NULL
- Field (bad_symbol_aspect) — NOT NULL
- Field (identity_aspect) — NOT NULL
- Field (problem_aspect) — NOT NULL
- Field (aspect) — NOT NULL
- Field (stat) — NOT NULL
- Field (skill) — NOT NULL
chat
- Key (id) — Primary key — NOT NULL
- Key (session_id) — Foreign key → session.Key — NOT NULL
- Key (character_id) — Foreign key → character.Key
- id (user_id) — Foreign key → user.id
- Field (cre_date) — NOT NULL
scenario
- Key (id) — Primary key — NOT NULL
- id (room_id) — Foreign key → Untitled.id — NOT NULL
- Field (is_template) — NOT NULL
- Field2 (scale) — NOT NULL
- Field3 (genre) — NOT NULL
- Field4 (desc) — NOT NULL
- Field (problems) — NOT NULL
- Field (targets) — NOT NULL
- Field2 (symbols) — NOT NULL
- Field3 (characters) — NOT NULL
- Field (aspects) — NOT NULL
session
- Key (id) — Primary key — NOT NULL
- Key (scenario_id) — Foreign key → scenario.Key — NOT NULL
- Field (summary) — NOT NULL
- Field (is_finished) — NOT NULL
user (User)
- id — Primary key — NOT NULL
- Field (is_banned)
- Field (auth_provider) — NOT NULL
- Field2 (nickname) — NOT NULL
- Field (profile_image_url)
- Field (created_at) — NOT NULL
- Field (last_login_at)
- Field (gold_free)
- Field2 (gold_real)
- Field (max_free_gold)
- Field (max_ai_gm)
- Field2 (max_playkit)
- Field3 (max_world)
- Field (max_character_slot)