Skip to content

tasks

Info

This page was last generated 2023.07.15

Relationship Diagram(s)

Diagram Edit

Relationships

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

Schema

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
reward_id_list text Reward ID List
cash_reward int Cash Reward in Copper
xpreward int Experience Reward
reward_method tinyint Reward Method
reward_points int Reward Points
reward_point_type int Reward Point Type: 4 = Radiant, 5 = Ebon
min_level tinyint Minimum Level
max_level 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
faction_amount int Faction Amount