tasks¶
Info
This page was last generated 2022.06.19
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 |
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 |