tasks

Relationships

erDiagram
    tasks {
        intunsigned id
        tinyint type
        intunsigned dz_template_id
    }
    task_activities {
        intunsigned activityid
        varchar goalid
        varchar delivertonpc
        intunsigned taskid
        varchar zones
    }
    tasksets {
        intunsigned taskid
    }
    character_tasks {
        intunsigned charid
        intunsigned taskid
        tinyint type
    }
    dynamic_zone_templates {
        intunsigned id
    }
    tasks ||--o{ task_activities : "Has-Many"
    tasks ||--o{ tasksets : "Has-Many"
    tasks ||--o{ character_tasks : "Has-Many"
    tasks ||--o{ dynamic_zone_templates : "One-to-One"

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
cash_reward	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
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
enabled	smallint