Item instancesTable: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| Line 13: | Line 13: | ||
| char_id_owner | | char_id_owner | ||
| int(10) unsigned | | int(10) unsigned | ||
| | | Y | ||
| | | | ||
|- | |- | ||
| char_id_guardian | | char_id_guardian | ||
| int(10) unsigned | | int(10) unsigned | ||
| | | Y | ||
| | | | ||
|- | |- | ||
| parent_item_id | | parent_item_id | ||
| int(10) unsigned | | int(10) unsigned | ||
| | | Y | ||
| | | | ||
|- | |- | ||
| Line 38: | Line 38: | ||
| creator_mark_id | | creator_mark_id | ||
| int(10) unsigned | | int(10) unsigned | ||
| | | Y | ||
| | | | ||
|- | |- | ||
| guild_mark_id | | guild_mark_id | ||
| int(10) unsigned | | int(10) unsigned | ||
| | | Y | ||
| | | | ||
|- | |- | ||
| Line 53: | Line 53: | ||
| loc_sector_id | | loc_sector_id | ||
| smallint(4) unsigned | | smallint(4) unsigned | ||
| | | Y | ||
| | | | ||
|- | |- | ||
| Line 93: | Line 93: | ||
| item_stats_id_standard | | item_stats_id_standard | ||
| int(10) unsigned | | int(10) unsigned | ||
| | | Y | ||
| | | | ||
|- | |- | ||
| item_stats_id_unique | | item_stats_id_unique | ||
| int(10) unsigned | | int(10) unsigned | ||
| | | Y | ||
| | | | ||
|- | |- | ||
Revision as of 22:14, 18 July 2012
| field | type | foreign key | description |
|---|---|---|---|
| id | int(10) unsigned | ||
| char_id_owner | int(10) unsigned | Y | |
| char_id_guardian | int(10) unsigned | Y | |
| parent_item_id | int(10) unsigned | Y | |
| location_in_parent | smallint(4) | ||
| stack_count | int(10) unsigned | ||
| creator_mark_id | int(10) unsigned | Y | |
| guild_mark_id | int(10) unsigned | Y | |
| loc_instance | int(11) unsigned | ||
| loc_sector_id | smallint(4) unsigned | Y | |
| loc_x | float(14,6) | ||
| loc_y | float(14,6) | ||
| loc_z | float(14,6) | ||
| loc_yrot | float(14,6) | ||
| decay_resistance | float(3,2) | ||
| item_quality | float(5,2) | ||
| crafted_quality | float(5,2) | ||
| item_stats_id_standard | int(10) unsigned | Y | |
| item_stats_id_unique | int(10) unsigned | Y | |
| flags | varchar(200) | ||
| lock_str | int(5) | ||
| lock_skill | int(2) | ||
| openable_locks | varchar(100) | ||
| item_name | varchar(100) | ||
| item_description | varchar(255) | ||
| charges | int(3) |