petitions¶
Info
This page was last generated 2023.04.23
Relationship Diagram(s)¶
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 |