Old Wiki:Invtypes
invtypes
Description of the invtypes Table in the EVEmu database.
| Field Name | Field Type | Nullable | Key |
|---|---|---|---|
| 'typeID' | int(11) | NOT NULL | PRIMARY |
| 'groupID' | int(11) | NULL | |
| 'typeName' | text | NULL | |
| 'description' | text | NULL | |
| 'graphicID' | int(11) | NULL | |
| 'radius' | double | NULL | |
| 'mass' | double | NULL | |
| 'volume' | double | NULL | |
| 'capacity' | double | NULL | |
| 'portionSize' | int(11) | NULL | |
| 'raceID' | tinyint(3) unsigned | NULL | |
| 'basePrice' | bigint(20) | NULL | |
| 'published' | bit(1) | NULL | |
| 'marketGroupID' | int(11) | NULL | |
| 'chanceOfDuplicating' | double | NULL | |
| 'soundID' | int(11) | NULL | |
| 'iconID' | int(11) | NULL | |
| 'dataID' | int(11) | NULL | |
| 'typeNameID' | int(11) | NULL | |
| 'descriptionID' | int(11) | NULL |
Description of the fields
'typeID'
The unique number for each type of item/ship/implant/station/etc in the game. Many tables refer to this number.
'groupID'
Group this item belongs to, foe example all Small Hybrid Turrets would have the same groupID. Many tables refer to this number.
'typeName'
The name of the item/ship/implant/station/etc.
'description'
In game description of the item/ship/implant/station/etc. As appears in the Info window.
'graphicID'
The graphic used for the item.
'radius'
Radius of item, if applicable.
'mass'
Mass of item, if applicable.
'volume'
Volume of item, if applicable.
'capacity'
The holding (cargo) capacity, if applicable.
'portionSize'
Portion size of item, if applicable. Portion size is size of group for reprocessing purposes, for example. It also represents the number of units produced by a production run of the item.
'raceID'
The Loyalty Points (LP) needed to make a purchase.
'basePrice'
Which race(s) this item belongs to. Races are bitmask.
'published'
-1 if the item is published in the game market (including in Contracts), otherwise 0.
'marketGroupID'
Market group of item. If NULL, the item cannot be sold on the market. It could be sold through Contracts however.
'chanceOfDuplicating'
Chance of duplicating item. Duplication process is not implemented.
'soundID'
More information needed
'iconID'
More information needed
'dataID'
More information needed
'typeNameID'
More information needed
'descriptionID'
More information needed