Field	Type	Description
Id	int	Table record number/id
Setting_id	int	Setting identification #
Campaign_no	int	Campaign number
Chest_No	int	Chest number. A single find of treasure is considered a chest. Heterogeneous treasure in a single find required multiple records in this table, but with the same chest number. The chest number is unique when keyed with the setting id and campaign number.
Amount	int	Amount - number of coins, number of jewels, etc.
xp	int	Experience point worth of this piece of treasure.
Worth	int	Worth of the item in gp.
Possession_id	int	The Possession id field.
Treasure_Type	enum	Treasure type/category.
Item_Label	string	The Item Label field.
Time_Year	int	The Time Year field.
Time_Month	int	The Time Month field.
Time_Day	int	The Time Day field.
Time_Hour	int	The Time Hour field.
Time_Minute	int	The Time Minute field.
Curr_Time	int	The Curr Time field.
Time_Second	int	The Time Second field.
Location	string	The Location field.

Table: CampaignLog

The CampaignLog is the common log amongst the members of an adventure party when campaigning/adventuring.

Field	Type	Description
Id	int	Table record number/id
Setting_id	int	Setting identification #
Campaign_no	int	Campaign number
Message	string	Log message worth noting.
Time_Year	int	Timestamp Year
Time_Month	int	Timestamp Month
Time_Day	int	Timestamp Day
Time_Hour	int	Timestamp Hour
Time_Minute	int	Timestamp Minute
Curr_Time	int	The Curr Time field.
Location	string	The Location field.

Table: CampaignRecord

The CampaignRecord table schema:

Field	Type	Description
Id	int	Table record number/id.
Setting_id	int	The Setting id field.
Campaign_no	int	The Campaign no field.
Locale	int	The Locale field.
Start_Year	int	The Start Year field.
Start_Month	int	The Start Month field.
Start_Day	int	The Start Day field.
Start_Hour	int	The Start Hour field.
Start_Minute	int	The Start Minute field.
Start_Time	int	The Start Time field.
Stop_Year	int	The Stop Year field.
Stop_Month	int	The Stop Month field.
Stop_Day	int	The Stop Day field.
Stop_Hour	int	The Stop Hour field.
Stop_Minute	int	The Stop Minute field.
Stop_Time	int	The Stop Time field.
XP_Slain	int	The XP Slain field.
XP_Booty	int	The XP Booty field.
XP_Bonus	int	The XP Bonus field.
XP_Multiplier	float	The XP Multiplier field.
XP_Share	int	The XP Share field.
PC_list	string	The PC list field.

Table: CartReceipt

The CartReceipt table schema:

Field	Type	Description
Id	int	Table record number/id.
Xact_id	int	The Xact id field.
Catalog_id	int	The Catalog id field.
Price	float	The Price field.
Amount	float	The Amount field.
Discount	float	The Discount field.
DiscountCode	string	The DiscountCode field.
R_Vendor	float	The R Vendor field.
R_Site	float	The R Site field.
Timestamp	int	The Timestamp field.
User_id	int	The User id field.
Vendor_id	int	The Vendor id field.
Type	string	The Type field.
Quantity	int	The Quantity field.
ShipTo	string	The ShipTo field.
Terms	string	The Terms field.

Table: CatalogIndex

The CatalogIndex table schema:

Field	Type	Description
Id	int	Table record number/id.
Title	string	The Title field.
Domain	string	The Domain field.
Website	string	The Website field.
TabLayout	string	The TabLayout field.
Description	string	The Description field.
Featured	string	The Featured field.
Popular	string	The Popular field.
Intro	string	The Intro field.
Free	string	The Free field.
Thumbnail	int	The Thumbnail field.

Table: CatalogItem

The CatalogItem table schema:

Field	Type	Description
Id	int	Table record number/id.
Catalog_id	int	The Catalog id field.
Visible	boolean	The Visible field.
Version	float	The Version field.
Title	string	The Title field.
Series	string	The Series field.
Vendor_id	int	The Vendor id field.
Author	string	The Author field.
Difficulty	string	The Difficulty field.
Description	string	The Description field.
ReleaseDate	int	The ReleaseDate field.
CopyrightYear	int	The CopyrightYear field.
CopyrightHolder	string	The CopyrightHolder field.
SystemTarget	string	The SystemTarget field.
SystemCompat	string	The SystemCompat field.
Thumbnail	int	The Thumbnail field.
EDelivery	boolean	The EDelivery field.
Price	float	The Price field.
UpgradePrice	float	The UpgradePrice field.
Layout	string	The Layout field.
Rating	boolean	The Rating field.
Score	float	The Score field.
NoAreas	int	The NoAreas field.
NoLevels	int	The NoLevels field.
NoDetails	int	The NoDetails field.
NoPurchases	int	The NoPurchases field.
NoReturns	int	The NoReturns field.
NoReviews	int	The NoReviews field.
SharedWith	string	The SharedWith field.

Table: CatalogShop

The CatalogShop table schema:

Field	Type	Description
Id	int	Table record number/id.
Catalog_id	int	The Catalog id field.
VendorName	string	The VendorName field.
VendorEmail	string	The VendorEmail field.
VendorWebsite	string	The VendorWebsite field.
Country	string	The Country field.
Province	string	The Province field.
NoModulesInCatalog	int	The NoModulesInCatalog field.
NoModulesSold	int	The NoModulesSold field.
Score	float	The Score field.
TabLayout	string	The TabLayout field.
Description	string	The Description field.
Featured	string	The Featured field.
Intro	string	The Intro field.
Free	string	The Free field.
Thumbnail	int	The Thumbnail field.

Table: CharWeapon

This table is for tracking the weapons that a player character (PC) possesses.

Field	Type	Description
Id	int	Table record number/id
PC_id	int	PC identification #
Weapon_Type	int	Weapon id from the Weapon table.
Bonus_Damage	int	Bonus Damage, e.g. magical plus
Proficient	boolean	Proficient - T/F if PC has trained for this weapon.
Specialize	boolean	Specialize - T/F if PC has specialized for this weapon.
Possession_id	int	The Possession id field.
Magic	string	The Magic field.

Table: Country

This table is for tracking all the countries (politically grouped places).

Field	Type	Description
Id	int	Table record number/id
User_id	int	The User id field.
Name	string	Name
Capitol_id	int	Capitol: place id from Place table.
Government	string	A short phrase describing the government form, e.g. Monarchy
Ruler	string	The name of the ruler.
Ruler_id	int	The Ruler id field.
Races	string	A list of peoples/monsters races that inhabit this country.
Description	string	A description about this country.
Notes	string	The Notes field.
Allies	string	A list of allied countries.
Enemies	string	A list of enemy countries.
Base_id	int	The Base id field.

