character_task_timers

Relationships

erDiagram
    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

Schema

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