Skip to content

petitions

Info

This page was last generated 2023.04.23

Relationship Diagram(s)

Diagram Edit

Relationships

Relationship Type Local Key Relates to Table Foreign Key
One-to-One charname character_data name
One-to-One accountname account name
One-to-One lastgm character_data name
One-to-One zone zone zoneidnumber

Schema

Column Data Type Description
dib int Unknown
petid int Unique Petition Entry Identifier
charname varchar Character Name
accountname varchar Account Name
lastgm varchar Last GM
petitiontext text Petition Text
gmtext text GM Text
zone varchar Zone Short Name
urgency int Urgency
charclass int Character Class
charrace int Character Race
charlevel int Character Level
checkouts int Checkouts
unavailables int Unavailables
ischeckedout tinyint Is Checked Out: 0 = False, 1 = True
senttime bigint Sent Time UNIX Timestamp