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 |