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