NPC Corporations Table (MSSQL)

Table of all NPC Corporations.

NPC Corporations

  • Table Name: crpNPCCorporations
  • Description: NPC Corporations list.

Columns

Column Type Default Xrefs Description
corporationID PK int Unique corporation ID.
size char(1) Corporation size. One of 'H', 'L', 'M', 'S', or 'T' corresponding to 'Huge', 'Large', 'Medium', 'Small', and 'Tiny', respectively.
extent char(1) Corporation extent. One of 'G', 'N', 'R', 'C', or 'L' corresponding to 'Global', 'National', 'Regional', 'Constellation', and 'Local', respectively.
solarSystemID int mapSolarSystems.solarSystemID
Solar system ID where corporation headquarters is located.
investorID1 int crpNPCCorporations.corporationID
First investor corporation ID, if applicable.
investorShares1 tinyint Percent of shares held by first investor.
investorID2 int crpNPCCorporations.corporationID
Second investor corporation ID, if applicable.
investorShares2 tinyint Percent of shares held by second investor.
investorID3 int crpNPCCorporations.corporationID
Third investor corporation ID, if applicable.
investorShares3 tinyint Percent of shares held by third investor.
investorID4 int crpNPCCorporations.corporationID
Fourth investor corporation ID, if applicable.
investorShares4 tinyint Percent of shares held by fourth investor.
friendID int crpNPCCorporations.corporationID
Corporation ID of friendly corporation.
enemyID int crpNPCCorporations.corporationID
Corporation ID of enemy corporation.
publicShares bigint Percentage of shares available to the public. Currently not used.
initialPrice int Initial offering prce of public shares. Currently not used.
minSecurity float Unknown.
scattered bit 1 if corporation's stations are scattered in Universe. 0 otherwise.
fringe tinyint Number of fringe systems in which corporation's stations reside.
corridor tinyint Number of corridor systems in which corporation's stations reside.
hub tinyint Number of hub systems in which corporation's stations reside.
border tinyint Number of border systems in which corporation's stations reside.
factionID int chrFactions.factionID
Faction ID of the faction to which this corporation belongs.
sizeFactor float Numeric size of corporation.
stationCount smallint Number of stations owned by corporation.
stationSystemCount smallint Number of systems in which this corporation has a station.
description nvarchar(4000) Corporation description.
iconID int iconIDs file Icon ID for this corporation.