MyLittleChat

Tables (14)

Untitled (chat_tag)

  • Field

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)