Table: DieLog

The DieLog table schema:

Field	Type	Description
Id	int	Table record number/id.
Timestamp	int	The Timestamp field.
User_id	int	The User id field.
Dice	string	The Dice field.
Roll	int	The Roll field.

Table: DraftMap

The DraftMap table schema:

Field	Type	Description
Id	int	Table record number/id.
Name	string	The Name field.
Category	string	The Category field.
Level	int	The Level field.
UserId	int	The UserId field.
Properties	string	The Properties field.
Map	string	The Map field.
Areas	string	The Areas field.
Mode	string	The Mode field.

Table: EmailIndex

The EmailIndex table schema:

Field	Type	Description
Id	int	Table record number/id.
EmailAddress	string	The EmailAddress field.
SettingInvites	string	The SettingInvites field.
LastSend	int	The LastSend field.
User_id	int	The User id field.
Dup_EmailIndex_id	int	The Dup EmailIndex id field.

Table: EncounterTable

The EncounterTable table schema:

Field	Type	Description
Id	int	Table record number/id.
User_id	int	The User id field.
Base_id	int	The Base id field.
Name	string	The Name field.
Map_id	int	The Map id field.
Encounter	string	The Encounter field.
EncType	string	The EncType field.
Chance	boolean	The Chance field.
ChanceSum	int	The ChanceSum field.
Frequency	int	The Frequency field.
Notes	string	The Notes field.

Table: Event

A record of pending events associated with a setting.

Field

Type

Description

int

Table record number/id

Setting_id

int

Setting identification #

Time_Year

int

Future timestamp Year

Time_Month

int

Future timestamp Month

Time_Day

int

Future timestamp Day

Time_Hour

int

Future timestamp Hour

Time_Minute

int

Future timestamp Minute

Curr_Time

int

The Curr Time field.

Intr

enum

The kind of event.

Intr	Description
monster	A wandering monster will arrive where party is.
birthday	A PC will have a birthday
afflict	PC status will be changed, e.g. petrified
unafflict	PC status will change back.
score-mod	A PC attribute will be changed.
msg	A text message or comment needing human interpretation of the event.

PC_id

int

PC identification #

Amount

int

A number to be used with the event.

Comment

string

Comment

Data

string

Another number to be used with the event

Table: Gem

Table of gems possessed by PC's.

Field	Type	Description
Id	int	Table record number/id
PC_id	int	PC identification #
Qty	int	Qty
Worth	int	Worth
Gem	boolean	Gem

Table: GuiState

A table that tracks key user state variables.

Field	Type	Description
Id	int	Table record number/id
PC_id	int	PC identification #
User_id	int	User identification #
Tag	string	Tag
Value	string	Value

Table: GuiXact

A table that tracks queries sent to the user and the user's responses.

Field	Type	Description
Id	int	Table record number/id
PC_id	int	PC identification #
User_id	int	User identification #
Query	string	Query
QueryType	string	QueryType
Response	string	Response
ReplyTo	string	ReplyTo
ReplyRef	string	ReplyRef
Prefill	string	Prefill
CBTag	string	CBTag
QueryTime	int	The QueryTime field.
ResponseTime	int	ResponseTime
Tag	string	Tag

Table: Hex

A piece of the landmap, a hexagon from the collection of hexagons (frequently used in games).

Field	Type	Description
Id	int	Table record number/id
Longitude	int	Longitude
Latitude	int	Latitude
Terrain_id	int	Terrain identification # (see Terrain table.
Terrain_Type	int	Terrain Type
Hills	boolean	Flag if hills present. T/F
Coast	string	Sequence to describe where coastline is. "-" means land; something else means water. Think of the coast as pie wedges. E.g. --34-- means the there is ocean in direction 3 and direction 4.
Land_up	boolean	Land up flag - T/F. Determines if land is above or below the drawn coastline. deprecated
WMList_id	int	Wandering monster list identification # from WMListName table.
WM_Freq	int	Wandering monster frequency
Road	string	Sequence to describe where roads go. "-" means no road. E.g. 1---5- means the road goes from the center to direction 1 and from the center to direction 5.
River	string	Sequence to describe where river goes. "-" means no river. E.g. -2--5- means the rivers goes from the center to direction 2 and from the center to direction 5.
Void_Type	boolean	Sequence to describe where map void is. "-" means land; something void. Think of the void as pie wedges. E.g. 123--- means the there is void down and to the right half. Void map is needed for a round world to accommodate curvature.
Subhex	boolean	Subhex flag - T/F. Set to true if this hex is further broken down into smaller hexes for greater detail.
World_id	int	The World id field.

Table: Hex_Path

The Hex_Path table schema:

Field	Type	Description
Id	int	Table record number/id.
Setting_id	int	The Setting id field.
Longitude	int	The Longitude field.
Latitude	int	The Latitude field.
Shared	boolean	The Shared field.
Mapped	boolean	The Mapped field.
People	string	The People field.
Path	string	The Path field.

Table: Hex_State

The Hex_State table schema:

Field	Type	Description
Id	int	Table record number/id.
Setting_id	int	The Setting id field.
Longitutde	int	The Longitutde field.
Latitude	int	The Latitude field.
Monsters	string	The Monsters field.
Items	string	The Items field.
Booty	string	The Booty field.
Rolls	string	The Rolls field.
Notes	string	The Notes field.
CoinsPresent	string	The CoinsPresent field.
CoinsTaken	string	The CoinsTaken field.
Traps	string	The Traps field.
Phenomena	string	The Phenomena field.

Table: HistorySource

This table contains various sources for world history facts.

Field	Type	Description
Id	int	Table record number/id
Name	string	Name of the source. May be a person's name, deity's name, oracle's place, written history, etc.
PC_id	int	PC identification #, if known.

Table: ImageLib

The ImageLib table schema:

Field	Type	Description
Id	int	Table record number/id.
Name	string	The Name field.
Category	string	The Category field.
Type	string	The Type field.
Image	binary	The Image field.
Checksum	int	The Checksum field.
Height	int	The Height field.
Width	int	The Width field.
Owner_id	int	The Owner id field.

Table: Item

This table provides an inventory of items possessable in the world.

Field

Type

Description

int

Table record number/id

User_id

int

The User id field.

Base_id

int

The Base id field.

Name

string

Name of the item

Keyword

string

Keyword for succinct item reference.

Ruleset

string

The rulest for this item - AD&D or D&D5e.

Cost

string

Cost in coins.

Shop_Type

string

Shop Type where this item could be found for sale, e.g. Baker, Boatwrite, Butcher, Doctor, Farmer, Fisherman, General, Guide, Inn, Magickery, Peasant, Rancher, Scripe, Smithy, Tack&Harness, Tailor, Teamser, Temple, Wine-Maker.

