|
ObjectName
|
Type
|
Description
|
|
Aleigance_Organisation
|
RELATIONSHIP
|
|
|
Aleigence_Aleigence_Strength
|
RELATIONSHIP
|
|
|
Aleigence_Aleigence_Type
|
RELATIONSHIP
|
|
|
Alias
|
ENTITY
|
Alias maps two characters as being an alias of each other
|
|
Alias_Character
|
RELATIONSHIP
|
|
|
Allegiance
|
ENTITY
|
The relationshps between various Organisations.
|
|
Associated_Character
|
RELATIONSHIP
|
|
|
Association_Association_Category
|
RELATIONSHIP
|
|
|
Association_Association_Rating
|
RELATIONSHIP
|
|
|
Built_At
|
ENTITY
|
The mapping between a holding and the location it is built at.
|
|
Built_At_Location
|
RELATIONSHIP
|
|
|
Character
|
ENTITY
|
The properites of a character which are typically very static. These tend to be subjective attributes which a player defines rather than statistics, and are generally common to all RPGs. Another table is used to define the statistics for character if required.
|
|
Character_Alias
|
RELATIONSHIP
|
|
|
Character_Association
|
ENTITY
|
The associations which are made between characters.
|
|
Character_Associations
|
RELATIONSHIP
|
|
|
Character_Character
|
RELATIONSHIP
|
|
|
Character_Character_Event
|
RELATIONSHIP
|
|
|
Character_Character_Holding
|
RELATIONSHIP
|
|
|
Character_Character_Title
|
RELATIONSHIP
|
|
|
Character_Character_Type
|
RELATIONSHIP
|
|
|
Character_Holding
|
ENTITY
|
The mapping between a character and the character''s holdings. Including the dates between which the character possess the holdings.
|
|
Character_Holding_Holdings
|
RELATIONSHIP
|
|
|
Character_Organisations_Head
|
RELATIONSHIP
|
|
|
Character_Possession_List
|
RELATIONSHIP
|
|
|
Character_Report
|
RELATIONSHIP
|
|
|
Character_Sheet
|
ENTITY
|
A session character sheet. This still does not contain statistics, as this should be things like roumors etc.
|
|
Character_Sheet_Event_Subjectivity
|
RELATIONSHIP
|
|
|
Character_Sheet_Session
|
RELATIONSHIP
|
|
|
Character_Title
|
ENTITY
|
The mappings between the titles the character holds. This table also maintains the dates for which the character possessed the titles.
|
|
Character_Title_Title
|
RELATIONSHIP
|
|
|
Chr_Race
|
RELATIONSHIP
|
|
|
Chr_Subjectivity
|
RELATIONSHIP
|
|
|
Default_Character
|
RELATIONSHIP
|
The character the player will see when logging if, by default.
|
|
Event
|
ENTITY
|
Knowledge and Events, as defined by both the players and the GM
|
|
Event_Character_Sheet_Event
|
RELATIONSHIP
|
|
|
Event_Event
|
RELATIONSHIP
|
|
|
Event_Event_Type
|
RELATIONSHIP
|
|
|
Event_Was_At
|
RELATIONSHIP
|
|
|
Gm_Raiting_Event
|
RELATIONSHIP
|
|
|
Group
|
ENTITY
|
The available groups for administring the system. The name grp is to avoid a cofilict with a MySql reserved word.
|
|
Group_Roles
|
RELATIONSHIP
|
|
|
Group_User
|
RELATIONSHIP
|
|
|
Holding
|
ENTITY
|
The list of possible holdings which are available to be owned.
|
|
Holdings_Built_At
|
RELATIONSHIP
|
|
|
Holdings_Organisations_Holding
|
RELATIONSHIP
|
|
|
Is_At
|
ENTITY
|
This table stores the period when a prop was at a particular location.
|
|
Is_At_Location
|
RELATIONSHIP
|
|
|
Location
|
ENTITY
|
A game world location where knows and other such things can be located.
|
|
Location_Map
|
RELATIONSHIP
|
|
|
Lu_Allegiance_Strength
|
ENTITY
|
|
|
Lu_Allegiance_Type
|
ENTITY
|
The ratings which may be used to define the strength of an aleigence between organisations
|
|
Lu_Association_Category
|
ENTITY
|
Look Up Table - They type of the relation ship, friend, family, enemy
|
|
Lu_Association_Rating
|
ENTITY
|
Look Up Table - The strength of the relationship as the source character sees it.
|
|
Lu_Character_Type
|
ENTITY
|
What role can play the character
|
|
Lu_Event_Type
|
ENTITY
|
The list of possible classifications for an know.
|
|
Lu_Gm_Raiting
|
ENTITY
|
The raiting the GM gives the know about it''s validity
|
|
Lu_Organisation_Type
|
ENTITY
|
The types of social organisations which exist for this LARP
|
|
Lu_Race
|
ENTITY
|
The races of the world/universe/multiverse.
|
|
Lu_Rank
|
ENTITY
|
Defines the various ranks which titles can beston on their possesor.
|
|
Lu_Reliability
|
ENTITY
|
A description of all the levels of trustedness
|
|
Lu_Report_State
|
ENTITY
|
|
|
Map
|
ENTITY
|
The database representation of a map, which will usually be represented a graphic file.
|
|
Note
|
ENTITY
|
This table stores all of the notes which are kept about anything in the database.
|
|
Organisation
|
ENTITY
|
Organisations which exist in the LARP. There are many type as specified by the Organisation Type table
|
|
Organisation_Aleigance
|
RELATIONSHIP
|
|
|
Organisation_Event
|
RELATIONSHIP
|
|
|
Organisation_Member
|
ENTITY
|
Maintains a list of the characters which are members of an organisation.
|
|
Organisation_Member_Character
|
RELATIONSHIP
|
|
|
Organisation_Organisation_Member
|
RELATIONSHIP
|
|
|
Organisation_Organisation_Type
|
RELATIONSHIP
|
|
|
Organisation_Organisations_Head
|
RELATIONSHIP
|
|
|
Organisation_Organisations_Holding
|
RELATIONSHIP
|
|
|
Organisations_Head
|
ENTITY
|
The heads of all the organisations are listed in this table. A organisation head can be either another organisation or a character.
|
|
Organisations_Head_Organisation
|
RELATIONSHIP
|
|
|
Organisations_Holding
|
ENTITY
|
The mapping between an organisation and it''s holdings. Incliding the dates between which the organisation possessed the holdings.
|
|
Owned_By
|
RELATIONSHIP
|
|
|
Possession_List
|
ENTITY
|
|
|
Possession_List_Prop
|
RELATIONSHIP
|
|
|
Possession_List_Trustedness
|
RELATIONSHIP
|
|
|
Privilege
|
ENTITY
|
A list of the privlages the system recognises.
|
|
Prop
|
ENTITY
|
|
|
Prop_Event
|
RELATIONSHIP
|
|
|
Prop_Is_At
|
RELATIONSHIP
|
|
|
Prop_Prop
|
RELATIONSHIP
|
|
|
Report
|
ENTITY
|
|
|
Report_Report
|
RELATIONSHIP
|
|
|
Report_Report_State
|
RELATIONSHIP
|
|
|
Report_Session
|
RELATIONSHIP
|
|
|
Report_Subjectivity
|
RELATIONSHIP
|
|
|
Roles
|
ENTITY
|
A list of the roles which the system recognises.
|
|
Roles_Privilege
|
RELATIONSHIP
|
|
|
Session
|
ENTITY
|
Details about sessions
|
|
Session_Venue
|
RELATIONSHIP
|
|
|
Subjectivity
|
ENTITY
|
Defines a list of the knows know about for each character sheet.
|
|
Title
|
ENTITY
|
The list of possible titles that can be held, in the past, present and future
|
|
Title_Rank
|
RELATIONSHIP
|
|
|
Titles_Holding
|
ENTITY
|
The mapping between the holdings which the tile possesses
|
|
Titles_Holding_Holdings
|
RELATIONSHIP
|
|
|
Titles_Holding_Title
|
RELATIONSHIP
|
Defines the title which holds the property
|
|
Trustedness_Character_Sheet_Event
|
RELATIONSHIP
|
|
|
User
|
ENTITY
|
A list of all the users who may have access to the system.
|
|
User_Character
|
RELATIONSHIP
|
|
|
Venue
|
ENTITY
|
A list of locations where a session may be run. These are real world locations.
|
