game_db

Tables (56)

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Untitled8 (DwTutorialReplayDataAsset복사4)

  • Key (aliasId) — int — Primary key — NOT NULL

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Untitled5 (t_offering_reward_info)

  • Key (aliasId) — int — Primary key — NOT NULL
  • Key (userId) — bigint — Foreign key → Copy Of Copy Of Copy Of Copy Of Untitled5.Key — NOT NULL
  • Field (level) — int
  • Field (updatedTime) — datetime

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Untitled52 (t_tutorial)

  • Key (userId) — bigint — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Untitled52.Key — NOT NULL
  • Key (aliasId) — int — Foreign key → Copy Of Copy Of Copy Of Untitled8.Key — NOT NULL
  • Field (state) — tinyint unsigned
  • Field (updatedTime) — datetime

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Untitled8 (DwItemDataAsset_복사4)

  • Key (aliasId) — int — Primary key — NOT NULL

Copy Of Copy Of Copy Of Copy Of Copy Of Untitled5 (t_offering_info)

  • Key (aliasId) — int — Primary key — NOT NULL
  • Key (userId) — bigint — Foreign key → Copy Of Copy Of Copy Of Copy Of Untitled5.Key — NOT NULL
  • Field (offeredCount) — int
  • Field (currentLevel) — int
  • Field (updatedTime) — datetime

Copy Of Copy Of Copy Of Copy Of Copy Of Untitled52 (t_user_info_복사6)

  • Key (userId) — bigint — Primary key — NOT NULL

Copy Of Copy Of Copy Of Copy Of Copy Of Untitled8 (DwRecipeDataAsset)

  • Key (aliasId) — int — Primary key — NOT NULL

Copy Of Copy Of Copy Of Copy Of Untitled5 (t_user_info_복사5)

  • Key (userId) — bigint — Primary key — NOT NULL

Copy Of Copy Of Copy Of Copy Of Untitled8 (DwUnlockableContentTable)

  • Key (aliasId) — int — Primary key — NOT NULL

Copy Of Copy Of Copy Of Untitled5 (t_user_info_복사4)

  • Key (userId) — bigint — Primary key — NOT NULL

Copy Of Copy Of Copy Of Untitled8 (DwTutorialDataAsse)

  • Key (aliasId) — int — Primary key — NOT NULL

Copy Of Copy Of Untitled2 (DwGadgetDataAsset\Automata)

  • Key (aliasId) — int — Primary key — NOT NULL

Copy Of Copy Of Untitled22 (DwDungeon)

  • Key (aliasId) — int — Primary key — NOT NULL

Copy Of Copy Of Untitled5 (t_user_info_복사3)

  • Key (userId) — bigint — Primary key — NOT NULL

Copy Of Copy Of Untitled6 (t_npc_domain_event)

  • Key (eventId) — bigint — Primary key — NOT NULL
  • Field (eventType) — smallint
  • Field (dataSize) — int
  • Field (eventData) — json
  • Field (encodeVersion) — tinyint unsigned
  • Field (snapshotVersion) — tinyint unsigned
  • Field (createTime) — datetime
  • Key (aggregateId) — bigint — Foreign key → Copy Of Copy Of Copy Of Untitled5.Key — NOT NULL

Copy Of Copy Of Untitled62 (t_quest_domain_event)

  • Key (eventId) — bigint — Primary key — NOT NULL
  • Field (eventType) — smallint
  • Field (dataSize) — int
  • Field (eventData) — json
  • Field (encodeVersion) — tinyint unsigned
  • Field (snapshotVersion) — tinyint unsigned
  • Field (createTime) — datetime
  • Key (aggregateId) — bigint — Foreign key → Copy Of Copy Of Copy Of Copy Of Untitled5.Key — NOT NULL

Copy Of Copy Of Untitled7 (t_npc_snapshot)

  • Key (aggregateId) — bigint — Foreign key → Copy Of Copy Of Copy Of Untitled5.Key — NOT NULL
  • Field (lastEventId) — bigint
  • Field (dataSize) — int
  • Field (snapshotData) — mediumblob
  • Field (snapshotVersion) — tinyint unsigned
  • Field (updatedTime) — datetime

