Item instancesTable: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 14: | Line 14: | ||
| int(10) unsigned | | int(10) unsigned | ||
| Y | | Y | ||
| | | Key into the [[CharactersTable]] for the owner of this item. | ||
|- | |- | ||
| char_id_guardian | | char_id_guardian | ||
| int(10) unsigned | | int(10) unsigned | ||
| Y | | Y | ||
| | | Key into the [[CharactersTable]] for the guardian of this item. | ||
|- | |- | ||
| parent_item_id | | parent_item_id | ||
| Line 39: | Line 39: | ||
| int(10) unsigned | | int(10) unsigned | ||
| Y | | Y | ||
| | | Key into the [[CharactersTable]] for the creator of this item if craftet. | ||
|- | |- | ||
| guild_mark_id | | guild_mark_id | ||
| Line 94: | Line 94: | ||
| int(10) unsigned | | int(10) unsigned | ||
| Y | | Y | ||
| | | Key into the [[ItemStatsTable]] for the standard version of this item. | ||
|- | |- | ||
| item_stats_id_unique | | item_stats_id_unique | ||
| int(10) unsigned | | int(10) unsigned | ||
| Y | | Y | ||
| | | Key into the [[ItemStatsTable]] for unique versions of this item. | ||
|- | |- | ||
| flags | | flags | ||
Revision as of 22:20, 18 July 2012
| field | type | foreign key | description |
|---|---|---|---|
| id | int(10) unsigned | ||
| char_id_owner | int(10) unsigned | Y | Key into the CharactersTable for the owner of this item. |
| char_id_guardian | int(10) unsigned | Y | Key into the CharactersTable for the guardian of this item. |
| parent_item_id | int(10) unsigned | Y | |
| location_in_parent | smallint(4) | ||
| stack_count | int(10) unsigned | ||
| creator_mark_id | int(10) unsigned | Y | Key into the CharactersTable for the creator of this item if craftet. |
| 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 | Key into the ItemStatsTable for the standard version of this item. |
| item_stats_id_unique | int(10) unsigned | Y | Key into the ItemStatsTable for unique versions of this item. |
| 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) |