Home › Database access › Tables used by the exe

Engine executable. Settings and tools of the game program (CivilizationVI.exe), usable without a mod. Mostly undocumented debug and configuration functionality; descriptions come from analysis of the executable and have not all been tried in the running game.

Tables used by the exe

Every table named in a statement, grouped by the database it runs against (inferred).

Mod framework (Mods.sqlite) (43 tables)

Table Operations Columns seen Functions
AdditionalScannedFiles INSERT 1, SELECT 1 LastWriteTime, Path, ScannedFileRowId Modding::ModDiscoveryService::DiscoverMods
ComponentCriteria SELECT 1, INSERT 1 Any, ComponentRowId, CriteriaRowId ModdingComponentDiscoveryService::FilterComponents, Modding::XmlModLoader::ParseModXml
ComponentFiles SELECT 1, INSERT 1 ComponentRowId, FileRowId, Path, Priority Modding::FileService::Initialize, Modding::ModLoaderService::ParseMod, Modding::XmlModLoader::ParseModXml
ComponentProperties INSERT 1, SELECT 1 ComponentRowId, Name, Value Modding::ModLoaderService::ParseMod, Modding::XmlModLoader::ParseModXml, Modding::PropertyService::Initialize
ComponentReferences INSERT 1 ComponentRowId, Priority, Uri Modding::XmlModLoader::ParseModXml
ComponentRelationships SELECT 1, INSERT 1 ComponentRowId, OtherComponentId, OtherModId, Relationship Modding::ModAssociationsService::Initialize, Modding::XmlModLoader::ParseModXml
Components SELECT 5, INSERT 1 ComponentId, ComponentRowId, ComponentType, ModRowId Modding::Framework::GetModComponents, Modding::Framework::GetComponentId, 0xb32ac0
Criteria SELECT 3, INSERT 1 Any, CriteriaId, CriteriaRowId, ModRowId ModdingComponentDiscoveryService::FilterComponents, ModdingSettingDiscoveryService::FilterSettings, Modding::XmlModLoader::ParseModXml
Criterion INSERT 1 CriteriaRowId, CriterionType, Inverse Modding::XmlModLoader::ParseModXml
CriterionProperties INSERT 1 CriterionRowId, Name, Value Modding::XmlModLoader::ParseModXml
GameCores SELECT 1 DllPrefix, GameCore, PackageId AppModdingFramework::GetDLLPathFromConfig
LocalizedText INSERT 1 Locale, ModRowId, Tag, Text Modding::XmlModLoader::ParseLocalizationBuffer, Modding::ModLoaderService::ParseMod
Map SELECT 1 MapSizeType ModdingWorldBuilderSettingHandler::LoadWorldBuilderDatabase
MapAttributes SELECT 2 Value GameCore::Serializer::Manager::ApplyModdingState, ModdingWorldBuilderSettingHandler::LoadWorldBuilderDatabase
MapLeaders INSERT 1 LeaderType, Map ModdingWorldBuilderSettingHandler::LoadWorldBuilderDatabase
Maps INSERT 2 Description, Domain, File, Name, StaticMap ModdingMapSettingHandler::BeginApplySettings
MapSupportedValues INSERT 1 Domain, Map, Value ModdingWorldBuilderSettingHandler::LoadWorldBuilderDatabase
MetaData SELECT 2, INSERT 1 Name, Value GameCore::Serializer::Manager::ApplyModdingState, Modding::ModLoaderService::ParseMod, GameCore::Serializer::Manager::SaveMetaData
Migrations SELECT 2 SQL Application::Data::GameSummaryDatabase::MigrateDatabaseData, Modding::Framework::MigrateDatabaseData
ModCompatibilityWhitelist SELECT 1, DELETE 1 1 Modding::Framework::IsModIgnoreCompatibility, Modding::Framework::SetModIgnoreCompatibility
ModComponents SELECT 1 ID, Type Modding::ModLoaderService::ParseMod
ModComponents_Items SELECT 1 Name, Value Modding::ModLoaderService::ParseMod
ModComponents_Properties SELECT 1 Name, Value Modding::ModLoaderService::ParseMod
ModDependencies SELECT 2 ID, Title GameCore::Serializer::Manager::ApplyModdingState, Modding::ModLoaderService::ParseMod
ModFiles SELECT 5, INSERT 1 1, FileRowId, ModRowId, Path Modding::FileService::Initialize, Modding::ModLoaderService::ParseMod, Modding::XmlModLoader::ParseModXml
ModGroupItems SELECT 2, DELETE 1, INSERT 1 Disabled, ModGroupRowId, ModId, ModRowId Modding::Framework::GetEnabledMods, Modding::Framework::ResetGroup, Modding::Framework::CreateModGroup
ModGroups SELECT 3, UPDATE 1, INSERT 1, DELETE 1 CanDelete, ModGroupRowId, Name, Selected, SortIndex Modding::Framework::GetModGroups, Modding::Framework::GetModGroupDetails, Modding::Framework::GetSelectedModGroup
ModProperties SELECT 3, INSERT 1 ModRowId, Name, Value GameCore::Serializer::Manager::UnserializeWorldBuilderState, ModdingWorldBuilderSettingHandler::LoadWorldBuilderDatabase, Modding::ModLoaderService::ParseMod
ModRelationships SELECT 1, INSERT 1 ModRowID, OtherModID, OtherModId, OtherModTitle, Relationship Modding::ModAssociationsService::Initialize, Modding::ModLoaderService::ParseMod, Modding::XmlModLoader::ParseModXml
Mods SELECT 8, INSERT 1 1, ModGroupRowId, ModId, ModRowId, Path, ScannedFileRowId, Version Modding::Framework::IsModInstalled, Modding::Framework::IsModHandleValid, Modding::Framework::GetModHandle
ModSettings SELECT 1 ID, Type Modding::ModLoaderService::ParseMod
ModSettings_Items SELECT 1 Name, Value Modding::ModLoaderService::ParseMod
ModSettings_Properties SELECT 1 Name, Value Modding::ModLoaderService::ParseMod
ModText SELECT 1 ID, Language, Value ModdingWorldBuilderSettingHandler::LoadWorldBuilderDatabase, Modding::ModLoaderService::ParseMod
Players SELECT 2 CivilizationType, LeaderType GameCore::Serializer::Manager::ApplyModdingState, ModdingWorldBuilderSettingHandler::LoadWorldBuilderDatabase
RulesetDomainOverrides SELECT 1 Domain ModdingWorldBuilderSettingHandler::LoadWorldBuilderDatabase
Rulesets SELECT 1 DllPrefix, GameCore, PackageId AppModdingFramework::GetDLLPathFromConfig
ScannedFiles SELECT 2, DELETE 1, INSERT 1 LastWriteTime, Path, ScannedFileRowId Modding::FileService::Initialize, Modding::ModDiscoveryService::DiscoverMods
SettingCriteria SELECT 1, INSERT 1 Any, CriteriaRowId, SettingRowId ModdingSettingDiscoveryService::FilterSettings, Modding::XmlModLoader::ParseModXml
SettingFiles SELECT 1, INSERT 1 FileRowId, Path, Priority, SettingRowId Modding::FileService::Initialize, Modding::ModLoaderService::ParseMod, Modding::XmlModLoader::ParseModXml
SettingProperties INSERT 1, SELECT 1 Name, SettingRowId, Value Modding::ModLoaderService::ParseMod, Modding::XmlModLoader::ParseModXml, Modding::PropertyService::Initialize
Settings SELECT 4, INSERT 1 ModRowId, SettingId, SettingRowId, SettingType Modding::Framework::GetModSettings, Modding::Framework::GetSettingId, 0xb35a10
StartPositions SELECT 1 Type, Value GameCore::Serializer::Manager::ApplyModdingState