Copy Of Copy Of Untitled72 (t_quest_snapshot)

  • Key (aggregateId) — bigint — Foreign key → Copy Of Copy Of Copy Of Copy Of Untitled5.Key — NOT NULL
  • Field (lastEventId) — bigint
  • Field (dataSize) — int
  • Field (snapshotData) — mediumblob
  • Field (snapshotVersion) — tinyint unsigned
  • Field (updatedTime) — datetime

Copy Of Copy Of Untitled8 (DwPhaseLayerAsset)

  • Key (aliasId) — int — Primary key — NOT NULL

Copy Of Copy Of Untitled9 (t_item_usable)

  • Key (uniqueId) — bigint — Primary key — NOT NULL
  • Key (userId) — bigint — Foreign key → Copy Of Copy Of Untitled5.Key — NOT NULL
  • Key (aliasId) — int — Foreign key → Copy Of Untitled8.Key — NOT NULL
  • Field (count) — int
  • Field (createTime) — datetime
  • Field (updatedTime) — datetime
  • Field (expiredTime) — datetime

Copy Of Untitled (ItemDbJobReason)

  • Key (aliasId) — int — Primary key — NOT NULL

Copy Of Untitled10 (config_db.t_push_mail)

  • Key (uniqueId) — bigint — Primary key — NOT NULL

Copy Of Untitled2 (DwDungeonDataAsset)

  • Key (aliasId) — int — Primary key — NOT NULL

Copy Of Untitled3 (t_dungeon)

  • Key (userId) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (dungeonAliasId) — int — Foreign key → Copy Of Copy Of Untitled22.Key — NOT NULL
  • Field (enteredTime) — datetime
  • Field (clearedTime) — datetime
  • Field (rewardReceivedTime) — datetime
  • Field (updatedTime) — datetime

Copy Of Untitled4 (DwItemDataAsset_복사1)

  • Key (aliasId) — int — Primary key — NOT NULL

Copy Of Untitled5 (t_user_info_복사2)

  • Key (userId) — bigint — Primary key — NOT NULL

Copy Of Untitled6 (t_gimmick_domain_event)

  • Key (eventId) — bigint — Primary key — NOT NULL
  • Field (eventType) — smallint
  • Field (dataSize) — int
  • Field (eventData) — json
  • Field (encodeVersion) — tinyint unsigned
  • Field (snapshotVersion) — tinyint unsigned
  • Field (createTime) — datetime
  • Key (aggregateId) — bigint — Foreign key → Copy Of Untitled5.Key — NOT NULL

Copy Of Untitled7 (t_gimmick_snapshot)

  • Key (aggregateId) — bigint — Foreign key → Copy Of Untitled5.Key — NOT NULL
  • Field (lastEventId) — bigint
  • Field (dataSize) — int
  • Field (snapshotData) — mediumblob
  • Field (snapshotVersion) — tinyint unsigned
  • Field (updatedTime) — datetime

Copy Of Untitled8 (DwItemDataAsset_복사2)

  • Key (aliasId) — int — Primary key — NOT NULL

Copy Of Untitled9 (t_item_misc)

  • Key (uniqueId) — bigint — Primary key — NOT NULL
  • Key (userId) — bigint — Foreign key → Copy Of Copy Of Untitled5.Key — NOT NULL
  • Key (aliasId) — int — Foreign key → Copy Of Untitled8.Key — NOT NULL
  • Field (count) — int
  • Field (createTime) — datetime
  • Field (updatedTime) — datetime