Availability

string

Indication of item availability, e.g. common, uncommon, rare, veryrare

Description

string

A description of the item

Magic_id

int

If it has magical properties, this is the MagicLibrary id for its magic.

Codes

string

Codes about the capabilities of this item. A weapon has combat capabilities.

Code	Value	Description
AC	n \| +n	Set AC to the value n. If preceded by + or -, then AC is modified that much.
food	potion \| water \| ration	This item is food of the type specified - potion, water, or rations.
meals	n	This item is the equivalent of n meals.
service	T \| F	This item is actually a service (not a tangible thing). Default: F.
light	r	This item can illuminate the dark with a radius of r.
weapon	n	(AD&D) This item is a weapon. n' refers to the Weapon id.
DexMod	T \| F	(D&D5e) The Dexterity Modifier can be used with this item if T; it cannot be used if F. Default: T.
Stealth	T \| F	Moving quietly undetected is possible if the value is T, otherwise no. Default: T.
MinS	n	(D&D5e) The user of this item must have a minimum strength of n to use this item.
Damage	dice	(D&D5e) This item is a weapon and causes dice damage in close-range combat.
WeaponType	bludgeoning \| piercing \| slashing	(D&D5e) This item is a weapon of the type specified.
MissileDamage	dice	(D&D5e) This item is a weapon and causes dice damage in far-range combat.
MissileRange	normal,long	(D&D5e) This item is a weapon/missile which can be shot to great distance. That is, it typically can go to a range of normal, but it can reach long with less accuracy.
amo	keyword	(D&D5e) This item is ammunition for another item/weaon, such as an arrow is ammunicaiton for a bow. The keyword is the Item.Keyword value for the other item/weapon.
kit	keywordlist	This items is actually a bundle of items. The keywordlist is a comma separate list of keywords that match Item.Keyword value of other items.
transport	n	This item is a vehicle or beast for transporting n people at a time.
move	n	(D&D5e) This item is a vehicle or beast for tranportation with a movement rate of n.

Notes

string

Notes for the DM about this item.

CustomMade

boolean

CustomMade flag - T/F. T if the item is unique or requires specific skills to construct.

Labor

float

An estimate on the amount of Labor required to construct this item.

Weight

float

The Weight of the item, in pounds.

int

The XP field.

Table: Land

The Land table schema:

Field	Type	Description
Id	int	Table record number/id.
User_id	int	The User id field.
Milieu_id	int	The Milieu id field.
Name	string	The Name field.
Squares	string	The Squares field.
LowerLeft	string	The LowerLeft field.
UpperRight	string	The UpperRight field.
Notes	string	The Notes field.

Table: LandDetails

The LandDetails table schema:

Field	Type	Description
Id	int	Table record number/id.
WorldShape	string	The WorldShape field.
DistanceUnits	string	The DistanceUnits field.
Height	int	The Height field.
Width	int	The Width field.
LandPos	string	The LandPos field.
PlacePos	string	The PlacePos field.
CountryPos	string	The CountryPos field.
TerrainPos	string	The TerrainPos field.

Table: LibraryMap

The LibraryMap table schema:

Field	Type	Description
Id	int	Table record number/id.
Name	string	The Name field.
Category	string	The Category field.
Comment	string	The Comment field.
UserId	int	The UserId field.
Map	string	The Map field.
Areas	string	The Areas field.
WMList	string	The WMList field.

Table: Link

A table to associate data between records. For example, two PC's may be related: friends, married, lord/servant, etc.

Field	Type	Description
Id	int	Table record number/id
Table1	string	Table1
Id1	int	Id1
Table2	string	Table2
Id2	int	Id2
Table3	string	Table3
Id3	int	Id3
Relationship	string	Relationship

Table: LocationState

The LocationState table schema:

Field	Type	Description
Id	int	Table record number/id.
Setting_id	int	The Setting id field.
Longitutde	int	The Longitutde field.
Latitude	int	The Latitude field.
Place_id	int	The Place id field.
Location	string	The Location field.
State	string	The State field.

Table: MC

The MC table schema:

Field	Type	Description
Id	int	Table record number/id.
User_id	int	The User id field.
Base_id	int	The Base id field.
Setting_id	int	The Setting id field.
Intent	string	The Intent field.
GroupNo	int	The GroupNo field.
PosNo	int	The PosNo field.
HP	int	The HP field.
MaxHP	int	The MaxHP field.
Money	string	The Money field.
Booty	string	The Booty field.
Shopping_Wishlist	string	The Shopping Wishlist field.
Magic	string	The Magic field.
AutoDamage	int	The AutoDamage field.
Name	string	The Name field.
Notes	string	The Notes field.
Location	string	The Location field.

Table: MagicBeast

The MagicBeast table schema:

Field	Type	Description
Id	int	Table record number/id.
User_id	int	The User id field.
Base_id	int	The Base id field.
Name	string	The Name field.
Ruleset	string	The Ruleset field.
Book	string	The Book field.
Page	int	The Page field.
TargetRange	string	The TargetRange field.
TargetType	string	The TargetType field.
TargetData	string	The TargetData field.
MaxUse	int	The MaxUse field.
UsePer	string	The UsePer field.
RechargeTime	int	The RechargeTime field.
Chance	int	The Chance field.
Notes	string	The Notes field.

Table: MagicDevice

The MagicDevice table schema:

Field	Type	Description
Id	int	Table record number/id.
User_id	int	The User id field.
Base_id	int	The Base id field.
Class	string	The Class field.
Name	string	The Name field.
Ruleset	string	The Ruleset field.
Book	string	The Book field.
Page	int	The Page field.
TargetRange	string	The TargetRange field.
TargetType	string	The TargetType field.
TargetData	string	The TargetData field.
Notes	string	The Notes field.

Table: MagicLibrary

The MagicLibrary table schema:

Field	Type	Description
Id	int	Table record number/id.
Name	string	The Name field.
Category	string	The Category field.
Ruleset	string	The Ruleset field.
MetaData	string	The MetaData field.
Code	string	The Code field.
Vars	string	The Vars field.
Triggers	string	The Triggers field.
TriggerPC	string	The TriggerPC field.
CodePC	string	The CodePC field.
SourceCode	string	The SourceCode field.
SourceLocation	string	The SourceLocation field.
SourceLine0	int	The SourceLine0 field.

Table: MagicQueue

The MagicQueue table schema:

Field	Type	Description
Id	int	Table record number/id.
Setting_id	int	The Setting id field.
Effect	string	The Effect field.

Table: MagicSpell

The MagicSpell table schema:

