Skip to content



This page was last generated 2022.05.11

Relationship Diagram

Diagram Edit


Relationship Type Local Key Relates to Table Foreign Key
One-to-One delivertonpc npc_types id
Has-Many goalid goallists listid


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
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
optional tinyint Optional: 0 = False, 1 = True
Back to top