Trade processesTable
		
		
		
		Jump to navigation
		Jump to search
		
| 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) |