Database Tables - System

From EVEDev

Jump to: navigation, search
Image:Database.pngDatabase Dump Tables - Category Home - Example Queries - Tables - Relationships


This group contain tables with common to all other groups. These tables have names beginning with eve.
Database Tables Categories

Main Page

eveGraphics

Graphics and icons used in game.
Column Links to Used Note
graphicID * Unique ID of Graphics. Should be primary key.
url3D * 3D Image URL as in-game resource.
urlWeb * Actually there is item name, not URL at all.
description * Description of Graphics.
published * 1 if Graphics is published in-game.
obsolete * 1 if Graphics is obsolete.
icon * Name of icon file.
urlSound * Sound URL as in-game resource.
explosionID * (internal?) ID of explosion.

eveNames

Names of space objects, corporations, people etc.
Column Links to Used Note
itemID * Unique ID of this name. Should be primary key.
itemName * Actual name.
categoryID invCategories.categoryID * Category of item called with this name.
groupID invGroups.groupID * Group of item called with this name.
typeID invTypes.typeID * Item type of this name.

eveUnits

Measurement units used in game, for example in dgmAttributeTypes table.
Column Links to Used Note
unitID * Unique ID of measurement unit. Should be primary key.
unitName * Name of unit.
displayName * Text as displayed in game.
description * Description of unit.
Personal tools