Difference between revisions of "EVEmu Database Guide"
Jump to navigation
Jump to search
DarksHeiress (talk | contribs) |
DarksHeiress (talk | contribs) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
== <span id="The_EVE_Database" class="mw-headline"> The EVE Database </span> == | == <span id="The_EVE_Database" class="mw-headline"> The EVE Database </span> == | ||
| − | See [ | + | See [https://wiki.evemu.dev/wiki/Category:EVE_Database here] for a complete listing of tables both brought in by the official CCP static DB dump as well as those created and maintained by the EVEmu project. |
== <span id="Database_Table_Types" class="mw-headline"> ''Database Table Types'' </span> == | == <span id="Database_Table_Types" class="mw-headline"> ''Database Table Types'' </span> == | ||
Latest revision as of 03:12, 4 April 2021
The EVE Database
See here for a complete listing of tables both brought in by the official CCP static DB dump as well as those created and maintained by the EVEmu project.
Database Table Types
Below is a description of the different table types and a list of tables:
IndexRowset - these are simple keyed tables:
The following tables are in IndexRowset form:
TABLENAME PRIMARY KEY --------------------------- ------------------ invcategories categoryID invgroups groupID invmetagroups metaGroupID invtypes typeID invbptypes blueprintTypeID dgmattribs attributeID dgmeffects effectID evegraphics graphicID eveunits unitID eveowners ownerID evelocations locationID corptickernames corporationID allianceshortnames allianceID ramaltypes assemblyLineTypeID ramactivities activityID ramcompletedstatuses completedStatusID mapcelestialdescriptions celestialID certificates certificateID certificaterelationships relationshipID locationwormholeclasses locationID
FilterRowset - these are accessed as dicts, keyed on the table's "primary key", and each value is a standard list or an IndexRowset containing the data rows for the key.
The following tables are in FilterRowset form:
TABLENAME PRIMARY KEY --------------------------- ------------------ dgmtypeeffects typeID dgmtypeattribs typeID invmetatypes typeID invreactiontypes reactionTypeID ramaltypesdetailpercategory assemblyLineTypeID ramaltypesdetailpergroup assemblyLineTypeID ramtyperequirements typeID ramtypematerials typeID