| List of Universes in game.
|
| Column
| Links to
| Used
| Note
|
| universeID
|
| *
| Unique ID of universe. Should be primary key.
|
| universeName
|
| *
| Name of universe.
|
| x
|
| *
| Absolute coordinate X of universe's center.
|
| y
|
| *
| Absolute coordinate Y of universe's center.
|
| z
|
| *
| Absolute coordinate Z of universe's center.
|
| xMin
|
| *
| Minimal value of X coordinate.
|
| xMax
|
| *
| Maximal value of X coordinate.
|
| yMin
|
| *
| Minimal value of Y coordinate.
|
| yMax
|
| *
| Maximal value of Y coordinate.
|
| zMin
|
| *
| Minimal value of Z coordinate.
|
| zMax
|
| *
| Maximal value of Z coordinate.
|
| radius
|
| *
| Radius of universe.
|
| List of regions.
|
| Column
| Links to
| Used
| Note
|
| regionID
|
| *
| Unique ID of region. Should be primary key.
|
| regionName
|
| *
| Name of region. Also see eveNames table linked on eveNames.itemID=mapRegions.regionID.
|
| x
|
| *
| Absolute coordinate X of region's center.
|
| y
|
| *
| Absolute coordinate Y of region's center.
|
| z
|
| *
| Absolute coordinate Z of region's center.
|
| xMin
|
| *
| Minimal value of X coordinate.
|
| xMax
|
| *
| Maximal value of X coordinate.
|
| yMin
|
| *
| Minimal value of Y coordinate.
|
| yMax
|
| *
| Maximal value of Y coordinate.
|
| zMin
|
| *
| Maximal value of Z coordinate.
|
| zMax
|
| *
| Maximal value of Z coordinate.
|
| factionID
| chrFactions.factionID
| *
| ID of controlling faction.
|
| radius
|
| *
| Radius of region.
|
| List of constellations.
|
| Column
| Links to
| Used
| Note
|
| regionID
| mapRegions.regionID
| *
| ID of region.
|
| constellationID
|
| *
| Unique ID of constellation. Should be primary key.
|
| constellationName
|
| *
| Name of constellation. Also see eveNames table linked on eveNames.itemID=mapConstellations.constellationID.
|
| x
|
| *
| Absolute coordinate X of constellations's center.
|
| y
|
| *
| Absolute coordinate Y of constellations's center.
|
| z
|
| *
| Absolute coordinate Z of constellations's center.
|
| xMin
|
| *
| Minimal value of X coordinate.
|
| xMax
|
| *
| Maximal value of X coordinate.
|
| yMin
|
| *
| Minimal value of Y coordinate.
|
| yMax
|
| *
| Maximal value of Y coordinate.
|
| zMin
|
| *
| Minimal value of Z coordinate.
|
| zMax
|
| *
| Maximal value of Z coordinate.
|
| factionID
| chrFactions.factionID
| *
| ID of controlling faction.
|
| radius
|
| *
| Radius of constellation.
|
| List of solar systems.
|
| Column
| Links to
| Used
| Note
|
| regionID
| mapRegions.regionID
| *
| ID of region.
|
| constellationID
| mapConstellations.constellationID
| *
| ID of constellation.
|
| solarSystemID
|
| *
| Unique ID of solar system. Should be primary key.
|
| solarSystemName
|
| *
| Name of solar system. Also see eveNames table linked on eveNames.itemID=mapSolarSystems.solarSystemID.
|
| x
|
| *
| Absolute coordinate X of solar system's center.
|
| y
|
| *
| Absolute coordinate Y of solar system's center.
|
| z
|
| *
| Absolute coordinate Z of solar system's center.
|
| xMin
|
| *
| Minimal value of X coordinate.
|
| xMax
|
| *
| Maximal value of X coordinate.
|
| yMin
|
| *
| Minimal value of Y coordinate.
|
| yMax
|
| *
| Maximal value of Y coordinate.
|
| zMin
|
| *
| Minimal value of Z coordinate.
|
| zMax
|
| *
| Maximal value of Z coordinate.
|
| luminosity
|
| *
| Star luminousity. Also see mapCelestialStatistics table.
|
| border
|
|
| 1 if solar system is on border.
|
| fringe
|
|
| 1 if solar system is in fringe, i.e. have only one link.
|
| corridor
|
|
| 1 if solar system is corridor, i.e have 2 links.
|
| hub
|
|
| 1 if solar system is hub, i.e. have 3 or more links.
|
| international
|
|
| 1 if solar system have stations of different factions. (note: there are a number of systems that are marked as international but only have 1 or no stations at all)
|
| regional
|
|
| 1 if solar system have interregional link.
|
| constellation
|
|
| 1 if solar system have interconstellational link.
|
| security
|
| *
| Security level of system.
|
| factionID
| chrFactions.factionID
| *
| ID of controlling faction. Note: Don't rely on this field because most entries are NULL.
|
| radius
|
| *
| Radius of solar system.
|
| sunTypeID
| invTypes.typeID
| *
| typeID of star in center of solar system.
|
| securityClass
|
| *
| Security class of system. Used to determine available minerals, see mapSolarSystemMinerals and mapSolarSystemOreBySecurityClass tables (not included in dump).
|
| allianceID
|
|
| Sovereign alliance. Not used in static dump.
|
| sovereigntyLevel
|
|
| Level of sovereignity. Not used in static dump.
|
| sovereigntyDateTime
|
|
| Date of sovereignity start. Not used in static dump.
|
| List of all space objects, including regions and constellations.
|
| Column
| Links to
| Used
| Note
|
| itemID
|
| *
| Unique ID of celestial object. Should be primary key.
|
| typeID
| invTypes.typeID
| *
| typeID of object.
|
| groupID
| invGroups.groupID
| *
| ID of group object belongs to.
|
| solarSystemID
| mapSolarSystems.solarSystemID
| *
| ID of solar system where object is located, if applicable.
|
| constellationID
| mapConstellations.constellationID
| *
| ID of constellation where object is located, if applicable.
|
| regionID
| mapRegions.regionID
| *
| ID of region where object is located, if applicable.
|
| orbitID
| mapDenormalize.itemID
| *
| ID of object around which this object orbits, i.e. Station orbits around Moon, Moon around Planet etc.
|
| x
|
| *
| Absolute (for region, constellation, solar system) or relative from solar system center (all other objects) coordinate X of object.
|
| y
|
| *
| Absolute (for region, constellation, solar system) or relative from solar system center (all other objects) coordinate Y of object.
|
| z
|
| *
| Absolute (for region, constellation, solar system) or relative from solar system center (all other objects) coordinate Z of object.
|
| radius
|
| *
| Radius of object, if applicable.
|
| itemName
|
| *
| Name of object. Also see eveNames table linked on eveNames.itemID=mapDenormalize.itemID.
|
| security
|
| *
| Security level of object, if applicable.
|
| celestialIndex
|
| *
| Number of solar orbit of object in solar system, if applicable.
|
| orbitIndex
|
| *
| Number of planetary orbit of object in planetary system, if applicable.
|
| Astronomical statistics for all celestial objects (stars, planets, moons, asteroid belts). Lore interest only.
|
| Column
| Links to
| Used
| Note
|
| celestialID
| mapDenormalize.itemID
| *
| ID of object.
|
| temperature
|
| *
| Temperature on absolute scale.
|
| spectralClass
|
| *
| Spectral class for stars.
|
| luminosity
|
| *
| Luminosity for stars.
|
| age
|
| *
| Age of object.
|
| life
|
| *
| Level of life on surface.
|
| orbitRadius
|
| *
| Radius of orbit.
|
| eccentricity
|
| *
| Eccentricity of orbit.
|
| massDust
|
| *
| Mass of planet.
|
| massGas
|
| *
| Mass of atmosphere.
|
| fragmented
|
| *
| 1 if object is fragmented, i.e. asteroid belt.
|
| density
|
| *
| Density of object.
|
| surfaceGravity
|
| *
| Gravity on surface.
|
| escapeVelocity
|
| *
| Velocity for escaping from this object.
|
| orbitPeriod
|
| *
| Period of orbit.
|
| rotationRate
|
| *
| Period of rotation.
|
| locked
|
| *
| Unknown.
|
| pressure
|
| *
| Atmospheric pressure on surface.
|
| radius
|
| *
| Radius of object.
|
| mass
|
| *
| Mass of object.
|
