Skip to content



This page was last generated 2023.07.15

Relationship Diagram(s)

Diagram Edit


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


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