task_activities¶
Info
This page was last generated 2023.04.23
Relationship Diagram(s)¶
Relationships¶
Relationship Type | Local Key | Relates to Table | Foreign Key |
---|---|---|---|
One-to-One | delivertonpc | npc_types | id |
Has-Many | goalid | goallists | listid |
One-to-One | taskid | tasks | id |
One-to-One | zones | zone | zoneidnumber |
Schema¶
Column | Data Type | Description |
---|---|---|
taskid | int | Task Identifier |
activityid | int | Activity Identifier: Starts at 0 |
req_activity_id | int | |
step | int | Step: 0 = Always Available, >0 = Must Complete Previous |
activitytype | tinyint | Activity Type |
target_name | varchar | Target Name |
goalmethod | int | Goal Method: 0 = Single Value, 1 = List |
goalcount | int | Goal Count |
description_override | varchar | Description Override |
npc_match_list | text | |
item_id_list | text | |
item_list | varchar | Item Identifier List |
dz_switch_id | int | |
delivertonpc | int | Deliver To NPC: 0 = No Delivery NPC, >0 = NPC Type Identifier |
min_y | float | |
min_z | float | |
max_x | float | |
max_y | float | |
max_z | float | |
skill_list | varchar | Skill Identifier List |
spell_list | varchar | Spell Identifier List |
zones | varchar | Zones List |
zone_version | int | Zone Version |
optional | tinyint | Optional: 0 = False, 1 = True |