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 |