task_activities¶
Info
This page was last generated 2022.05.11
Relationship Diagram¶
Relationships¶
Relationship Type | Local Key | Relates to Table | Foreign Key |
---|---|---|---|
One-to-One | delivertonpc | npc_types | id |
Has-Many | goalid | goallists | listid |
Schema¶
Column | Data Type | Description |
---|---|---|
taskid | int | Task Identifier |
activityid | int | Activity Identifier: Starts at 0 |
step | int | Step: 0 = Always Available, >0 = Must Complete Previous |
activitytype | tinyint | Activity Type |
target_name | varchar | Target Name |
item_list | varchar | Item Identifier List |
skill_list | varchar | Skill Identifier List |
spell_list | varchar | Spell Identifier List |
description_override | varchar | Description Override |
goalid | int | Goal Identifier or Goal List Identifier |
goal_match_list | text | |
goalmethod | int | Goal Method: 0 = Single Value, 1 = List |
goalcount | int | Goal Count |
delivertonpc | int | Deliver To NPC: 0 = No Delivery NPC, >0 = NPC Type Identifier |
zones | varchar | Zones List |
optional | tinyint | Optional: 0 = False, 1 = True |