Untitled (t_automata_construct)

  • Key (uniqueId) — bigint — Primary key — NOT NULL
  • Key (userId) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (aliasId) — int — Foreign key → Copy Of Copy Of Untitled2.Key — NOT NULL
  • Field (automataType) — tinyint unsigned
  • Field (constructIndex) — smallint
  • Field (Scope) — tinyint
  • Field (featureData) — json
  • Field (x) — double
  • Field (y) — double
  • Field (z) — double
  • Field (yaw) — double
  • Field (pitch) — double
  • Field (roll) — double
  • Field (endpointUse) — tinyint
  • Field (endX) — double
  • Field (endY) — double
  • Field (endZ) — double
  • Field (endYaw) — double
  • Field (endPitch) — double
  • Field (endRoll) — double
  • Field (isActivated) — tinyint
  • Field (isDeleted) — tinyint
  • Field (deletedTime) — datetime
  • Field (durationType) — tinyint
  • Field (duration) — int
  • Field (startTime) — bigint
  • Field (expiredTime) — bigint
  • Field (updatedTime) — datetime
  • Field (createTime) — datetime

Untitled

  • Key (userId) — bigint — Foreign key → Copy Of Copy Of Copy Of Copy Of Untitled5.Key — NOT NULL
  • Key (pushMailuniqueId) — bigint — Foreign key → Copy Of Untitled10.Key — NOT NULL
  • Field (createTime) — datetime

Untitled (t_item_pc)

  • Key (uniqueId) — bigint — Primary key — NOT NULL
  • Key (userId) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (aliasId) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (exp) — int
  • Field (level) — int
  • Field (hp) — int
  • Field (mp) — int
  • Field (FieldascensionCount) — tinyint
  • Field2 (gradeLevel) — tinyint
  • Field2 (skillLevel10) — tinyint
  • Field2 (skillLevel11) — tinyint
  • Field2 (skillLevel12) — tinyint
  • Field2 (skillLevel13) — tinyint
  • Field2 (skillLevel14) — tinyint
  • Field2 (skillLevel15) — tinyint
  • Field2 (skillLevel16) — tinyint
  • Field2 (createTime) — datetime
  • Key (createReason) — int — Foreign key → Copy Of Untitled.Key — NOT NULL
  • Field2 (updatedTime) — datetime
  • Field2 (totalOnFieldSeconds) — int

Untitled (DwItemDataAsset)

  • Key (aliasId) — int — Primary key — NOT NULL

Untitled (t_phase)

  • Key (userId) — bigint — Foreign key → Copy Of Copy Of Copy Of Copy Of Untitled5.Key — NOT NULL
  • Key (aliasId) — int — Foreign key → Copy Of Copy Of Untitled8.Key — NOT NULL
  • Field (isActivated) — tinyint
  • Field (updatedTime) — datetime

Untitled (t_party_info)

  • Key (partyIndex) — tinyint — Primary key — NOT NULL
  • Key (userId) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (partyName) — varchar(80)
  • Field
  • Key (itemPcUniqueId1) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (itemPcUniqueId2) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (itemPcUniqueId3) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (itemPcUniqueId4) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field2 (isDeleted) — tinyint
  • Field2 (updatedTime) — datetime

Untitled (t_cooldown_group_info)

  • Key (userId) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (cooldownGroupData) — json
  • Field (updatedTime) — datetime

Untitled (t_equipment_equipping_state)

  • Key (userId) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (uniqueId) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (slot1EquipmentUniqueId) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (slot2EquipmentUniqueId) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (slot3EquipmentUniqueId) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (slot4EquipmentUniqueId) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (slot5EquipmentUniqueId) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (slot6EquipmentUniqueId) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (slot7EquipmentUniqueId) — bigint
  • Field (slot8EquipmentUniqueId) — bigint
  • Field (slot9EquipmentUniqueId) — bigint
  • Field (slot10EquipmentUniqueId) — bigint
  • Field (slot11EquipmentUniqueId) — bigint
  • Field (slot12EquipmentUniqueId) — bigint
  • Field (updatedTime) — datetime

Untitled (t_user_info_복사1)

  • Key (userId) — bigint — Primary key — NOT NULL

