Skip to content



    petitions {
        varchar accountname
        varchar charname
        varchar lastgm
        varchar zone
    character_data {
        intunsigned id
        varchar name
        varchar nane
        intunsigned zone_instance
        intunsigned zone_id
    account {
        int id
        varchar name
    zone {
        int zoneidnumber
        varchar short_name
        tinyintunsigned version
        varchar content_flags
        varchar content_flags_disabled
    petitions ||--o{ character_data : "One-to-One"
    petitions ||--o{ account : "One-to-One"
    petitions ||--o{ character_data : "One-to-One"
    petitions ||--o{ zone : "One-to-One"

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


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