| UE
|
Field
|
Type
|
Key Type
|
Default
|
Extra
|
Description
|
|
|
process_id
|
int(10) unsigned
|
PRI
|
|
|
|
|
|
subprocess_number
|
int(4) unsigned
|
PRI
|
|
|
subprocess number
|
|
|
name
|
varchar(40)
|
|
|
|
process name
|
|
|
animation
|
varchar(30)
|
|
|
|
transformation animation
|
|
|
render_effect
|
char(32)
|
|
|
|
transformation render effect
|
|
|
workitem_id
|
int(10) unsigned
|
|
|
|
target item to complete transformation
|
|
|
equipment_id
|
int(10) unsigned
|
|
|
|
required equipped item
|
|
|
constraints
|
varchar(64)
|
|
|
|
constraints that apply to the transformation
|
|
|
garbage_id
|
int(10) unsigned
|
|
|
|
garbage item for flubbed transformations
|
|
|
garbage_qty
|
int(8) unsigned
|
|
|
|
garbage quantity for flubbed transformations
|
|
|
primary_skill_id
|
int(10)
|
|
|
|
primary skill for transformation
|
|
|
primary_min_skill
|
int(8) unsigned
|
|
|
|
minimum primary skill level required to perform the transformation, 0 is no minimum
|
|
|
primary_max_skill
|
int(8) unsigned
|
|
|
|
maximum primary skill level at which practice and quality are affected, 0 is no maximum
|
|
|
primary_practice_points
|
int(4)
|
|
|
|
number of practice primary skill points gained for performing transformation
|
|
|
primary_quality_factor
|
int(3) unsigned
|
|
0
|
|
percentage of the primary skill range that applies to quality
|
|
|
secondary_skill_id
|
int(10)
|
|
|
|
secondary skill foreign key
|
|
|
secondary_min_skill
|
int(8) unsigned
|
|
|
|
minimum secondary skill level required to perform the transformation, 0 is no minimum
|
|
|
secondary_max_skill
|
int(8) unsigned
|
|
|
|
maximum secondary skill level at which practice and quality are affected, 0 is no maximum
|
|
|
secondary_practice_points
|
int(4)
|
|
|
|
number of practice secondary skill points gained for performing transformation
|
|
|
secondary_quality_factor
|
int(3) unsigned
|
|
|
|
percentage of the secondary skill range that applies to quality
|
|
|
script
|
varchar(255)
|
|
Apply Post Trade Process
|
|
A script to run after a process has been completed. In order to apply custom effects to the result.
|
|
|
description
|
varchar(255)
|
|
|
|
|