Aquarionics

PFd4-II - Database Design

(! - Generated; * - Mandatory; ? - Optional; & foreign key)
Game
----

ID
Campaign
Title
Description
Owner
World
Date_created
date_modified
status
view-permissions

! 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)
	Magic:
		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)
* status
	10 construction - game hasn't started yet
	20 active - Game is in play
	30 paused - Game is temporarily stopped
	40 ended - Game is over.
* view-permissions
	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