Field	Type	Description
Id	int	Table record number/id.
User_id	int	The User id field.
Base_id	int	The Base id field.
Name	string	The Name field.
Ruleset	string	The Ruleset field.
Book	string	The Book field.
Page	int	The Page field.
TargetRange	string	The TargetRange field.
TargetType	string	The TargetType field.
TargetData	string	The TargetData field.
Level	int	The Level field.
Class	boolean	The Class field.
Components	string	The Components field.
Notes	string	The Notes field.

Table: MagicTrace

The MagicTrace table schema:

Field	Type	Description
ManifestationId	int	The ManifestationId field.
MagicId	int	The MagicId field.
TraceId	int	The TraceId field.
PC	int	The PC field.
SourceLine	int	The SourceLine field.
SourceChar	int	The SourceChar field.
TriggerState	string	The TriggerState field.
Action	string	The Action field.
id	int	The id field.

Table: Manifestation

The Manifestation table schema:

Field	Type	Description
Id	int	Table record number/id.
Magic_id	int	The Magic id field.
Setting_id	int	The Setting id field.
TargetArea	string	The TargetArea field.
Recipe	string	The Recipe field.
SourceLine	int	The SourceLine field.
SourceChar	int	The SourceChar field.
Vars	string	The Vars field.
ObjIsCaster	boolean	The ObjIsCaster field.
Save	boolean	The Save field.
SaveRoll	int	The SaveRoll field.
SaveModRoll	int	The SaveModRoll field.
SavePC	int	The SavePC field.
PC	int	The PC field.
RunStatus	int	The RunStatus field.
RunLimit	int	The RunLimit field.
ErrorMsg	string	The ErrorMsg field.
Object	string	The Object field.
ObjectEffect	string	The ObjectEffect field.
TargetPids	string	The TargetPids field.
ParentId	int	The ParentId field.
PossessTime	string	The PossessTime field.
AttachTime	string	The AttachTime field.
OnTime	string	The OnTime field.
StartTime	string	The StartTime field.
Now	string	The Now field.
NumberStack	string	The NumberStack field.
CurrentBlock	string	The CurrentBlock field.
InStates	string	The InStates field.

Table: MarketUser

The MarketUser table schema:

Field	Type	Description
Id	int	Table record number/id.
SortBy	string	The SortBy field.
Viewed	string	The Viewed field.
WishList	string	The WishList field.
Shared	string	The Shared field.
Purchased	string	The Purchased field.
SearchResults	string	The SearchResults field.
Cart	string	The Cart field.
LastUpdate	int	The LastUpdate field.
Filter	string	The Filter field.

Table: Melee

The Melee table schema:

Field	Type	Description
Id	int	Table record number/id.
Setting_id	int	The Setting id field.
Ruleset	string	The Ruleset field.
Core_Channel	string	The Core Channel field.
No_teams	int	The No teams field.
Round_no	int	The Round no field.
Location	string	The Location field.
Time_Year	int	The Time Year field.
Time_Month	int	The Time Month field.
Time_Day	int	The Time Day field.
Time_Hour	int	The Time Hour field.
Time_Minute	int	The Time Minute field.
Curr_Time	int	The Curr Time field.
Complete	boolean	The Complete field.

Table: MeleeMember

The MeleeMember table schema:

Field	Type	Description
Id	int	Table record number/id.
Melee_id	int	The Melee id field.
Team_no	int	The Team no field.
Team_Name	string	The Team Name field.
Member	string	The Member field.
HP	int	The HP field.
Max_HP	int	The Max HP field.
Current_Intent	int	The Current Intent field.
Opponent_Team_Preferred	int	The Opponent Team Preferred field.
Opponents	string	The Opponents field.
Swing_Amount	int	The Swing Amount field.
Location	string	The Location field.
Attack_State	string	The Attack State field.
Attack_Codes	string	The Attack Codes field.

Table: MeleeMoment

The MeleeMoment table schema:

Field	Type	Description
Id	int	Table record number/id.
Melee_id	int	The Melee id field.
Round_no	int	The Round no field.
TimeIndex	int	The TimeIndex field.
Member	string	The Member field.
Action	int	The Action field.
Action_Params	string	The Action Params field.
Target	string	The Target field.
Target_Area	string	The Target Area field.
Rolls	string	The Rolls field.
Location	string	The Location field.
Query_State	int	The Query State field.

Table: Milieu

The Milieu table schema:

Field	Type	Description
Id	int	Table record number/id.
Base_id	int	The Base id field.
User_id	int	The User id field.
Name	string	The Name field.
Ruleset	string	The Ruleset field.
Land_idlist	string	The Land idlist field.
LandPos	string	The LandPos field.
Place_idlist	string	The Place idlist field.
PlacePos	string	The PlacePos field.
StartPC_idlist	string	The StartPC idlist field.
PC_idlist	string	The PC idlist field.
MC_idlist	string	The MC idlist field.
Vendor_idlist	string	The Vendor idlist field.
Monster_idlist	string	The Monster idlist field.
FoePC_idlist	string	The FoePC idlist field.
FoeMC_idlist	string	The FoeMC idlist field.
Encounter_idlist	string	The Encounter idlist field.
Item_idlist	string	The Item idlist field.
Artifact_idlist	string	The Artifact idlist field.
MagicDevice_idlist	string	The MagicDevice idlist field.
Quest_idlist	string	The Quest idlist field.
Secrets_idlist	string	The Secrets idlist field.
Story_idlist	string	The Story idlist field.
Terrain_idlist	string	The Terrain idlist field.
Country_idlist	string	The Country idlist field.
Milieu_idlist	string	The Milieu idlist field.
Publish_time	int	The Publish time field.

Table: ModuleContent

The ModuleContent table schema:

Field	Type	Description
Id	int	Table record number/id.
Map	string	The Map field.
Catalog_id	int	The Catalog id field.

Table: ModuleReview

The ModuleReview table schema:

Field	Type	Description
Id	int	Table record number/id.
User_id	int	The User id field.
Score	float	The Score field.
Comment	string	The Comment field.
Catalog_id	int	The Catalog id field.

Table: Monster

This table contains an inventory of monsters roaming the world.

