Old Wiki:Stastations
staStations
Description of the staStations Table in the EVEmu database.
| Field Name | Field Type | Nullable | Key |
|---|---|---|---|
| 'stationID' | int(11) | NOT NULL | PRIMARY |
| 'security' | smallint(6) | NULL | |
| 'dockingCostPerVolume' | double | NULL | |
| 'maxShipVolumeDockable' | double | NULL | |
| 'officeRentalCost' | int(11) | NULL | |
| 'operationID' | tinyint(3) unsigned | NULL | |
| 'stationTypeID' | int(11) | NULL | |
| 'corporationID' | int(11) | NULL | |
| 'solarSystemID' | int(11) | NULL | |
| 'constellationID' | int(11) | NULL | |
| 'regionID' | int(11) | NULL | |
| 'stationName' | varchar(100) | NULL | |
| 'x' | double | NULL | |
| 'y ' | double | NULL | |
| 'z' | double | NULL | |
| 'reprocessingEfficiency' | double | NULL | |
| 'reprocessingStationsTake' | double | NULL | |
| 'reprocessingHangarFlag' | tinyint(4) | NULL |
Description of the fields
'stationID'
The unique number for each station. Many tables refer to this number.
'security'
More information needed.
'dockingCostPerVolume'
Docking fees based on ship volume.
'maxShipVolumeDockable'
In game description of the item/ship/implant/station/etc. As appears in the Info window.
'officeRentalCost'
Base rental costs for any corporation offices on this station.
'operationID'
More information needed.
'stationTypeID'
Coordinate system for the station and undocking. Also keeps the hangar and docking bay graphics. Refers to the stastationtypes table.
'corporationID'
The corporation owning the station. Refers to the corporation table.
'solarSystemID'
Solar system the station is located. Refers to the mapsolarsystems table.
'constellationID'
Constellation the station is located. Refers to the mapconstellations table.
'regionID'
Region the station is located. Refers to the mapregions table.
'stationName'
The name of the station.
'x'
The x coordinate in the system.
'y'
The y coordinate in the system.
'z'
The z coordinate in the system.
'reprocessingEfficiency'
The efficiency of the reprocessing facilities. A value of 0.5 represents 50%
'reprocessingStationsTake'
The amount of resources a station takes if standings are neutral.
'reprocessingHangarFlag'
More information needed. May refer to flagID in the invflags table (value is Hangar)