Skip to content



    character_task_timers {
        intunsigned character_id
        intunsigned task_id
    character_data {
        intunsigned id
        varchar name
        varchar nane
        intunsigned zone_instance
        intunsigned zone_id
    tasks {
        intunsigned id
        tinyint type
        intunsigned dz_template_id
    character_task_timers ||--o{ character_data : "One-to-One"
    character_task_timers ||--o{ tasks : "One-to-One"

Relationship Type Local Key Relates to Table Foreign Key
One-to-One character_id character_data id
One-to-One task_id tasks id


Column Data Type Description
id int Unique Task Timer Identifier
character_id int Character Identifer
task_id int Task Identifier
timer_type int Timer Type (0 = Replay, 1 = Request)
timer_group int Group Timer
expire_time datetime Expire Time