tasks¶
Info
This page was last generated 2023.07.15
Relationship Diagram(s)¶
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 |