From EVEDev
[edit] Structure
staOperations
| Operation types for stations.
|
| Column
| Links to
| Used
| Note
|
| activityID
| crpActivities.activityID
| *
| The activity this relates to. Unused in EVE, I think.
|
| 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.
|
[edit] Examples