Skip to content



This page was last generated 2023.04.23

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
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