Skip to content



    character_tasks {
        intunsigned charid
        intunsigned taskid
        tinyint type
    character_data {
        intunsigned id
        varchar name
        varchar nane
        intunsigned zone_instance
        intunsigned zone_id
    tasks {
        intunsigned id
        tinyint type
        intunsigned dz_template_id
    character_tasks ||--o{ character_data : "One-to-One"
    character_tasks ||--o{ tasks : "One-to-One"
    character_tasks ||--o{ tasks : "One-to-One"

Relationship Type Local Key Relates to Table Foreign Key
One-to-One charid character_data id
One-to-One taskid tasks id
One-to-One type tasks type


Column Data Type Description
charid int Character Identifier
taskid int Task Identifier
slot int Slot
type tinyint Task Type
acceptedtime int Accepted Time UNIX Timestamp
was_rewarded tinyint Was Rewarded: 0 = False, 1 = True