Plea:
I need help from a database administrator / designer to help me structure the the tables in a database.
I am just not a dBase guru when it comes to design.
The rough hierarchical structure needs to handle an OO run-time that looks something like this...when you drill down
Special Event
...Frame
......Team
.........Squad
............Pilot
...............Sortie
..................LogDataEntr
y
The trouble I am having is just looking at the bottom of the ladder, LogDataEntry. A log line can contain a ton of disparate data, such as the entry might be an object destroyed, an assist, a landing etc...if may or may not include reference to another pilot in the game for the event, such as an awarded kill, assisted another pilot, was shot down by etc.
The total of types for a log entry:
Departed (includes additional data the field)
Takes On Fuel (includes additional data the field)
Awarded Kill (includes the name of the victim)
Shot Down (includes the name of the victim and his plane type)
Assist (includes the name of the pilot assisted)
Destroyed (includes the base the object was attached to)
Was Shot Down (includes the name of the pilot who killed)
Bravely Bailed
Skillfully Ditched
Vanished
Arrived Safely (includes the field)
After the data is gathered from the logs, the program then goes back and fills in the missing pieces. For instance, and Awarded Kill then goes and looks up the pilot in the dBase and finds out what he was flying when the kill was awarded. And in the case of an Assist...it does the same thing.
I just do not know exactly how to structure my tables.
If their are any Data Base Guru's out there that can give me a few minutes on Team Speak to go over what I am trying to do and then suggest how to set up the database, I would be deeply grateful.
Not that it matters but I am coding in C# 3.5 via the VS 2008 and using SQL express...
Oneway
