Old Wiki:Entity
entity
Description of the entity Table in the EVEmu database.
| Field Name | Field Type | Nullable | Key |
|---|---|---|---|
| 'itemID' | int(10) unsigned | NOT NULL | PRIMARY |
| 'itemName' | varchar(85) | NOT NULL | |
| 'typeID' | int(10) unsigned | NOT NULL | |
| 'ownerID' | int(10) unsigned | NOT NULL | |
| 'locationID' | int(10)unsigned | NOT NULL | |
| 'flag' | int(10) | NOT NULL | |
| 'contraband' | int(10) unsigned | NOT NULL | |
| 'singleton' | int(10) unsigned | NOT NULL | |
| 'quantity' | int(10) unsigned | NOT NULL | |
| 'x' | double | NOT NULL | |
| 'y' | double | NOT NULL | |
| 'z' | double | NOT NULL | |
| 'customInfo' | text | NULL |
Description of the fields
'itemID'
This is each item/character/NPC's ID in the table. Incremental for every offer. Several tables refer to this number.
'itemName'
The name of the item.
'typeID'
The typeID of the item/character/NPC given. Refers to the invtypes table.
'ownerID'
The owner of item/character/NPC. This would refer to a previous itemID.
'locationID'
The in-station or solar-system location if applicable. This value can be 0. Refers to the stastations or mapsolarsystems table.
'flag'
The flagID. Refers to invflags.
'contraband'
More information needed.
'singleton'
More information needed.
'quantity'
The quantity of the item (if in a stack)
'x'
The 'x' location if in space.
'y'
The 'y' location if in space.
'z'
The 'z' location if in space.
'customInfo'
Server generated info about the item.