Game summary (HallofFame.sqlite) (10 tables)

Table Operations Columns seen Functions
ChallengeGames SELECT 6, INSERT 1 ChallengeId, GameId, LeaderName, LeaderType, PlayerObjectId, VictoryType Application::GameSummary::BeginGameTransfer, 0xb55b0, 0xb4bd0
DataSets INSERT 2 DataSet, GameId, ObjectId, Type Application::GameSummary::BeginGameTransfer
DataSetValues SELECT 2, INSERT 1 DataSetId, X, Y Application::GameSummary::BeginGameTransfer, AppLuaGameSummaryLibrary::lGetGraphs
GameDataPointValues INSERT 1, SELECT 1 1, DataPoint, GameId, ValueNumeric, ValueObjectId, ValueString, ValueType Application::GameSummary::BeginGameTransfer, Application::GameSummary::UpdateAggregateDataPoints
GameObjects SELECT 6, INSERT 1 ExtraData, GameId, Icon, LeaderName, LeaderType, Name, PlayerObjectId, PlotIndex, Type, VictoryType Application::GameSummary::BeginGameTransfer, 0xb55b0, 0xb4bd0
GamePlayers SELECT 6, INSERT 1 CivilizationName, CivilizationType, DifficultyType, IsAI, IsLocal, IsMajor, LeaderName, LeaderType, PlayerId, PlayerObjectId, Score, TeamId, VictoryType Application::GameSummary::BeginGameTransfer, 0xb55b0, 0xb4bd0
Games SELECT 3, DELETE 1, INSERT 1 GameMode, GameSpeedType, LastPlayed, LeaderType, Map, MapSizeType, Ruleset, StartEraType, StartTurn, TurnCount, VictorTeamId, VictoryType Application::GameSummary::DeleteGame, Application::GameSummary::BeginGameTransfer, 0xb4bd0
GAMES SELECT 3 LeaderName, LeaderType, PlayerObjectId, VictoryType 0xb55b0, 0xb6130, 0xb4800
ObjectDataPointValues INSERT 1, SELECT 1 1, DataPoint, ObjectId, ValueNumeric, ValueObjectId, ValueString, ValueType Application::GameSummary::BeginGameTransfer, Application::GameSummary::UpdateAggregateDataPoints
RulesetDataPointValues DELETE 1 — Application::GameSummary::DeleteAggregateDataPoints