Field	Type	Description
Id	int	Table record number/id
User_id	int	The User id field.
Base_id	int	The Base id field.
Name	string	Common name used to refer to the monster
Formal_Name	string	Formal Name or designation of the monster
Ruleset	string	The Ruleset field.
TypeLabel	string	The TypeLabel field.
Size	enum	Size, used for combat purposes.
Tags	string	The Tags field.
Probability	int	Probability of encountering this monster in its native habitat.
Quantity	string	Quantity of monsters encountered in its native habitat.
HitDice	string	Hit Dice, used for calculating HP.
Challenge	int	The Challenge field.
Monster_AC	int	Monster armor class
XP_Base	int	XP Base, used for calculating experience points
XP_Per_HP	int	XP Per HP, used for calculating experience points
Treasure	string	List of Treasure it keeps in its lair
Level	int	Level of difficulty (combat)
Book	string	The book from which this monster comes.
Book_Page	int	The page reference for this monster.
AttDef	string	The attack/defense codes which are decoded to conduct combat.
Attacks	string	A textual description of monster attacks and defenses.
Movex	string	The Movex field.
Movement	string	The monster's movement rate
Body	string	The Body field.
Alignment	string	The Alignment field.
Strength	int	The Strength field.
Dexterity	int	The Dexterity field.
Constitution	int	The Constitution field.
Intelligence	int	The Intelligence field.
IntelligenceLabel	string	The IntelligenceLabel field.
Wisdom	int	The Wisdom field.
Charisma	int	The Charisma field.
Notes	string	The Notes field.

Table: MovementLog

The MovementLog table schema:

Field	Type	Description
Id	int	Table record number/id.
Setting_id	int	The Setting id field.
PC_id	int	The PC id field.
Locomotion	int	The Locomotion field.
Location	string	The Location field.
Time_Year	int	The Time Year field.
Time_Month	int	The Time Month field.
Time_Day	int	The Time Day field.
Time_Hour	int	The Time Hour field.
Time_Minute	int	The Time Minute field.
Curr_Time	int	The Curr Time field.

Table: MsgListeners

A table used by msgbroker to record which daemons are listening on which channels.

Field	Type	Description
Id	int	Table record number/id
Name	string	Name
AppId	string	AppId - code by which commhub know the app
AppName	string	AppName - the name of the app
Persist	boolean	Persist flag. Should messages be kept if listener is not active.
Active	boolean	Active flag. Set if listener is active.

Table: NewUserRequest

The NewUserRequest table schema:

Field	Type	Description
Id	int	Table record number/id.
Name	string	The Name field.
Email	string	The Email field.
ConfirmId	int	The ConfirmId field.
RequestTime	int	The RequestTime field.
SessionId	int	The SessionId field.
RequesterIP	string	The RequesterIP field.
NoRequests	int	The NoRequests field.
TermsVersion	int	The TermsVersion field.
Old	boolean	The Old field.

Table: NewsSystem

The NewsSystem table schema:

Field	Type	Description
Id	int	Table record number/id.
PostTime	int	The PostTime field.
PostedBy	int	The PostedBy field.
PostedFor	int	The PostedFor field.
Priority	boolean	The Priority field.
Domain	string	The Domain field.
Message	string	The Message field.

Table: PC

This table contains all the known PC's and NPC's - their attributes and properties.

Field	Type	Description
Id	int	Table record number/id
User_id	int	User identification # from User table.
Base_id	int	The Base id field.
Name	string	Name
Setting_id	int	Setting identification # from Setting table.
Ruleset	string	The Ruleset field.
Gender	string	The Gender field.
Team_id	int	The Team id field.
Rank	int	Rank within the party as measure as closeness to front
FormationPosition	string	The FormationPosition field.
NPC	boolean	NPC flag, T if character is an NPC
Auto_Roll	boolean	Auto Roll flag, T if computer should roll dice for PC
Race	string	Race of character
Race_id	int	The Race id field.
No_Classes	int	Number of Classes that PC has trained in. Common is just 1.
Class1	enum	Class, first class
Level1	int	Level, first class
Experience1	int	Experience points, first class
Class2	enum	Class, second class
Level2	int	Level, second class
Experience2	int	Experience points, second class
Class3	enum	Class, third class
Level3	int	Level, third level
Experience3	int	Experience points, third class
Challenge	int	The Challenge field.
Strength	int	Strength, e.g. 3 to 18
Strength_Percent	int	Strength Percent, e.g. 0 to 100 (if strength is 18)
Intelligence	int	Intelligence, e.g. 3 to 18
Wisdom	int	Wisdom, e.g. 3 to 18
Dexterity	int	Dexterity, e.g. 3 to 18
Constitution	int	Constitution, e.g. 3 to 18
Charisma	int	Charisma, e.g. 3 to 18
Bonus_to_hit	int	Bonus to hit for combat
Bonus_damage	int	Bonus damage for combat
AC	int	AC
Current_HP	int	Current HP
Max_HP	int	Max HP
Combat_Ready	boolean	Combat Ready flag
Age	int	Age in years
Birthday	int	Birthday (day of month)
Birthmonth	int	Birthmonth
Hometown	int	Hometown id from Place table
Alignment	string	Alignment
No_weapons	int	No weapons
Weapon_no	int	Weapon number in hand from Place CharWeapon
Weapon_Proficiency	string	The Weapon Proficiency field.
Deity	string	Deity name(s) worshipped
SC	int	SC
Thieving	int	Thieving skills
Spell_Success	int	Spell Success
Spells	string	The Spells field.
Friends	int	Friends
Liege_id	int	Liege identification #
Lord_id	int	Lord identification #
Locale_id	int	The Locale id field.
Country_id	int	The Country id field.
Secondary_Skill1	int	Secondary Skill1
Secondary_Skill2	int	Secondary Skill2
Skills	string	The Skills field.
Money	string	The Money field.
Booty	string	The Booty field.
Shopping_Wishlist	string	The Shopping Wishlist field.
No_Comments	int	No Comments
Standard_Rations	int	Standard Rations
Iron_Rations	int	Iron Rations
Encumberance	int	Encumberance
Title	string	Title
Habits	string	Habits
Description	string	Description
Notes	string	Notes
Move	string	Movement rate
Location	string	The Location field.
BodyMagic	string	The BodyMagic field.
BodyNatural	string	The BodyNatural field.
Intent	string	The Intent field.
Combat_Intent	string	The Combat Intent field.
Source	string	The Source field.

Table: PCLog

Table of personal log entries for a specific PC.

Field	Type	Description
Id	int	Table record number/id
PC_id	int	PC identification #
Message	string	Message
Time_Year	int	Timestamp Year
Time_Month	int	Timestamp Month
Time_Day	int	Timestamp Day
Time_Hour	int	Timestamp Hour
Time_Minute	int	Timestamp Minute
Curr_Time	int	The Curr Time field.

Table: PendingLink

This table is used with the Link table for links that have not been resolved to specific/existing table records.

Field	Type	Description
Id	int	Table record number/id
Table1	string	Table1
Name1	string	Name1
Table2	string	Table2
Name2	string	Name2
Table3	string	Table3
Name3	string	Name3
Relationship	string	Relationship

Table: PendingMsgs

This table is used by msgbroker to store messages awaiting delivery to daemons that are not active/running.

Field	Type	Description
Id	int	Table record number/id
Source	string	Source
Destination	string	Destination
Text	string	Text
Timestamp	int	Timestamp

Table: Place

