Toggle menu
Toggle preferences menu
Toggle personal menu
Not logged in
Your IP address will be publicly visible if you make any edits.

Static Data Export: Difference between revisions

From EVE University Wiki
added more SDE info
added more SDE info
Line 255: Line 255:
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/invCategories.csv.bz2 invCategories.csv.bz2]|| Item category IDs and names<br>
| [https://www.fuzzwork.co.uk/dump/latest/invCategories.csv.bz2 invCategories.csv.bz2]|| Item category IDs and names<br>
categoryID - defined ID for this table<br>
'''categoryID''' - defined ID for this table<br>
categoryName - defines names of categories<br>
'''categoryName''' - defines names of categories<br>
'''iconID''' - the ID of icons for categories. Corresponds to iconID in eveIcons<br>
'''iconID''' - the ID of icons for categories. Corresponds to iconID in eveIcons<br>
'''published''' - Boolean flag for whether categories are published and available in game
'''published''' - Boolean flag for whether categories are published and available in game
Line 270: Line 270:
| [https://www.fuzzwork.co.uk/dump/latest/invControlTowerResourcePurposes.csv.bz2 invControlTowerResourcePurposes.csv.bz2]|| Empty file
| [https://www.fuzzwork.co.uk/dump/latest/invControlTowerResourcePurposes.csv.bz2 invControlTowerResourcePurposes.csv.bz2]|| Empty file
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/invControlTowerResources.csv.bz2 invControlTowerResources.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/invControlTowerResources.csv.bz2 invControlTowerResources.csv.bz2]|| Describes control tower properties<br>
'''controlTowerTypeID''' - the ID of control towers. Corresponds to typeID in invTypes<br>
'''resourceTypeID''' - the ID of resource required by control towers. Corresponds to typeID in invTypes<br>
'''purpose''' - <br>
'''quantity''' - required quantity of resource<br>
'''minSecurityLevel''' - minimum security level of the system in which control tower can be anchored<br>
'''factionID''' - the ID of faction of control tower
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/invFlags.csv.bz2 invFlags.csv.bz2]||  
| [https://www.fuzzwork.co.uk/dump/latest/invFlags.csv.bz2 invFlags.csv.bz2]|| Flags describing various items<br>
'''flagID''' - defined ID for this table<br>
'''flagName''' - defines names of flags<br>
'''flagText''' - displayed text for flags<br>
'''orderID''' -
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/invGroups.csv.bz2 invGroups.csv.bz2]|| Contains information on inventory groups, such as groupID, categoryID, and other metadata
| [https://www.fuzzwork.co.uk/dump/latest/invGroups.csv.bz2 invGroups.csv.bz2]|| Describes inventory groups<br>
'''groupID''' - defined ID for this table<br>
'''categoryID''' - the ID of categories of inventory groups. Corresponds to categoryID in invCategories<br>
'''groupName''' - defines names of inventory groups<br>
'''iconID''' - the ID of icons for inventory groups. Corresponds to iconID in eveIcons<br>
'''useBasePrice''' - Boolean flag to use base item price instead of adjusted item price in job cost calculation<br>
'''anchored''' - Boolean flag to mark a permanently anchored items<br>
'''anchorable''' - Boolean flag to mark items that can be anchored<br>
'''fittableNonSingleton''' - Boolean flag to mark items that are fittable despite not being flagged as Singletons<br>
'''published''' - Boolean flag to mark inventory groups that are published and available in game
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/invItems.csv.bz2 invItems.csv.bz2]|| Information about itemID and typeID, and some others
| [https://www.fuzzwork.co.uk/dump/latest/invItems.csv.bz2 invItems.csv.bz2]|| Describes items that have defined owners<br>
'''itemID''' - defined ID for this table<br>
'''typeID''' - the ID of the item type. Corresponds to typeID in invTypes<br>
'''ownerID''' - the ID of items' owner. Corresponds to itemID in invNames<br>
'''locationID''' - the ID of items' location. Corresponds to itemID in invPositions<br>
'''flagID''' - the ID of items' flag. Corresponds to flagID in invFlags<br>
'''quantity''' - the items' quantity. Quantity = -1 means unlimited quantity
|-
|-
| [https://www.fuzzwork.co.uk/dump/latest/invMarketGroups.csv.bz2 invMarketGroups.csv.bz2]|| Defines the market group hierarchy
| [https://www.fuzzwork.co.uk/dump/latest/invMarketGroups.csv.bz2 invMarketGroups.csv.bz2]|| Defines the market group hierarchy