mapDenormalize (CCP DB)

From EVEDev
Jump to: navigation, search
CCP DB Table Categories

Structure

mapDenormalize

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.

Examples

Personal tools