task_activities¶
Info
This page was last generated 2023.07.15
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 | Required Activity Identifier |
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 | NPC Match List |
goal_match_list | text | Goal Match List: Pipe ( |
item_list | varchar | Item Identifier List |
dz_switch_id | int | Dynamic Zone Switch ID |
delivertonpc | int | Deliver To NPC: 0 = No Delivery NPC, >0 = NPC Type Identifier |
min_y | float | Minimum Y Coordinate |
min_z | float | Minimum Z Coordinate |
max_x | float | Maximum X Coordinate |
max_y | float | Maximum Y Coordinate |
max_z | float | Maximum Z Coordinate |
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 |