This table contains an inventory of places (above ground works).

Field	Type	Description
Id	int	Table record number/id
User_id	int	The User id field.
Base_id	int	The Base id field.
Longitude	int	Longitude
Latitude	int	Latitude
World_id	int	The World id field.
Name	string	Name - expected to be unique
Map_id	int	The Map id field.
Directory	string	The Directory field.
Country_id	int	Country identification #, if part of a country
WM_id	int	Wandering monster list identification #
AreaEnc_id	int	The AreaEnc id field.
Ruin	boolean	Ruin flag - T if a ruin
Lower_Level	int	Lower Level (minimum difficulty level)
Upper_Level	int	Upper Level (maximum difficulty level)
Rough_Size	int	Rough Size - city, town, village, hamlet, thorp
Description	string	General description of place
Notes	string	Notes for the DM about the place
Phi	float	The Phi field.
Elevation	int	The Elevation field.
Property	string	The Property field.

Table: PlaceMap

The PlaceMap table schema:

Field	Type	Description
Id	int	Table record number/id.
Name	string	The Name field.
UserId	int	The UserId field.
Properties	string	The Properties field.
Map	string	The Map field.
Directory	string	The Directory field.

Table: Place_Building

The Place_Building table schema:

Field	Type	Description
Id	int	Table record number/id.
Place_id	int	The Place id field.
Name	string	The Name field.
Siding	string	The Siding field.
Roof	string	The Roof field.
Sign	string	The Sign field.
Properties	string	The Properties field.
CenterPt	string	The CenterPt field.
Notes	string	The Notes field.
Exterior	string	The Exterior field.
BoundingBox	string	The BoundingBox field.
Introduction	string	The Introduction field.
Levels	string	The Levels field.

Table: Place_Level

The Place_Level table schema:

Field	Type	Description
Id	int	Table record number/id.
Place_id	int	The Place id field.
Name	string	The Name field.
Building_Name	string	The Building Name field.
Description	string	The Description field.
Author	string	The Author field.
Entrance	string	The Entrance field.
WMList_id	int	The WMList id field.
WMFreq	int	The WMFreq field.
Level	int	The Level field.
Introduction	string	The Introduction field.
Notes	string	The Notes field.
Layout_North	string	The Layout North field.

Table: Place_Partition

This table provides an inventory of geometric shapes (walls, doors, etc.) to provide physical layout information for a place.

Field	Type	Description
Id	int	Table record number/id
Place_id	int	Place identification # from Place table.
Level	int	Level
Partition_Type	int	Partition Type - wall, door, etc.
Point1	string	Point1 - (x,y)
Point2	string	Point2 - (x,y)
Portal	boolean	Portal flag - T if this connects to areas
Width	float	Width/thickness of wall
Height	float	Height of wall
Slope	float	Slope of floor, from Point1 to Point2
AreaCCW_id	string	Area identification # that is in the CCW direction of Point1- >Point2 (left) from Place_Area table.
AreaCW_id	string	Area identification # that is in the CW direction of Point1- >Point2 (right) from Place_Area table.
Note	string	Note
Data	string	Data needed by some partition types
Building_id	int	The Building id field.

Table: Place_Path

The Place_Path table schema:

Field	Type	Description
Id	int	Table record number/id.
Setting_id	int	The Setting id field.
Place_id	int	The Place id field.
BuildingName	string	The BuildingName field.
Level	int	The Level field.
Area	string	The Area field.
SubArea	string	The SubArea field.
Shared	boolean	The Shared field.
Mapped	boolean	The Mapped field.
MappedDoors	string	The MappedDoors field.
People	string	The People field.
Path	string	The Path field.

Table: Place_State

The Place_State table schema:

Field	Type	Description
Id	int	Table record number/id.
Setting_id	int	The Setting id field.
Place_id	int	The Place id field.
BuildingName	string	The BuildingName field.
Level	int	The Level field.
State	string	The State field.
Area	string	The Area field.
SubArea	string	The SubArea field.
Monsters	string	The Monsters field.
Items	string	The Items field.
Booty	string	The Booty field.
Rolls	string	The Rolls field.
Notes	string	The Notes field.
Doors	string	The Doors field.
CoinsPresent	string	The CoinsPresent field.
CoinsTaken	string	The CoinsTaken field.
Traps	string	The Traps field.
Phenomena	string	The Phenomena field.

Table: Possession

This table contains an inventory of PC posessions.

Field	Type	Description
Id	int	Table record number/id
User_id	int	The User id field.
Artifact	boolean	The Artifact field.
PC_id	int	PC identification #
Item_id	int	Item identification # from Item table.
Qty	int	Quantity of item
Location	string	Location of item
Setting_id	int	The Setting id field.
Usability	int	The Usability field.
State	int	The State field.
Magic	string	The Magic field.
Owner	string	The Owner field.
Manifestation_id	int	The Manifestation id field.
MagicActive	boolean	The MagicActive field.
Placement	string	The Placement field.
Name	string	The Name field.
Cost	string	The Cost field.
Notes	string	The Notes field.

Table: PossessionLog

The PossessionLog table schema:

Field	Type	Description
Id	int	Table record number/id.
Setting_id	int	The Setting id field.
Possession_id	int	The Possession id field.
PC_id	int	The PC id field.
Action	int	The Action field.
ActionDetail	string	The ActionDetail field.
Time_Year	int	The Time Year field.
Time_Month	int	The Time Month field.
Time_Day	int	The Time Day field.
Time_Hour	int	The Time Hour field.
Time_Minute	int	The Time Minute field.
Curr_Time	int	The Curr Time field.
TradeLog_id	int	The TradeLog id field.
Owner	string	The Owner field.
Location	string	The Location field.

Table: Property

The Property table schema:

Field	Type	Description
Id	int	Table record number/id.
AppName	string	The AppName field.
Section	string	The Section field.
Variable	string	The Variable field.
Value	string	The Value field.

Table: Quest

The Quest table schema:

Field	Type	Description
Id	int	Table record number/id.
User_id	int	The User id field.
Base_id	int	The Base id field.
Name	string	The Name field.
Description	string	The Description field.
Notes	string	The Notes field.
Milestones	string	The Milestones field.
Giver_listids	string	The Giver listids field.
Secrets_listids	string	The Secrets listids field.
Prereq_listids	string	The Prereq listids field.

Table: RpcServices

Table used by rpcbroker to manage what services are registered.

Field	Type	Description
Id	int	Table record number/id
Name	string	Name
AppId	string	AppId
AppName	string	AppName
Timeout	int	Timeout

Table: SecondarySkill

The SecondarySkill table schema:

Field	Type	Description
Id	int	Table record number/id.
Probability	int	The Probability field.
Name	string	The Name field.

Table: Secrets

