Games

"Game" is a game being played (or planned) on the system.

Attributes:

ID: an automatically assigned number, used thoughout the system to link things to games.
Title: The displayed title for the game. Must be unique on the system.
Creator: The ID number of the user who created the game (Not the same as the Game Master)
Access: Access Control.
0 - Gestation. Only the Creator can even see the game exists. This state cannot be returned to.
1 - Users. Only accepted users may view or see the game.
2 - Anyone. Game is played in public, anyone can read it.
Description: A text/html description of the game, written originally by the Creator but then editable by any player with Gamemaster privaledges.
Status: 0 - Dead. This game has ceased to be and is unavailable within the system. Used for games that are stopped by the site admins for whatever reason. Uneditable, unviewable.
1 - Suspended. Game has been externally paused due to the players being suspected of attempting to break the system or some other transgression.
2 - Over. This game has finished, no new plays may be added, but the archive of previous posts can be seen according to access (see "game"). GMs and Archivist level players may add/edit documents.
3 - Paused. This game is in suspended animation by GM request. No new plays may be added until this state is removed.
4 - Active. Active game, characters may add plays, GMs and Archivist level players may add documents. People can play.
date_created: Timestamp of original creation of game.

Any user may create a game, they become the creator of it. Creators have the ability to bless users with player level, archivist level, or GM Level for that game. Games consist of "Plays" (Movements/descriptions by the players), "Messages" (Private messages between players) and "Documents" (Articles for player reference) all described below.

user

The backbone of the society. The cream in our coffee, the users. User accounts allow people to apply for games, characters are associated with games, and belong to players.

id: Unique, system generated, ID for a user. You are not a free particle, you are a number. Deal. You can use this as a username, just in case you aren fool enough to choose a username you can't spell consistantly.
username: A name of your own. How precious! You can log on as this, too.
password: An encrypted password, with which we check you are who you say you are. There is no known way of getting from our encryption to your password, so we'll generate a new one for you if you forget it. Aren't we kind?
name: The name by which you wish to be called on the site. This needn't be unique on the system.
email: Occasionally we will need to talk to our users. Rest assured it won't be often, nasty horrible creatures. But yet, we need this information.
date_joined: When they entered our realm.
prefs: A serialized string containing stuff we may need to know.

avatar

The people you are while playing the game. Not called characters for two very good reasons: first because some characters will be played by the same person (GMs), but mostly because I can write characters four times in a sentance and spell it differantly each time. It's a bug reduction measure, in other words.

id: See? Not only are you not a free person, but your avatar isn't either! Complain to your MP! You're being oppressed!
game: ID of the game the avatar belongs to. Avatars can be transfered between games, but can only be in one game at a time, or no games
owner: ID of the user who owns the avatar. Avatars can be transfered between users, but only if the new owner is in the same game that the Avatar is in, unless the Avatar isn't in a game.
name: Avatar's given name.
Bio: A place to put the backstory of your character. Or not.
Info: More information, like stats or something, you want to include.
description: Description of your appearance. If you like
Status: 0 - No current game
1 - Applied to be in game, awaiting GM of game. 2 - Active in game
date_created: When this Avatar was created
date_edited: Whenever any of this info was modified
date_confirmed: Date avatar was confirmed to enter the current game. Resets to zero if avatar is moved to a new game or user.

Access

id: It's an ID number for the access. You may be spotting a pattern here.
game: The ID of the game granted access to
user: The ID of the user granted access
level: Level granted:
0 - Banned, No access even if all access is granted to the world. Pointless, I grant you, since they could - I dunno - not be logged in, or something, but I digress.
1 - Applied, User has applied to be in game.
2 - Player, User is a player of said game, and able to access things that are players only.
3 - Archivist, Player who is allowed to add things to the Game Library, seen later.
4 - GM, Player is a games master, granted permission to add users to the game.
42 - God, user is Aquarion.
granted_by: Who granted this permission.
granted_date: When the permission was granted

Play

A play is a movement or turn in the game. It belongs to a game, and is only editable by the player who wrote it or a GM.

id: Blah Blah Free Man Blah Blah System Generated Blah.
title: an optional title of the play
game: The ID of the game the move was played in.
avatar: The ID of the charector who wrote the post
voice: Okay, this is slightly complicated. Since it is occasionally necessary to speak as one avatar being someone else, this box is here. So say Kharyis, a level 23 wizard, is pretending to be Bob so he can trick a guard, then "Bob" would be in the voice field. More usefully, it means a GM can create a dummy "GM" avatar and play NPCs by setting the Voice to, say "Shopkeeper".
date_created: Date the play was first posted.
date_edited: Date the post was last edited, will be displayed at the bottom of the post.
content: What Happens
OOC: Out Of Character Commentary box, completely optional and possibly best avoided, it enables the interface to provide the option to hide non-gaming text.

Document

Documents are text articles stored in a library for all players to read.

ID: ID number
game: The ID of the game the document is attached to
author: ID of the user who wrote or assembled the document
date_created: Creation date of the document
date_edited: Last edited date
Title: Title of the document
Content: Content of the document

Messages

Private messages sent from person to person, or person to people.

ID: [...]
Recieve: Avatar or User the message was sent to
Send: Who sent the message (User or Avatar)
Subject: What the message is about
Content: Content of the message
Sent: date message was sent
status: 0 - Unread
1 - Read
2 - Filed