Game databases (48 tables)

Table Operations Columns seen Functions
AudioLanguages SELECT 1 AudioLanguage, Locale AppLuaLocaleLibrary::lGetAudioLanguages
CivilizationAudioTags SELECT 2 CivilizationType, MusicOverride AmbientAudio::StartupStrategyGame
CivilizationLeaders SELECT 1 LeaderType GameCore::App::Telemetry::Listener::OnPostLoadBegin
Civilizations SELECT 1 LeaderType GameCore::App::Telemetry::Listener::OnPostLoadBegin
CivilopediaTranslateCharacters SELECT 1 TranslateCharacter AppLuaSearchLibrary::lAddData
Colors SELECT 3, INSERT 1 Alpha, Blue, Color, Green, Red, Type GameCore::Color::Manager::PopulateDatabase, GameCore::Color::Manager::ScrapeDatabase
DataPointAggregateQueries SELECT 1 AggregateDataPoint, DataPoint, ExtraData, Operation, Query, SQL Application::GameSummary::UpdateAggregateDataPoints
DataPointAggregateUpdates SELECT 2 AggregateDataPoint, DataPoint, ExtraData, Operation, Query, SQL Application::GameSummary::DeleteAggregateDataPoints, Application::GameSummary::UpdateAggregateDataPoints
DefaultAudioLanguages SELECT 1 AudioLanguage Civ6App::UpdateLanguageIniSettings
DomainValues SELECT 1 Name 0x181380
Eras SELECT 2 ChronologyIndex, EraType GameCore::App::UI::Tree::TreeManager::GetEraList
Features SELECT 2 AddsFreshWater, FeatureType, Name 0x17e810, WorldView_StartupGame
FontStyleSheets SELECT 2 DefaultFont, StyleOverride, StyleSheet AppUIManager::GetStyleSheetAndDefaultFont, AppUIManager::GetStyleSheetLanguageOverrides
GlobalParameters SELECT 2 Name, Value Application::Data::GameplayDatabase::Initialize, AppLuaDBLibrary::lua_RegisterGlobalParametersLibrary
GraphQueries SELECT 2 — AppLuaGameSummaryLibrary::lGetGraphs
GraphRulesetOverrides SELECT 1 — AppLuaGameSummaryLibrary::lGetGraphs
Graphs SELECT 2 — AppLuaGameSummaryLibrary::lGetGraphs
IconAliases SELECT 1 Name, OtherName DatabaseIconProvider::ScrapeDatabase
IconDefinitions SELECT 1 Atlas, Name DatabaseIconProvider::ScrapeDatabase
IconTextureAtlases SELECT 1 Baseline, FileName, IconSize, IconsPerRow, Name, OffsetH, OffsetV DatabaseIconProvider::ScrapeDatabase
InputActionDefaultGestures SELECT 1 GestureData, GestureType CivTech::Input::Manager::ReloadInputActions
InputActions SELECT 1 ActionId, Description, LayoutType, Name, Value CivTech::Input::Manager::ReloadInputActions
InputCategories SELECT 1 ActionId, Description, LayoutType, Name, Value CivTech::Input::Manager::ReloadInputActions
InputContexts SELECT 1 ActionId, Description, LayoutType, Name, Value CivTech::Input::Manager::ReloadInputActions
InputKeyData SELECT 1 KeyIcon, KeyId, KeyString, KeyType CivTech::Input::Manager::LoadKeyData
Languages SELECT 1 SupportsSmallCaps AppUIManager::AppUIManager
Leaders SELECT 1 LeaderType GameCore::App::Telemetry::Listener::OnPostLoadBegin
Maps SELECT 1 Domain, File 0xb8840
NavigationProperties SELECT 1 BaseTable, IsCollection, PropertyName, Query, TargetTable AppLuaDBLibrary::lua_RegisterDatabase
PlayerColors SELECT 2, INSERT 1 Alt1PrimaryColor, Alt1SecondaryColor, Alt2PrimaryColor, Alt2SecondaryColor, Alt3PrimaryColor, Alt3SecondaryColor, PrimaryColor, SecondaryColor, Type, Usage GameCore::Color::Manager::PopulateDatabase, GameCore::Color::Manager::ScrapeDatabase
Players SELECT 2 CivilizationIcon, CivilizationName, CivilizationType, LeaderIcon, LeaderName, LeaderType 0xb4bd0, AppLuaGameSummaryLibrary::lGetLeaderProgress, AppLuaGameSummaryLibrary::lGetRulesetPlayableLeaders
ReportColumnRulesetOverrides SELECT 1 — AppLuaGameSummaryLibrary::lGetReports
ReportColumns SELECT 2 — AppLuaGameSummaryLibrary::lGetReports
ReportQueries SELECT 2 — AppLuaGameSummaryLibrary::lGetReports
ReportRulesetOverrides SELECT 1 — AppLuaGameSummaryLibrary::lGetReports
Reports SELECT 2 — AppLuaGameSummaryLibrary::lGetReports
RulesetDomainOverrides SELECT 2 Domain 0xb4bd0, AppLuaGameSummaryLibrary::lGetLeaderProgress, AppLuaGameSummaryLibrary::lGetRulesetPlayableLeaders
Rulesets SELECT 3 Description, GameCore, IsScenario, Name, RulesetType, SortIndex, VictoryDomain 0xb55b0, GameCoreInUseCriterion::BeforeCheck, AppLuaGameSummaryLibrary::lGetAvailableRulesets
RulesetTypes SELECT 1 Icon, Kind, Name, Type AppLuaGameSummaryLibrary::lGetRulesetTypes
RulesetUnSupportedValues SELECT 2 CivilizationIcon, CivilizationName, CivilizationType, LeaderIcon, LeaderName, LeaderType 0xb4bd0, AppLuaGameSummaryLibrary::lGetLeaderProgress, AppLuaGameSummaryLibrary::lGetRulesetPlayableLeaders
sqlite_master SELECT 1 1 GameCore::App::UI::Tree::TreeManager::GetListFromDB, GameCore::App::UI::Tree::TreeManager::GetListFromGameCore
sqlite_sequence SELECT 1 seq Application::GameSummary::BeginGameTransfer
StatisticCategories SELECT 1 — AppLuaGameSummaryLibrary::lGetStatisticsCategories
StatisticCategoryRulesetOverrides SELECT 1 — AppLuaGameSummaryLibrary::lGetStatisticsCategories
StatisticRulesetOverrides SELECT 1 — AppLuaGameSummaryLibrary::lGetStatistics
Statistics SELECT 1 — AppLuaGameSummaryLibrary::lGetStatistics
SteamLanguages SELECT 1 Locale Civ6App::UpdateLanguageIniSettings
Victories SELECT 4 EnabledByDefault, Icon, Name, VictoryType 0xb55b0, 0x1801f0, Network::Manager::OnTeamVictory