From EVEDev
This group of tables lists stations, station services, manufacturing and research slots and related information. These tables use the ram and sta prefixes. ram is mnemonic for Research and Manufacture and sta is mnemonic for Station.
|
|
staStations
| List of all stations.
|
| Column
| Links to
| Used
| Note
|
| stationID
| mapDenormalize.itemID
| *
| Unique ID of station. Should be primary key.
|
| security
|
| *
| Security level of station.
|
| dockingCostPerVolume
|
|
| Cost of docking per ship volume.
|
| maxShipVolumeDockable
|
| *
| Maximum volume of ship that can dock here.
|
| officeRentalCost
|
| *
| Cost of office rent. Should be not static data?
|
| operationID
| staOperations.operationID
| *
| Operation mode of this station.
|
| stationTypeID
| staStationTypes.stationTypeID
| *
| typeID of station.
|
| corporationID
| chrNPCCorporations.corporationID
| *
| ID of owning corporation.
|
| solarSystemID
| mapSolarSystems.solarSystemID
| *
| Solar system where station is located.
|
| constellationID
| mapConstellations.constellationID
| *
| Constellation where station is located.
|
| regionID
| mapRegions.regionID
| *
| Region where station is located.
|
| stationName
|
| *
| Name of station. Also see eveNames table linked on staStations.stationID=eveNames.itemID.
|
| x
|
| *
| X coordinate of station, relative of Solar system center.
|
| y
|
| *
| Y coordinate of station, relative of Solar system center.
|
| z
|
| *
| Z coordinate of station, relative of Solar system center.
|
| reprocessingEfficiency
|
| *
| Reprocessing efficiency of station.
|
| reprocessingStationsTake
|
| *
| Reprocessing mineral cost of station.
|
| reprocessingHangarFlag
|
|
| Unknown.
|
| capitalStation
|
|
| Not used in static dump.
|
| ownershipDateTime
|
|
| Not used in static dump.
|
| upgradeLevel
|
|
| Not used in static dump.
|
| customServiceMask
|
|
| Not used in static dump.
|
staStationTypes
| Types of stations.
|
| Column
| Links to
| Used
| Note
|
| stationTypeID
| invTypes.typeID
| *
| typeID of station.
|
| dockingBayGraphicID
| eveGraphics.graphicID
| *
| Graphic of docking area.
|
| hangarGraphicID
| eveGraphics.graphicID
| *
| Graphic of hangar area.
|
| dockEntryX
|
| *
| X coordinate of dock entry point, relative of station center.
|
| dockEntryY
|
| *
| Y coordinate of dock entry point, relative of station center.
|
| dockEntryZ
|
| *
| Z coordinate of dock entry point, relative of station center.
|
| dockOrientationX
|
| *
| X coordinate of dock exit orientation, relative of station center.
|
| dockOrientationY
|
| *
| Y coordinate of dock exit orientation, relative of station center.
|
| dockOrientationZ
|
| *
| Z coordinate of dock exit orientation, relative of station center.
|
| operationID
| staOperations.operationID
| *
| Operation mode of this station.
|
| officeSlots
|
| *
| Nimber of office slots.
|
| reprocessingEfficiency
|
| *
| Reprocessing efficiency of stations of this type.
|
| conquerable
|
| *
| 1 if station is conquerable.
|
staOperations
| Operation types for stations.
|
| Column
| Links to
| Used
| Note
|
| activityID
|
| *
| Unknown.
|
| operationID
|
| *
| Unique ID of operation type. Should be primary key.
|
| operationName
|
| *
| Name of operation type.
|
| description
|
| *
| Description of operation type.
|
| fringe
|
| *
| Percentage of stations with this type in fringe systems.
|
| corridor
|
| *
| Percentage of stations with this type in corridor systems.
|
| hub
|
| *
| Percentage of stations with this type in hub systems.
|
| border
|
| *
| Percentage of stations with this type in border systems.
|
| ratio
|
| *
| Total ration of this type??
|
| caldariStationTypeID
| staStationTypes.stationTypeID
| *
| typeID of Caldari station for this operation type.
|
| minmatarStationTypeID
| staStationTypes.stationTypeID
| *
| typeID of Minmatar station for this operation type.
|
| amarrStationTypeID
| staStationTypes.stationTypeID
| *
| typeID of Amarr station for this operation type.
|
| gallenteStationTypeID
| staStationTypes.stationTypeID
| *
| typeID of Gallente station for this operation type.
|
| joveStationTypeID
| staStationTypes.stationTypeID
| *
| typeID of Jove station for this operation type.
|
staServices
| List of available services.
|
| Column
| Links to
| Used
| Note
|
| serviceID
|
| *
| Unique ID of service. Should be primary key. Service codes are in bitmask range: 1,2,4,8,16 etc.
|
| serviceName
|
| *
| Name of service.
|
| description
|
| *
| Description of service.
|
staOperationServices
ramAssemblyLines
| List of assembly lines.
|
| Column
| Links to
| Used
| Note
|
| assemblyLineID
|
| *
| Unique ID of line. Should be primary key.
|
| assemblyLineTypeID
| ramAssemblyLineTypes.assemblyLineTypeID
| *
| Type of assembly line.
|
| containerID
| staStations.stationID
| *
| ID of station on which this assembly line is installed.
|
| nextFreeTime
|
|
| Next free time for line. Not used in static dump.
|
| UIGroupingID
|
| *
| UI internal group of assembly line.
|
| costInstall
|
| *
| Cost of installing job.
|
| costPerHour
|
| *
| Cost per hour of running job.
|
| restrictionMask
|
|
| Unknown.
|
| discountPerGoodStandingPoint
|
| *
| Discount (in percents) per each point of positive standing with owning corporation.
|
| surchargePerBadStandingPoint
|
| *
| Surcharge (in percents) per each point of negative standing with owning corporation.
|
| minimumStanding
|
| *
| Minimum standing with owning corporation need to use this line.
|
| minimumCharSecurity
|
| *
| Minimum security status of character need to use this line.
|
| minimumCorpSecurity
|
| *
| Minimum security status of player's corporation need to use this line.
|
| maximumCharSecurity
|
| *
| Maximum security status of character need to use this line.
|
| maximumCorpSecurity
|
| *
| Maximum security status of player's corporation need to use this line.
|
| ownerID
| chrNPCCorporations.corporationID
| *
| ID of owning corporation.
|
| oldContainerID
|
|
| Unknown.
|
| oldOwnerID
|
|
| Unknown.
|
| activityID
|
| *
| Which activity this line supports. See TL2MaterialsActivity table (not included in CCP data dump).
|
ramAssemblyLineTypes
| List of assembly lines types.
|
| Column
| Links to
| Used
| Note
|
| assemblyLineTypeID
|
| *
| Unique ID of type. Should be primary key.
|
| assemblyLineTypeName
|
| *
| Name of type.
|
| description
|
| *
| Description of type.
|
| baseTimeMultiplier
|
| *
| Base time multiplier for lines of this type.
|
| baseMaterialMultiplier
|
| *
| Base material multiplier for lines of this type.
|
| volume
|
|
| Unknown.
|
| activityID
|
| *
| Which activity line of this type supports. See TL2MaterialsActivity table (not included in CCP data dump).
|
| minCostPerHour
|
| *
| Minimal cost per hour for lines of this type.
|
ramAssemblyLineStations
ramAssemblyLineTypeDetailPerCategory
| Assembly line multipliers per produced item category.
|
| Column
| Links to
| Used
| Note
|
| assemblyLineTypeID
| ramAssemblyLineTypes.assemblyLineTypeID
| *
| Type of assembly line.
|
| categoryID
| invCategories.categoryID
| *
| Category of produced item.
|
| timeMultiplier
|
| *
| Time multiplier for assembly lines of this type.
|
| materialMultiplier
|
| *
| Material multiplier for assembly lines of this type.
|
ramAssemblyLineTypeDetailPerGroup
| Assembly line multipliers per produced item group.
|
| Column
| Links to
| Used
| Note
|
| assemblyLineTypeID
| ramAssemblyLineTypes.assemblyLineTypeID
| *
| Type of assembly line.
|
| groupID
| invGroups.groupID
| *
| Group of produced item.
|
| timeMultiplier
|
| *
| Time multiplier for assembly lines of this type.
|
| materialMultiplier
|
| *
| Material multiplier for assembly lines of this type.
|
ramCompletedStatuses
| Job completion statuses.
|
| Column
| Links to
| Used
| Note
|
| completedStatus
|
| *
| Unique ID of status. Should be primary key.
|
| completedStatusText
|
| *
| Text of status as seen in game.
|
| description
|
|
| Description of status.
|
ramActivities
| Research and Manufacturing Activities
|
| Column
| Links to
| Used
| Note
|
| activityID
|
| *
| Unique ID of the activity.
|
| activityName
|
| *
| Name of the activity (e.g. Manufacturing, Copying, Reverse Engineering).
|
| iconNo
|
| *
|
|
| description
|
| *
| Text description of the activity.
|
| published
|
| *
| 1 means the activity has been published and is available in game. 0 means it is not available.
|
