Trade transformationsTable: Difference between revisions
Jump to navigation
Jump to search
Created page with '{| border="1" |- ! field ! type ! foreign key ! description |- | id | integer | | |- | pattern_id | integer | | |- | process_id | integer | | |- | result_id | integer | | …' |
No edit summary |
||
| (One intermediate revision by one other user not shown) | |||
| Line 1: | Line 1: | ||
{| | {| class="wikitable" | ||
|+ | |||
!UE | |||
!Field | |||
!Type | |||
!Key Type | |||
!Default | |||
!Extra | |||
!Description | |||
|- | |- | ||
| | |||
|id | |||
|int(10) unsigned | |||
|PRI | |||
| | |||
|auto_increment | |||
| | |||
|- | |- | ||
| | | | ||
| | |pattern_id | ||
| | |int(10) unsigned | ||
| | | | ||
| | |||
| | |||
|pattern for the transformation | |||
|- | |- | ||
| | | | ||
| | |process_id | ||
| | |int(10) unsigned | ||
| | | | ||
| | |||
| | |||
|process for transformation | |||
|- | |- | ||
| | | | ||
| | |result_id | ||
| | |int(10) unsigned | ||
| | | | ||
| | |||
| | |||
|resulting item | |||
|- | |- | ||
| | | | ||
| | |result_qty | ||
| | |int(8) unsigned | ||
| | | | ||
| | |||
| | |||
|resulting item quantity | |||
|- | |- | ||
| | | | ||
| | |item_id | ||
| | |int(10) unsigned | ||
| | | | ||
| | |||
| | |||
|item to be transformed | |||
|- | |- | ||
| | | | ||
| | |item_qty | ||
| | |int(8) unsigned | ||
| | | | ||
| | |||
| | |||
|required quantity for transformation | |||
|- | |- | ||
| | | | ||
| | |trans_points | ||
| | |varchar(255) | ||
| | | | ||
|0 | |||
| | |||
|ammount of time to complete transformation | |||
|- | |- | ||
| | | | ||
| | |penalty_pct | ||
| | |float(10,6) | ||
| | | | ||
|1.000000 | |||
| | |||
|percent of quality for resulting item | |||
|- | |- | ||
| | | | ||
| | |description | ||
| | |varchar(255) | ||
| | |||
| | |||
| | |||
| | | | ||
|- | |- | ||
| | |ADD | ||
| | |present_in_book | ||
| | |tinyint(4) | ||
| | | | ||
|1 | |||
| | |||
|If true, this transform will be present in the crafting book | |||
|} | |} | ||
[[Category:Engine documents]] | |||
Latest revision as of 13:25, 11 January 2022
| UE | Field | Type | Key Type | Default | Extra | Description |
|---|---|---|---|---|---|---|
| id | int(10) unsigned | PRI | auto_increment | |||
| pattern_id | int(10) unsigned | pattern for the transformation | ||||
| process_id | int(10) unsigned | process for transformation | ||||
| result_id | int(10) unsigned | resulting item | ||||
| result_qty | int(8) unsigned | resulting item quantity | ||||
| item_id | int(10) unsigned | item to be transformed | ||||
| item_qty | int(8) unsigned | required quantity for transformation | ||||
| trans_points | varchar(255) | 0 | ammount of time to complete transformation | |||
| penalty_pct | float(10,6) | 1.000000 | percent of quality for resulting item | |||
| description | varchar(255) | |||||
| ADD | present_in_book | tinyint(4) | 1 | If true, this transform will be present in the crafting book |