The Secrets table schema:

Field	Type	Description
Id	int	Table record number/id.
User_id	int	The User id field.
Base_id	int	The Base id field.
Information	string	The Information field.
Notes	string	The Notes field.
Accuracy	string	The Accuracy field.
Privacy	string	The Privacy field.
SecretsTable_id	int	The SecretsTable id field.

Table: SecretsTable

The SecretsTable table schema:

Field	Type	Description
Id	int	Table record number/id.
User_id	int	The User id field.
Base_id	int	The Base id field.
Name	string	The Name field.
Secrets	string	The Secrets field.
Description	string	The Description field.
Notes	string	The Notes field.

Table: Setting

This table contains each adventuring party with its relevant context.

Field	Type	Description
Id	int	Table record number/id
User_id	int	User identification # from User table.
World_id	int	The World id field.
World_Name	string	World Name
Name	string	Name of the party / group of adventurers
Ruleset	string	The Ruleset field.
Locale	int	Locale id that is the base of operation from from Place table.
No_characters	int	No characters
No_encounters	int	The No encounters field.
Leader	int	The Leader field.
Formation	string	The Formation field.
Longitude	int	Longitude of current location of party
Latitude	int	Latitude of current location of party
Terrain_Monster_List	int	Terrain Monster List of current location of party
Place_id	int	Place identification # from Place table of current location of party.
Place_Location	string	Place Location
Place_Monster_List	int	Place Monster List
Time_Year	int	Time Year
Time_Month	int	Time Month
Time_Day	int	Time Day
Time_Hour	int	Time Hour
Time_Minute	int	Time Minute
Curr_Time	int	The Curr Time field.
Days_Till_Rain	int	Days Till Rain
Weather	int	Weather data
Inside	boolean	Inside flag - T if party is inside current place
Unawarded_Experience	int	Unawarded, accumulating Experience points
Days_Since_Last_Update	int	Days Since Last Update (day # out on campaign)
Campaign_no	int	Campaign number
Start_Year	int	Start Year for campaign
Start_Month	int	Start Month
Start_Day	int	Start Day
Start_Hour	int	Start Hour
Start_Minute	int	Start Minute
Start_Time	int	The Start Time field.
Place_Level	int	Place Level, if inside of a place
Place_Area_id	string	Place Area identification # from Place_Area table, if inside of place.
livePlay	boolean	The livePlay field.
Location	string	The Location field.

Table: SettingCall

The SettingCall table schema:

Field	Type	Description
Id	int	Table record number/id.
Name	string	The Name field.
User_id	int	The User id field.
Ruleset	string	The Ruleset field.
Params	string	The Params field.
Invitee_emails	string	The Invitee emails field.
Invitee_ids	string	The Invitee ids field.
Invite_Intro	string	The Invite Intro field.
Created	int	The Created field.
CallOpen	boolean	The CallOpen field.
CallClosed	boolean	The CallClosed field.

Table: SettingResponse

The SettingResponse table schema:

Field	Type	Description
Id	int	Table record number/id.
SettingCall_id	int	The SettingCall id field.
User_id	int	The User id field.
PCParams	string	The PCParams field.
Behavior	string	The Behavior field.
Email	string	The Email field.
RequestState	string	The RequestState field.
Created	int	The Created field.
PC_id	int	The PC id field.

Table: ShareRegistry

The ShareRegistry table schema:

Field	Type	Description
Id	int	Table record number/id.
Owner_id	int	The Owner id field.
Catalog_id	int	The Catalog id field.
Recipient_id	int	The Recipient id field.
Sharetime	int	The Sharetime field.
Unsharetime	int	The Unsharetime field.
RecipientEmail	string	The RecipientEmail field.

Table: SlainHistory

The SlainHistory is the record of slain monsters when campaigning.

Field	Type	Description
Id	int	Table record number/id
Setting_id	int	Setting identification #
Campaign_no	int	Campaign number
Monster_id	int	Monster identification # from Monster table.
WMList_id	int	Wandering monster list identification # from WMListName table.
WMList_ref	int	Wandering monster list ref (ordinal position within list)
Experience	int	Experience points earned
No_Killed	int	No of monsters killed
hp	string	A comma delimited list of slain monster's hp
Time_Year	int	Combat conclusion Year
Time_Month	int	Combat conclusion Month
Time_Day	int	Combat conclusion Day
Time_Hour	int	Combat conclusion Hour
Time_Minute	int	Combat conclusion Minute
Curr_Time	int	The Curr Time field.
kill_credit	string	The kill credit field.
Location	string	The Location field.

Table: Story

The Story table schema:

Field	Type	Description
Id	int	Table record number/id.
User_id	int	The User id field.
Base_id	int	The Base id field.
Milieu_id	int	The Milieu id field.
Name	string	The Name field.
CoverPage	string	The CoverPage field.
CoverArt	int	The CoverArt field.
Author	string	The Author field.
Copyright	string	The Copyright field.
Background	string	The Background field.
History	string	The History field.
TimelineTitle	string	The TimelineTitle field.
Timeline	string	The Timeline field.
Quests	string	The Quests field.
Secrets	string	The Secrets field.
StoryPaths	string	The StoryPaths field.
StoryHooks	string	The StoryHooks field.
HookEncounter	int	The HookEncounter field.
Notes	string	The Notes field.
Credits	string	The Credits field.
License	string	The License field.
Settings	string	The Settings field.

Table: Terrain

This table is for named geographic regions, e.g. the Black Forest.

Field	Type	Description
Id	int	Table record number/id
User_id	int	The User id field.
Base_id	int	The Base id field.
Name	string	Name or terrain region
Description	string	Description of region
Risk	string	Risk level on how dangerous this region is (due to monsters)
Climate	string	Climate code for this region
WMList_id	int	Wandering monster list identification # from WMListName table.
Notes	string	Notes for the DM

Table: TradeLog

The TradeLog table schema:

Field	Type	Description
Id	int	Table record number/id.
Setting_id	int	The Setting id field.
Action	int	The Action field.
Time_Year	int	The Time Year field.
Time_Month	int	The Time Month field.
Time_Day	int	The Time Day field.
Time_Hour	int	The Time Hour field.
Time_Minute	int	The Time Minute field.
Curr_Time	int	The Curr Time field.
Location	string	The Location field.
Value	string	The Value field.
Possession_id	int	The Possession id field.
CoinsFrom	string	The CoinsFrom field.
CoinsTo	string	The CoinsTo field.
ItemsFrom	string	The ItemsFrom field.
ItemsTo	string	The ItemsTo field.
From_PC_id	int	The From PC id field.
To_PC_id	int	The To PC id field.
Comment	string	The Comment field.

Table: User

This table contains all the humans who may access this world.

Field	Type	Description
Name	string	Human's real name
Id	int	Table record number/id
Password	string	Password to login
Created	int	The date this account was created
LastLogin	date	The date of the last login by this user
LastLoginTS	int	The LastLoginTS field.
LoginCount	int	The number of times this user has logged in
SessionId	int	Session Id for ensuring authenticity of user throughout session
Email	string	Email address of the user
AdminId	int	This player is part of a campaign with a DM; so this is the DM's user id?
TermsVersion	int	The TermsVersion field.
WorldId	int	The WorldId field.
ResetRequest	int	The ResetRequest field.
TempPassword	string	The TempPassword field.
FailedLogins	int	The FailedLogins field.
LastFailed	int	The LastFailed field.
Disabled	boolean	The Disabled field.
FailedLoginsGroup	int	The FailedLoginsGroup field.
LastFailedGroup	int	The LastFailedGroup field.

Table: UserComment

The UserComment table schema:

Field	Type	Description
Id	int	Table record number/id.
UserId	int	The UserId field.
Title	string	The Title field.
CommentType	boolean	The CommentType field.
Comment	string	The Comment field.
PostTime	int	The PostTime field.
ReplyTime	int	The ReplyTime field.
ReplyUserId	int	The ReplyUserId field.
ResolveTime	int	The ResolveTime field.
ResolveUserId	int	The ResolveUserId field.
Severity	int	The Severity field.
Priority	int	The Priority field.

Table: UserNotice

The UserNotice table schema:

Field	Type	Description
Id	int	Table record number/id.
UserId	int	The UserId field.
PostTime	int	The PostTime field.
ConfirmedTime	int	The ConfirmedTime field.
FormLongName	string	The FormLongName field.
FormShortName	string	The FormShortName field.
Data	string	The Data field.
Urgency	string	The Urgency field.
FromApp	string	The FromApp field.
Address	string	The Address field.
SendStatus	string	The SendStatus field.
SendMedia	string	The SendMedia field.

Table: UserProperty

The UserProperty table schema:

Field	Type	Description
Id	int	Table record number/id.
User_id	int	The User id field.
AppName	string	The AppName field.
Section	string	The Section field.
Variable	string	The Variable field.
value	string	The value field.

Table: UserSettings

The UserSettings table schema:

Field	Type	Description
Id	int	Table record number/id.
Domain	string	The Domain field.
CurrentApp	string	The CurrentApp field.
CurrentWorld	int	The CurrentWorld field.
CurrentRole	int	The CurrentRole field.
BirthYear	int	The BirthYear field.
BirthMonth	int	The BirthMonth field.
BirthDay	int	The BirthDay field.
Address1	string	The Address1 field.
Address2	string	The Address2 field.
City	string	The City field.
State	string	The State field.
PostalCode	string	The PostalCode field.
Country	string	The Country field.
Handle	string	The Handle field.
Origin	string	The Origin field.
Store	string	The Store field.
Phone	string	The Phone field.
TaxId	string	The TaxId field.
Visible	boolean	The Visible field.
JoinInvitations	boolean	The JoinInvitations field.
CampaignUpdates	boolean	The CampaignUpdates field.
AranaNews	boolean	The AranaNews field.
Promotions	boolean	The Promotions field.
PendingInvitations	string	The PendingInvitations field.
CurrentMode	string	The CurrentMode field.

Table: Vendor

The Vendor table schema:

Field	Type	Description
Id	int	Table record number/id.
User_id	int	The User id field.
Base_id	int	The Base id field.
Vendor_id	string	The Vendor id field.
Setting_id	int	The Setting id field.
Place_id	int	The Place id field.
Place_Area_id	string	The Place Area id field.
Name	string	The Name field.
Trade	string	The Trade field.
Description	string	The Description field.
Notes	string	The Notes field.
Makes	string	The Makes field.
Resells	string	The Resells field.
Inventory	string	The Inventory field.
Markup_Mfg	float	The Markup Mfg field.
Markup_Resell	float	The Markup Resell field.
Availability	string	The Availability field.
Shops	string	The Shops field.
AutoRestock	boolean	The AutoRestock field.

Table: WMList

This table contains each monster assigned to each wandering monster list.

Field	Type	Description
Id	int	Table record number/id
Name	string	The Name field.
WMList_id	int	Wandering Monster List identification # from WMListName table.
Monster_id	int	Monster identification # from Monster table.
Probability	int	Probability of encounter - how frequently to check, e.g. 30 minutes
Quantity	string	The quantity of these monsters found when encountered, specified as a die roll

Table: WMListName

This table contains the names of the wandering monster lists.

Field	Type	Description
Id	int	Table record number/id
Name	string	Name of this list, e.g. Tasgar 1st Level

Table: WMListTable

Given a place, multiple wandering monster lists may be defined per level.

Field	Type	Description
Place_id	int	Place identification # from Place table.
Pos	int	This record is a row in a table of lists, this is the table row #.
WMList_id	int	WMList identification # from WMListName table.
wm_freq	int	Default encounter frequency - one this in this many minutes.
Level	int	Level within place that uses this list.
Id	int	Table record number/id.
Building_id	int	The Building id field.

Table: Weapon

This table contains an inventory of possible weapons in use by PC's/NPC's and their capabilities.

Field	Type	Description
Id	int	Table record number/id
Label	string	Short form or keyword to quickly identify this weapon.
Name	string	Name of the weapon
HandToHand	boolean	HandToHand flag - T if weapon can be used for hand-to-hand combat.
Missile	boolean	Missile flag - T if weapon can be used for remote/missile combat.
DamageSM	string	Damage to small or medium opponents, specified as a die roll.
DamageL	string	Damage to large opponents, specified as a die roll.
Length	float	The Length field.
SpaceRequired	float	The SpaceRequired field.
SpeedFactor	int	The SpeedFactor field.

Table: World

The World table schema:

Field	Type	Description
Id	int	Table record number/id.
Name	string	The Name field.
Description	string	The Description field.
User_id	int	The User id field.
Market_State	int	The Market State field.

Table: WorldHistory

This is a table of reported events on a world-wide scale.

Field	Type	Description
Id	int	Table record number/id
Title	string	Title of the event (short description)
Message	string	Description of the event (can be a long description)
Time_Year	int	Event's Year
Time_Month	int	Event's Month
Time_Day	int	Event's Day
Time_Hour	int	Event's Hour
Time_Minute	int	Event's Minute
Curr_Time	int	The Curr Time field.
Continent_id	int	Continent identification # from Continent table or 0.
World_id	int	The World id field.
Country_id	int	Country identification # from Country table or 0.
Place_id	int	Place identification # from Place table or 0.
PC_id	int	PC identification # from PC table or 0.
Source_id	int	Source identification # from HistorySource table.