-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathschema-simplified.txt
40 lines (40 loc) · 13 KB
/
schema-simplified.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
Home_Player_Listing: ID, idPlayer_Names, strName, idPlayer_Types, idTeam_Listing, idTeam_Listing_Previous, idRaces, iPlayerColor, iSkinScalePercent, iSkinMeshVariant, iSkinTextureVariant, fAgeing, iNumber, Characteristics_fMovementAllowance, Characteristics_fStrength, Characteristics_fAgility, Characteristics_fArmourValue, idPlayer_Levels, iExperience, idEquipment_Listing_Helmet, idEquipment_Listing_Pauldron, idEquipment_Listing_Gauntlet, idEquipment_Listing_Boot, Durability_iHelmet, Durability_iPauldron, Durability_iGauntlet, Durability_iBoot, iSalary, Contract_iDuration, Contract_iSeasonRemaining, idNegotiation_Condition_Types, Negotiation_iRemainingTries, Negotiation_iConditionDemand, iValue, iMatchSuspended, iNbLevelsUp, LevelUp_iRollResult, LevelUp_iRollResult2, LevelUp_bDouble, bGenerated, bStar, bEdited, bDead, strLevelUp
Home_Player_Types: ID, DATA_CONSTANT, idRaces, idPlayer_BaseTypes, idPlayer_Name_Types, idStrings_Localized, strName, Characteristics_fMovementAllowance, Characteristics_fStrength, Characteristics_fAgility, Characteristics_fArmourValue, iPrice, iMaxQuantity
Home_Player_Skills: ID, idPlayer_Listing, idSkill_Listing
Home_Player_Type_Skills: ID, idPlayer_Types, idSkill_Listing, DESCRIPTION
Home_Player_Type_Skill_Categories_Normal: ID, idPlayer_Types, idSkill_Categories, DESCRIPTION
Home_Player_Type_Skill_Categories_Double: ID, idPlayer_Types, idSkill_Categories, DESCRIPTION
Home_Player_Casualties: ID, idPlayer_Listing, idPlayer_Casualty_Types
Home_Equipment_Listing: ID, idStrings_Localized, strName, idRaces, idPlayer_Types, idEquipment_Types, idEquipment_Visuals, iPrice, idPlayer_Levels, iDurability, idCharacteristics_Bonus, idCharacteristics_Malus, iQuantifier_Bonus, iQuantifier_Malus, bUseable, fBuffProba, bCustom
Home_Team_Listing: ID, strName, idRaces, strLogo, iTeamColor, strLeitmotiv, strBackground, iValue, iPopularity, iCash, iCheerleaders, iBalms, bApothecary, iRerolls, bEdited, idTeam_Listing_Filters, idStrings_Formatted_Background, idStrings_Localized_Leitmotiv, iNextPurchase, iAssistantCoaches
Home_Races: ID, DATA_CONSTANT, idStrings_Localized, idStrings_Localized_Info, strName, iRerollPrice
Home_Team_Rankings: ID, idTeam_Listing, idRule_Types, iSeason, iGroup, iPoints, iRanking, iWins, iDraws, iLosses, iTeamValue
Home_Statistics_Players: ID, idPlayer_Listing, iMatchPlayed, iMVP, Inflicted_iPasses, Inflicted_iCatches, Inflicted_iInterceptions, Inflicted_iTouchdowns, Inflicted_iCasualties, Inflicted_iTackles, Inflicted_iKO, Inflicted_iStuns, Inflicted_iInjuries, Inflicted_iDead, Inflicted_iMetersRunning, Inflicted_iMetersPassing, Sustained_iInterceptions, Sustained_iCasualties, Sustained_iTackles, Sustained_iKO, Sustained_iStuns, Sustained_iInjuries, Sustained_iDead
Home_Statistics_Season_Players: ID, idPlayer_Listing, iSeason, iMatchPlayed, iMVP, Inflicted_iPasses, Inflicted_iCatches, Inflicted_iInterceptions, Inflicted_iTouchdowns, Inflicted_iCasualties, Inflicted_iTackles, Inflicted_iKO, Inflicted_iStuns, Inflicted_iInjuries, Inflicted_iDead, Inflicted_iMetersRunning, Inflicted_iMetersPassing, Sustained_iInterceptions, Sustained_iCasualties, Sustained_iTackles, Sustained_iKO, Sustained_iStuns, Sustained_iInjuries, Sustained_iDead
Home_Statistics_Teams: ID, idTeam_Listing, iMatchPlayed, iMVP, Inflicted_iPasses, Inflicted_iCatches, Inflicted_iInterceptions, Inflicted_iTouchdowns, Inflicted_iCasualties, Inflicted_iTackles, Inflicted_iKO, Inflicted_iInjuries, Inflicted_iDead, Inflicted_iMetersRunning, Inflicted_iMetersPassing, Sustained_iPasses, Sustained_iCatches, Sustained_iInterceptions, Sustained_iTouchdowns, Sustained_iCasualties, Sustained_iTackles, Sustained_iKO, Sustained_iInjuries, Sustained_iDead, Sustained_iMetersRunning, Sustained_iMetersPassing, iPoints, iWins, iDraws, iLoss, iBestMatchRating, Average_iMatchRating, Average_iSpectators, Average_iCashEarned, iSpectators, iCashEarned, iPossessionBall, Occupation_iOwn, Occupation_iTheir
Home_Statistics_Season_Teams: ID, idTeam_Listing, iSeason, iMatchPlayed, iMVP, Inflicted_iPasses, Inflicted_iCatches, Inflicted_iInterceptions, Inflicted_iTouchdowns, Inflicted_iCasualties, Inflicted_iTackles, Inflicted_iKO, Inflicted_iInjuries, Inflicted_iDead, Inflicted_iMetersRunning, Inflicted_iMetersPassing, Sustained_iPasses, Sustained_iCatches, Sustained_iInterceptions, Sustained_iTouchdowns, Sustained_iCasualties, Sustained_iTackles, Sustained_iKO, Sustained_iInjuries, Sustained_iDead, Sustained_iMetersRunning, Sustained_iMetersPassing, iPoints, iWins, iDraws, iLoss, iBestMatchRating, Average_iMatchRating, Average_iSpectators, Average_iCashEarned, iSpectators, iCashEarned, iPossessionBall, Occupation_iOwn, Occupation_iTheir
Home_AI_Positions: ID, idAI_Tactics, iList_Cell, iList_idAI_Character_Role_Types, iRosterNumber, Attack_idAI_Character_Roles, Defense_idAI_Character_Roles, Priority
Home_AI_Tactics: ID, CONSTANT, idTeam_Listing, iList_AI_Character_Role_Types, idStrings_Localized, strName
Home_Races_StarPlayers: ID, idRaces, idPlayer_Types, DESCRIPTION
Away_Player_Listing: ID, idPlayer_Names, strName, idPlayer_Types, idTeam_Listing, idTeam_Listing_Previous, idRaces, iPlayerColor, iSkinScalePercent, iSkinMeshVariant, iSkinTextureVariant, fAgeing, iNumber, Characteristics_fMovementAllowance, Characteristics_fStrength, Characteristics_fAgility, Characteristics_fArmourValue, idPlayer_Levels, iExperience, idEquipment_Listing_Helmet, idEquipment_Listing_Pauldron, idEquipment_Listing_Gauntlet, idEquipment_Listing_Boot, Durability_iHelmet, Durability_iPauldron, Durability_iGauntlet, Durability_iBoot, iSalary, Contract_iDuration, Contract_iSeasonRemaining, idNegotiation_Condition_Types, Negotiation_iRemainingTries, Negotiation_iConditionDemand, iValue, iMatchSuspended, iNbLevelsUp, LevelUp_iRollResult, LevelUp_iRollResult2, LevelUp_bDouble, bGenerated, bStar, bEdited, bDead, strLevelUp
Away_Player_Types: ID, DATA_CONSTANT, idRaces, idPlayer_BaseTypes, idPlayer_Name_Types, idStrings_Localized, strName, Characteristics_fMovementAllowance, Characteristics_fStrength, Characteristics_fAgility, Characteristics_fArmourValue, iPrice, iMaxQuantity
Away_Player_Skills: ID, idPlayer_Listing, idSkill_Listing
Away_Player_Type_Skills: ID, idPlayer_Types, idSkill_Listing, DESCRIPTION
Away_Player_Type_Skill_Categories_Normal: ID, idPlayer_Types, idSkill_Categories, DESCRIPTION
Away_Player_Type_Skill_Categories_Double: ID, idPlayer_Types, idSkill_Categories, DESCRIPTION
Away_Player_Casualties: ID, idPlayer_Listing, idPlayer_Casualty_Types
Away_Equipment_Listing: ID, idStrings_Localized, strName, idRaces, idPlayer_Types, idEquipment_Types, idEquipment_Visuals, iPrice, idPlayer_Levels, iDurability, idCharacteristics_Bonus, idCharacteristics_Malus, iQuantifier_Bonus, iQuantifier_Malus, bUseable, fBuffProba, bCustom
Away_Team_Listing: ID, strName, idRaces, strLogo, iTeamColor, strLeitmotiv, strBackground, iValue, iPopularity, iCash, iCheerleaders, iBalms, bApothecary, iRerolls, bEdited, idTeam_Listing_Filters, idStrings_Formatted_Background, idStrings_Localized_Leitmotiv, iNextPurchase, iAssistantCoaches
Away_Races: ID, DATA_CONSTANT, idStrings_Localized, idStrings_Localized_Info, strName, iRerollPrice
Away_Team_Rankings: ID, idTeam_Listing, idRule_Types, iSeason, iGroup, iPoints, iRanking, iWins, iDraws, iLosses, iTeamValue
Away_Statistics_Players: ID, idPlayer_Listing, iMatchPlayed, iMVP, Inflicted_iPasses, Inflicted_iCatches, Inflicted_iInterceptions, Inflicted_iTouchdowns, Inflicted_iCasualties, Inflicted_iTackles, Inflicted_iKO, Inflicted_iStuns, Inflicted_iInjuries, Inflicted_iDead, Inflicted_iMetersRunning, Inflicted_iMetersPassing, Sustained_iInterceptions, Sustained_iCasualties, Sustained_iTackles, Sustained_iKO, Sustained_iStuns, Sustained_iInjuries, Sustained_iDead
Away_Statistics_Season_Players: ID, idPlayer_Listing, iSeason, iMatchPlayed, iMVP, Inflicted_iPasses, Inflicted_iCatches, Inflicted_iInterceptions, Inflicted_iTouchdowns, Inflicted_iCasualties, Inflicted_iTackles, Inflicted_iKO, Inflicted_iStuns, Inflicted_iInjuries, Inflicted_iDead, Inflicted_iMetersRunning, Inflicted_iMetersPassing, Sustained_iInterceptions, Sustained_iCasualties, Sustained_iTackles, Sustained_iKO, Sustained_iStuns, Sustained_iInjuries, Sustained_iDead
Away_Statistics_Teams: ID, idTeam_Listing, iMatchPlayed, iMVP, Inflicted_iPasses, Inflicted_iCatches, Inflicted_iInterceptions, Inflicted_iTouchdowns, Inflicted_iCasualties, Inflicted_iTackles, Inflicted_iKO, Inflicted_iInjuries, Inflicted_iDead, Inflicted_iMetersRunning, Inflicted_iMetersPassing, Sustained_iPasses, Sustained_iCatches, Sustained_iInterceptions, Sustained_iTouchdowns, Sustained_iCasualties, Sustained_iTackles, Sustained_iKO, Sustained_iInjuries, Sustained_iDead, Sustained_iMetersRunning, Sustained_iMetersPassing, iPoints, iWins, iDraws, iLoss, iBestMatchRating, Average_iMatchRating, Average_iSpectators, Average_iCashEarned, iSpectators, iCashEarned, iPossessionBall, Occupation_iOwn, Occupation_iTheir
Away_Statistics_Season_Teams: ID, idTeam_Listing, iSeason, iMatchPlayed, iMVP, Inflicted_iPasses, Inflicted_iCatches, Inflicted_iInterceptions, Inflicted_iTouchdowns, Inflicted_iCasualties, Inflicted_iTackles, Inflicted_iKO, Inflicted_iInjuries, Inflicted_iDead, Inflicted_iMetersRunning, Inflicted_iMetersPassing, Sustained_iPasses, Sustained_iCatches, Sustained_iInterceptions, Sustained_iTouchdowns, Sustained_iCasualties, Sustained_iTackles, Sustained_iKO, Sustained_iInjuries, Sustained_iDead, Sustained_iMetersRunning, Sustained_iMetersPassing, iPoints, iWins, iDraws, iLoss, iBestMatchRating, Average_iMatchRating, Average_iSpectators, Average_iCashEarned, iSpectators, iCashEarned, iPossessionBall, Occupation_iOwn, Occupation_iTheir
Away_AI_Positions: ID, idAI_Tactics, iList_Cell, iList_idAI_Character_Role_Types, iRosterNumber, Attack_idAI_Character_Roles, Defense_idAI_Character_Roles, Priority
Away_AI_Tactics: ID, CONSTANT, idTeam_Listing, iList_AI_Character_Role_Types, idStrings_Localized, strName
Away_Races_StarPlayers: ID, idRaces, idPlayer_Types, DESCRIPTION
SavedGameInfo: ID, strName, strSaveDate, strVersion, Championship_idTeam_Listing, Championship_strTeamName, Championship_idTeamLogo, Championship_idRule_Types_Current, Championship_iCurrentDay, Championship_iCurrentSeason, Championship_iTeamCash, Championship_iTeamValue, Championship_iTeamPopularity, Campaign_idCampaign_Listing, Campaign_bRealTime, Campaign_iTeamPrestige, Campaign_iCurrentPeriod, Match_strSave, Match_idDifficultyLevels, Match_iStadium, Match_bDeathZoneEnabled, iSlot, strTeamLogo, iLogoRace, iLogoIndex, strAvailableRaces, iInMatch, iRace, Story_strName, Story_strContext
Calendar: ID, idTeam_Listing_Away, idTeam_Listing_Home, Championship_iSeason, Championship_iDay, Championship_iGroup, Championship_idRule_Types, Championship_iEliminitationLevel, Playoff_iEliminationLevel, Playoff_bAwayGame, Away_iScore, Away_iReward, Away_iCashEarned, Away_iPossessionBall, Away_Occupation_iOwn, Away_Occupation_iTheir, Away_iMVP, Away_Inflicted_iPasses, Away_Inflicted_iCatches, Away_Inflicted_iInterceptions, Away_Inflicted_iTouchdowns, Away_Inflicted_iCasualties, Away_Inflicted_iTackles, Away_Inflicted_iKO, Away_Inflicted_iInjuries, Away_Inflicted_iDead, Away_Inflicted_iMetersRunning, Away_Inflicted_iMetersPassing, Away_Sustained_iPasses, Away_Sustained_iCatches, Away_Sustained_iInterceptions, Away_Sustained_iTouchdowns, Away_Sustained_iCasualties, Away_Sustained_iTackles, Away_Sustained_iKO, Away_Sustained_iInjuries, Away_Sustained_iDead, Away_Sustained_iMetersRunning, Away_Sustained_iMetersPassing, Away_iMetersRunning, Away_iMetersPassing, Home_iScore, Home_iReward, Home_iCashEarned, Home_iPossessionBall, Home_Occupation_iOwn, Home_Occupation_iTheir, Home_iMVP, Home_Inflicted_iPasses, Home_Inflicted_iCatches, Home_Inflicted_iInterceptions, Home_Inflicted_iTouchdowns, Home_Inflicted_iCasualties, Home_Inflicted_iTackles, Home_Inflicted_iKO, Home_Inflicted_iInjuries, Home_Inflicted_iDead, Home_Inflicted_iMetersRunning, Home_Inflicted_iMetersPassing, Home_Sustained_iPasses, Home_Sustained_iCatches, Home_Sustained_iInterceptions, Home_Sustained_iTouchdowns, Home_Sustained_iCasualties, Home_Sustained_iTackles, Home_Sustained_iKO, Home_Sustained_iInjuries, Home_Sustained_iDead, Home_Sustained_iMetersRunning, Home_Sustained_iMetersPassing, Home_iMetersRunning, Home_iMetersPassing, iSpectators, iRating, bPlayed
Rule_Listing: ID, DESCRIPTION, idStringsLocalized, idStringsLocalizedInfo, strName, bRealTime, iNbTeams, idRule_Types, Championship_iNbGroups, Championship_iNbMatchsPerGroup, Cup_iNbGroups, Cup_iNbMatchsPerGroup, Playoff_iStartingLevel, Playoff_iDoubleElimination, bChallenge, Reward_iWinner, Reward_iLoser, bSponsor, bBuyExperiencedPlayers, bDeath, bAgeing, bNegociation, bMagic, bBribery, bDoping, Coups_bCoupDeMain, Coups_bCoupFiesta, bPreMatchEvent, Max_iCheerleaders, Max_iBalms, Max_iRerolls, Max_iPopularity, Max_iExperienceLevel, bStarPlayers, bEquipment, bCustomEquipment, iMatchDuration, MatchDuration_iRT, MatchDuration_iTT, idTrophy_Names, Trophy_strName, idTrophy_Visuals, bExtendedInducements, bContracts, bTraining, bRacialScrolls
Replay_NetCommands: ID, iTurn, iPlayerIndex, iType, iPart1, iPart2, iPart3, iPart4, iPart5, iPart6, iPart7, iPart8, iPart9, iPart10, iPart11, iPart12