petitions

Relationships

erDiagram
    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

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