Untitled (t_item_weapon)

  • Key (uniqueId) — bigint — Primary key — NOT NULL
  • Key (userId) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (aliasId) — int — Foreign key → Copy Of Untitled4.Key — NOT NULL
  • Field (createTime) — datetime
  • Field (createReason) — int
  • Field (isLocked) — tinyint
  • Field (isDeleted) — tinyint
  • Field (deletedTime) — datetime
  • Field (enchantLevel) — int
  • Field (deletedReason) — int
  • Field (updatedTime) — datetime
  • Field (ascensionGrade) — tinyint
  • Field (refineCount) — int

Untitled (t_item_emblem)

  • Key (uniqueId) — bigint — Primary key — NOT NULL
  • Key (userId) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (aliasId) — int — Foreign key → Copy Of Untitled4.Key — NOT NULL
  • Field (createTime) — datetime
  • Field (createReason) — int
  • Field (isLocked) — tinyint
  • Field (isDeleted) — tinyint
  • Field (deletedTime) — datetime
  • Field (randomLevelStatAliasId) — int
  • Field (subStatTypeIndex1) — int
  • Field (subStatValueIndex1) — int
  • Field (subStatTypeIndex2) — int
  • Field (subStatValueIndex2) — int
  • Field2 (subStatTypeIndex3) — int
  • Field (subStatValueIndex3) — int
  • Field (subStatTypeIndex4) — int
  • Field (subStatValueIndex4) — int
  • Field (enchantLevel) — int
  • Field2 (optimizedSlotIndex) — int
  • Field (optimizationCount) — int
  • Field (ascensionGrade) — int
  • Field (deletedReason) — int
  • Field (updatedTime) — datetime

Untitled (t_gadget_domain_event)

  • Key (eventId) — bigint — Primary key — NOT NULL
  • Field (eventType) — smallint
  • Field (dataSize) — int
  • Field (eventData) — json
  • Field (encodeVersion) — tinyint unsigned
  • Field (snapshotVersion) — tinyint unsigned
  • Field (createTime) — datetime
  • Key (aggregateId) — bigint — Foreign key → Untitled.Key — NOT NULL

Untitled (t_gadget_snapshot)

  • Key (aggregateId) — bigint — Foreign key → Copy Of Untitled5.Key — NOT NULL
  • Field (lastEventId) — bigint
  • Field (dataSize) — int
  • Field (snapshotData) — mediumblob
  • Field (snapshotVersion) — tinyint unsigned
  • Field (updatedTime) — datetime

Untitled (t_item_automata)

  • Key (uniqueId) — bigint — Primary key — NOT NULL
  • Key (userId) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (aliasId) — int — Foreign key → Copy Of Untitled8.Key — NOT NULL
  • Field (count) — int
  • Field (isDeleted) — tinyint
  • Field (createTime) — datetime
  • Field (updatedTime) — datetime

Untitled (t_item_currency)

  • Key (uniqueId) — bigint — Primary key — NOT NULL
  • Key (userId) — bigint — Foreign key → Copy Of Copy Of Untitled5.Key — NOT NULL
  • Key (aliasId) — int — Foreign key → Copy Of Untitled8.Key — NOT NULL
  • Field (count) — int
  • Field (createTime) — datetime
  • Field (updatedTime) — datetime

Untitled (t_item_quickslot)

  • Key (typeTagAliasId) — int — Primary key — NOT NULL
  • Key (userId) — bigint — Foreign key → Copy Of Copy Of Untitled5.Key — NOT NULL
  • Field (selectedSlot) — int
  • Field (slotData) — json
  • Field (updatedTime) — datetime

Untitled (t_user_info)

  • Key (userId) — bigint — Primary key — NOT NULL
  • Field (nickname) — varchar(80)
  • Field (adventureLevel) — smallint
  • Field (accountExp) — int
  • Field (x) — double
  • Field (y) — double
  • Field (z) — double
  • Field (createTime) — datetime
  • Field (lastLoginTime) — datetime
  • Key (selectedPartyIndex) — tinyint — Foreign key → Untitled.Key — NOT NULL
  • Field (selectedPcIndex) — tinyint
  • Field (staminaLevel) — tinyint unsighed
  • Field (worldAliasId) — int
  • Field (isOld) — tinyint
  • Field (lastHeartbeatTime) — datetime
  • Field (connectedSeconds) — bigint
  • Field (linkPoint) — int
  • Field (genderType) — tinyint
  • Field (maxWorldLevel) — int
  • Field (currentWorldLevel) — int
  • Field (lastWorldLevelSetTime) — datetime
  • Key (currentDungeonAliasId) — int — Foreign key → Copy Of Untitled2.Key — NOT NULL
  • Field (birthMonth) — int
  • Field (birthDay) — int
  • Field2 (selfIntroduction) — varchar(255)
  • Key (currentPartyIndex) — tinyint — Foreign key → Untitled.Key — NOT NULL

