Skip to content



This page was last generated 2022.09.16

Relationship Diagram(s)

Diagram Edit


Relationship Type Local Key Relates to Table Foreign Key
Has-Many id task_activities taskid
Has-Many id tasksets taskid
Has-Many type character_tasks type
One-to-One dz_template_id dynamic_zone_templates id


Column Data Type Description
id int Unique Task Identifier
type tinyint Task Type
duration int Duration
duration_code tinyint Duration Code
title varchar Title
description text Description
reward varchar Reward Description
rewardid int Reward Item Identifier
cashreward int Cash Reward in Copper
xpreward int Experience Reward
rewardmethod tinyint Reward Method: 0 = Single Item ID, 1 = List of Items, 2 = Quest Controlled
reward_points int Reward Points
reward_point_type int Reward Point Type: 4 = Radiant, 5 = Ebon
minlevel tinyint Minimum Level
maxlevel tinyint Maximum Level
level_spread int Level Spread
min_players int Minimum Players
max_players int Maximum Players
repeatable tinyint Repeatable: 0 = False, 1 = True
faction_reward int Faction Reward
completion_emote varchar Completion Emote
replay_timer_group int Group Replay Timer in Seconds
replay_timer_seconds int Replay Timer in Seconds
request_timer_group int Group Request Timer in Seconds
request_timer_seconds int Request Timer in Seconds
dz_template_id int Dynamic Zone Template Identifier
lock_activity_id int Lock Activity Identifier