(! - Generated; * - Mandatory; ? - Optional; & foreign key)
! ID - An identification number. (int)
* Title - Title of the game (Text-128 Unicode) (Unique to Campaign)
* ShortTitle - Short Title of the game for URLs. Autodefaulted from title (Text-64 Ascii)
& Campaign - A link to the parent campaign. (int)
0 - no campaign
* Description - Text description of the game. (medium unicode text)
& Owner - id of user who created - or otherwise owns - this game.
? World - Name of the world the universe/world is being played in (text-128, Unicode)
! Date_created (datetime)
! date_modified (datetime)
10 construction - game hasn't started yet
20 active - Game is in play
30 paused - Game is temporarily stopped
40 ended - Game is over.
10 - Only the owner can see the game
20 - Only the GMs can see the game
30 - Only the players can see the game
40 - Only logged in users can see the game
50 - anyone can see the game.
That’s an extract from today’s document. Going though this for every table gives me a good idea of where I’ve mucked up the data relationships, or put in circuler dependancies and maps fairly easily into SQL. Also it provides a reference which I can paste into a comment in the handling code (either this or the SQL itself) to give me a heads-up on the desired formats. Next Up: SQL