Old Wiki:Invtypematerials
Jump to navigation
Jump to search
invtypematerials
Description of the invtypematerials Table in the EVEmu database.
| Field Name | Field Type | Nullable | Key |
|---|---|---|---|
| 'id' | int(11) | NOT NULL | PRIMARY |
| 'typeID' | int(11) | NULL | |
| 'materialTypeID' | int(11) | NULL | |
| 'quantity' | int(11) | NULL |
Description of the fields
'id'
Unique ID for this process. Each component for every item has a unique number. Raised incrementally.
'typeID'
The database ID of the item being manufactured/reprocessed/refined. Refers to the 'invtypes' table.
'materialTypeID'
Refers to typeID number in 'invtypes'.
Most common entries.
| materialTypeID | Field Type |
|---|---|
| '34' | Tritanium |
| '35' | Pyerite |
| '36' | Mexallon |
| '37' | Isogen |
| '38' | Nocxium |
| '39' | Zydrine |
| '40' | Megacyte |
'quantity'
The 100% amount of mineral/item for manufacturing/reprocessing/refining.
Example
The entry 1179 is Velspar. Velspar is typeID 1230. It refines into Tritanium (34) at a quantity of 1000 at 100% efficiency. This is for a single refining (for each quantity of 333).