Untitled (t_mail_info)

  • Key (uniqueId) — bigint — Primary key — NOT NULL
  • Key (userId) — bigint — Foreign key → Copy Of Copy Of Copy Of Untitled5.Key — NOT NULL
  • Field (mailAliasId) — int
  • Field (isMarking) — tinyint
  • Field (isSavedMail) — tinyint
  • Field (isItemReceived) — tinyint
  • Field (sendTime) — datetime
  • Field (expiredTime) — datetime
  • Field (savedTime) — datetime
  • Field (mailTitle) — varchar(200)
  • Field (mailBody) — varchar(800)
  • Field (mailSenderAliasId) — int
  • Field (mailType) — tinyint
  • Field (languageType) — varchar(20)
  • Field (mailItemList) — json
  • Field (isDeleted) — tinyint
  • Field (deletedTime) — datetime

Untitled (t_npc_shop_purchase_info)

  • Key (shopAliasId) — int — Primary key — NOT NULL
  • Key (shopItemAliasId) — int — Primary key — NOT NULL
  • Key (userId) — bigint — Foreign key → Copy Of Copy Of Copy Of Untitled5.Key — NOT NULL
  • Field (purchasedCount) — smallint unsigned
  • Field (resetStartTime) — datetime
  • Field (updatedTime) — datetime

Untitled (t_persistent_ability_info)

  • Key (userId) — bigint — Foreign key → Copy Of Copy Of Copy Of Copy Of Untitled5.Key — NOT NULL
  • Field (abilityData) — json
  • Field (updatedTime) — datetime

Untitled2 (t_world_time_info)

  • Key (userId) — bigint — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Untitled52.Key — NOT NULL
  • Field (hours) — tinyint
  • Field (minutes) — tinyint
  • Field (lastUpdatedTime) — bigint
  • Field (updatedTime) — datetime

Untitled2 (t_unlocked_content)

  • Key (userId) — bigint — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Untitled52.Key — NOT NULL
  • Key (aliasId) — int — Foreign key → Copy Of Copy Of Copy Of Copy Of Untitled8.Key — NOT NULL
  • Field (createTime) — datetime

Untitled2 (t_recipe)

  • Key (userId) — bigint — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Untitled52.Key — NOT NULL
  • Key (aliasId) — int — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Untitled8.Key — NOT NULL
  • Field (isBookmarked) — boolean
  • Field (masteryExp) — int
  • Field (masteryLevel) — int
  • Field (createTime) — datetime
  • Field (updatedTime) — datetime

Untitled2 (t_custom_data)

  • Key — bigint — Primary key — NOT NULL
  • Key (userId) — bigint — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Untitled52.Key — NOT NULL
  • Field (data) — text

Untitled2 (t_user_item_info)

  • Key (userId) — bigint — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Untitled52.Key — NOT NULL
  • Field (currentEstus) — int
  • Field (maxEstus) — int
  • Key (estusAliasId) — int — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Untitled8.Key — NOT NULL
  • Field (estusUniqueId) — bigint
  • Field (lastEstusUsedTime) — datetime

Untitled2 (t_tutorial_replay)

  • Key (userId) — bigint — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Untitled52.Key — NOT NULL
  • Key (aliasId) — int — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Untitled8.Key — NOT NULL
  • Field (state) — tinyint
  • Field (unlockedTime) — datetime
  • Field (updatedTime) — datetime