Lee, here's what I've currently going on the data model:
(This is where we store characters, not players)
*Profile ID is tied to a different table that stores the actual user's (real world) info, not the character's info.
(This is where we store what happened in the mission)
**List of bridges involved in the session
(This is where we store where the characters work during a particular session)
*** The bridge ID; each bridge should be assigned a unique number
****Selectable from Crewmember table, delimited by faction
All of these sessions would have unique IDs, so a specific mission would be tied to a Session, which would be tied one or more bridges, each of which would be a bridge instance containing several crewmembers.
There should be a larger Universe table as well; these will be instanced versions globalized mods/game universes that keep track of overall victories/defeats among multiple bridges against preset victory conditions (E.G.: Universe 48 is stock Artemis, and the first faction to make it to 20 victories/accumulate 20 victory points wins). This enables a "league" type ongoing war situation.
I'm still building it out, but I'd love to hear any feedback or suggestions!
[Last edited Oct 19, 2012 09:40:21]