tasks

Info

This page was last generated 2022.09.16

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
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