Ok so, I've been in development of my own Database for quite a while now and although it was only going to be for my own use, I'm very happy with how it's turning out so thought I'd gauge any interest in a public release.
Intro:
The DB is based on the season 2019/2020 and won't be updated to current years, the reason for this, is that the whole aim is to create a DB that is the most accurate, most realistic and least bloated available, constantly updating means this can't really happen. The 19/20 season was obviously the last before covid hit and when i started doing this DB in the 20/21 season some leagues weren't fully running so it made sense just to stick with 19/20
The DB was created by using the default historical 2006 DB that comes with the game, this default DB had the least amount of data that cant be deleted i.e only around 4500 clubs, 500 Comps etc so was the perfect one to start with, All players, staff, officials were deleted so it was semi blank.
Playable Leagues:
See the screenshot below for what leagues are available to play
View attachment 590402
Leagues were selected based on how accurately they can be represented, so no US junior or college leagues, and how many games are in the season. I would love to have included the Spanish league for example, but they only play 16 games which would make for a boring game. BeNe League is included as although the season only has 20 games, they also have two cup competitions that increase it to over 30.
League Rules and Structures:
Every playable league has been built from scratch and sim tested until 2050 multiple times to ensure there are no bugs, no conflicts with international tournaments, drafts or playoffs and all rules are working correctly.
The rules have been established as close to real life as possible. Most leagues have official rulebooks available, so this has been what I have used to decide what to add. Some rules are not possible to 100% add so some variations have been done. For example in Belarus the top league has a rule of only 7 players over the age of 27 on the roster, this isnt possible to add in EHM without causing other issues so I have added a limit of 7 vets on the roster based on games played of 440 which after testing does closely match the age limit.
Teams which compete in more than one National comp has been implemented. So Jesenice will play in both the Alps league the domestic Slovenian league, Corona Brasov in both the Eerste Liga and domestic Romanian League, Triglav in the domestic Slovenian League and the International League for just a few examples.
International Competitions:
Same as above, international comps have been accurately modelled and, in some cases, expanded. See below for a list:
View attachment 590407
Most notable feature here is an expanded U20 World Championship to include the lower divisions
View attachment 590408
Naming convention:
I've took a leaf out of an add on for Football Manager I used to use for real name fixes, this creates a consistency in names for clubs and leagues. The long name will be expanded so, example, instead of long name Brynas IF and Short name being Brynas it becomes like the below
View attachment 590411
Where the short name will become Brynas IF.
As can be seen in the playable league list, Leagues names and named as they would be locally for example Drzavno Prvenstvo Slovenije for the Slovenian National League.
Finances/Salaries:
I have spent an obscene amount of time on the finance info section of the editor to try and model European player salaries as realistically as possible. Team budgets and player wages are based on numerous local paper articles for leagues like the SHL,NLA and also on agent websites which list average wages for each league. Player wages will not be accurate as nobody, outside of the KHL and a few players in other top league are known, but they do match team budgets.
View attachment 590413
View attachment 590414
This is just a small peak. Later on, after I've finished a bit more stuff Ill demonstrate how this DB will handle prospect generation and some other stuff. If there is anything people want me to screenshot and show now or talk about, just let me know.