task_activities

Relationships

erDiagram
    task_activities {
        intunsigned activityid
        varchar goalid
        varchar delivertonpc
        intunsigned taskid
        varchar zones
    }
    npc_types {
        intunsigned alt_currency_id
        int id
        int npc_faction_id
        text name
        intunsigned loottable_id
        intunsigned merchant_id
        intunsigned emoteid
        intunsigned adventure_template_id
        intunsigned armortint_id
        intunsigned npc_spells_id
        intunsigned npc_spells_effects_id
        intunsigned trap_template
    }
    goallists {
        varchar listid
    }
    tasks {
        intunsigned id
        tinyint type
        intunsigned dz_template_id
    }
    zone {
        int zoneidnumber
        varchar short_name
        tinyintunsigned version
        varchar content_flags
        varchar content_flags_disabled
    }
    task_activities ||--o{ npc_types : "One-to-One"
    task_activities ||--o{ goallists : "Has-Many"
    task_activities ||--o{ tasks : "One-to-One"
    task_activities ||--o{ zone : "One-to-One"

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
goalid	int	Goal Identifier or Goal List Identifier
goal_match_list	text	Goal Match List: Pipe (
item_list	varchar	Item Identifier List
dz_switch_id	int	Dynamic Zone Switch ID
min_x	float	Minimum X Coordinate
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
list_group	tinyint