Template:WikiTable table/doc

This table exists to manage the versions of Hearthstone databases and wiki tables.

There are three types of tables:

• Client
  • Directly imported from Hearthstone client. build is mandatory.
• Derived
  • Key values that are generated based on the client tables and can be modified. build is optional.
• Custom
  • Key values made up by wiki, but they are mostly used to cover server-side data that do not exist in Hearthstone client. Also, some key values can be useful in querying. build is unavailable for these tables.

Tables

page	type	build	metadata
Template:Ability table	Client	200,097	LETTUCE_ABILITY
Template:AbilityTier table	Client	200,097	LETTUCE_ABILITY_TIER
Template:Achieve table	Client	200,097	ACHIEVE
Template:AchieveCondition table	Client	200,097	ACHIEVE_CONDITION
Template:Achievements table	Client	200,097	ACHIEVEMENT
Template:AchievementsCategories table	Client	65,614	ACHIEVEMENT_CATEGORY
Template:AchievementsSectionItems table	Client	200,097	ACHIEVEMENT_SECTION_ITEM
Template:AchievementsSections table	Client	200,097	ACHIEVEMENT_SECTION
Template:AchievementsSubCategories table	Client	200,097	ACHIEVEMENT_SUBCATEGORY
Template:AdventureGuestHero table	Client	200,097	ADVENTURE_GUEST_HEROES
Template:AdventureHeroPower table	Client	200,097	ADVENTURE_HERO_POWER
Template:AdventureLoadoutTreasure table	Client	200,097	ADVENTURE_LOADOUT_TREASURES
Template:AudioText table	Custom	170,824	Extracted from GAMEPLAY_AUDIO.txt and MISSION_AUDIO.txt. Also includes AudioText for minions manually added.
Template:BattlegroundsBoardSkin table	Client	200,097	BATTLEGROUNDS_BOARD_SKIN
Template:BattlegroundsEmote table	Client	200,097	BATTLEGROUNDS_EMOTE
Template:BattlegroundsFinisher table	Client	200,097	BATTLEGROUNDS_FINISHER
Template:BattlegroundsGuideSkin table	Client	200,097	BATTLEGROUNDS_GUIDE_SKIN
Template:BattlegroundsHeroSkin table	Client	200,097	BATTLEGROUNDS_HERO_SKIN
Template:BonusBountyDropChance table	Client	200,097	BONUS_BOUNTY_DROP_CHANCE
Template:Booster table	Client	200,097	BOOSTER
Template:BoosterCardSet table	Client	200,097	BOOSTER_CARD_SET
Template:Bounty table	Client	200,097	LETTUCE_BOUNTY
Template:BountyFinalReward table	Client	200,097	LETTUCE_BOUNTY_FINAL_REWARDS
Template:BountySet table	Client	200,097	LETTUCE_BOUNTY_SET
Template:BuildingTier table	Client	200,097	BUILDING_TIER
Template:Bundle table	Server
Template:BundleInfo table	Server
Template:BundleItem table	Server
Template:Card table	Client	200,097	CARD
Template:Card2 table	Client	160,183	CARD
Template:CardBack table	Client	200,097	CARD_BACK
Template:CardHero table	Client	200,097	CARD_HERO
Template:CardRace table	Client	200,097	CARD_RACE
Template:CardsCardClass table	Wiki		Additional info to Hearthstone classes
Template:CardsCardType table	Wiki		Additional info to Hearthstone card types
Template:CardSetTiming table	Client	200,097	CARD_SET_TIMING
Template:CardsGameTag table	Client	175,913	Game tags' id and their enum string used in coding.
Template:CardsMultiClassGroup table	Wiki		Additional info to Hearthstone multi-class groups
Template:CardsOfficial2 table	API	150,659	Card data extracted from [https://api.hearthstonejson.com/v1/latest/enUS/cards.json HearthSim's API].
Template:CardsRace table	Wiki		Additional info to Hearthstone minion types
Template:CardsRarity table	Wiki		Additional info to Hearthstone rarities
Template:CardsSpellSchool table	Wiki		Additional info to Hearthstone spell schools
Template:CardTag table	Client	200,097	CARD_TAG, but handled very specifically
Template:CardTagBg table	Client	200,097	CARD_TAG, but only for Battlegrounds fields
Template:CardTagMercs table	Client	200,097	CARD_TAG, but only for Mercenaries fields
Template:CardTagTest table	Client	190,920	CARD_TAG, but handled very specifically
Template:Coin table	Client	195,635	COSMETIC_COIN
Template:CustomAchievement table	Custom		Extra info about Hearthstone achievements
Template:CustomBattlegroundsArmor table	Custom		Additional info to Battlegrounds armor system
Template:CustomBattlegroundsBoardSkin table	Custom		Additional data to BattlegroundsBoardSkin entities
Template:CustomBattlegroundsEmote table	Custom		Additional data to BattlegroundsEmote entities
Template:CustomBattlegroundsFinisher table	Custom		Additional data to BattlegroundsFinisher entities
Template:CustomBooster table	Custom		Additional data to card packs
Template:CustomBundleItemType table	Custom
Template:CustomCard table	Custom		CUSTOM. Key values that are made up or unable to extracted from Hearthstone client.
Template:CustomCardBack table	Custom		Additional data to CardBack entities
Template:CustomCardBackCategory table	Custom		Information about card back categories.
Template:CustomCardNote table	Custom		CUSTOM. List of templates that represent card notes.
Template:CustomCardStrategy table	Custom		CUSTOM. List of templates that archived Strategy contents that were supposed to be removed.
Template:CustomEventTimingEvent table	Custom		Additional info about Hearthstone events
Template:CustomFaction table	Custom		Additional info to Mercenaries factions
Template:CustomLoreRace table	Custom		CUSTOM. List of ''Warcraft'' character races by lore. Used in card infoboxes to refer.
Template:CustomRewardTrack table	Custom		Additional data to RewardTrack entities
Template:CustomSound table	Custom		CUSTOM. Audio files that can't be extracted.
Template:CustomSpecialEvent table	Custom		Additional data to SpecialEvent entities
Template:Deck table	Client	200,097	DECK
Template:DeckTemplate table	Client	200,097	DECK_TEMPLATE
Template:DeckTemplateChoice table	Client	200,097	DECK_TEMPLATE_CHOICES
Template:DerivedCard table	Derived		DERIVED from Card, CardTag, CardSetTiming, CardChange table
Template:DerivedDeckCard table	Derived		DERIVED from DeckCard
Template:DerivedEquipment table	Derived	145,077	DERIVED from Card, EquipmentTier, RewardItem, VisitorTask, TaskList, Achievements, BonusBountyDropChance tables.
Template:EquipmentModifier table	Client		LETTUCE_EQUIPMENT_MODIFIER_DATA
Template:EquipmentTier table	Client	200,097	LETTUCE_EQUIPMENT_TIER
Template:EventRewardTrack table	Client	200,097	EVENT_REWARD_TRACK
Template:EventTimingEvent table	Server		EventTimingManager
Template:FixedReward table	Client	200,097	FIXED_REWARD
Template:FixedRewardAction table	Client	200,097	FIXED_REWARD_ACTION
Template:FixedRewardMap table	Client	200,097	FIXED_REWARD_MAP
Template:FormulaChangePoint table	Client	200,097	FORMULA_CHANGE_POINT
Template:GuestHero table	Client	200,097	GUEST_HERO
Template:InitCardValue table	Client	200,097	INIT_CARD_VALUE
Template:LeagueRank table	Client	200,097	LEAGUE_RANK
Template:LuckyDrawBox table	Client	200,097	LUCKY_DRAW_BOX
Template:LuckyDrawReward table	Client	200,097	LUCKY_DRAW_REWARDS
Template:MercenariesRandomReward table	Client	200,097	MERCENARIES_RANDOM_REWARD
Template:MercenariesRankedSeasonRewardRank table	Client	200,097	MERCENARIES_RANKED_SEASON_REWARD_RANK
Template:MercenaryAbility table	Client	200,097	LETTUCE_MERCENARY_ABILITY
Template:MercenaryAllowTreasure table	Client	200,097	MERCENARY_ALLOWED_TREASURE
Template:MercenaryArtVariation table	Client	200,097	MERCENARY_ART_VARIATION
Template:MercenaryArtVariationPremium table	Client	200,097	MERCENARY_ART_VARIATION_PREMIUM
Template:MercenaryEquipment table	Client	200,097	LETTUCE_MERCENARY_EQUIPMENT
Template:MercenaryLevelStats table	Client	200,097	LETTUCE_MERCENARY_LEVEL_STATS
Template:MercenaryName table	Client	200,097	LETTUCE_MERCENARY
Template:MercenarySpecialization table	Client	200,097	LETTUCE_MERCENARY_SPECIALIZATION
Template:MercenaryTreasure table	Client	200,097	LETTUCE_TREASURE
Template:MercenaryTreasureTier table	Client	163,976	LETTUCE_TREASURE_TIER
Template:MercenaryVisitor table	Client	200,097	MERCENARY_VISITOR
Template:MiniSet table	Client	200,097	MINI_SET
Template:MythicAbilityScalingCardTag table	Client	200,097	MYTHIC_ABILITY_SCALING_CARD_TAG
Template:MythicEquipmentScalingCardTag table	Client	200,097	MYTHIC_EQUIPMENT_SCALING_CARD_TAG
Template:MythicEquipmentScalingDestinationCardTag table	Client	200,097	MYTHIC_EQUIPMENT_SCALING_DESTINATION_CARD_TAG
Template:OwnershipReqList table	Client	200,097	OWNERSHIP_REQ_LIST
Template:Quest table	Client	200,097	QUEST
Template:QuestPool table	Client	200,097	QUEST_POOL
Template:RankedPlaySeason table	Client	200,097	RANKED_PLAY_SEASON
Template:RewardChest table	Client	200,097	REWARD_CHEST
Template:RewardChestContent table	Client	200,097	REWARD_CHEST_CONTENTS
Template:RewardItem table	Client	200,097	REWARD_ITEM
Template:RewardList table	Client	200,097	REWARD_LIST
Template:RewardTrack table	Client	200,097	REWARD_TRACK
Template:RewardTrackLevel table	Client	200,097	REWARD_TRACK_LEVEL
Template:ScalingTreasureCardTag table	Client	200,097	SCALING_TREASURE_CARD_TAG
Template:Scenario table	Client	200,097	SCENARIO
Template:ScenarioGuestHero table	Client	200,097	SCENARIO_GUEST_HEROES
Template:Sound table	Client	195,635	CLIENT. Extracted by [https://github.com/Zero-to-Heroes/hs-reference-data Zero-To-Heroes]
Template:Sound2 table	Client	170,824	CLIENT. Extracted by [https://github.com/Zero-to-Heroes/hs-reference-data Zero-To-Heroes]
Template:SpecialEvent table	Client	200,097	SPECIAL_EVENT
Template:SubsetRule table	Client	190,145	SUBSET_RULE
Template:TaskList table	Client	200,097	TASK_LIST
Template:VisitorTask table	Client	200,097	VISITOR_TASK
Template:VisitorTaskChain table	Client	200,097	VISITOR_TASK_CHAIN
Template:VisitorTaskFR table	Client	0	VISITOR_TASK fr_FR
Template:WikiAbility table	Wiki		WikiMercenary entities' abilities.
Template:WikiAbilityTier table	Wiki		WikiAbility entities' tiers.
Template:WikiArenaSet table	Wiki		Information about [[Arena]] rotations.
Template:WikiArtist table	Wiki		Information about artists.
Template:WikiBanPool table	Wiki		Pools of banned cards. Used with WikiCardPool
Template:WikiBgMigratedCard table	Wiki		List of Battlegrounds cards that were also in Constructed that were created a separated id.
Template:WikiBgSeasonSnapshot table	Wiki		Snapshots of Battlegrounds seasons
Template:WikiBoosterPool table	Wiki		Extra info about Booster's pools.
Template:WikiBossRush table	Wiki		Information about Mercenaries' Boss Rushes and their setup for every single day.
Template:WikiCard table	Custom		Variations of official cards. They are only meant to perserve history of card-designing and not real cards.
Template:WikiCardPool table	Wiki		Pools of cards for generation
Template:WikiCountableText table	Wiki		Definitions of countable nouns that appear in card texts.
Template:WikiDisambiguation table	Custom		Disambiguation pages
Template:WikiDuelsSet table	Wiki		Information about [[Duels]] seasons.
Template:WikiMercenary table	Wiki		Manually defined mercs which didn't exist in client data, but designed to be like a merc.
Template:WikiMeta table	Custom		Metadata of the wiki pages. This is mainly used in [[:Category:Disambiguations|disambiguation]] pages to provide short description of the article.
Template:WikiSubmissionSound table	Custom		Transcripts that are being waited for revision by administrators.
Template:WikiTemp table	Custom		Temporary card change data which have been generated from article paragraphs by bot.
Template:WikiTwistRule table	Wiki		Information about [[Twist]] rules.
Template:WikiTwistSet table	Wiki		Information about [[Twist]] months.
Template:WikiVfxArtist table	Wiki		Information about vfx artists.
Template:WikiVideo table	Wiki		Data-oriented list of videos.
Template:WikiVoiceActor table	Wiki		Information about voice actor.
Template:Wing table	Client	200,097	WING