Skip to content

tasks

Info

This page was last generated 2022.06.19

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

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
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_radiant_crystals int Reward Radiant Crystals
reward_ebon_crystals int Reward Ebon Crystals
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_seconds int Replay Timer in Seconds
request_timer_seconds int Request Timer in Seconds
Back to top