Skip to content



This page was last generated 2022.09.16

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
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 Goal Match List: Pipe (
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
zone_version int Zone Version
optional tinyint Optional: 0 = False, 1 = True