Aurora stores its game data in a SQLite database. A database can hold several saved games together with shared definitions, catalogues, design templates and interface settings. The dictionary below lists all 214 tables and 2902 columns, including SQLite housekeeping tables. Table and column spellings are preserved exactly.

Reading the database

Section titled “Reading the database”

The dictionary covers the AuroraDB.db layout. A different Aurora release or an edited database can have different columns and catalogue values. A table’s existence does not mean every column is active in every game. Tables with Old in their names remain separate entries.

FCT_ tables usually hold game state or game-related definitions. DIM_ tables usually hold shared catalogues. The prefixes are a naming convention rather than an enforced rule. For example, DIM_KnownSystems has a GameID column, while several reusable template tables have no GameID.

Select the game first. Rows with GameID belong to the stated game or to a special shared-definition scope. A value of 0 can identify shared technology and component definitions. Follow each table’s scope rather than filtering every table blindly. Game identity and reload explains separate object ID ranges and the table-wide maxima used when a game loads.

Stored IDs are not display names. A ship’s ShipID, HullNumber and name serve different purposes. The same number can occur in different identity domains. A column ending in ID can refer to a catalogue entry, an object, or a target whose kind is selected by another column. For example, ContactID uses ContactType, TargetID uses TargetType, and DestinationID uses DestinationType. A number alone is insufficient for those links.

Knowledge is local to the observer. The FCT_Alien*, survey and contact tables can describe what one race knows. Their estimates, names and detection dates are separate from the underlying ship, colony or system records. Observation and knowledge and intelligence explain those boundaries.

Time and units depend on the column. FCT_Game.GameTime and dated game history use simulation seconds. The display calendar starts from StartYear. One fixed game year is 31,536,000 seconds. Ship class and component sizes commonly use hull spaces of 50 tons. Colony population uses millions of people, mineral stockpiles use tons, and maintenance supplies use MSP. A numeric SQL type alone supplies no unit. Game clocks and ship design cover the conversions.

Stored values can be settings, snapshots or running state. Race rows include interface preferences and technology-derived capacities. Class rows include capacities, while ship rows hold current fuel, crew and damage state. History, observed intelligence and current object records are different kinds of data. Displayed state, history records and ship readiness describe those differences.

Storage notation and relationships

Section titled “Storage notation and relationships”

The SQL type is the declared SQLite type, including declared lengths or precision. An empty type is shown as (none). These declarations are distinct from game units and game limits. BOOLEAN is a declared type rather than a separate SQLite storage class.

The Key column shows PK 1 for the first primary key column, PK 2 for the second part of a composite key, and a dash when no primary key is declared. 100 tables declare a primary key. The NULL column reports the explicit NOT NULL declaration. A single-column INTEGER PRIMARY KEY aliases the rowid in an ordinary rowid table, except for the column declaration INTEGER PRIMARY KEY DESC. Composite keys do not have this alias behaviour. A reported nullable declaration is not a promise that the game accepts a missing value.

The Default column reproduces the SQL expression. none means no DEFAULT clause. NULL means the declared default is SQL NULL. An empty quoted string is different from both. A default is used when an insert omits the column. It does not describe every existing value or every new-game choice.

The database declares 0 foreign keys. Identity links in this dictionary describe game identity domains and do not claim SQLite enforces them. Some are optional, some use 0 as an absent selection, and some require an additional category or observer. Do not infer a cascade rule, uniqueness guarantee or a mandatory parent from an ID spelling. Persistence and reload explains how the relationships are restored.

The column descriptions give the named datum and its context. Descriptions beginning Label only expand the stored name without assigning an extra unit, range, relationship or conversion. For category-dependent values, use the related mechanics guide and the category stored alongside the value. In particular, Amount, Size, MaxChance, ComponentValue and technology input slots have no single meaning across all tables.

Section titled “Reading related records”

These read-only queries use named parameters. Bind :game to the selected game and :race to the selected race. A join reads the stored records and does not recalculate current game displays.

Find the ships, their classes and their fleets within one game’s records.

SELECT s.ShipID, s.ShipName, s.HullNumber,
       c.ShipClassID, c.ClassName, f.FleetID, f.FleetName
FROM FCT_Ship AS s
JOIN FCT_ShipClass AS c
  ON c.GameID = s.GameID AND c.ShipClassID = s.ShipClassID
JOIN FCT_Fleet AS f
  ON f.GameID = s.GameID AND f.FleetID = s.FleetID
WHERE s.GameID = :game AND s.RaceID = :race
ORDER BY f.FleetName, s.ShipName;

Find a race’s colony installation quantities and their shared installation definitions. The shorter PopID in the installation rows identifies the same colony domain as PopulationID.

SELECT p.PopulationID, p.PopName,
       i.PlanetaryInstallationID, i.Name, pi.Amount
FROM FCT_Population AS p
JOIN FCT_PopulationInstallations AS pi
  ON pi.GameID = p.GameID AND pi.PopID = p.PopulationID
JOIN DIM_PlanetaryInstallation AS i
  ON i.PlanetaryInstallationID = pi.PlanetaryInstallationID
WHERE p.GameID = :game AND p.RaceID = :race
ORDER BY p.PopName, i.DisplayOrder, i.Name;

Read contact observations through the detecting race, rather than treating every contact as information the selected race knows.

SELECT UniqueID, ContactType, ContactID, ContactName,
       SystemID, LastUpdate, Xcor, Ycor
FROM FCT_Contacts
WHERE GameID = :game AND DetectRaceID = :race
ORDER BY SystemID, UniqueID;

Table directory

Section titled “Table directory”
Area Tables Related mechanics
Game state and presentation 9 game time and state refresh
Systems, stars and bodies 26 star system and planetary generation
Races, species and diplomacy 6 player race creation and starting configuration
Colonies, industry and trade 22 colony and population lifecycle
Technology and designs 22 technology to deployment
Fleets, movement and orders 19 movement and logistics
Ships, combat and recovery 25 space combat resolution
Ground forces 17 ground force organisation
Commanders and honours 14 commander lifecycle
Observation and intelligence 21 observation and knowledge lifecycle
Automated planning 13 npr strategic planning
Names and themes 17 naming themes automatic naming and hull numbers
SQLite housekeeping 3 object identity reload

Game state and presentation

Section titled “Game state and presentation”

DIM_EventType / DefaultEventColour / FCT_EventColour / FCT_Game / FCT_GameLog / FCT_HideEvents / FCT_Increments / FCT_MapLabel / FCT_WindowPosition

DIM_EventType

Section titled “DIM_EventType”

Event categories and combat display, damage display and interruption settings.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in event types interrupts and hidden events.

Column SQL type Key NULL Default Meaning and relationships
EventTypeID INTEGER PK 1 NOT NULL none Label only. Event Type ID identifier or catalogue selection for event type.
Description TEXT - allowed* NULL Descriptive text for the row.
CombatDisplay INTEGER - allowed* 0 Whether the category belongs in combat event displays.
DamageDisplay INTEGER - allowed* 0 Whether the category belongs in damage event displays.
AttackEvent Numeric - allowed* NULL Whether the category is treated as an attack event.
PlayerInterrupt INTEGER - allowed* 0 Player interruption selection for this event category.
AIInterrupt INTEGER - allowed* 0 Automatic interruption selection for this event category.

DefaultEventColour

Section titled “DefaultEventColour”

Default event alert and text colours and associated presentation data.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in application colours theme.

Column SQL type Key NULL Default Meaning and relationships
EventTypeID INTEGER PK 1 allowed* NULL Label only. Event Type ID identifier or catalogue selection for default event colour.
RaceID INTEGER PK 2 allowed* 0 Race identifier. The table purpose determines whether this is an owner, subject or observer.
AlertColour INTEGER - allowed* 0 Label only. Alert Colour value for default event colour.
TextColour INTEGER - allowed* NULL Label only. Text Colour value for default event colour.
CreationOrder INTEGER - allowed* NULL Label only. Creation Order value for default event colour.
Test TEXT - allowed* none Label only. Test text for default event colour.

Indexes. DefaultEventColour_EventTypeID (non-unique, EventTypeID). sqlite_autoindex_DefaultEventColour_1 (unique, EventTypeID, RaceID).

FCT_EventColour

Section titled “FCT_EventColour”

Per-race event alert and text colours.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in application colours theme.

Column SQL type Key NULL Default Meaning and relationships
EventTypeID INTEGER PK 1 NOT NULL none Label only. Event Type ID identifier or catalogue selection for event colour.
RaceID INTEGER PK 2 NOT NULL 0 Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
AlertColour INTEGER - allowed* 0 Label only. Alert Colour value for event colour.
TextColour INTEGER - allowed* NULL Label only. Text Colour value for event colour.

Indexes. sqlite_autoindex_FCT_EventColour_1 (unique, EventTypeID, RaceID).

FCT_Game

Section titled “FCT_Game”

Saved game identity, simulation time and game-wide options.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in game rule options and effects.

Column SQL type Key NULL Default Meaning and relationships
GameID INTEGER PK 1 allowed* none Identifier of this game. Other game-owned tables use GameID to keep separate campaigns in the same database.
AutoJumpGates INTEGER - allowed* 0 All Jump Points are Stable option. New jump points receive JumpGateStrength 1000, allowing every ship to transit them. Existing jump points retain their saved strength. The New Game preset is 0.
CivilianShippingLinesActive INTEGER - allowed* 1 Civilian Shipping Lines Active option. Enables ordinary civilian shipping activity. Civilian fuel harvester construction also depends on AllowCivilianHarvesters. See civilian logistics.
DefaultRaceID INTEGER - allowed* 0 Saved default race identifier. It refers to RaceID in FCT_Race.
DifficultyModifier INTEGER - allowed* 100 Difficulty percentage with 100 as normal. It enters NPR homeworld population, starting technology calculations. It is not a multiplier on every game output. See difficulty formulas.
GameName TEXT - allowed* NULL Name shown in the game selection window.
GameTime Double - allowed* 1 Elapsed simulation time in seconds since the beginning of the campaign. StartYear supplies the calendar origin. Saving and loading this clock does not itself advance time. See game time.
GenerateNonTNOnly INTEGER - allowed* 0 Generate Pre-industrial Only option. The selection is saved and restored. Race level generation uses PreIndustrialChance, ConventionalChance and MinorRaceChance without consulting this option.
GenerateNPRs INTEGER - allowed* 0 Generate New Races as NPRs option. Determines whether races created during discovery are non-player races. It does not convert existing races.
InexpFleets INTEGER - allowed* 1 Inexperienced Fleet Penalties option. Open fire and fire at will orders from the Naval Organization window apply experience-based firing delays when enabled.
INTEGER - allowed* 0 NPRsGenerateRifts extends generation eligibility to NPR discoveries.
LastGrowthTime Double - allowed* 0 GameTime in seconds of the last strategic construction cycle. The next cycle uses the accumulated interval since this clock. Loading preserves the interval without crediting production.
LastViewed Double - allowed* 0 Last-played marker used to choose the game that opens automatically. Saving sets this game’s value to 1 and all other games to 0. It is not a date or elapsed time.
LocalSystemChance INTEGER - allowed* 50 Local System Generation Chance percentage. With positive LocalSystemSpread, this determines whether a procedural jump link uses a nearby system number rather than an unrestricted number. It does not measure physical distance.
LocalSystemSpread INTEGER - allowed* 15 Maximum local procedural system number offset. A local link adds or subtracts a die roll of this size and wraps across NumberOfSystems. A value of 0 disables local number selection. It is not a distance in light-years.
MinComets INTEGER - allowed* 0 Minimum comet count applied to ordinary primary-star generation outside Sol. A random count below this number is raised to it. This does not give every special generation path the same comet count.
NewRuinCreationChance INTEGER - allowed* 20 Percentage chance for a ruin on a qualifying generated body. Ordinary bodies need a surface temperature above 200 K and below 360 K, gravity above 0.4 and the distance test. Comets use a separate qualification path. The New Game preset uses 20.
NoOverhauls INTEGER - allowed* 0 No Maintenance Required option. Skips ordinary ship maintenance, overhauls, maintenance failures and ground unit maintenance expenses during construction cycles. Ships have their last overhaul time refreshed and become operational. Existing component damage and deployment strain are separate.
NonPlayerSystemDetection INTEGER - allowed* 0 Saved Detection selection. Values are 0 for Normal in all systems, 1 for None without player presence and 2 for Automatic without player presence. Detection during play does not consult this saved selection.
NumberOfSystems INTEGER - allowed* 1000 Maximum procedural system number used when selecting generated systems and jump destinations. The New Game preset uses 1000. It does not truncate the known star catalogue.
OrbitalMotion INTEGER - allowed* 0 Orbital Motion for Planets option. Gates ordinary orbital position and orbital climate updates for planets and moons. A forced update can bypass the gate.
OrbitalMotionAst INTEGER - allowed* 0 Orbital Motion for Asteroids option. Permits non-trojan asteroid movement within an orbital update. OrbitalMotion must also permit the outer update unless it is forced.
PlayerExplorationTime Double - allowed* NULL Label only. Player Exploration Time value for game.
PoliticalAdmirals INTEGER - allowed* 1 Commander Political Bonuses option. Enables Political Reliability rolls for new commanders and Political Reliability experience gains.
INTEGER - allowed* 0 Enables eligibility for ruin defenders and random wreck generation.
RaceChance INTEGER - allowed* 30 NPR generation chance percentage copied into a non-Sol system discovered by a player race. A qualifying body must pass this chance before its race level is selected.
RaceChanceNPR INTEGER - allowed* 10 NPR generation chance percentage copied into a system discovered by an NPR. It is an alternative to RaceChance and is not added to it.
RealisticPromotions INTEGER - allowed* 1 Saved Realistic Commander Promotions option. It is shown and restored by the settings window but does not alter promotion processing during play.
SMPassword TEXT - allowed* NULL Spacemaster password stored with the game settings.
INTEGER - allowed* 0
StartYear INTEGER - allowed* 2020 Calendar year at the beginning of the campaign. GameTime adds the elapsed seconds to this origin. The New Game preset uses 2050.
SubPulseLength INTEGER - allowed* 0 Length in seconds of the movement and sensor subpulse. Increment preparation can change this value to suit the selected increment and combat conditions.
TruceCountdown Double - allowed* 0 Remaining truce countdown in raw seconds. Construction cycles subtract elapsed seconds while the value is positive. Fixed relationship flags clear only when subtraction takes it below 0. Reaching exactly 0 leaves them fixed. The settings box saves its entered number directly despite displaying the loaded value in years.
UseKnownStars INTEGER - allowed* 0 Known Star Systems option. New systems and links use known stellar coordinates and catalogue data when enabled. Changing it does not convert existing systems.
MinConstructionPeriod INTEGER - allowed* 432000 Construction cycle threshold in seconds. The cycle runs when GameTime minus LastGrowthTime is strictly greater than this value and processes the accumulated interval once. The New Game preset uses 430000 seconds.
MinGroundCombatPeriod INTEGER - allowed* 28800 Interval in seconds between scheduled ground combat rounds. The initial value is 28800 seconds, or eight hours.
LastGroundCombatTime Double - allowed* 0 Elapsed game time in seconds used as the origin for scheduling ground combat rounds. It is separate from the construction cycle clock.
SolDisaster INTEGER - allowed* 0 Saved Sol Disaster dropdown position. Values 0 to 12 select no disaster, three warming rates, three cooling rates, three Earth death spirals and three radiation rates. Applying settings also changes Sol’s disaster status. See the complete selector.
TechFromConquest INTEGER - allowed* 1 New Tech from Conquest option. A non-zero value enables technology capture when a defeated population surrenders to its conqueror. See population control transfer.
ResearchSpeed INTEGER - allowed* 100 Research speed percentage with 100 as normal. Scales colony research output and generated race research budgets. Player-designed component development costs also multiply by this percentage.
TerraformingSpeed INTEGER - allowed* 100 Terraforming speed percentage with 100 as normal. Multiplies each colony’s Earth-equivalent annual terraforming capacity. See terraforming.
AllowCivilianHarvesters INTEGER - allowed* 1 Allow Civilian Harvesters option. Civilian fuel harvester construction also needs active civilian shipping, suitable surveyed Sorium deposits, sufficient population and the harvester technology. It is not a command to create harvesters immediately.
INTEGER - allowed* 0 Mineral deposits, oxygen, climate, gravity and distance requirements still apply.
HumanNPRs INTEGER - allowed* 0 Allow Human NPRs option passed to race creation during discovery. The other conditions for human NPR creation still apply.
CurrentGroundCombat Boolean - allowed* FALSE Flag recording whether ground combat is currently active for round scheduling. It works with LastGroundCombatTime and MinGroundCombatPeriod.
SurveySpeed INTEGER - allowed* 100 Survey speed percentage with 100 as normal. Scales fleet geological and gravitational survey progress, missile geological survey progress and ground geological survey progress.
MaxEventDays INTEGER - allowed* 60 Number of days selected for the Events window history range. The initial value is 60. It is separate from MaxEventCount.
MaxEventCount INTEGER - allowed* 300 Maximum event count selected for the Events window. The initial value is 300. It is separate from the history range in MaxEventDays.
ConstellationNames INTEGER - allowed* FALSE Use Constellation Names option. Chooses the display form of a known system’s real name when a race names that system.
INTEGER - allowed* 0
INTEGER - allowed* 0
NPRsGenerateRifts INTEGER - allowed* 0
INTEGER - allowed* 0 A value of 0 stops the strategic raider generation and deployment pass. It does not remove the saved raider race.
NPRsEncounterRaiders INTEGER - allowed* 0 NPRs Encounter Raiders option. With 0, raid targets are restricted to systems known to player races. When enabled, half the target selections still use that restricted pool.
INTEGER - allowed* 0 Successful progression advances this position and wraps it to 0 after 14.
RaiderSystems INTEGER - allowed* 0 The creation window starts at 10.
INTEGER - allowed* 0 The creation window starts at 30.
INTEGER - allowed* 0 The creation window starts at 50.
StarEccentricity INTEGER - allowed* 0 Eccentric Orbits option. With 0, generated star and body eccentricity is 0 and tactical orbits draw as circles.
GasGiantEffects INTEGER - allowed* 0 Gas Giant Effects option. Enables the giant-planet stability pass during generation. Saving settings does not rerun this pass on existing systems.
LimitedLabs INTEGER - allowed* 0 Limited Research Administration option. Changes new scientist research administration, profession chances, administration experience gains and the academy assignment threshold.
OneSecondSubPulse INTEGER - allowed* 1 One Second Sub Pulse option. When enabled, an increment that is exactly five seconds after the early combat shortening steps uses one-second movement and sensor subpulses. This does not create five construction cycles.
HostilityModifier INTEGER - allowed* 0 Modifier applied to a generated Standard NPR species. It adds to Xenophobia and Militancy and subtracts from Trade and Diplomacy. The former are capped at 100 and the latter remain at least 1.
Double - allowed* 0 Later threat scaling uses elapsed time from this origin.
Double - allowed* 0
Double - allowed* 0
MinorRaceChance INTEGER - allowed* 25 Minor trans-Newtonian NPR percentage range after the pre-industrial and industrial ranges. Remaining outcomes create a Standard race. The New Game preset uses 20.
LimitPlanetaryDistance INTEGER - allowed* 1 Limited Planet Distance option. Applies companion-star and body distance restrictions during generation. Ordinary bodies beyond 80 AU times the system scale are removed or repositioned according to their periapsis.
ParallelUniverse INTEGER - allowed* 0 Saved hidden Parallel Universes option. Enabling it clears UseKnownStars. It does not generate parallel Sol systems during play.
UseThemeInKnownStars INTEGER - allowed* 0 Use Theme in Known Stars option. Uses a race’s system naming theme instead of the real catalogue name when naming a newly charted known system.
NPRMaxSystems INTEGER - allowed* 0 Cap on initial exploration and colonisation for eligible generated NPRs, including the home system. A value of 0 means no cap. Starting templates may override it.
NPRBaseTransits INTEGER - allowed* 0 Base number of initial exploration transits for eligible generated NPRs. NPRRandomTransits adds a die roll. Starting templates may override the total.
NPRRandomTransits INTEGER - allowed* 0 Die size for the random part of eligible NPR initial exploration. The roll adds to NPRBaseTransits. Both values at 0 skip that initial exploration.
INTEGER - allowed* 0 The base diameter remains 10000000 km, with additional large random diameters on qualifying rolls.
INTEGER - allowed* 0
INTEGER - allowed* 0 Changes tomb emergence and combat behaviour.
INTEGER - allowed* 0 A value of 0 means no invasion system is recorded. A later expansion attempt with no matching system resets it to 0.
INTEGER - allowed* 600000 The initial value is 600000. Player-based research scaling can raise the actual budget above this floor.
PreIndustrialChance INTEGER - allowed* 0 First percentage range when selecting a newly generated race’s level. A successful first roll creates a pre-industrial race. The New Game preset uses 10.
ConventionalChance INTEGER - allowed* 0 Industrial NPR percentage range after the pre-industrial range. The roll is over the remaining range after PreIndustrialChance. The New Game preset uses 10.
chkOrders Boolean - allowed* FALSE Show move order indicators in the fleet tree. Stored as 0 or 1.
chkOverhauls Boolean - allowed* FALSE Show overhaul indicators in the fleet tree. Stored as 0 or 1.
chkShowJD Boolean - allowed* FALSE Show jump drive indicators in the fleet tree. Stored as 0 or 1.
INTEGER - allowed* 1 Enables the relic generation step for player-generated systems after the earlier special feature choices. The New Game preset enables it.
AllowCMC INTEGER - allowed* 1 Allow Civilian Mining Companies option. The New Game preset enables it. See civilian economy.

FCT_GameLog

Section titled “FCT_GameLog”

Dated game events and their race, location and subject references.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in event types interrupts and hidden events.

Column SQL type Key NULL Default Meaning and relationships
IncrementID INTEGER - allowed* 0 Label only. Increment ID identifier or catalogue selection for game log.
GameID INTEGER - allowed* NULL Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
RaceID INTEGER - allowed* NULL Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
SMOnly INTEGER - allowed* NULL Whether this event is visible only in Spacemaster mode.
Time Double - allowed* NULL Simulation clock time of the event, in seconds.
EventType INTEGER - allowed* 0 Event category identifier from DIM_EventType.
MessageText TEXT - allowed* NULL Event or order message text.
SystemID INTEGER - allowed* NULL Star system identifier. Related identity domain FCT_System.SystemID.
Xcor Double - allowed* NULL X coordinate. System-space and map-space coordinates must be interpreted in the context of this table.
Ycor Double - allowed* NULL Y coordinate. System-space and map-space coordinates must be interpreted in the context of this table.
IDType INTEGER - allowed* 0 Category used to interpret the event subject.
PopulationID INTEGER - allowed* 0 Colony identifier. A population is a race-and-species colony on a system body. Related identity domain FCT_Population.PopulationID.

FCT_HideEvents

Section titled “FCT_HideEvents”

Event types hidden for an individual race.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in event types interrupts and hidden events.

Column SQL type Key NULL Default Meaning and relationships
RaceID INTEGER - NOT NULL none Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
EventID INTEGER - NOT NULL none Label only. Event ID identifier or catalogue selection for hide events.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.

FCT_Increments

Section titled “FCT_Increments”

Simulation increment identity, game time and elapsed length.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in game time and state refresh.

Column SQL type Key NULL Default Meaning and relationships
IncrementID INTEGER PK 1 NOT NULL 0 Label only. Increment ID identifier or catalogue selection for increments.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
GameTime DOUBLE - allowed* 0 Simulation clock in seconds since the beginning of the game.
Length INTEGER - allowed* 0 Label only. Length value for increments.

FCT_MapLabel

Section titled “FCT_MapLabel”

Per-race map label text, font, colour and position.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in displayed state and refresh.

Column SQL type Key NULL Default Meaning and relationships
GameID INTEGER - allowed* NULL Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
RaceID INTEGER - allowed* NULL Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
Caption TEXT - allowed* NULL Label only. Caption text for map label.
Colour INTEGER - allowed* NULL Label only. Colour value for map label.
FontSize INTEGER - allowed* NULL Label only. Font Size value for map label.
FontBold Boolean - allowed* NULL Label only. Font Bold selection for map label.
FontItalic Boolean - allowed* NULL Label only. Font Italic selection for map label.
FontName TEXT - allowed* NULL Label only. Font Name text for map label.
Xcor Double - allowed* NULL X coordinate. System-space and map-space coordinates must be interpreted in the context of this table.
Ycor Double - allowed* NULL Y coordinate. System-space and map-space coordinates must be interpreted in the context of this table.

FCT_WindowPosition

Section titled “FCT_WindowPosition”

Saved window positions.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in displayed state and refresh.

Column SQL type Key NULL Default Meaning and relationships
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
WindowName TEXT - allowed* NULL Name of the window whose position is saved.
Left INTEGER - allowed* 0 Horizontal window position.
Top INTEGER - allowed* 0 Vertical window position.

Systems, stars and bodies

Section titled “Systems, stars and bodies”

DIM_Constellation / DIM_Gases / DIM_KnownSystems / DIM_KnownSystems_Old / DIM_PlanetaryTerrain / DIM_Ruin / DIM_SetAtmosphere / DIM_SolSystemBodies / DIM_StellarType / DIM_SystemAbundance / DIM_SystemAge / FCT_AtmosphericGas / FCT_JumpPoint / FCT_LagrangePoint / FCT_MineralDeposit / FCT_MissileGeoSurvey / FCT_RuinRace / FCT_Star / FCT_SurveyLocation / FCT_System / FCT_SystemBody / Wormholes

DIM_Constellation

Section titled “DIM_Constellation”

Constellation abbreviations and stellar designation data.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in star system and planetary generation.

Column SQL type Key NULL Default Meaning and relationships
Constellation TEXT - allowed* none Label only. Constellation text for constellation.
MaxFlamsteed TEXT - allowed* none Label only. Max Flamsteed text for constellation.
Alpha TEXT - allowed* none Label only. Alpha text for constellation.
Beta TEXT - allowed* none Label only. Beta text for constellation.
Gamma TEXT - allowed* none Label only. Gamma text for constellation.
Delta TEXT - allowed* none Label only. Delta text for constellation.
Epsilon TEXT - allowed* none Label only. Epsilon text for constellation.
Zeta TEXT - allowed* none Label only. Zeta text for constellation.
Eta TEXT - allowed* none Label only. Eta text for constellation.
Theta TEXT - allowed* none Label only. Theta text for constellation.
Iota TEXT - allowed* none Label only. Iota text for constellation.
Kappa TEXT - allowed* none Label only. Kappa text for constellation.
Lambda TEXT - allowed* none Label only. Lambda text for constellation.
Mu TEXT - allowed* none Label only. Mu text for constellation.
Nu TEXT - allowed* none Label only. Nu text for constellation.
Xi TEXT - allowed* none Label only. Xi text for constellation.
Omicron TEXT - allowed* none Label only. Omicron text for constellation.
Pi TEXT - allowed* none Label only. Pi text for constellation.
Rho TEXT - allowed* none Label only. Rho text for constellation.
Sigma TEXT - allowed* none Label only. Sigma text for constellation.
Tau TEXT - allowed* none Label only. Tau text for constellation.
Upsilon TEXT - allowed* none Label only. Upsilon text for constellation.
Phi TEXT - allowed* none Label only. Phi text for constellation.
Chi TEXT - allowed* none Label only. Chi text for constellation.
Psi TEXT - allowed* none Label only. Psi text for constellation.
Omega TEXT - allowed* none Label only. Omega text for constellation.

DIM_Gases

Section titled “DIM_Gases”

Atmospheric gas definitions and climate or toxicity properties.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in terraforming mechanics.

Column SQL type Key NULL Default Meaning and relationships
GasID INTEGER PK 1 allowed* none Atmospheric gas identifier.
Name TEXT - allowed* NULL Name stored for the row. Name text is distinct from numeric identity.
Symbol TEXT - allowed* NULL Label only. Symbol text for gases.
Weight INTEGER - allowed* NULL Label only. Weight value for gases.
BoilingPoint INTEGER - allowed* NULL Label only. Boiling Point value for gases.
GHGas Numeric - allowed* NULL Label only. GH Gas value for gases.
AntiGHGas Numeric - allowed* NULL Label only. Anti GH Gas value for gases.
Dangerous INTEGER - allowed* NULL Label only. Dangerous value for gases.
DangerousLevel Double - allowed* none Label only. Dangerous Level value for gases.

DIM_KnownSystems

Section titled “DIM_KnownSystems”

Known-star catalogue entries used to create named systems and stellar components.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in star system and planetary generation.

Column SQL type Key NULL Default Meaning and relationships
KnownSystemID INTEGER PK 1 allowed* none Label only. Known System ID identifier or catalogue selection for known systems.
Name TEXT - allowed* NULL Name stored for the row. Name text is distinct from numeric identity.
PrimaryName TEXT - allowed* NULL Label only. Primary Name text for known systems.
Component1ID INTEGER - allowed* 0 Label only. Component1 ID identifier or catalogue selection for known systems.
Component2ID INTEGER - allowed* 0 Label only. Component2 ID identifier or catalogue selection for known systems.
C2Orbit Double - allowed* 0 Label only. C2 Orbit value for known systems.
Component3ID INTEGER - allowed* 0 Label only. Component3 ID identifier or catalogue selection for known systems.
C3Orbit Double - allowed* 0 Label only. C3 Orbit value for known systems.
C3OrbitType INTEGER - allowed* 0 Label only. C3 Orbit Type value for known systems.
Component4ID INTEGER - allowed* 0 Label only. Component4 ID identifier or catalogue selection for known systems.
C4Orbit Double - allowed* 0 Label only. C4 Orbit value for known systems.
C4OrbitType INTEGER - allowed* 0 Label only. C4 Orbit Type value for known systems.
X Double - allowed* 0 Label only. X value for known systems.
Y Double - allowed* 0 Label only. Y value for known systems.
Z Double - allowed* 0 Label only. Z value for known systems.
Distance Double - allowed* 0 Label only. Distance value for known systems.
ConstellationName TEXT - allowed* none Label only. Constellation Name text for known systems.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows.

DIM_KnownSystems_Old

Section titled “DIM_KnownSystems_Old”

An older known-star catalogue retained alongside DIM_KnownSystems. Its presence does not make it the active catalogue.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in star system and planetary generation.

Column SQL type Key NULL Default Meaning and relationships
KnownSystemID INTEGER PK 1 allowed* none Label only. Known System ID identifier or catalogue selection for known systems_old.
Name TEXT - allowed* NULL Name stored for the row. Name text is distinct from numeric identity.
PrimaryName TEXT - allowed* NULL Label only. Primary Name text for known systems_old.
Component1ID INTEGER - allowed* NULL Label only. Component1 ID identifier or catalogue selection for known systems_old.
Component2ID INTEGER - allowed* 0 Label only. Component2 ID identifier or catalogue selection for known systems_old.
C2Orbit Double - allowed* 0 Label only. C2 Orbit value for known systems_old.
Component3ID INTEGER - allowed* 0 Label only. Component3 ID identifier or catalogue selection for known systems_old.
C3Orbit Double - allowed* 0 Label only. C3 Orbit value for known systems_old.
C3OrbitType INTEGER - allowed* 0 Label only. C3 Orbit Type value for known systems_old.
Component4ID INTEGER - allowed* 0 Label only. Component4 ID identifier or catalogue selection for known systems_old.
C4Orbit Double - allowed* 0 Label only. C4 Orbit value for known systems_old.
C4OrbitType INTEGER - allowed* 0 Label only. C4 Orbit Type value for known systems_old.
X Double - allowed* 0 Label only. X value for known systems_old.
Y Double - allowed* 0 Label only. Y value for known systems_old.
Z Double - allowed* 0 Label only. Z value for known systems_old.
Distance Double - allowed* NULL Label only. Distance value for known systems_old.
ConstellationName TEXT - allowed* none Label only. Constellation Name text for known systems_old.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows.

DIM_PlanetaryTerrain

Section titled “DIM_PlanetaryTerrain”

Terrain definitions, environmental selection limits and ground combat effects.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in planetary terrain.

Column SQL type Key NULL Default Meaning and relationships
TerrainID INTEGER - allowed* none Label only. Terrain ID identifier or catalogue selection for planetary terrain.
Name TEXT - allowed* none Name stored for the row. Name text is distinct from numeric identity.
Abbreviation TEXT - allowed* none Short display name or abbreviation.
FortificationModifier Double - allowed* none Label only. Fortification Modifier value for planetary terrain.
ToHitModifier Double - allowed* none Label only. To Hit Modifier value for planetary terrain.
MinimumHydro Double - allowed* none Label only. Minimum Hydro value for planetary terrain.
MinimumOxygen Double - allowed* none Label only. Minimum Oxygen value for planetary terrain.
MaximumHydro Double - allowed* none Label only. Maximum Hydro value for planetary terrain.
MinimumTemperature Double - allowed* none Label only. Minimum Temperature value for planetary terrain.
MaximumTemperature Double - allowed* none Label only. Maximum Temperature value for planetary terrain.
MaximumTectonics INTEGER - allowed* none Label only. Maximum Tectonics value for planetary terrain.
MinimumTectonics INTEGER - allowed* none Label only. Minimum Tectonics value for planetary terrain.
BaseTerrainType INTEGER - allowed* 0 Label only. Base Terrain Type value for planetary terrain.
MinTempRange INTEGER - allowed* 0 Label only. Min Temp Range value for planetary terrain.
DesertTerrain Boolean - allowed* FALSE Label only. Desert Terrain selection for planetary terrain.
JungleTerrain Boolean - allowed* FALSE Label only. Jungle Terrain selection for planetary terrain.

DIM_Ruin

Section titled “DIM_Ruin”

Ruins generation definitions, abandoned industry and defender selections.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in salvage and archaeology.

Column SQL type Key NULL Default Meaning and relationships
RuinID INTEGER PK 1 allowed* NULL Label only. Ruin ID identifier or catalogue selection for ruin.
MaxChance INTEGER - allowed* NULL Selection threshold or limit. Its interpretation depends on this catalogue and is not a universal percentage.
Description TEXT - allowed* NULL Descriptive text for the row.
FactoriesBase INTEGER - allowed* NULL Label only. Factories Base value for ruin.
FactoriesRandom INTEGER - allowed* NULL Label only. Factories Random value for ruin.
DefenceBases INTEGER - allowed* NULL Label only. Defence Bases value for ruin.
OffenceBases INTEGER - allowed* 0 Label only. Offence Bases value for ruin.
Fleet INTEGER - allowed* 0 Label only. Fleet value for ruin.
Squadron INTEGER - allowed* 0 Label only. Squadron value for ruin.
Patrol INTEGER - allowed* 0 Label only. Patrol value for ruin.
STO INTEGER - allowed* none Label only. STO value for ruin.
Regiment INTEGER - allowed* none Label only. Regiment value for ruin.
FixedDSTS INTEGER - allowed* none Label only. Fixed DSTS value for ruin.
RandomDSTS INTEGER - allowed* none Label only. Random DSTS value for ruin.
NoDefenders INTEGER - allowed* NULL Label only. No Defenders value for ruin.
EmergenceModifier Double - allowed* NULL Label only. Emergence Modifier value for ruin.

DIM_SetAtmosphere

Section titled “DIM_SetAtmosphere”

Atmosphere generation choices by temperature band.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in star system and planetary generation.

Column SQL type Key NULL Default Meaning and relationships
AtmosphereID INTEGER PK 1 allowed* none Label only. Atmosphere ID identifier or catalogue selection for set atmosphere.
TempBand INTEGER - allowed* NULL Label only. Temp Band value for set atmosphere.
MaxChance INTEGER - allowed* NULL Selection threshold or limit. Its interpretation depends on this catalogue and is not a universal percentage.
Gas1 INTEGER - allowed* 0 Label only. Gas1 value for set atmosphere.
Gas2 INTEGER - allowed* 0 Label only. Gas2 value for set atmosphere.
Gas3 INTEGER - allowed* 0 Label only. Gas3 value for set atmosphere.
Description VARCHAR(100) - allowed* NULL Descriptive text for the row.

DIM_SolSystemBodies

Section titled “DIM_SolSystemBodies”

Starting Solar System body templates.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in star system and planetary generation.

Column SQL type Key NULL Default Meaning and relationships
SystemBodyID INTEGER PK 1 allowed* none System body identifier. Bodies include planets, moons, asteroids and comets.
Name TEXT - allowed* ' ' Name stored for the row. Name text is distinct from numeric identity.
PlanetNumber INTEGER - allowed* 0 Label only. Planet Number value for sol system bodies.
OrbitNumber INTEGER - allowed* 0 Label only. Orbit Number value for sol system bodies.
TrojanPlanet INTEGER - allowed* 0 Label only. Trojan Planet value for sol system bodies.
TrojanLocation INTEGER - allowed* 0 Label only. Trojan Location value for sol system bodies.
TrojanOffset Double - allowed* 0 Label only. Trojan Offset value for sol system bodies.
OrbitalDistance Double - allowed* 0 Label only. Orbital Distance value for sol system bodies.
CurrentDistance Double - allowed* 0 Label only. Current Distance value for sol system bodies.
HeadingInward Numeric - allowed* NULL Label only. Heading Inward value for sol system bodies.
Bearing Double - allowed* 0 Label only. Bearing value for sol system bodies.
BodyClass INTEGER - allowed* 0 Label only. Body Class value for sol system bodies.
Density Double - allowed* 0 Label only. Density value for sol system bodies.
Radius INTEGER - allowed* 0 Label only. Radius value for sol system bodies.
Gravity Double - allowed* 0 Label only. Gravity value for sol system bodies.
ParentBodyType INTEGER - allowed* 0 Label only. Parent Body Type value for sol system bodies.
BodyTypeID INTEGER - allowed* 0 Label only. Body Type ID identifier or catalogue selection for sol system bodies.
Mass Double - allowed* 0 Label only. Mass value for sol system bodies.
Escape Double - allowed* 0 Label only. Escape value for sol system bodies.
Year Double - allowed* 0 Label only. Year value for sol system bodies.
Day Double - allowed* 0 Label only. Day value for sol system bodies.
TidalForce Double - allowed* 0 Label only. Tidal Force value for sol system bodies.
TidalLock Numeric - allowed* 0 Label only. Tidal Lock value for sol system bodies.
Tilt INTEGER - allowed* 0 Label only. Tilt value for sol system bodies.
Eccentricity Double - allowed* 0 Label only. Eccentricity value for sol system bodies.
Roche Double - allowed* 0 Label only. Roche value for sol system bodies.
TectonicActivity INTEGER - allowed* 1 Label only. Tectonic Activity value for sol system bodies.
Ring Numeric - allowed* 0 Label only. Ring value for sol system bodies.
MagneticField Double - allowed* 0 Label only. Magnetic Field value for sol system bodies.
BaseTemp Double - allowed* 0 Base equilibrium temperature in kelvin.
SurfaceTemp Double - allowed* 0 Surface temperature in kelvin.
HydroID INTEGER - allowed* 1 Label only. Hydro ID identifier or catalogue selection for sol system bodies.
HydroExt INTEGER - allowed* 0 Label only. Hydro Ext value for sol system bodies.
AtmosPress Double - allowed* 0 Atmospheric pressure in atmospheres.
Albedo Double - allowed* 1 Label only. Albedo value for sol system bodies.
GHFactor Double - allowed* 1 Greenhouse factor.
RGE Numeric - allowed* 0 Label only. RGE value for sol system bodies.
Xcor Double - allowed* 0 X coordinate. System-space and map-space coordinates must be interpreted in the context of this table.
Ycor Double - allowed* 0 Y coordinate. System-space and map-space coordinates must be interpreted in the context of this table.
PlanetIcon TEXT - allowed* NULL Label only. Planet Icon text for sol system bodies.
DominantTerrain INTEGER - allowed* 0 Label only. Dominant Terrain value for sol system bodies.

DIM_StellarType

Section titled “DIM_StellarType”

Stellar type definitions, physical properties, colours and generation weights.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in star system and planetary generation.

Column SQL type Key NULL Default Meaning and relationships
StellarTypeID INTEGER PK 1 allowed* none Label only. Stellar Type ID identifier or catalogue selection for stellar type.
SpectralClass TEXT - allowed* NULL Label only. Spectral Class text for stellar type.
SpectralNumber INTEGER - allowed* NULL Label only. Spectral Number value for stellar type.
Checked Boolean - allowed* NULL Label only. Checked selection for stellar type.
NotPS Boolean - allowed* NULL Label only. Not PS selection for stellar type.
MaxChance INTEGER - allowed* NULL Selection threshold or limit. Its interpretation depends on this catalogue and is not a universal percentage.
BDMaxChance INTEGER - allowed* 0 Label only. BD Max Chance value for stellar type.
SizeText TEXT - allowed* NULL Label only. Size Text text for stellar type.
SizeID INTEGER - allowed* NULL Label only. Size ID identifier or catalogue selection for stellar type.
Luminosity Double - allowed* NULL Label only. Luminosity value for stellar type.
Mass Double - allowed* NULL Label only. Mass value for stellar type.
Temperature INTEGER - allowed* NULL Label only. Temperature value for stellar type.
Radius Double - allowed* NULL Label only. Radius value for stellar type.
AgeRangeID INTEGER - allowed* NULL Label only. Age Range ID identifier or catalogue selection for stellar type.
Red INTEGER - allowed* NULL Label only. Red value for stellar type.
Green INTEGER - allowed* NULL Label only. Green value for stellar type.
Blue INTEGER - allowed* NULL Label only. Blue value for stellar type.
MaxChanceOld INTEGER - allowed* NULL Label only. Max Chance Old value for stellar type.
ExtraJP INTEGER - allowed* 0 Label only. Extra JP value for stellar type.

DIM_SystemAbundance

Section titled “DIM_SystemAbundance”

System mineral abundance categories and generation modifiers.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in star system and planetary generation.

Column SQL type Key NULL Default Meaning and relationships
AbundanceID INTEGER PK 1 allowed* none Label only. Abundance ID identifier or catalogue selection for system abundance.
Description TEXT - allowed* NULL Descriptive text for the row.
MaxChance INTEGER - allowed* NULL Selection threshold or limit. Its interpretation depends on this catalogue and is not a universal percentage.
Modifier INTEGER - allowed* NULL Label only. Modifier value for system abundance.

DIM_SystemAge

Section titled “DIM_SystemAge”

Stellar age and luminosity progression data.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in star system and planetary generation.

Column SQL type Key NULL Default Meaning and relationships
AgeID INTEGER PK 1 allowed* none Label only. Age ID identifier or catalogue selection for system age.
SpectralClass TEXT - allowed* NULL Label only. Spectral Class text for system age.
TotalLife Double - allowed* NULL Label only. Total Life value for system age.
Lum1 Double - allowed* NULL Label only. Lum1 value for system age.
Lum2 Double - allowed* NULL Label only. Lum2 value for system age.
Lum3 Double - allowed* NULL Label only. Lum3 value for system age.
Lum4 Double - allowed* NULL Label only. Lum4 value for system age.
Lum5 Double - allowed* NULL Label only. Lum5 value for system age.
Lum6 Double - allowed* NULL Label only. Lum6 value for system age.
Lum7 Double - allowed* NULL Label only. Lum7 value for system age.
Lum8 Double - allowed* NULL Label only. Lum8 value for system age.
Lum9 Double - allowed* NULL Label only. Lum9 value for system age.
Lum10 Double - allowed* NULL Label only. Lum10 value for system age.
Age1 Double - allowed* NULL Label only. Age1 value for system age.
Age2 Double - allowed* NULL Label only. Age2 value for system age.
Age3 Double - allowed* NULL Label only. Age3 value for system age.
Age4 Double - allowed* NULL Label only. Age4 value for system age.
Age5 Double - allowed* NULL Label only. Age5 value for system age.
Age6 Double - allowed* NULL Label only. Age6 value for system age.
Age7 Double - allowed* NULL Label only. Age7 value for system age.
Age8 Double - allowed* NULL Label only. Age8 value for system age.
Age9 Double - allowed* NULL Label only. Age9 value for system age.
Age10 Double - allowed* NULL Label only. Age10 value for system age.

FCT_Gates

Section titled “FCT_AetherGates”

FCT_Rift

Section titled “FCT_AetherRift”

FCT_

Section titled “FCT_AncientConstruct”

FCT_AtmosphericGas

Section titled “FCT_AtmosphericGas”

Atmospheric gas quantities and frozen-out state for a system body.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in terraforming mechanics.

Column SQL type Key NULL Default Meaning and relationships
GameID INTEGER - allowed* NULL Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
SystemBodyID INTEGER - allowed* NULL System body identifier. Bodies include planets, moons, asteroids and comets. Related identity domain FCT_SystemBody.SystemBodyID.
AtmosGasID INTEGER - allowed* NULL Atmospheric gas identifier. Related identity domain DIM_Gases.GasID.
AtmosGasAmount Double - allowed* 0 Stored percentage of the atmosphere. It can lag behind pressure changes until an atmosphere display refresh.
GasAtm Double - allowed* 0 Atmospheric gas pressure in atmospheres.
FrozenOut Boolean - allowed* NULL Whether the gas is frozen out. This is a flag, not a gas quantity.

FCT_JumpPoint

Section titled “FCT_JumpPoint”

Jump point positions, linked endpoints and gate ownership or strength.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in jump point network and galaxy topology.

Column SQL type Key NULL Default Meaning and relationships
WarpPointID INTEGER PK 1 allowed* none Jump point identifier, using the database’s warp point spelling.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
SystemID INTEGER - allowed* 0 Star system identifier. Related identity domain FCT_System.SystemID.
Distance DOUBLE - allowed* 0 Label only. Distance value for jump point.
Bearing INTEGER - allowed* 0 Label only. Bearing value for jump point.
Xcor DOUBLE - allowed* NULL X coordinate. System-space and map-space coordinates must be interpreted in the context of this table.
Ycor DOUBLE - allowed* NULL Y coordinate. System-space and map-space coordinates must be interpreted in the context of this table.
JumpGateStrength INTEGER - allowed* 0 Label only. Jump Gate Strength value for jump point.
JumpGateRaceID INTEGER - allowed* 0 Label only. Jump Gate Race ID identifier or catalogue selection for jump point.

FCT_LagrangePoint

Section titled “FCT_LagrangePoint”

Lagrange point locations and their associated star and planet.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in jump point network and galaxy topology.

Column SQL type Key NULL Default Meaning and relationships
LagrangePointID INTEGER PK 1 allowed* none Label only. Lagrange Point ID identifier or catalogue selection for lagrange point.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
SystemID INTEGER - allowed* NULL Star system identifier. Related identity domain FCT_System.SystemID.
StarID INTEGER - allowed* NULL Individual star identifier. Related identity domain FCT_Star.StarID.
PlanetID INTEGER - allowed* NULL Label only. Planet ID identifier or catalogue selection for lagrange point.
Xcor DOUBLE - allowed* NULL X coordinate. System-space and map-space coordinates must be interpreted in the context of this table.
Ycor DOUBLE - allowed* NULL Y coordinate. System-space and map-space coordinates must be interpreted in the context of this table.
Distance DOUBLE - allowed* NULL Label only. Distance value for lagrange point.
Bearing DOUBLE - allowed* NULL Label only. Bearing value for lagrange point.

FCT_MineralDeposit

Section titled “FCT_MineralDeposit”

Mineral deposits on bodies, current amounts and accessibility.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in production mechanics.

Column SQL type Key NULL Default Meaning and relationships
GameID INTEGER - allowed* NULL Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
MaterialID INTEGER - allowed* NULL Mineral type identifier.
SystemID INTEGER - allowed* NULL Star system identifier. Related identity domain FCT_System.SystemID.
SystemBodyID INTEGER - allowed* NULL System body identifier. Bodies include planets, moons, asteroids and comets. Related identity domain FCT_SystemBody.SystemBodyID.
Amount Double - allowed* NULL Current mineral amount remaining in the deposit, in tons.
Accessibility Double - allowed* NULL Current mineral deposit accessibility multiplier.
HalfOriginalAmount Double - allowed* NULL Half of the deposit’s original mineral quantity, retained for depletion calculations.
OriginalAcc Double - allowed* NULL Original mineral deposit accessibility.

FCT_MissileGeoSurvey

Section titled “FCT_MissileGeoSurvey”

Geological survey points delivered by missiles.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in exploration surveys and discovery.

Column SQL type Key NULL Default Meaning and relationships
SystemBodyID INTEGER PK 1 allowed* NULL System body identifier. Bodies include planets, moons, asteroids and comets. Related identity domain FCT_SystemBody.SystemBodyID.
RaceID INTEGER PK 2 allowed* NULL Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
SurveyPoints Double - allowed* NULL Accumulated survey progress.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.

Indexes. sqlite_autoindex_FCT_MissileGeoSurvey_1 (unique, SystemBodyID, RaceID).

FCT_TombGroup

Section titled “FCT_PrecursorTombGroup”

FCT_RuinRace

Section titled “FCT_RuinRace”

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in salvage and archaeology.

Column SQL type Key NULL Default Meaning and relationships
RuinRaceID INTEGER PK 1 allowed* none
GameID INTEGER - allowed* NULL Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
Title TEXT - allowed* NULL Label only. Title text for ruin race.
Name TEXT - allowed* NULL Name stored for the row. Name text is distinct from numeric identity.
RacePic TEXT - allowed* NULL Label only. Race Pic text for ruin race.
FlagPic TEXT - allowed* NULL Label only. Flag Pic text for ruin race.
Level INTEGER - allowed* NULL Label only. Level value for ruin race.

FCT_Star

Section titled “FCT_Star”

Individual stars, stellar types, orbital state and disaster state.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in star system and planetary generation.

Column SQL type Key NULL Default Meaning and relationships
StarID INTEGER PK 1 allowed* none Individual star identifier.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
SystemID INTEGER - allowed* 0 Star system identifier. Related identity domain FCT_System.SystemID.
StarTypeID INTEGER - allowed* NULL Label only. Star Type ID identifier or catalogue selection for star.
Name TEXT - allowed* NULL Name stored for the row. Name text is distinct from numeric identity.
Protostar INTEGER - allowed* 0 Label only. Protostar value for star.
Xcor Double - allowed* 0 X coordinate. System-space and map-space coordinates must be interpreted in the context of this table.
Ycor Double - allowed* 0 Y coordinate. System-space and map-space coordinates must be interpreted in the context of this table.
Component INTEGER - allowed* 1 Label only. Component value for star.
OrbitingComponent INTEGER - allowed* 0 Label only. Orbiting Component value for star.
Bearing Double - allowed* 0 Label only. Bearing value for star.
Luminosity Double - allowed* 0 Label only. Luminosity value for star.
OrbitalPeriod Double - allowed* 0 Label only. Orbital Period value for star.
OrbitalDistance Double - allowed* 0 Label only. Orbital Distance value for star.
DisasterStatus INTEGER - allowed* 0 Label only. Disaster Status value for star.
Eccentricity Double - allowed* 0 Label only. Eccentricity value for star.
EccentricityDirection Double - allowed* 0 Label only. Eccentricity Direction value for star.
MeanOrbitalSpeed Double - allowed* 0 Label only. Mean Orbital Speed value for star.
DistanceToOrbitCentre Double - allowed* 0 Label only. Distance To Orbit Centre value for star.
DistanceToParent Double - allowed* 0 Label only. Distance To Parent value for star.
CurrentOrbitalSpeed Double - allowed* 0 Label only. Current Orbital Speed value for star.

FCT_SurveyLocation

Section titled “FCT_SurveyLocation”

Gravitational survey location numbering and positions.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in exploration surveys and discovery.

Column SQL type Key NULL Default Meaning and relationships
SurveyLocationID INTEGER PK 1 allowed* none Label only. Survey Location ID identifier or catalogue selection for survey location.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
SystemID INTEGER - allowed* NULL Star system identifier. Related identity domain FCT_System.SystemID.
LocationNumber INTEGER - allowed* NULL Label only. Location Number value for survey location.
Xcor Double - allowed* 0 X coordinate. System-space and map-space coordinates must be interpreted in the context of this table.
Ycor Double - allowed* 0 Y coordinate. System-space and map-space coordinates must be interpreted in the context of this table.

FCT_System

Section titled “FCT_System”

Star system identity, generation properties, dust and supernova state.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in system lifecycle.

Column SQL type Key NULL Default Meaning and relationships
SystemID INTEGER PK 1 allowed* none Star system identifier.
SystemNumber INTEGER - NOT NULL 0 Label only. System Number value for system.
Age Double - allowed* NULL Label only. Age value for system.
AbundanceModifier INTEGER - allowed* NULL Label only. Abundance Modifier value for system.
Stars INTEGER - allowed* NULL Stored number of stellar components.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
JumpPointSurveyPoints INTEGER - allowed* 0 Gravitational survey points required in the system.
SystemTypeID INTEGER - allowed* 0 Label only. System Type ID identifier or catalogue selection for system.
DustDensity INTEGER - allowed* 0 System dust density used for sensor restrictions.
SolSystem Numeric - allowed* NULL Whether the system uses the Solar System starting configuration.
NoSensorChecks INTEGER - allowed* 0 Label only. No Sensor Checks value for system.
SupernovaForce Double - allowed* 0 Label only. Supernova Force value for system.
SupernovaElapsedTime Double - allowed* 0 Label only. Supernova Elapsed Time value for system.

FCT_SystemBody

Section titled “FCT_SystemBody”

Planets, moons, asteroids and comets with physical, orbital and environmental state.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in star system and planetary generation.

Column SQL type Key NULL Default Meaning and relationships
SystemBodyID INTEGER PK 1 allowed* none System body identifier. Bodies include planets, moons, asteroids and comets.
SystemID INTEGER - allowed* 0 Star system identifier. Related identity domain FCT_System.SystemID.
StarID INTEGER - allowed* 0 Individual star identifier. Related identity domain FCT_Star.StarID.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
Name TEXT - allowed* ' ' Name stored for the row. Name text is distinct from numeric identity.
PlanetNumber INTEGER - allowed* 0 Label only. Planet Number value for system body.
OrbitNumber INTEGER - allowed* 0 Label only. Orbit Number value for system body.
TrojanAsteroid Double - allowed* 0 Label only. Trojan Asteroid value for system body.
OrbitalDistance Double - allowed* 0 Label only. Orbital Distance value for system body.
Bearing Double - allowed* 0 Label only. Bearing value for system body.
BodyClass INTEGER - allowed* 0 Label only. Body Class value for system body.
Density Double - allowed* 0 Label only. Density value for system body.
Radius INTEGER - allowed* 0 Label only. Radius value for system body.
Gravity Double - allowed* 0 Label only. Gravity value for system body.
ParentBodyID INTEGER - allowed* 0 Label only. Parent Body ID identifier or catalogue selection for system body.
ParentBodyType INTEGER - allowed* 0 Label only. Parent Body Type value for system body.
BodyTypeID INTEGER - allowed* 0 Label only. Body Type ID identifier or catalogue selection for system body.
Mass Double - allowed* 0 Label only. Mass value for system body.
EscapeVelocity Double - allowed* 0 Label only. Escape Velocity value for system body.
Year Double - allowed* 0 Label only. Year value for system body.
TidalForce Double - allowed* 0 Label only. Tidal Force value for system body.
TidalLock Boolean - allowed* 0 Label only. Tidal Lock selection for system body.
Tilt INTEGER - allowed* 0 Label only. Tilt value for system body.
Eccentricity Double - allowed* 0 Label only. Eccentricity value for system body.
DayValue Double - allowed* 0 Label only. Day Value value for system body.
Roche Double - allowed* 0 Label only. Roche value for system body.
TectonicActivity INTEGER - allowed* 1 Label only. Tectonic Activity value for system body.
Ring Boolean - allowed* 0 Label only. Ring selection for system body.
MagneticField Double - allowed* 0 Label only. Magnetic Field value for system body.
BaseTemp Double - allowed* 0 Base equilibrium temperature in kelvin.
SurfaceTemp Double - allowed* 0 Surface temperature in kelvin.
HydroID INTEGER - allowed* 1 Label only. Hydro ID identifier or catalogue selection for system body.
HydroExt Double - allowed* 0 Label only. Hydro Ext value for system body.
AtmosPress Double - allowed* 0 Atmospheric pressure in atmospheres.
Albedo Double - allowed* 1 Label only. Albedo value for system body.
GHFactor Double - allowed* 1 Greenhouse factor.
RGE Boolean - allowed* 0 Label only. RGE selection for system body.
Xcor Double - allowed* 0 X coordinate. System-space and map-space coordinates must be interpreted in the context of this table.
Ycor Double - allowed* NULL Y coordinate. System-space and map-space coordinates must be interpreted in the context of this table.
PlanetIcon TEXT - allowed* NULL Label only. Planet Icon text for system body.
RuinID INTEGER - allowed* 0 Label only. Ruin ID identifier or catalogue selection for system body.
RuinRaceID INTEGER - allowed* 0
RadiationLevel Double - allowed* 0 Label only. Radiation Level value for system body.
DustLevel Double - allowed* 0 Label only. Dust Level value for system body.
AbandonedFactories INTEGER - allowed* 0 Label only. Abandoned Factories value for system body.
DominantTerrain INTEGER - allowed* 0 Label only. Dominant Terrain value for system body.
GroundMineralSurvey INTEGER - allowed* 0 Label only. Ground Mineral Survey value for system body.
AsteroidBeltID INTEGER - allowed* 0 Label only. Asteroid Belt ID identifier or catalogue selection for system body.
AGHFactor Double - allowed* 1 Anti-greenhouse factor.
EccentricityDirection Double - allowed* 0 Label only. Eccentricity Direction value for system body.
MeanOrbitalSpeed Double - allowed* 0 Label only. Mean Orbital Speed value for system body.
DistanceToOrbitCentre Double - allowed* 0 Label only. Distance To Orbit Centre value for system body.
DistanceToParent Double - allowed* 0 Label only. Distance To Parent value for system body.
CurrentOrbitalSpeed Double - allowed* 0 Label only. Current Orbital Speed value for system body.
FixedBody Boolean - allowed* FALSE Label only. Fixed Body selection for system body.
FixedBodyParentID INTEGER - allowed* 0 Label only. Fixed Body Parent ID identifier or catalogue selection for system body.

Wormholes

Section titled “Wormholes”

Wormhole identity and system coordinates.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in jump point network and galaxy topology.

Column SQL type Key NULL Default Meaning and relationships
WormholeID INTEGER PK 1 allowed* none Label only. Wormhole ID identifier or catalogue selection for wormholes.
GameID INTEGER - allowed* NULL Saved game identifier. Select the same game before combining game-specific rows.
SystemID INTEGER - allowed* NULL Star system identifier.
Xcor DOUBLE - allowed* NULL X coordinate. System-space and map-space coordinates must be interpreted in the context of this table.
Ycor DOUBLE - allowed* NULL Y coordinate. System-space and map-space coordinates must be interpreted in the context of this table.

Races, species and diplomacy

Section titled “Races, species and diplomacy”

FCT_Race / FCT_SectorCommand / FCT_Species / ForeignAid / GovType / RaceCompare

FCT_Race

Section titled “FCT_Race”

Empire identity, economic and technology-derived values, and race-specific display preferences.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in player race creation and starting configuration.

Column SQL type Key NULL Default Meaning and relationships
RaceID INTEGER PK 1 allowed* none Identifier of the race. Race-owned records use RaceID to identify their owner or observer.
GameID INTEGER - allowed* none GameID in FCT_Game to which this race belongs. Related identity domain FCT_Game.GameID.
NPR Numeric - allowed* none Non-player race flag. A non-zero value identifies a race controlled as an NPR. SpecialNPRID separately records its race type.
SpecialNPRID INTEGER - allowed* none Race type. Values are 0 Standard.
RaceGridSize INTEGER - allowed* none Label only. Race Grid Size value for race.
RaceName TEXT - allowed* none Name of the race shown in race selection and race information.
RaceTitle TEXT - allowed* none Title attached to the race’s name.
WealthPoints REAL - allowed* none Current race treasury in wealth points. Negative wealth reduces EconomicProdModifier according to the debt relative to AnnualWealth. See treasury and income.
PreviousWealth REAL - allowed* none Label only. Previously retained race treasury.
StartingWealth REAL - allowed* none Race’s starting wealth amount. It is saved separately from the current treasury in WealthPoints.
AnnualWealth INTEGER - allowed* none Calculated annual gross wealth production summed over the race’s populations. It is an annual production quantity, not the current treasury. It supplies the debt denominator for EconomicProdModifier.
GovTypeID INTEGER - allowed* none Label only. Gov Type ID identifier or catalogue selection for race.
UnreadMessages Numeric - allowed* none Label only. Unread Messages value for race.
FlagPic TEXT - allowed* none Image filename used for the race flag.
HullPic TEXT - allowed* none Image filename used for the race’s ship illustration.
Contacts INTEGER - allowed* none Label only. Contacts value for race.
Colour INTEGER - allowed* none Label only. Colour value for race.
Red INTEGER - allowed* none Label only. Red value for race.
Green INTEGER - allowed* none Label only. Green value for race.
Blue INTEGER - allowed* none Label only. Blue value for race.
Password TEXT - allowed* none Password associated with this race.
ThemeID INTEGER - allowed* none Saved general naming theme identifier. More specific class, missile, ground and system themes have separate columns.
ClassThemeID INTEGER - allowed* none Naming theme identifier for automatically named ship classes.
SystemThemeID INTEGER - allowed* none Naming theme identifier for automatically named systems. Known star naming also depends on FCT_Game.UseThemeInKnownStars.
NameThemeID INTEGER - allowed* none Label only. Naming theme selection. The table purpose determines which naming catalogue applies.
MinSystem INTEGER - allowed* none Label only. Min System value for race.
MaxSystem INTEGER - allowed* none Label only. Max System value for race.
MapSize INTEGER - allowed* none Label only. Map Size value for race.
DisplayGrade INTEGER - allowed* none Label only. Display Grade value for race.
ShowHighlight INTEGER - allowed* none Label only. Show Highlight value for race.
MapRed INTEGER - allowed* none Label only. Map Red value for race.
MapGreen INTEGER - allowed* none Label only. Map Green value for race.
MapBlue INTEGER - allowed* none Label only. Map Blue value for race.
FleetViewOption INTEGER - allowed* none Label only. Fleet View Option value for race.
SelectRace INTEGER - allowed* none Label only. Select Race value for race.
FleetsVisible Numeric - allowed* none Label only. Fleets Visible value for race.
LastMapSystemViewed INTEGER - allowed* none Saved identifier of the system last viewed by this race on the tactical map.
chkAllowAny INTEGER - allowed* none Label only. Allow Any display or option selection for this race or game.
chkAutoAssign INTEGER - allowed* none Label only. Auto Assign display or option selection for this race or game.
chkTons INTEGER - allowed* none Label only. Tons display or option selection for this race or game.
StandardTour INTEGER - allowed* none Label only. Standard Tour value for race.
LastAssignment REAL - allowed* none Label only. Last Assignment value for race.
CurrentXenophobia INTEGER - allowed* none Label only. Current Xenophobia value for race.
AcademyCrewmen Double - allowed* none Available academy-trained crewmen and junior officers. Crewing and replacement crew draw down this pool. The initial pool is 10000 people. A shortfall can reduce the crew grade provided to a ship.
MaintenanceCapacity INTEGER - allowed* none Technology-derived supported ship tonnage per maintenance facility. The initial value is 1000 tons per facility. This is a facility rating, not the race’s total supported tonnage.
OrdnanceCapacity REAL - allowed* none Label only. Ordnance Capacity value for race.
FighterCapacity REAL - allowed* none Label only. Fighter Capacity value for race.
ShipBuilding REAL - allowed* none Technology-derived shipbuilding rate. The initial rating is 400. Shipyard capacity and production modifiers determine the resulting output. See production.
FuelProduction REAL - allowed* none Technology-derived fuel production rating per refinery. The initial value is 40000. Refinery count and production modifiers determine colony fuel output.
ConstructionProduction REAL - allowed* none Technology-derived annual construction point rating per construction factory. The initial value is 10. It is a production rating rather than accumulated construction points.
OrdnanceProduction REAL - allowed* none Technology-derived annual ordnance production point rating per ordnance factory. The initial value is 10.
FighterProduction REAL - allowed* none Technology-derived annual fighter production point rating per fighter factory. The initial value is 10.
MineProduction REAL - allowed* none Technology-derived mining production rating per mine. The initial value is 10. Mineral accessibility and production modifiers affect actual extraction.
Research INTEGER - allowed* none Technology-derived annual research point rating per laboratory. The initial value is 200. Species, economic, colony and game research speed modifiers determine actual output.
PlanetarySensorStrength INTEGER - allowed* none Technology-derived planetary sensor strength rating. The initial value is 250. It is a sensor capability rating rather than a current contact count.
TrainingLevel INTEGER - allowed* none Racial crew training multiplier used when academy crew provide grade points. The initial value is 1.
GUStrength INTEGER - allowed* none Technology-derived ground unit strength rating. The initial value is 10. It is separate from the race’s number of units or the current strength of any formation.
GUTrained INTEGER - allowed* none Label only. GU Trained value for race.
TerraformingRate REAL - allowed* none Technology-derived annual terraforming rate per installation. The initial value is 0.00025. Colony and global terraforming modifiers determine the resulting Earth-equivalent capacity.
ColonizationSkill REAL - allowed* none Technology-derived colonisation cost multiplier. The initial value is 1. Colony cost reduction research changes this rating.
StartTechPoints INTEGER - allowed* none Starting research point budget entered during race creation. Player starting budgets also contribute to the research floor used when scaling later generated races.
StartBuildPoints INTEGER - allowed* none Starting ship build point budget entered during race creation. The initial ground forces build point budget is set to half this amount.
WealthCreationRate REAL - allowed* none Technology-derived racial wealth creation rating. The initial value is 100. It contributes to colony income rather than directly recording treasury growth.
EconomicProdModifier REAL - allowed* none Economic production multiplier. It is 1 with a non-negative treasury. With debt it is 1 minus absolute WealthPoints divided by AnnualWealth, with a floor of 0.01. Debt with no annual wealth also gives 0.01.
ShipyardOperations REAL - allowed* none Technology-derived shipyard operations multiplier. The initial value is 1.
MSPProduction INTEGER - allowed* none Technology-derived maintenance supply production rating. The initial value is 20. It is a production capability and not a stock of maintenance supplies.
MaxRefuellingRate INTEGER - allowed* none Maximum refuelling system rate unlocked by the race’s technology. Individual ship systems and transfer conditions determine actual transfer.
UnderwayReplenishmentRate Double - allowed* 0 Technology-derived underway replenishment rate rating. It controls replenishment capability rather than the amount of supplies carried.
Hostile INTEGER - allowed* none Label only. Hostile value for race.
Neutral INTEGER - allowed* none Label only. Neutral value for race.
Friendly INTEGER - allowed* none Label only. Friendly value for race.
Allied INTEGER - allowed* none Label only. Allied value for race.
Civilian INTEGER - allowed* none Label only. Civilian value for race.
DisplayFunction INTEGER - allowed* none Label only. Display Function value for race.
chkPlanets INTEGER - allowed* none Saved tactical map display preference for planets.
chkDwarf INTEGER - allowed* none Saved tactical map display preference for dwarf planets.
chkMoons INTEGER - allowed* none Saved tactical map display preference for moons.
chkAst INTEGER - allowed* none Saved tactical map display preference for asteroids.
chkWP INTEGER - allowed* none Saved tactical map display preference for jump points. Waypoints use chkWaypoint.
chkStarOrbits INTEGER - allowed* none Saved display preference for star orbits.
chkPlanetOrbits INTEGER - allowed* none Saved display preference for planet orbits.
chkDwarfOrbits INTEGER - allowed* none Saved display preference for dwarf planet orbits.
chkMoonOrbits INTEGER - allowed* none Saved display preference for moon orbits.
chkAsteroidOrbits INTEGER - allowed* none Saved display preference for asteroid orbits.
chkStarNames INTEGER - allowed* none Saved display preference for star names.
chkPlanetNames INTEGER - allowed* none Saved display preference for planet names.
chkDwarfNames INTEGER - allowed* none Saved display preference for dwarf planet names.
chkMoonNames INTEGER - allowed* none Saved display preference for moon names.
chkAstNames INTEGER - allowed* none Saved display preference for asteroid names.
chkFleets INTEGER - allowed* none Saved tactical map display preference for fleets.
chkMoveTail INTEGER - allowed* none Saved display preference for fleet movement tails.
chkColonies INTEGER - allowed* none Saved tactical map display preference for colonies.
chkCentre INTEGER - allowed* none Saved preference for centring the tactical map on the selected object.
chkSL INTEGER - allowed* none Saved display preference for gravitational survey locations. chkHideSL separately hides surveyed locations.
chkWaypoint INTEGER - allowed* none Saved display preference for waypoints. Jump points use chkWP.
chkOrder INTEGER - allowed* none Saved display preference for the next fleet order.
chkNoOverlap INTEGER - allowed* none Saved preference to prevent overlap between child and parent body labels.
chkActiveSensors INTEGER - allowed* none Saved display preference for active sensors.
chkTracking INTEGER - allowed* none Saved display preference for the tracking bonus.
chkActiveOnly INTEGER - allowed* none Saved contact display filter for active contacts only.
chkShowDist INTEGER - allowed* none Saved display preference for contact distances.
chkSBSurvey INTEGER - allowed* none Saved tactical display preference for surveyed bodies.
chkMinerals INTEGER - allowed* none Saved display preference for mineral concentrations.
chkCometPath INTEGER - allowed* none Saved display preference for comet orbits.
chkAstColOnly INTEGER - allowed* none Saved display filter restricting asteroids to those with colonies.
chkAstMinOnly INTEGER - allowed* none Saved display filter restricting asteroids to those with minerals.
chkTAD INTEGER - allowed* none Saved display preference for order time and distance.
chkFiringRanges INTEGER - allowed* none Saved display preference for weapon ranges.
chkSalvoOrigin INTEGER - allowed* none Saved display preference for a missile salvo’s launch platform.
chkSalvoTarget INTEGER - allowed* none Saved display preference for a missile salvo’s target.
chkEscorts INTEGER - allowed* none Saved preference to hide escorts. A checked value hides them rather than showing them.
chkFireControlRange INTEGER - allowed* none Saved display preference for fire control range.
PassiveSensor INTEGER - allowed* none Label only. Passive Sensor value for race.
ActiveSensor INTEGER - allowed* none Label only. Active Sensor value for race.
DetRange INTEGER - allowed* none Label only. Det Range value for race.
chkHideIDs INTEGER - allowed* none Saved preference to group contacts. This affects presentation rather than deleting contact records.
chkHideSL INTEGER - allowed* none Saved preference to hide already surveyed gravitational survey locations.
chkEvents INTEGER - allowed* none Saved display preference for events.
chkPackets INTEGER - allowed* none Saved display preference for mass driver mineral packets.
chkMPC INTEGER - allowed* none Saved display preference for mineral packet contents.
chkLifepods INTEGER - allowed* none Saved display preference for lifepods.
chkWrecks INTEGER - allowed* none Saved display preference for wrecks.
chkHostileSensors INTEGER - allowed* none Saved sensor range display preference. It changes the map presentation rather than the sensor capability of a ship.
chkGeoPoints INTEGER - allowed* none Saved display preference for geological survey points.
chkBearing INTEGER - allowed* none Saved display preference for fleet headings.
chkCoordinates INTEGER - allowed* none Saved display preference for body and fleet coordinates.
chkLostContacts INTEGER - allowed* none Saved Lost Contacts 1 Month filter. It permits contacts last updated within 2592000 seconds. The one-year filter takes precedence when also enabled.
chkHideCivNames INTEGER - allowed* none Label only. Hide Civ Names display or option selection for this race or game.
chkSystemOnly INTEGER - allowed* none Saved military fleet tree filter for fleets in the current system only.
chkShowCivilianOOB INTEGER - allowed* none Saved military fleet tree preference to include civilian fleets.
chkHostile INTEGER - allowed* none Saved contact display filter for hostile contacts.
chkFriendly INTEGER - allowed* none Saved contact display filter for friendly contacts.
chkAllied INTEGER - allowed* none Saved contact display filter for allied contacts.
chkNeutral INTEGER - allowed* none Saved contact display filter for neutral contacts.
chkCivilian INTEGER - allowed* none Saved contact display filter for civilian contacts.
chkContactsCurrentSystem INTEGER - allowed* none Saved contact display filter restricting contacts to the current system.
chkTranspondersOn INTEGER - allowed* none Label only. Transponders On display or option selection for this race or game.
RankScientist TEXT - allowed* none Race-specific title used for scientist commanders.
RankAdministrator TEXT - allowed* none Race-specific title used for administrator commanders.
chkUnexJP INTEGER - allowed* 1 Saved display preference for unexplored jump points.
chkJPSurveyStatus INTEGER - allowed* 0 Saved display preference for jump point survey status.
chkSurveyLocationPoints INTEGER - allowed* 0 Saved display preference for survey location points.
chkSurveyedSystemBodies INTEGER - allowed* 0 Saved display preference for surveyed system bodies.
chkDistanceFromSelected INTEGER - allowed* 0 Saved display preference for distance from the selected system.
chkWarshipLocation INTEGER - allowed* 1 Saved galactic map display preference for warship locations.
chkAllFleetLocations INTEGER - allowed* 0 Saved galactic map display preference for non-civilian fleet locations.
chkKnownAlienForces INTEGER - allowed* 1 Saved galactic map preference to highlight systems containing contacts.
chkAlienControlledSystems INTEGER - allowed* 1 Saved galactic map display preference for alien-controlled systems.
chkPopulatedSystem INTEGER - allowed* 1 Saved galactic map display preference for populated systems.
chkShipyardComplexes INTEGER - allowed* 1 Saved galactic map display preference for shipyard complexes.
chkNavalHeadquarters INTEGER - allowed* 1 Saved galactic map display preference for naval headquarters.
chkSectors INTEGER - allowed* 0 Saved galactic map display preference for sectors.
chkPossibleDormantJP INTEGER - allowed* 1 Saved galactic map display preference for possible dormant jump points.
chkSecurityStatus INTEGER - allowed* 0 Saved galactic map display preference for security status.
chkDiscoveryDate INTEGER - allowed* 0 Saved galactic map display preference for discovery dates.
chkHabRangeWorlds INTEGER - allowed* 1 Saved habitable-world display filter for worlds within the normal gravity range.
chkLowCCNormalG INTEGER - allowed* 1 Saved display filter for low colony cost worlds within the normal gravity range.
chkMediumCCNormalG INTEGER - allowed* 1 Saved display filter for medium colony cost worlds within the normal gravity range.
chkLowCCLowG INTEGER - allowed* 0 Saved display filter for low colony cost worlds including low gravity worlds.
chkMediumCCLowG INTEGER - allowed* 0 Saved display filter for medium colony cost worlds including low gravity worlds.
SpaceStationPic TEXT - allowed* none Image filename used for the race’s station illustration.
MaxOrdnanceTransferRate INTEGER - allowed* 40 Maximum ordnance transfer system rate unlocked by the race’s technology. It is separate from carried ordnance and the number of transfer systems.
CargoShuttleLoadModifier INTEGER - allowed* 1 Technology-derived cargo shuttle loading modifier. The initial value is 1. It affects loading capability rather than cargo hold size.
GroundFormationConstructionRate INTEGER - allowed* 100 Technology-derived ground formation construction rate rating. The initial value is 250.
DesignThemeID INTEGER - allowed* 1 Label only. Design Theme ID identifier or catalogue selection for race.
ResearchTargetCost INTEGER - allowed* 0 Research point cost of the next NPR design philosophy progression. A completed progression subtracts this cost from CurrentResearchTotal and sets the next target.
CurrentResearchTotal INTEGER - allowed* 0 Accumulated NPR research points toward ResearchTargetCost. Completing a progression subtracts the target cost, so remaining points carry forward.
chkPassive10 INTEGER - allowed* none Saved passive sensor range display preference against a signature of 10.
chkPassive100 INTEGER - allowed* 0 Saved passive sensor range display preference against a signature of 100.
chkPassive1000 INTEGER - allowed* 0 Saved passive sensor range display preference against a signature of 1000.
GroundThemeID INTEGER - allowed* 0 Naming theme identifier for automatically named ground formations and designs.
MaximumOrbitalMiningDiameter INTEGER - allowed* 100 Maximum body diameter allowed by the race’s orbital mining technology, in kilometres. The initial value is 100 km.
ColonyDensity INTEGER - allowed* 5 Label only. Colony Density value for race.
MissileThemeID INTEGER - allowed* 0 Naming theme identifier for automatically named missile designs.
NeutralRace Boolean - allowed* 0 Saved Neutral Race selection from race creation. It is separate from the diplomatic contact status of each foreign race.
chkNumCometsPlanetlessSystem INTEGER - allowed* 0 Saved display preference for comet counts in systems with no planets.
chkPassive10000 INTEGER - allowed* 0 Saved passive sensor range display preference against a signature of 10000.
chkGroundSurveyLocations INTEGER - allowed* 0 Saved galactic map display preference for ground survey locations.
chkML INTEGER - allowed* 0 Saved display preference for maintenance locations.
chkBlocked INTEGER - allowed* 0 Saved galactic map display preference for systems blocked from automatic routing.
chkMilitaryRestricted INTEGER - allowed* 0 Saved galactic map display filter for military restricted systems. It is separate from the restriction on any individual system.
HideCMCPop Boolean - allowed* FALSE Saved Economics window preference to hide civilian mining colonies in the population tree.
ShowPopStar Boolean - allowed* FALSE Saved Economics window preference to group the population tree by star.
ShowPopSystemBody Boolean - allowed* FALSE Saved Economics window preference to show the system body in the population tree.
PopByFunction Boolean - allowed* FALSE Saved Economics window preference to group the population tree by function.
chkLostContactsOneYear INTEGER - allowed* 0 Saved Lost Contacts 1 Year filter. It permits contacts last updated within 31536000 seconds and takes precedence over the month and day filters.
chkDisplayMineralSearch INTEGER - allowed* 0 Saved galactic map display filter for systems marked with the mineral search flag.
chkLostContactsOneDay INTEGER - allowed* 0 Saved Lost Contacts 1 Day filter. It permits contacts last updated within 86400 seconds when neither the year nor month filter is enabled. With no age filter, only contacts updated at the current time are listed.
chkHabRangeWorldsLowG INTEGER - allowed* 0 Saved habitable-world display filter that includes low gravity worlds.
chkAllRace INTEGER - allowed* 0 Saved preference to link all open windows to the selected race.
chkDisplayAllForms INTEGER - allowed* 0 Saved preference to keep the tactical map in the background.
TonnageSent Double - allowed* 0 New deployments add their group tonnage and reduce the remaining available invasion budget.
LastProgressionOrder INTEGER - allowed* 0 Eligible later groups have a higher progression order. The position can reset to 0 when the progression restarts.
chkHideOrbitFleets INTEGER - allowed* 0 Saved preference to hide fleets in orbit.
chkEventsAllRaces INTEGER - allowed* 0 Saved display preference for events from all races.
chkUseMaxCCDisplay INTEGER - allowed* 0 Saved preference to use maximum colony cost for the habitable-world display.
chkSelectedOrbit INTEGER - allowed* 0 Saved display preference for the selected body’s orbit.
chkMilitaryRestrictedJP INTEGER - allowed* 0 Saved galactic map display filter for military restricted jump points. It is separate from the restriction on any individual jump point.
chkDistanceFromSelectedMR INTEGER - allowed* 0 Saved display preference for distance from the selected system excluding military restricted jump points.
chkUseHullNumbers INTEGER - allowed* 1 Saved preference to use hull numbers in ship presentation.
chkDistanceRealSpace INTEGER - allowed* 0 Saved display preference for real-space distance from the selected system.
chkSupernovaImpactTime INTEGER - allowed* 0 Saved galactic map display preference for the time until supernova impact.
UseRoman INTEGER - allowed* 0 Saved ground unit training naming preference. Enabled names append a Roman numeral after the formation template name. Disabled names put an ordinal number before the template name.
INTEGER - allowed* 0
chkNumWrecks INTEGER - allowed* 0 Saved galactic map display preference for wreck counts.
GeneticConversionRate Double - allowed* 0.5 Technology-derived genetic conversion rate rating. The initial value is 0.5. See species engineering.
chkHideWreckIDs INTEGER - allowed* 0 Saved preference to group wrecks by ship class.
MaxOrganizationLinkID INTEGER - allowed* 0 Label only. Highest organisation link number retained for the race.
ShippingLineTax Double - allowed* 0 Civilian shipping tax rate stored as a fraction. A value of 0.5 is displayed as 50 percent. It is separate from the wealth balance of a shipping line.
SelectedAdminIcon INTEGER - allowed* 0 Naval administrative command identifier selected for the saved map icon display. A value of 0 records no selected command.
SelectedClassIcon INTEGER - allowed* 0 Ship class identifier selected for the saved map icon display. A value of 0 records no selected class.
chkClassIcon INTEGER - allowed* 0 Saved galactic map preference to display the selected ship class icon. SelectedClassIcon identifies the class.
chkAdminIcon TEXT - allowed* 0 Saved galactic map preference to display the selected naval administrative command icon. SelectedAdminIcon identifies the command.
ZoomSetting Double - allowed* 1 Saved galactic map zoom setting for this race.
MinMapFontSize Double - allowed* 6 Saved minimum map font size for this race.
chkSystemIconOnly INTEGER - allowed* 0 Saved galactic map preference to show only the system icon.
CrewDesignEfficiency Double - allowed* 1 Technology-derived crew quarter design efficiency. The initial value is 1. It affects crew quarter design rather than the current number of crew aboard a ship.
chkHullCategory INTEGER - allowed* 1 Label only. Hull Category display or option selection for this race or game.
RaceStartingLevel INTEGER - allowed* 0 Starting development level. Values are 0 Standard, 1 Conventional Player, 2 Conventional NPR, 3 Pre-Industrial and 4 Minor.
BioShips Boolean - allowed* FALSE Biological ship flag. Among its display effects, active sensor contact labels for this race’s ships use BIO alongside their detected tonnage.
chkComets INTEGER - allowed* 1 Saved tactical map display preference for comets.
chkCometNames INTEGER - allowed* 1 Saved display preference for comet names.
RandomClassName INTEGER - allowed* 1 Saved option for choosing random ship class names. The initial value is 1. ClassThemeID supplies the class naming theme.

FCT_SectorCommand

Section titled “FCT_SectorCommand”

Civilian sector commands, their headquarters and presentation.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in civilian governance and sectors.

Column SQL type Key NULL Default Meaning and relationships
SectorCommandID INTEGER PK 1 allowed* none Label only. Sector Command ID identifier or catalogue selection for sector command.
RaceID INTEGER - allowed* 0 Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
PopulationID INTEGER - allowed* 0 Colony identifier. A population is a race-and-species colony on a system body. Related identity domain FCT_Population.PopulationID.
SectorName VARCHAR(100) - allowed* NULL Label only. Sector Name text for sector command.
Colour INTEGER - allowed* NULL Label only. Colour value for sector command.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.

FCT_Species

Section titled “FCT_Species”

Species biology, environmental tolerances, social traits and inherited modifiers.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in species engineering.

Column SQL type Key NULL Default Meaning and relationships
SpeciesID INTEGER PK 1 allowed* none Species identifier.
GameID INTEGER - allowed* NULL Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
TechSystemID INTEGER - allowed* 0 Technology identifier. Related identity domain FCT_TechSystem.TechSystemID.
HomeworldID INTEGER - allowed* NULL Homeworld system body identifier.
DerivedSpeciesID INTEGER - allowed* 0 Species from which this species was derived.
SpeciesName TEXT - allowed* NULL Species name.
RacePic TEXT - allowed* NULL Label only. Race Pic text for species.
BreatheID INTEGER - allowed* 10 Breathing gas identifier.
Oxygen Double - allowed* 0.2 Central preferred breathing-gas pressure in atmospheres. This column also applies when BreatheID selects a gas other than oxygen.
OxyDev Double - allowed* 0.5 Allowed deviation from the preferred breathing-gas pressure.
PressMax Double - allowed* NULL Maximum atmospheric pressure tolerated by the species.
Temperature Double - allowed* 15 Central preferred temperature.
TempDev Double - allowed* 20 Allowed temperature deviation.
Gravity Double - allowed* 1 Central preferred gravity.
GravDev Double - allowed* 0.5 Allowed gravity deviation.
Xenophobia INTEGER - allowed* NULL Label only. Xenophobia value for species.
Diplomacy INTEGER - allowed* NULL Label only. Diplomacy value for species.
Translation INTEGER - allowed* NULL Label only. Translation value for species.
Militancy INTEGER - allowed* NULL Label only. Militancy value for species.
Expansionism INTEGER - allowed* NULL Label only. Expansionism value for species.
Determination INTEGER - allowed* NULL Label only. Determination value for species.
Trade INTEGER - allowed* NULL Label only. Trade value for species.
SpecialNPRID INTEGER - allowed* 0 Label only. Special NPRID identifier or catalogue selection for species.
ProductionRateModifier Double - allowed* 1 Label only. Production Rate Modifier value for species.
ResearchRateModifier Double - allowed* 1 Label only. Research Rate Modifier value for species.
PopulationGrowthModifier Double - allowed* 1 Label only. Population Growth Modifier value for species.
PopulationDensityModifier Double - allowed* 1 Label only. Population Density Modifier value for species.
GraduationAge INTEGER - allowed* 21 Species graduation age, in years. Commander ages use it with career start.

ForeignAid

Section titled “ForeignAid”

Foreign aid amounts associated with races and games.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in intelligence mechanics.

Column SQL type Key NULL Default Meaning and relationships
RaceID INTEGER PK 1 allowed* NULL Race identifier. The table purpose determines whether this is an owner, subject or observer.
AlienID INTEGER PK 2 allowed* NULL Label only. Alien ID identifier or catalogue selection for foreign aid.
GameID INTEGER - allowed* NULL Saved game identifier. Select the same game before combining game-specific rows.
Amount INTEGER - allowed* NULL Quantity or measured value. The table purpose and any type selector determine what is counted.

Indexes. sqlite_autoindex_ForeignAid_1 (unique, RaceID, AlienID).

GovType

Section titled “GovType”

Government type definitions, starting economic selections and social modifiers.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in player race creation and starting configuration.

Column SQL type Key NULL Default Meaning and relationships
GovTypeID INTEGER PK 1 allowed* none Label only. Gov Type ID identifier or catalogue selection for gov type.
GovName VARCHAR(30) - allowed* NULL Label only. Gov Name text for gov type.
MissileBases DOUBLE - allowed* NULL Label only. Missile Bases value for gov type.
TotalIndustrial INTEGER - allowed* NULL Label only. Total Industrial value for gov type.
ResearchRate DOUBLE - allowed* 1 Label only. Research Rate value for gov type.
TrainingLevel INTEGER - allowed* 1 Label only. Training Level value for gov type.
SYPerAcademy INTEGER - allowed* 1 Label only. SY Per Academy value for gov type.
MaxChance SMALLINT - allowed* NULL Selection threshold or limit. Its interpretation depends on this catalogue and is not a universal percentage.
GrowthMod DOUBLE - allowed* 1 Label only. Growth Mod value for gov type.
ConstMod DOUBLE - allowed* 1 Label only. Const Mod value for gov type.
Shipyards INTEGER - allowed* 0 Label only. Shipyards value for gov type.
Labs INTEGER - allowed* 0 Label only. Labs value for gov type.
Construction INTEGER - allowed* 0 Label only. Construction value for gov type.
Refineries DOUBLE - allowed* 0 Label only. Refineries value for gov type.
Mines INTEGER - allowed* NULL Label only. Mines value for gov type.
Sensors INTEGER - allowed* NULL Label only. Sensors value for gov type.
XenophobiaMod INTEGER - allowed* 0 Label only. Xenophobia Mod value for gov type.
DiplomacyMod INTEGER - allowed* 0 Label only. Diplomacy Mod value for gov type.
MilitancyMod INTEGER - allowed* 0 Label only. Militancy Mod value for gov type.
ExpansionismMod INTEGER - allowed* 0 Label only. Expansionism Mod value for gov type.
DeterminationMod INTEGER - allowed* NULL Label only. Determination Mod value for gov type.
TradeMod INTEGER - allowed* 0 Label only. Trade Mod value for gov type.
UserDefined BOOLEAN - allowed* NULL Label only. User Defined selection for gov type.
HA INTEGER - allowed* 0 Label only. HA value for gov type.
MI INTEGER - allowed* 0 Label only. MI value for gov type.
AI INTEGER - allowed* 0 Label only. AI value for gov type.
GAR INTEGER - allowed* 0 Label only. GAR value for gov type.

RaceCompare

Section titled “RaceCompare”

Race comparison figures retained in the database.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in player race creation and starting configuration.

Column SQL type Key NULL Default Meaning and relationships
RaceID INTEGER PK 1 allowed* NULL Race identifier. The table purpose determines whether this is an owner, subject or observer.
RaceName VARCHAR(255) - allowed* NULL Race name.
Pop DOUBLE - allowed* NULL Label only. Pop value for race compare.
NavalSY INTEGER - allowed* NULL Label only. Naval SY value for race compare.
CommercialSY INTEGER - allowed* NULL Label only. Commercial SY value for race compare.
Research INTEGER - allowed* NULL Label only. Research value for race compare.
Factories INTEGER - allowed* NULL Label only. Factories value for race compare.
Mines INTEGER - allowed* NULL Label only. Mines value for race compare.
AM INTEGER - allowed* NULL Label only. AM value for race compare.
Refineries INTEGER - allowed* NULL Label only. Refineries value for race compare.
Naval INTEGER - allowed* NULL Label only. Naval value for race compare.
Commercial INTEGER - allowed* NULL Commercial classification selection.
Civilian INTEGER - allowed* NULL Label only. Civilian value for race compare.
DSTS INTEGER - allowed* NULL Label only. DSTS value for race compare.
Academies INTEGER - allowed* NULL Label only. Academies value for race compare.
Fuel INTEGER - allowed* NULL Fuel quantity.

Colonies, industry and trade

Section titled “Colonies, industry and trade”

DIM_MineralDataType / DIM_PlanetaryInstallation / DIM_PopPoliticalStatus / DIM_TradeGoods / DIM_WealthUse / FCT_IndustrialProjects / FCT_MassDriverPackets / FCT_PopComponent / FCT_PopInstallationDemand / FCT_PopMDChanges / FCT_PopTradeBalance / FCT_Population / FCT_PopulationInstallations / FCT_PopulationWeapon / FCT_Prisoners / FCT_RaceMineralData / FCT_ShippingLines / FCT_ShippingWealthData / FCT_Shipyard / FCT_ShipyardTask / FCT_WealthData / FCT_WealthHistory

DIM_MineralDataType

Section titled “DIM_MineralDataType”

Categories used for mineral accounting records.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in production mechanics.

Column SQL type Key NULL Default Meaning and relationships
MineralDataType INTEGER - allowed* 0 Label only. Mineral Data Type value for mineral data type.
Income Boolean - allowed* FALSE Label only. Income selection for mineral data type.
DisplayOrder INTEGER - allowed* 0 Ordering value for the related game display.
Description TEXT - allowed* none Descriptive text for the row.

DIM_PlanetaryInstallation

Section titled “DIM_PlanetaryInstallation”

Installation definitions, production values, labour requirements and mineral costs.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in planetary installation catalogue.

Column SQL type Key NULL Default Meaning and relationships
PlanetaryInstallationID INTEGER PK 1 allowed* none Planetary installation type identifier.
Name TEXT - allowed* NULL Name stored for the row. Name text is distinct from numeric identity.
Cost Double - allowed* NULL Build or development cost for the design or definition.
ConversionFrom INTEGER - allowed* 0 Label only. Conversion From value for planetary installation.
ConversionTo INTEGER - allowed* 0 Label only. Conversion To value for planetary installation.
CargoPoints INTEGER - allowed* 0 Label only. Cargo Points value for planetary installation.
ConstructionValue Double - allowed* 0 Label only. Construction Value value for planetary installation.
OrdnanceProductionValue Double - allowed* 0 Label only. Ordnance Production Value value for planetary installation.
FighterProductionValue Double - allowed* 0 Label only. Fighter Production Value value for planetary installation.
RefineryProductionValue Double - allowed* 0 Label only. Refinery Production Value value for planetary installation.
ResearchValue Double - allowed* 0 Label only. Research Value value for planetary installation.
TerraformValue Double - allowed* 0 Label only. Terraform Value value for planetary installation.
MaintenanceValue Double - allowed* 0 Label only. Maintenance Value value for planetary installation.
MiningProductionValue Double - allowed* 0 Label only. Mining Production Value value for planetary installation.
InfrastructureValue Double - allowed* 0 Label only. Infrastructure Value value for planetary installation.
LGInfrastructureValue Double - allowed* 0 Label only. LG Infrastructure Value value for planetary installation.
SensorValue Double - allowed* 0 Label only. Sensor Value value for planetary installation.
GroundTrainingValue Double - allowed* 0 Label only. Ground Training Value value for planetary installation.
AcademyValue Double - allowed* 0 Label only. Academy Value value for planetary installation.
SectorCommandValue Double - allowed* 0 Label only. Sector Command Value value for planetary installation.
MassDriverValue Double - allowed* 0 Label only. Mass Driver Value value for planetary installation.
FinancialProductionValue Double - allowed* 0 Label only. Financial Production Value value for planetary installation.
CargoShuttleValue Double - allowed* 0 Label only. Cargo Shuttle Value value for planetary installation.
GeneticModificationValue Double - allowed* 0 Label only. Genetic Modification Value value for planetary installation.
MassRefuelling INTEGER - allowed* 0 Label only. Mass Refuelling value for planetary installation.
Workers Double - allowed* 0 Label only. Workers value for planetary installation.
WorkerDesciption TEXT - allowed* NULL Label only. Worker Desciption text for planetary installation.
ThermalSignature Double - allowed* 0 Label only. Thermal Signature value for planetary installation.
EMsignature Double - allowed* 0 Label only. E Msignature value for planetary installation.
TargetSize INTEGER - allowed* NULL Label only. Target Size value for planetary installation.
CivilianInstallation Numeric - allowed* 0 Label only. Civilian Installation value for planetary installation.
Numeric - allowed* NULL Label only.
NoBuild Numeric - allowed* NULL Label only. No Build value for planetary installation.
CivMove Numeric - allowed* NULL Label only. Civ Move value for planetary installation.
DisplayOrder Double - allowed* NULL Ordering value for the related game display.
RequiredTechID INTEGER - allowed* 0 Label only. Required Tech ID identifier or catalogue selection for planetary installation.
Duranium Double - allowed* 0 Duranium mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Neutronium Double - allowed* 0 Neutronium mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Corbomite Double - allowed* 0 Corbomite mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Tritanium Double - allowed* 0 Tritanium mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Boronide Double - allowed* 0 Boronide mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Mercassium Double - allowed* 0 Mercassium mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Vendarite Double - allowed* 0 Vendarite mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Sorium Double - allowed* 0 Sorium mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Uridium Double - allowed* 0 Uridium mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Corundium Double - allowed* 0 Corundium mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Gallicite Double - allowed* 0 Gallicite mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
NavalHeadquartersValue INTEGER - allowed* 0 Label only. Naval Headquarters Value value for planetary installation.
MassOrdnanceTransfer INTEGER - allowed* 0 Label only. Mass Ordnance Transfer value for planetary installation.
Abbreviation TEXT - allowed* none Short display name or abbreviation.
TaxableWorkers Boolean - allowed* 0 Label only. Taxable Workers selection for planetary installation.

DIM_PopPoliticalStatus

Section titled “DIM_PopPoliticalStatus”

Political status definitions, production and wealth modifiers and transition requirements.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in political status catalogue.

Column SQL type Key NULL Default Meaning and relationships
StatusID INTEGER PK 1 allowed* NULL Label only. Status ID identifier or catalogue selection for pop political status.
StatusName VARCHAR(50) - allowed* NULL Label only. Status Name text for pop political status.
ProductionMod DOUBLE - allowed* NULL Industrial production multiplier.
WealthMod DOUBLE - allowed* NULL Wealth production multiplier.
SPRequired INTEGER - allowed* NULL Status points required for advancement.
NextStatusID INTEGER - allowed* NULL Next political status identifier. A value of 0 gives no ordinary next-status row.
OccupationForceMod DOUBLE - allowed* NULL Occupation force requirement multiplier.
ProtectionRequired DOUBLE - allowed* NULL Protection requirement multiplier.
ServiceSector DOUBLE - allowed* NULL Service sector modifier.

DIM_TradeGoods

Section titled “DIM_TradeGoods”

Civilian trade-good categories and population requirements.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in civilian economy and autonomous logistics.

Column SQL type Key NULL Default Meaning and relationships
TradeGoodID INTEGER PK 1 allowed* NULL Trade good type identifier.
Description TEXT - allowed* NULL Descriptive text for the row.
PopRequired Double - allowed* 0 Label only. Pop Required value for trade goods.
Category INTEGER - allowed* NULL Label only. Category value for trade goods.
RareGood Boolean - allowed* 0 Label only. Rare Good selection for trade goods.

DIM_WealthUse

Section titled “DIM_WealthUse”

Wealth accounting categories and income or expenditure classification.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in wealth income treasury.

Column SQL type Key NULL Default Meaning and relationships
WealthUseID INTEGER PK 1 allowed* NULL Label only. Wealth Use ID identifier or catalogue selection for wealth use.
Description VARCHAR(50) - allowed* NULL Descriptive text for the row.
Income BOOLEAN - allowed* NULL Label only. Income selection for wealth use.
DisplayOrder DOUBLE - allowed* NULL Ordering value for the related game display.

FCT_IndustrialProjects

Section titled “FCT_IndustrialProjects”

Industrial production projects, queue settings, completion and resource requirements.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in production mechanics.

Column SQL type Key NULL Default Meaning and relationships
ProjectID INTEGER PK 1 NOT NULL 0 Label only. Project ID identifier or catalogue selection for industrial projects.
GameID INTEGER - allowed* NULL Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
RaceID INTEGER - allowed* NULL Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
PopulationID INTEGER - allowed* NULL Colony identifier. A population is a race-and-species colony on a system body. Related identity domain FCT_Population.PopulationID.
SpeciesID INTEGER - allowed* 0 Species identifier. Related identity domain FCT_Species.SpeciesID.
Percentage DOUBLE - allowed* NULL Allocation percentage for the activity.
ProductionType INTEGER - allowed* NULL Production category. It determines what ProductionID identifies.
ProductionID INTEGER - allowed* NULL Produced item identifier interpreted together with ProductionType.
RefitClassID INTEGER - allowed* 0 Label only. Refit Class ID identifier or catalogue selection for industrial projects.
WealthUse INTEGER - allowed* NULL Label only. Wealth Use value for industrial projects.
Amount DOUBLE - allowed* NULL Quantity or measured value. The table purpose and any type selector determine what is counted.
PartialCompletion DOUBLE - allowed* 0 Label only. Partial Completion value for industrial projects.
ProdPerUnit DOUBLE - allowed* NULL Label only. Prod Per Unit value for industrial projects.
Description VARCHAR(255) - allowed* NULL Descriptive text for the row.
Pause BOOLEAN - allowed* NULL Paused selection for the project.
Queue INTEGER - allowed* 0 Label only. Queue value for industrial projects.
FuelRequired INTEGER - allowed* 0 Label only. Fuel Required value for industrial projects.
Duranium DOUBLE - allowed* 0 Duranium mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Neutronium DOUBLE - allowed* 0 Neutronium mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Corbomite DOUBLE - allowed* 0 Corbomite mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Tritanium DOUBLE - allowed* 0 Tritanium mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Boronide DOUBLE - allowed* 0 Boronide mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Mercassium DOUBLE - allowed* 0 Mercassium mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Vendarite DOUBLE - allowed* 0 Vendarite mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Sorium DOUBLE - allowed* 0 Sorium mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Uridium DOUBLE - allowed* 0 Uridium mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Corundium DOUBLE - allowed* 0 Corundium mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Gallicite DOUBLE - allowed* 0 Gallicite mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.

FCT_MassDriverPackets

Section titled “FCT_MassDriverPackets”

Mineral packets in flight, their positions and destination colonies.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in mass driver logistics.

Column SQL type Key NULL Default Meaning and relationships
PacketID INTEGER PK 1 allowed* none Label only. Packet ID identifier or catalogue selection for mass driver packets.
GameID INTEGER - allowed* NULL Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
RaceID INTEGER - allowed* NULL Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
SysID INTEGER - allowed* NULL Star system identifier, using the shorter database spelling. Related identity domain FCT_System.SystemID.
DestID INTEGER - allowed* NULL Destination colony identifier.
TotalSize DOUBLE - allowed* NULL Total mineral tonnage carried by the packet.
Speed INTEGER - allowed* NULL Packet speed in kilometres per second.
Xcor DOUBLE - allowed* NULL X coordinate. System-space and map-space coordinates must be interpreted in the context of this table.
Ycor DOUBLE - allowed* NULL Y coordinate. System-space and map-space coordinates must be interpreted in the context of this table.
LastXcor DOUBLE - allowed* NULL Previous X coordinate used to track movement.
LastYcor DOUBLE - allowed* NULL Previous Y coordinate used to track movement.
IncrementStartX DOUBLE - allowed* 0 X coordinate at the start of the simulation increment.
IncrementStartY DOUBLE - allowed* 0 Y coordinate at the start of the simulation increment.
Duranium DOUBLE - allowed* 0 Duranium quantity in tons.
Neutronium DOUBLE - allowed* 0 Neutronium quantity in tons.
Corbomite DOUBLE - allowed* 0 Corbomite quantity in tons.
Tritanium DOUBLE - allowed* 0 Tritanium quantity in tons.
Boronide DOUBLE - allowed* 0 Boronide quantity in tons.
Mercassium DOUBLE - allowed* 0 Mercassium quantity in tons.
Vendarite DOUBLE - allowed* 0 Vendarite quantity in tons.
Sorium DOUBLE - allowed* 0 Sorium quantity in tons.
Uridium DOUBLE - allowed* 0 Uridium quantity in tons.
Corundium DOUBLE - allowed* 0 Corundium quantity in tons.
Gallicite DOUBLE - allowed* 0 Gallicite quantity in tons.

FCT_PopComponent

Section titled “FCT_PopComponent”

Components held in colony stockpiles.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in production mechanics.

Column SQL type Key NULL Default Meaning and relationships
ComponentID INTEGER PK 1 allowed* NULL Ship component design identifier. Related identity domain FCT_ShipDesignComponents.SDComponentID.
PopulationID INTEGER PK 2 allowed* NULL Colony identifier. A population is a race-and-species colony on a system body. Related identity domain FCT_Population.PopulationID.
GameID INTEGER - allowed* NULL Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
Amount DOUBLE - allowed* NULL Quantity or measured value. The table purpose and any type selector determine what is counted.

Indexes. sqlite_autoindex_FCT_PopComponent_1 (unique, ComponentID, PopulationID).

FCT_PopInstallationDemand

Section titled “FCT_PopInstallationDemand”

Colony installation import or export requests.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in civilian economy and autonomous logistics.

Column SQL type Key NULL Default Meaning and relationships
PopulationID INTEGER - allowed* NULL Colony identifier. A population is a race-and-species colony on a system body. Related identity domain FCT_Population.PopulationID.
InstallationID INTEGER - allowed* NULL Planetary installation type identifier. Related identity domain DIM_PlanetaryInstallation.PlanetaryInstallationID.
Amount Double - allowed* NULL Quantity or measured value. The table purpose and any type selector determine what is counted.
Export Boolean - allowed* NULL Label only. Export selection for pop installation demand.
GameID INTEGER - allowed* none Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
NonEssential Boolean - allowed* FALSE Label only. Non Essential selection for pop installation demand.

FCT_PopMDChanges

Section titled “FCT_PopMDChanges”

Per-mineral mass driver changes recorded for colonies.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in mass driver logistics.

Column SQL type Key NULL Default Meaning and relationships
PopulationID INTEGER PK 1 NOT NULL none Colony identifier. A population is a race-and-species colony on a system body. Related identity domain FCT_Population.PopulationID.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
Duranium DOUBLE - allowed* 0 Duranium mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Neutronium DOUBLE - allowed* 0 Neutronium mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Corbomite DOUBLE - allowed* 0 Corbomite mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Tritanium DOUBLE - allowed* 0 Tritanium mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Boronide DOUBLE - allowed* 0 Boronide mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Mercassium DOUBLE - allowed* 0 Mercassium mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Vendarite DOUBLE - allowed* 0 Vendarite mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Sorium DOUBLE - allowed* 0 Sorium mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Uridium DOUBLE - allowed* 0 Uridium mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Corundium DOUBLE - allowed* 0 Corundium mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Gallicite DOUBLE - allowed* 0 Gallicite mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.

FCT_PopTradeBalance

Section titled “FCT_PopTradeBalance”

Production and current or previous trade balances by colony and trade good.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in civilian economy and autonomous logistics.

Column SQL type Key NULL Default Meaning and relationships
PopulationID INTEGER PK 1 allowed* NULL Colony identifier. A population is a race-and-species colony on a system body. Related identity domain FCT_Population.PopulationID.
TradeGoodID INTEGER PK 2 allowed* NULL Trade good type identifier.
GameID INTEGER - allowed* NULL Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
ProductionRate Double - allowed* NULL Label only. Production Rate value for pop trade balance.
TradeBalance Double - allowed* NULL Label only. Trade Balance value for pop trade balance.
LastTradeBalance Double - allowed* NULL Label only. Last Trade Balance value for pop trade balance.

Indexes. sqlite_autoindex_FCT_PopTradeBalance_1 (unique, PopulationID, TradeGoodID).

FCT_Population

Section titled “FCT_Population”

Colony identity, species, population, stockpiles, political status and production settings.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in colony and population lifecycle.

Column SQL type Key NULL Default Meaning and relationships
PopulationID INTEGER - allowed* none Colony identifier. A population is a race-and-species colony on a system body.
GameID INTEGER - allowed* none Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
RaceID INTEGER - allowed* none Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
SpeciesID INTEGER - allowed* none Species identifier. Related identity domain FCT_Species.SpeciesID.
PopName TEXT - allowed* none Colony name.
AcademyOfficers REAL - allowed* none Label only. Academy Officers value for population.
Capital Numeric - allowed* none Whether this colony is the race capital.
TerraformStatus INTEGER - allowed* none Label only. Terraform Status value for population.
PurchaseCivilianMinerals Numeric - allowed* none Label only. Purchase Civilian Minerals value for population.
ColonistDestination INTEGER - allowed* none Label only. Colonist Destination value for population.
Efficiency REAL - allowed* none Label only. Efficiency value for population.
FighterDestFleetID INTEGER - allowed* none Destination fleet identifier for newly produced fighters. Related identity domain FCT_Fleet.FleetID.
FuelProdStatus Numeric - allowed* none Label only. Fuel Prod Status value for population.
FuelStockpile REAL - allowed* none Fuel held at the colony.
GenModSpeciesID INTEGER - allowed* none Target genetically modified species selected for the colony. Related identity domain FCT_Species.SpeciesID.
GroundAttackID INTEGER - allowed* none Ground attack target identifier interpreted with the colony’s attack selection.
GroundAttackType INTEGER - allowed* none Label only. Ground Attack Type value for population.
LastColonyCost REAL - allowed* none Colony cost retained from the preceding update.
MaintenanceStockpile REAL - allowed* none Maintenance supplies held at the colony, in MSP.
MaintProdStatus Numeric - allowed* none Label only. Maint Prod Status value for population.
MassDriverDest INTEGER - allowed* none Destination colony identifier for mass driver shipments.
MaxAtm REAL - allowed* none Target gas pressure for the terraforming selection, in atmospheres.
NoStatusChange INTEGER - allowed* none Label only. No Status Change value for population.
PoliticalStatus INTEGER - allowed* none Political status selection from DIM_PopPoliticalStatus. Related identity domain DIM_PopPoliticalStatus.StatusID.
Population REAL - allowed* none Population amount. In FCT_Population this is measured in millions of people.
PreviousUnrest REAL - allowed* none Previously retained colony unrest.
ProvideColonists INTEGER - allowed* none Label only. Provide Colonists value for population.
ReqInf INTEGER - allowed* none Maximum required infrastructure setting for the colony.
StatusPoints REAL - allowed* none Accumulated progress toward the next political status.
SystemID INTEGER - allowed* none Star system identifier. Related identity domain FCT_System.SystemID.
SystemBodyID INTEGER - allowed* none System body identifier. Bodies include planets, moons, asteroids and comets. Related identity domain FCT_SystemBody.SystemBodyID.
TempMF INTEGER - allowed* none Label only. Temp MF value for population.
TerraformingGasID INTEGER - allowed* none Label only. Terraforming Gas ID identifier or catalogue selection for population.
UnrestPoints REAL - allowed* none Current colony unrest points.
Duranium REAL - allowed* none Duranium quantity in tons.
Neutronium REAL - allowed* none Neutronium quantity in tons.
Corbomite REAL - allowed* none Corbomite quantity in tons.
Tritanium REAL - allowed* none Tritanium quantity in tons.
Boronide REAL - allowed* none Boronide quantity in tons.
Mercassium REAL - allowed* none Mercassium quantity in tons.
Vendarite REAL - allowed* none Vendarite quantity in tons.
Sorium REAL - allowed* none Sorium quantity in tons.
Uridium REAL - allowed* none Uridium quantity in tons.
Corundium REAL - allowed* none Corundium quantity in tons.
Gallicite REAL - allowed* none Gallicite quantity in tons.
LastDuranium REAL - allowed* none Previously retained Duranium stockpile in tons.
LastNeutronium REAL - allowed* none Previously retained Neutronium stockpile in tons.
LastCorbomite REAL - allowed* none Previously retained Corbomite stockpile in tons.
LastTritanium REAL - allowed* none Previously retained Tritanium stockpile in tons.
LastBoronide REAL - allowed* none Previously retained Boronide stockpile in tons.
LastMercassium REAL - allowed* none Previously retained Mercassium stockpile in tons.
LastVendarite REAL - allowed* none Previously retained Vendarite stockpile in tons.
LastSorium REAL - allowed* none Previously retained Sorium stockpile in tons.
LastUridium REAL - allowed* none Previously retained Uridium stockpile in tons.
LastCorundium REAL - allowed* none Previously retained Corundium stockpile in tons.
LastGallicite REAL - allowed* none Previously retained Gallicite stockpile in tons.
ReserveDuranium REAL - allowed* none Reserved Duranium stockpile in tons.
ReserveNeutronium REAL - allowed* none Reserved Neutronium stockpile in tons.
ReserveCorbomite REAL - allowed* none Reserved Corbomite stockpile in tons.
ReserveTritanium REAL - allowed* none Reserved Tritanium stockpile in tons.
ReserveBoronide REAL - allowed* none Reserved Boronide stockpile in tons.
ReserveMercassium REAL - allowed* none Reserved Mercassium stockpile in tons.
ReserveVendarite REAL - allowed* none Reserved Vendarite stockpile in tons.
ReserveSorium REAL - allowed* none Reserved Sorium stockpile in tons.
ReserveUridium REAL - allowed* none Reserved Uridium stockpile in tons.
ReserveCorundium REAL - allowed* none Reserved Corundium stockpile in tons.
ReserveGallicite REAL - allowed* none Reserved Gallicite stockpile in tons.
GroundGeoSurvey REAL - allowed* none Accumulated ground geological survey progress.
DestroyedInstallationSize INTEGER - allowed* none Label only. Destroyed Installation Size value for population.
AIValue INTEGER - allowed* none Label only. AI Value value for population.
InvasionStagingPoint Numeric - allowed* none Label only. Invasion Staging Point value for population.
OriginalRaceID INTEGER - allowed* none Original race associated with the colony. Related identity domain FCT_Race.RaceID.
DoNotDelete Numeric - allowed* none Label only. Do Not Delete value for population.
MilitaryRestrictedColony Numeric - allowed* none Label only. Military Restricted Colony value for population.
AcademyName TEXT - allowed* none Label only. Academy Name text for population.
SpaceStationDestFleetID INTEGER - allowed* 0 Destination fleet identifier for newly produced space stations. Related identity domain FCT_Fleet.FleetID.
Importance INTEGER - allowed* 0 Label only. Importance value for population.
AutoAssign INTEGER - allowed* 0 Label only. Auto Assign value for population.
BonusOne INTEGER - allowed* 8 Label only. Bonus One value for population.
BonusTwo INTEGER - allowed* 20 Label only. Bonus Two value for population.
BonusThree INTEGER - allowed* 6 Label only. Bonus Three value for population.
AutoRefuel Boolean - allowed* TRUE Label only. Auto Refuel selection for population.
ParasiteSourceID INTEGER - allowed* 0 Label only. Parasite Source ID identifier or catalogue selection for population.
GeneticProdStatus Boolean - allowed* FALSE Label only. Genetic Prod Status selection for population.
AvailableColonists Double - allowed* 0 Colonists available for civilian movement.
ColonizationPressure Double - allowed* 0 Label only. Colonisation Pressure value for population.
WarningFuel INTEGER - allowed* 0 Colony fuel warning setting.
WarningMSP INTEGER - allowed* 0 Colony maintenance supply warning setting.
WarningConstant INTEGER - allowed* 1 Label only. Warning Constant value for population.
BuildReplacements INTEGER - allowed* 0 Label only. Build Replacements value for population.
ReplacementCapacity Double - allowed* 0 Label only. Replacement Capacity value for population.
AcademyNameThemeID INTEGER - allowed* 0 Label only. Academy Name Theme ID identifier or catalogue selection for population.
UseAcademyNameTheme INTEGER - allowed* 0 Label only. Use Academy Name Theme value for population.

FCT_PopulationInstallations

Section titled “FCT_PopulationInstallations”

Installation quantities belonging to colonies.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in planetary installation catalogue.

Column SQL type Key NULL Default Meaning and relationships
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
PopID INTEGER - allowed* 0 Colony identifier, using the shorter database spelling. Related identity domain FCT_Population.PopulationID.
PlanetaryInstallationID INTEGER - allowed* 0 Planetary installation type identifier. Related identity domain DIM_PlanetaryInstallation.PlanetaryInstallationID.
Amount Double - allowed* 0 Quantity of the selected planetary installation at the colony.

FCT_PopulationWeapon

Section titled “FCT_PopulationWeapon”

Missile stockpiles belonging to colonies.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in production mechanics.

Column SQL type Key NULL Default Meaning and relationships
GameID INTEGER - allowed* NULL Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
PopulationID INTEGER - allowed* NULL Colony identifier. A population is a race-and-species colony on a system body. Related identity domain FCT_Population.PopulationID.
MissileID INTEGER - allowed* NULL Missile design identifier. Related identity domain FCT_MissileType.MissileID.
Amount Double - allowed* NULL Number of missiles of the selected design at the colony.

FCT_Prisoners

Section titled “FCT_Prisoners”

Prisoner populations and processing counts at colonies.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in ground combat and conquest.

Column SQL type Key NULL Default Meaning and relationships
GameID INTEGER - allowed* NULL Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
PopulationID INTEGER - allowed* NULL Colony identifier. A population is a race-and-species colony on a system body. Related identity domain FCT_Population.PopulationID.
PrisonerRaceID INTEGER - allowed* NULL Label only. Prisoner Race ID identifier or catalogue selection for prisoners.
PrisonerSpeciesID INTEGER - allowed* NULL Label only. Prisoner Species ID identifier or catalogue selection for prisoners.
NumPrisoners INTEGER - allowed* NULL Label only. Num Prisoners value for prisoners.
NumProcessed INTEGER - allowed* 0 Label only. Num Processed value for prisoners.

FCT_RaceMineralData

Section titled “FCT_RaceMineralData”

Timed mineral accounting records by race, colony and mineral category.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in production mechanics.

Column SQL type Key NULL Default Meaning and relationships
RaceID INTEGER - allowed* 0 Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
PopulationID INTEGER - allowed* 0 Colony identifier. A population is a race-and-species colony on a system body. Related identity domain FCT_Population.PopulationID.
MineralID INTEGER - allowed* 0 Mineral type identifier.
MineralDataType INTEGER - allowed* 0 Label only. Mineral Data Type value for race mineral data.
Time Double - allowed* 0 Time associated with this event or accounting entry.
Amount Numeric - allowed* 0 Quantity or measured value. The table purpose and any type selector determine what is counted.

FCT_ShippingLines

Section titled “FCT_ShippingLines”

Civilian shipping line identity, wealth, assets and engine selections.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in civilian economy and autonomous logistics.

Column SQL type Key NULL Default Meaning and relationships
ShippingLineID INTEGER PK 1 allowed* none Civilian shipping line identifier.
GameID INTEGER - allowed* NULL Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
EmpireID INTEGER - allowed* NULL Label only. Empire ID identifier or catalogue selection for shipping lines.
NPRace Boolean - allowed* NULL Label only. NP Race selection for shipping lines.
LineName TEXT - allowed* NULL Label only. Line Name text for shipping lines.
ShortName TEXT - allowed* NULL Label only. Short Name text for shipping lines.
ShipNum INTEGER - allowed* 1 Label only. Ship Num value for shipping lines.
WealthBalance Double - allowed* 2000 Label only. Wealth Balance value for shipping lines.
LastDividendPaid Double - allowed* 0 Label only. Last Dividend Paid value for shipping lines.
LastDividendTime Double - allowed* NULL Label only. Last Dividend Time value for shipping lines.
MaxAssets Double - allowed* 1000 Label only. Max Assets value for shipping lines.
CommEngineID INTEGER - allowed* 0 Label only. Comm Engine ID identifier or catalogue selection for shipping lines.
CommercialEngines INTEGER - allowed* 0 Label only. Commercial Engines value for shipping lines.

FCT_ShippingWealthData

Section titled “FCT_ShippingWealthData”

Shipping transactions, cargo categories, revenue and colony endpoints.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in civilian economy and autonomous logistics.

Column SQL type Key NULL Default Meaning and relationships
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
ShippingLineID INTEGER - allowed* NULL Civilian shipping line identifier. Related identity domain FCT_ShippingLines.ShippingLineID.
ShipID INTEGER - allowed* NULL Individual ship identifier. Related identity domain FCT_Ship.ShipID.
Contract Boolean - allowed* NULL Label only. Contract selection for shipping wealth data.
Colonist Boolean - allowed* 0 Label only. Colonist selection for shipping wealth data.
Fuel Boolean - allowed* 0 Fuel quantity.
Amount Double - allowed* NULL Quantity or measured value. The table purpose and any type selector determine what is counted.
TradeGood INTEGER - allowed* NULL Label only. Trade Good value for shipping wealth data.
TradeTime Double - allowed* NULL Label only. Trade Time value for shipping wealth data.
OriginPop INTEGER - allowed* 0 Origin colony identifier for the shipping transaction.
DestinationPop INTEGER - allowed* NULL Destination colony identifier for the shipping transaction.

FCT_Shipyard

Section titled “FCT_Shipyard”

Shipyard identity, location, capacity, slipways and development state.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in shipyard development and ship work.

Column SQL type Key NULL Default Meaning and relationships
ShipyardID INTEGER PK 1 allowed* none Shipyard identifier.
GameID INTEGER - allowed* NULL Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
TractorParentShipID INTEGER - allowed* 0 Ship providing the tow.
PopulationID INTEGER - allowed* NULL Colony identifier. A population is a race-and-species colony on a system body. Related identity domain FCT_Population.PopulationID.
SYType INTEGER - allowed* 1 Label only. SY Type value for shipyard.
ShipyardName TEXT - allowed* NULL Label only. Shipyard Name text for shipyard.
Slipways Double - allowed* 1 Label only. Slipways value for shipyard.
Capacity Double - allowed* 1000 Label only. Capacity value for shipyard.
BuildClassID INTEGER - allowed* 0 Label only. Build Class ID identifier or catalogue selection for shipyard.
RetoolClassID INTEGER - allowed* 0 Label only. Retool Class ID identifier or catalogue selection for shipyard.
TaskType INTEGER - allowed* 0 Label only. Task Type value for shipyard.
RequiredBP Double - allowed* 0 Build points required for the shipyard development activity.
CompletedBP Double - allowed* 0 Build points already completed on the task.
PauseActivity Boolean - allowed* 0 Label only. Pause Activity selection for shipyard.
DefaultFleetID INTEGER - allowed* 0 Label only. Default Fleet ID identifier or catalogue selection for shipyard.
Xcor Double - allowed* 0 X coordinate. System-space and map-space coordinates must be interpreted in the context of this table.
Ycor Double - allowed* 0 Y coordinate. System-space and map-space coordinates must be interpreted in the context of this table.
RaceID INTEGER - allowed* NULL Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
CapacityTarget INTEGER - allowed* 0 Label only. Capacity Target value for shipyard.
ParentShipID INTEGER - allowed* 0 Parent ship identifier.
DefaultNavalAdminID INTEGER - allowed* 0 Label only. Default Naval Admin ID identifier or catalogue selection for shipyard.
UseAdmin INTEGER - allowed* 0 Label only. Use Admin value for shipyard.

FCT_ShipyardTask

Section titled “FCT_ShipyardTask”

Ship construction, refit or other shipyard work and its progress.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in shipyard development and ship work.

Column SQL type Key NULL Default Meaning and relationships
TaskID INTEGER PK 1 allowed* none Label only. Task ID identifier or catalogue selection for shipyard task.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
RaceID INTEGER - allowed* 0 Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
PopulationID INTEGER - allowed* 0 Colony identifier. A population is a race-and-species colony on a system body. Related identity domain FCT_Population.PopulationID.
ShipyardID INTEGER - allowed* NULL Shipyard identifier. Related identity domain FCT_Shipyard.ShipyardID.
TaskTypeID INTEGER - allowed* 0 Label only. Task Type ID identifier or catalogue selection for shipyard task.
Freighter Boolean - allowed* NULL Label only. Freighter selection for shipyard task.
FleetID INTEGER - allowed* 0 Fleet identifier. Related identity domain FCT_Fleet.FleetID.
ShipID INTEGER - allowed* 0 Individual ship identifier. Related identity domain FCT_Ship.ShipID.
ClassID INTEGER - allowed* 0 Ship class identifier in FCT_ShipClass.
NPRShip Boolean - allowed* 0 Label only. NPR Ship selection for shipyard task.
RefitID INTEGER - allowed* 0 Label only. Refit ID identifier or catalogue selection for shipyard task.
TotalBP Double - allowed* 0 Total build points required for the task.
CompletedBP Double - allowed* 0 Build points already completed on the task.
Paused Boolean - allowed* NULL Label only. Paused selection for shipyard task.
UnitName TEXT - allowed* NULL Label only. Unit Name text for shipyard task.
Duranium Double - allowed* 0 Duranium mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Neutronium Double - allowed* 0 Neutronium mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Corbomite Double - allowed* 0 Corbomite mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Tritanium Double - allowed* 0 Tritanium mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Boronide Double - allowed* 0 Boronide mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Mercassium Double - allowed* 0 Mercassium mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Vendarite Double - allowed* 0 Vendarite mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Sorium Double - allowed* 0 Sorium mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Uridium Double - allowed* 0 Uridium mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Corundium Double - allowed* 0 Corundium mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Gallicite Double - allowed* 0 Gallicite mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
UseComponents Boolean - allowed* FALSE Label only. Use Components selection for shipyard task.
NavalAdminID INTEGER - allowed* 0 Label only. Naval Admin ID identifier or catalogue selection for shipyard task.

FCT_WealthData

Section titled “FCT_WealthData”

Dated wealth accounting transactions by use category.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in wealth income treasury.

Column SQL type Key NULL Default Meaning and relationships
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
RaceID INTEGER - allowed* NULL Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
Amount Double - allowed* NULL Quantity or measured value. The table purpose and any type selector determine what is counted.
UseID INTEGER - allowed* NULL Label only. Use ID identifier or catalogue selection for wealth data.
TimeUsed Double - allowed* NULL Simulation time at which the wealth entry was recorded.

FCT_WealthHistory

Section titled “FCT_WealthHistory”

Race treasury history over simulation increments.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in wealth income treasury.

Column SQL type Key NULL Default Meaning and relationships
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
RaceID INTEGER - allowed* 0 Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
IncrementTime Double - allowed* 0 Simulation time associated with the treasury history entry.
WealthAmount Double - allowed* 0 Treasury amount recorded at the history time.

Technology and designs

Section titled “Technology and designs”

DIM_ClassSummaryType / DIM_ComponentType / DIM_ResearchCategories / DIM_ResearchField / DIM_TechType / FCT_ClassComponent / FCT_ClassComponentTemplate / FCT_ClassGroundTemplates / FCT_ClassMaterials / FCT_ClassOrdnanceTemplate / FCT_ClassSC / FCT_EligibleProjects / FCT_MissileType / FCT_PausedResearch / FCT_RaceTech / FCT_ResearchProject / FCT_ResearchQueue / FCT_ShipClass / FCT_ShipClassTemplate / FCT_ShipComponentTemplate / FCT_ShipDesignComponents / FCT_TechSystem

DIM_ClassSummaryType

Section titled “DIM_ClassSummaryType”

Categories used to group components in a ship class summary.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in ship and station design.

Column SQL type Key NULL Default Meaning and relationships
ClassSummaryTypeID INTEGER - allowed* 0 Label only. Class Summary Type ID identifier or catalogue selection for class summary type.
Description TEXT - allowed* none Descriptive text for the row.

DIM_ComponentType

Section titled “DIM_ComponentType”

Component categories, display groupings, repair priorities and category restrictions.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in component design.

Column SQL type Key NULL Default Meaning and relationships
ComponentTypeID INTEGER PK 1 NOT NULL none Component category identifier. Ground equipment and ship equipment use different catalogues.
TypeDescription TEXT - allowed* NULL Label only. Type Description text for component type.
EmptySpaceModifier Double - allowed* 0 Label only. Empty Space Modifier value for component type.
RatingDescription TEXT - allowed* NULL Label only. Rating Description text for component type.
ClassDisplayOrder INTEGER - allowed* NULL Label only. Class Display Order value for component type.
RepairPriority INTEGER - allowed* 0 Label only. Repair Priority value for component type.
ShowInClassDisplay Numeric - allowed* 0 Label only. Show In Class Display value for component type.
SingleSystem Numeric - allowed* 0 Label only. Single System value for component type.
ObsoleteAllowed Boolean - allowed* FALSE Label only. Obsolete Allowed selection for component type.
ClassSummaryTypeID INTEGER - allowed* 0 Label only. Class Summary Type ID identifier or catalogue selection for component type.

DIM_ResearchCategories

Section titled “DIM_ResearchCategories”

Research and component-design category definitions and presentation settings.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in component design.

Column SQL type Key NULL Default Meaning and relationships
CategoryID INTEGER PK 1 allowed* 0 Label only. Category ID identifier or catalogue selection for research categories.
CheckTech Numeric - allowed* NULL Label only. Check Tech value for research categories.
Name TEXT - allowed* NULL Name stored for the row. Name text is distinct from numeric identity.
CompanyNameType INTEGER - allowed* 1 Label only. Company Name Type value for research categories.
PlayerDefined Numeric - allowed* NULL Label only. Player Defined value for research categories.
SourceTechType0 INTEGER - allowed* 0 Label only. Source Tech Type0 value for research categories.
SecondPrimaryTech INTEGER - allowed* 0 Label only. Second Primary Tech value for research categories.
SourceTechType1 INTEGER - allowed* 0 Label only. Source Tech Type1 value for research categories.
SourceTechType2 INTEGER - allowed* 0 Label only. Source Tech Type2 value for research categories.
SourceTechType3 INTEGER - allowed* 0 Label only. Source Tech Type3 value for research categories.
SourceTechType4 INTEGER - allowed* 0 Label only. Source Tech Type4 value for research categories.
SourceTechType5 INTEGER - allowed* 0 Label only. Source Tech Type5 value for research categories.
SourceTechType6 INTEGER - allowed* 0 Label only. Source Tech Type6 value for research categories.
SourceTechType7 INTEGER - allowed* 0 Label only. Source Tech Type7 value for research categories.
Sort0 Numeric - allowed* NULL Label only. Sort0 value for research categories.
Sort1 Numeric - allowed* NULL Label only. Sort1 value for research categories.
Sort2 Numeric - allowed* NULL Label only. Sort2 value for research categories.
Sort3 Numeric - allowed* NULL Label only. Sort3 value for research categories.
Sort4 Numeric - allowed* NULL Label only. Sort4 value for research categories.
Sort5 Numeric - allowed* NULL Label only. Sort5 value for research categories.
Sort6 Numeric - allowed* NULL Label only. Sort6 value for research categories.
Sort7 Numeric - allowed* NULL Label only. Sort7 value for research categories.
Components Numeric - allowed* NULL Label only. Components value for research categories.
NoteField TEXT - allowed* NULL Label only. Note Field text for research categories.
RadioNumber INTEGER - allowed* 0 Label only. Radio Number value for research categories.
RadioText TEXT - allowed* none Label only. Radio Text text for research categories.

DIM_ResearchField

Section titled “DIM_ResearchField”

Research field names, abbreviations and display settings.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in research and scientific personnel.

Column SQL type Key NULL Default Meaning and relationships
ResearchFieldID INTEGER PK 1 allowed* NULL Research field identifier.
FieldName TEXT - allowed* NULL Label only. Field Name text for research field.
ShortName TEXT - allowed* NULL Label only. Short Name text for research field.
Abbreviation TEXT - allowed* NULL Short display name or abbreviation.
DoNotDisplay Boolean - allowed* FALSE Label only. Do Not Display selection for research field.

DIM_TechType

Section titled “DIM_TechType”

Technology families and their research-field assignments.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in research and scientific personnel.

Column SQL type Key NULL Default Meaning and relationships
TechTypeID INTEGER PK 1 allowed* NULL Label only. Tech Type ID identifier or catalogue selection for tech type.
Description TEXT - allowed* NULL Descriptive text for the row.
FieldID INTEGER - allowed* NULL Label only. Field ID identifier or catalogue selection for tech type.
DistributeLowerTech Boolean - allowed* TRUE Label only. Distribute Lower Tech selection for tech type.
RuinTechType Boolean - allowed* FALSE Label only. Ruin Tech Type selection for tech type.

FCT_ClassComponent

Section titled “FCT_ClassComponent”

Component quantities and damage selection weights within ship classes.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in ship and station design.

Column SQL type Key NULL Default Meaning and relationships
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
ClassID INTEGER - allowed* NULL Ship class identifier in FCT_ShipClass.
ComponentID INTEGER - allowed* NULL Ship component design identifier. Related identity domain FCT_ShipDesignComponents.SDComponentID.
NumComponent Double - allowed* NULL Number of this component design fitted to the class.
ChanceToHit INTEGER - allowed* 0 Component damage selection weight.
ElectronicCTH INTEGER - allowed* 0 Electronic component damage selection weight.

FCT_ClassComponentTemplate

Section titled “FCT_ClassComponentTemplate”

Component entries in reusable ship class templates.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in ship and station design.

Column SQL type Key NULL Default Meaning and relationships
ShipClassTemplateID INTEGER - allowed* 0 Reusable ship class template identifier.
NumComponent INTEGER - allowed* 0 Number of components of the selected design.
ShipComponentTemplateID INTEGER - allowed* 0 Reusable ship component template identifier.
StandardComponentID INTEGER - allowed* 0 Label only. Standard Component ID identifier or catalogue selection for class component template.

FCT_ClassGroundTemplates

Section titled “FCT_ClassGroundTemplates”

Ground formation complements assigned to ship classes.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in ship and station design.

Column SQL type Key NULL Default Meaning and relationships
ShipClassID INTEGER - allowed* none Ship class identifier. Related identity domain FCT_ShipClass.ShipClassID.
TemplateID INTEGER - allowed* none Ground formation template identifier in FCT_GroundUnitFormationTemplate.
GameID INTEGER - allowed* none Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
Number INTEGER - allowed* none Number of formations of this template assigned to the ship class.

FCT_ClassMaterials

Section titled “FCT_ClassMaterials”

Mineral costs associated with ship classes.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in ship and station design.

Column SQL type Key NULL Default Meaning and relationships
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
ClassID INTEGER - allowed* NULL Ship class identifier in FCT_ShipClass.
MaterialID INTEGER - allowed* NULL Mineral type identifier.
Amount Double - allowed* NULL Mineral tons required for the class.

FCT_ClassOrdnanceTemplate

Section titled “FCT_ClassOrdnanceTemplate”

Ordnance loadout templates assigned to ship classes.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in ship and station design.

Column SQL type Key NULL Default Meaning and relationships
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
ShipClassID INTEGER - allowed* NULL Ship class identifier. Related identity domain FCT_ShipClass.ShipClassID.
MissileID INTEGER - allowed* NULL Missile design identifier. Related identity domain FCT_MissileType.MissileID.
Amount INTEGER - allowed* NULL Quantity or measured value. The table purpose and any type selector determine what is counted.

FCT_ClassSC

Section titled “FCT_ClassSC”

Small craft complements assigned to ship classes.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in ship and station design.

Column SQL type Key NULL Default Meaning and relationships
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
ShipClassID INTEGER - allowed* 0 Ship class identifier. Related identity domain FCT_ShipClass.ShipClassID.
FighterClassID INTEGER - allowed* 0 Small-craft ship class identifier in FCT_ShipClass.
Number INTEGER - allowed* 0 Number of small craft assigned to the ship class complement.

FCT_EligibleProjects

Section titled “FCT_EligibleProjects”

Technology projects available to a race.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in research and scientific personnel.

Column SQL type Key NULL Default Meaning and relationships
RaceID INTEGER - allowed* 0 Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
TechSystemID INTEGER - allowed* 0 Technology identifier. Related identity domain FCT_TechSystem.TechSystemID.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.

FCT_MissileType

Section titled “FCT_MissileType”

Missile designs, propulsion, warheads, sensors and resource costs.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in component design.

Column SQL type Key NULL Default Meaning and relationships
MissileID INTEGER PK 1 NOT NULL none Missile design identifier.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
Name TEXT - allowed* NULL Name stored for the row. Name text is distinct from numeric identity.
MissileSeriesID INTEGER - allowed* 0 Missile naming series identifier.
EngineID INTEGER - allowed* 0 Label only. Engine ID identifier or catalogue selection for missile type.
NumEngines INTEGER - allowed* 0 Number of engines fitted to the missile.
Boolean - allowed* NULL Label only.
MissilesRequired INTEGER - allowed* 0 Label only. Missiles Required value for missile type.
MissilesAvailable INTEGER - allowed* 0 Label only. Missiles Available value for missile type.
Cost Double - allowed* 0 Build or development cost for the design or definition.
Size Double - allowed* NULL Label only. Size value for missile type.
Speed Double - allowed* NULL Label only. Speed value for missile type.
RadDamage Double - allowed* 1 Label only. Rad Damage value for missile type.
FuelRequired INTEGER - allowed* 0 Label only. Fuel Required value for missile type.
Endurance Double - allowed* 0 Label only. Endurance value for missile type.
MaxRange Double - allowed* 0 Label only. Max Range value for missile type.
WarheadStrength Double - allowed* NULL Missile warhead strength.
SensorStrength Double - allowed* 0 Sensor strength rating.
SensorResolution INTEGER - allowed* 0 Active sensor resolution rating.
SensorRange INTEGER - allowed* 0 Sensor range rating.
ThermalStrength Double - allowed* 0 Thermal sensor strength rating.
EMStrength Double - allowed* 0 Electromagnetic sensor strength rating.
Geostrength Double - allowed* 0 Geological survey sensor strength.
TotalFlightTime Double - allowed* 0 Label only. Total Flight Time value for missile type.
ECM INTEGER - allowed* 0 Label only. ECM value for missile type.
MR INTEGER - allowed* 10 Label only. MR value for missile type.
SecondStageID INTEGER - allowed* 0 Second-stage missile design identifier.
NumSS INTEGER - allowed* 0 Number of second-stage missiles carried.
SeparationRange INTEGER - allowed* 0 Range at which the missile releases its second stage.
Corbomite Double - allowed* 0 Corbomite mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Tritanium Double - allowed* 0 Tritanium mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Boronide Double - allowed* 0 Boronide mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Uridium Double - allowed* 0 Uridium mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Gallicite Double - allowed* 0 Gallicite mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
PreTNT Boolean - allowed* NULL Label only. Pre TNT selection for missile type.
MSPReactor Double - allowed* 0 Label only. MSP Reactor value for missile type.
MSPWarhead Double - allowed* 0 Label only. MSP Warhead value for missile type.
MSPEngine Double - allowed* 0 Label only. MSP Engine value for missile type.
MSPFuel Double - allowed* 0 Label only. MSP Fuel value for missile type.
MSPActive Double - allowed* 0 Label only. MSP Active value for missile type.
MSPThermal Double - allowed* 0 Label only. MSP Thermal value for missile type.
MSPEM Double - allowed* 0 Label only. MSPEM value for missile type.
MSPGeo Double - allowed* 0 Label only. MSP Geo value for missile type.
ECCM INTEGER - allowed* 0 Label only. ECCM value for missile type.
EMSensitivity INTEGER - allowed* 10 Label only. EM Sensitivity value for missile type.
GroundAP Double - allowed* 0 Label only. Ground AP value for missile type.
GroundDamage Double - allowed* 0 Label only. Ground Damage value for missile type.
GroundShots Double - allowed* 0 Label only. Ground Shots value for missile type.
GroundBaseDamage Double - allowed* 0 Label only. Ground Base Damage value for missile type.
PowerMod Double - allowed* 1 Label only. Power Mod value for missile type.
ATG Double - allowed* 1 Label only. ATG value for missile type.
Retargeting INTEGER - allowed* 0 Missile retargeting selection.
LaserWarhead Double - allowed* 0 Laser warhead selection.
MinDetonationRange Double - allowed* 0 Label only. Min Detonation Range value for missile type.
LaserWarheadRangeModifier INTEGER - allowed* 0 Label only. Laser Warhead Range Modifier value for missile type.
NumDecoys INTEGER - allowed* 0 Number of decoys carried by the missile.
MSPDecoys Double - allowed* 0 Label only. MSP Decoys value for missile type.
MissileECM INTEGER - allowed* 0 Label only. Missile ECM value for missile type.
MultipleWarheads INTEGER - allowed* 1 Multiple-warhead selection for the missile design.
MSPMultipleWarheads Double - allowed* 0 Label only. MSP Multiple Warheads value for missile type.
ShipDecoy INTEGER - allowed* 0 Label only. Ship Decoy value for missile type.
MSPShipDecoy Double - allowed* 0 Label only. MSP Ship Decoy value for missile type.
MaxDetonationRange Double - allowed* 0 Label only. Max Detonation Range value for missile type.

FCT_PausedResearch

Section titled “FCT_PausedResearch”

Research points retained for paused projects.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in research and scientific personnel.

Column SQL type Key NULL Default Meaning and relationships
TechSystemID INTEGER - allowed* NULL Technology identifier. Related identity domain FCT_TechSystem.TechSystemID.
GameID INTEGER - allowed* NULL Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
PointsAccumulated INTEGER - allowed* NULL Research points retained for the paused technology.
RaceID INTEGER - allowed* 0 Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.

FCT_RaceTech

Section titled “FCT_RaceTech”

Technologies possessed by a race and their obsolete status.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in research and scientific personnel.

Column SQL type Key NULL Default Meaning and relationships
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
TechID INTEGER - allowed* 0 Technology identifier. Related identity domain FCT_TechSystem.TechSystemID.
RaceID INTEGER - allowed* 0 Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
Obsolete Boolean - allowed* NULL Whether the race has marked this technology obsolete.

FCT_ResearchProject

Section titled “FCT_ResearchProject”

Active research projects and assigned laboratories.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in research and scientific personnel.

Column SQL type Key NULL Default Meaning and relationships
ProjectID INTEGER PK 1 allowed* none Label only. Project ID identifier or catalogue selection for research project.
GameID INTEGER - allowed* NULL Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
TechID INTEGER - allowed* NULL Technology identifier. Related identity domain FCT_TechSystem.TechSystemID.
RaceID INTEGER - allowed* NULL Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
PopulationID INTEGER - allowed* NULL Colony identifier. A population is a race-and-species colony on a system body. Related identity domain FCT_Population.PopulationID.
Facilities INTEGER - allowed* NULL Research laboratories assigned to the project.
ResSpecID INTEGER - allowed* NULL Research field specialisation identifier.
ResearchPointsRequired Double - allowed* NULL Decimal research points remaining to complete the active project. This value is not clamped to zero when a project starts.
Pause Boolean - allowed* NULL Paused selection for the project.
AssignNew Boolean - allowed* FALSE Whether to assign a new project after the current research project finishes.

FCT_ResearchQueue

Section titled “FCT_ResearchQueue”

Research projects queued at a colony.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in research and scientific personnel.

Column SQL type Key NULL Default Meaning and relationships
GameID INTEGER - allowed* NULL Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
PopulationID INTEGER - allowed* NULL Colony identifier. A population is a race-and-species colony on a system body. Related identity domain FCT_Population.PopulationID.
TechSystemID INTEGER - allowed* NULL Technology identifier. Related identity domain FCT_TechSystem.TechSystemID.
CurrentProjectID INTEGER - allowed* NULL Active project associated with the queued research entry.
ResearchOrder INTEGER - allowed* NULL Position in the colony research queue.

FCT_ShipClass

Section titled “FCT_ShipClass”

Ship class designs, capacities, costs and operational settings.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in ship and station design.

Column SQL type Key NULL Default Meaning and relationships
ShipClassID INTEGER PK 1 allowed* none Ship class identifier.
ClassName TEXT - allowed* NULL Design class name.
GameID INTEGER - allowed* NULL Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
RaceID INTEGER - allowed* NULL Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
ActiveSensorStrength INTEGER - allowed* 0 Active sensor strength rating.
ArmourThickness INTEGER - allowed* 0 Number of armour layers.
ArmourWidth INTEGER - allowed* 0 Width of the ship armour grid in columns.
BaseFailureChance Double - allowed* 1 Base annual maintenance failure chance. This is distinct from a ship’s current maintenance age.
CargoCapacity INTEGER - allowed* 0 Cargo capacity for the class.
ClassCrossSection Double - allowed* NULL Class cross section in hull spaces.
ClassThermal Double - allowed* 0 Ship class thermal signature.
Collier INTEGER - allowed* 0 Whether the class is designated as an ordnance supply ship.
ColonistCapacity INTEGER - allowed* 0 Colonist transport capacity.
CommanderPriority INTEGER - allowed* 0 Label only. Commander Priority value for ship class.
MilitaryEngines Boolean - allowed* NULL Whether the class has military engines.
ControlRating INTEGER - allowed* 1 Label only. Control Rating value for ship class.
ConscriptOnly INTEGER - allowed* 0 Whether the class uses conscript crew.
Cost Double - allowed* 0 Build or development cost for the design or definition.
Crew INTEGER - allowed* 0 Crew count. Designs hold a requirement while survivor records hold a surviving group.
CrewQuartersHS Double - allowed* 0 Crew quarters capacity expressed in hull spaces.
DCRating INTEGER - allowed* 0 Damage control rating.
EMSensorStrength INTEGER - allowed* 0 Electromagnetic passive sensor strength rating.
EnginePower INTEGER - allowed* 0 Engine power rating.
ESMaxDACRoll INTEGER - allowed* 0 Label only. ES Max DAC Roll value for ship class.
FighterClass Boolean - allowed* NULL Whether the class is classified as a fighter.
Commercial Boolean - allowed* 0 Commercial classification selection.
FuelCapacity INTEGER - allowed* 0 Maximum class fuel capacity.
FuelEfficiency Double - allowed* 0 Label only. Fuel Efficiency value for ship class.
FuelTanker INTEGER - allowed* 0 Whether the class is designated as a tanker.
GeoSurvey Double - allowed* 0 Label only. Geo Survey value for ship class.
GravSurvey INTEGER - allowed* 0 Label only. Grav Survey value for ship class.
Harvesters INTEGER - allowed* 0 Label only. Harvesters value for ship class.
HullDescriptionID INTEGER - allowed* 25 Label only. Hull Description ID identifier or catalogue selection for ship class.
JGConstructionTime INTEGER - allowed* 0 Label only. JG Construction Time value for ship class.
JumpDistance INTEGER - allowed* 0 Label only. Jump Distance value for ship class.
JumpRating INTEGER - allowed* 0 Label only. Jump Rating value for ship class.
Locked Boolean - allowed* 0 Whether the class design is locked.
MagazineCapacity Double - allowed* 0 Ordnance magazine capacity.
MaxChance INTEGER - allowed* 0 Selection threshold or limit. Its interpretation depends on this catalogue and is not a universal percentage.
MaxDACRoll INTEGER - allowed* 0 Label only. Max DAC Roll value for ship class.
MaxSpeed INTEGER - allowed* 1 Label only. Max Speed value for ship class.
MaintModules INTEGER - allowed* 0 Label only. Maint Modules value for ship class.
MinimumFuel INTEGER - allowed* 0 Minimum fuel setting for the class or class template.
MiningModules INTEGER - allowed* 0 Label only. Mining Modules value for ship class.
NameThemeID INTEGER - allowed* 0 Naming theme selection. The table purpose determines which naming catalogue applies.
NoArmour INTEGER - allowed* 0 Whether armour is disabled for the class or template.
Notes TEXT - allowed* none Free-text notes associated with the row.
MainFunction INTEGER - allowed* 0 Label only. Main Function value for ship class.
Obsolete INTEGER - allowed* 0 Obsolete selection for this design or technology.
OtherRaceClassID INTEGER - allowed* 0 Original other-race class identifier retained when a class is copied between races.
ParasiteCapacity Double - allowed* 0 Small-craft hangar capacity.
PassiveSensorStrength INTEGER - allowed* 1 Thermal passive sensor strength rating.
PlannedDeployment Double - allowed* 3 Planned deployment duration in months. The ordinary default is 3.
PreTNT Boolean - allowed* 0 Label only. Pre TNT selection for ship class.
ProtectionValue Double - allowed* NULL Label only. Protection Value value for ship class.
RankRequired INTEGER - allowed* 0 Label only. Rank Required value for ship class.
ReactorPower INTEGER - allowed* 0 Power supplied by the class reactors.
RecreationalModule Boolean - allowed* NULL Whether the class has a recreational module.
RefuelPriority INTEGER - allowed* 0 Refuelling priority selection.
RefuellingRate INTEGER - allowed* 10000 Label only. Refuelling Rate value for ship class.
RefuellingStations INTEGER - allowed* 1 Label only. Refuelling Stations value for ship class.
RequiredPower INTEGER - allowed* 0 Power required by the class equipment.
SalvageRate INTEGER - allowed* 0 Label only. Salvage Rate value for ship class.
SensorReduction Double - allowed* 1 Cross-section reduction factor used when calculating the class signature.
ShieldStrength INTEGER - allowed* 0 Shield capacity for the class or observed class.
Size Double - allowed* 0 Ship class size in hull spaces. One hull space is 50 tons.
STSTractor INTEGER - allowed* 0 Whether the class has ship-to-ship tractor capability.
SupplyShip INTEGER - allowed* 0 Whether the class is designated as a maintenance supply ship.
Terraformers INTEGER - allowed* 0 Label only. Terraformers value for ship class.
TotalNumber INTEGER - allowed* 0 Class ship-name counter, also advanced when ships refit to the class.
CargoShuttleStrength INTEGER - allowed* 0 Cargo shuttle handling strength.
TroopCapacity INTEGER - allowed* 0 Ground troop transport capacity.
WorkerCapacity INTEGER - allowed* 0 Stored habitation capacity. Ordinary class recalculation resets it to zero and no component category adds to it.
MaintPriority INTEGER - allowed* 0 Maintenance priority. Lower priorities are served first when assigning colony maintenance support.
CommercialHangar Boolean - allowed* 0 Commercial hangar selection.
ClassShippingLineID INTEGER - allowed* 0 Label only. Class Shipping Line ID identifier or catalogue selection for ship class.
MoraleCheckRequired Boolean - allowed* False Label only. Morale Check Required selection for ship class.
OrdnanceTransferHub INTEGER - allowed* 0 Label only. Ordnance Transfer Hub value for ship class.
OrdnanceTransferRate INTEGER - allowed* 0 Label only. Ordnance Transfer Rate value for ship class.
TroopTransportType INTEGER - allowed* 0 Label only. Troop Transport Type value for ship class.
AutomatedDesignID INTEGER - allowed* 0 Label only. Automated Design ID identifier or catalogue selection for ship class.
MinimumSupplies INTEGER - allowed* 0 Minimum maintenance supply setting for the class or class template.
ResupplyPriority INTEGER - allowed* 0 Maintenance resupply priority selection.
MaintSupplies INTEGER - allowed* 0 Maintenance supply capacity in MSP.
ELINTRating INTEGER - allowed* 0 Label only. ELINT Rating value for ship class.
DiplomacyRating INTEGER - allowed* 0 Label only. Diplomacy Rating value for ship class.
CommercialJumpDrive INTEGER - allowed* 0 Commercial jump drive selection.
BioEnergyCapacity INTEGER - allowed* 0 Bioenergy storage capacity.
SeniorCO INTEGER - allowed* 0 Senior commanding-officer selection.
RandomShipNameFromTheme INTEGER - allowed* 0 Whether ship names are selected randomly from the assigned theme.
PrefixName TEXT - allowed* none Prefix used when forming ship names.
SuffixName TEXT - allowed* none Suffix used when forming ship names.
ClassHullNumbers INTEGER - allowed* 1 Class-level hull-number presentation selection.
NoOfficers INTEGER - allowed* 0 Whether the class uses no officers.
RepairYardCapacity INTEGER - allowed* 0 Label only. Repair Yard Capacity value for ship class.
ArkShip Boolean - allowed* FALSE Whether the class is marked as an ark ship with standard colonist berths.
PDProtectionPriority INTEGER - allowed* 10 Priority for receiving point defence protection.
ActiveJammerStrength INTEGER - allowed* 0 Active-sensor jamming strength.
FireControlJammerStrength INTEGER - allowed* 0 Fire-control jamming strength.
MissileJammerStrength INTEGER - allowed* 0 Missile jamming strength.
MissileJammerCount INTEGER - allowed* 0 Label only. Missile Jammer Count value for ship class.
DecoyCapacity Double - allowed* 0 Decoy storage capacity.
CrewDesignEfficiency Double - allowed* 1 Crew quarters efficiency multiplier. The design display shows (1 - multiplier) x 100%.
FlagBridge Boolean - allowed* FALSE Whether the class has a flag bridge.

FCT_ShipClassTemplate

Section titled “FCT_ShipClassTemplate”

Reusable ship class design templates and their default settings.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in ship and station design.

Column SQL type Key NULL Default Meaning and relationships
ShipClassTemplateID INTEGER - allowed* 0 Reusable ship class template identifier.
ShipClassTemplateName TEXT - allowed* none Reusable ship class template name.
HullID INTEGER - allowed* 0 Label only. Hull ID identifier or catalogue selection for ship class template.
ArmourThickness INTEGER - allowed* 1 Number of armour layers.
Collier INTEGER - allowed* 0 Whether the class is designated as an ordnance supply ship.
FuelTanker INTEGER - allowed* 0 Whether the class is designated as a tanker.
SupplyShip INTEGER - allowed* 0 Whether the class is designated as a maintenance supply ship.
ConscriptOnly INTEGER - allowed* 0 Whether the class uses conscript crew.
NoArmour INTEGER - allowed* 0 Whether armour is disabled for the class or template.
NoOfficers INTEGER - allowed* 0 Whether the class uses no officers.
PlannedDeployment Double - allowed* 3 Label only. Planned Deployment value for ship class template.
SeniorCO INTEGER - allowed* 0 Senior commanding-officer selection.
MinimumSupplies INTEGER - allowed* 0 Minimum maintenance supply setting for the class or class template.
MinimumFuel INTEGER - allowed* 0 Minimum fuel setting for the class or class template.
ResupplyPriority INTEGER - allowed* 5 Maintenance resupply priority selection.
RefuelPriority INTEGER - allowed* 5 Refuelling priority selection.
PDProtectionPriority INTEGER - allowed* 5 Priority for receiving point defence protection.
CommanderPriority INTEGER - allowed* 0 Label only. Commander Priority value for ship class template.
MaintPriority INTEGER - allowed* 0 Maintenance priority. Lower priorities are served first when assigning colony maintenance support.
CrewDesignEfficiency Double - allowed* 1 Label only. Crew Design Efficiency value for ship class template.

FCT_ShipComponentTemplate

Section titled “FCT_ShipComponentTemplate”

Reusable component design templates and selected technology inputs.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in component design.

Column SQL type Key NULL Default Meaning and relationships
BGTech1 INTEGER - allowed* 0 Label only. BG Tech1 value for ship component template.
BGTech2 INTEGER - allowed* 0 Label only. BG Tech2 value for ship component template.
BGTech3 INTEGER - allowed* 0 Label only. BG Tech3 value for ship component template.
BGTech4 INTEGER - allowed* 0 Label only. BG Tech4 value for ship component template.
BGTech6 INTEGER - allowed* 0 Label only. BG Tech6 value for ship component template.
BGTech5 INTEGER - allowed* 0 Label only. BG Tech5 value for ship component template.
ComponentTypeID INTEGER - allowed* 0 Component category identifier. Ground equipment and ship equipment use different catalogues.
ShipComponentTemplateID INTEGER - allowed* 0 Reusable ship component template identifier.
BGTech7 INTEGER - allowed* 0 Label only. BG Tech7 value for ship component template.
Resolution INTEGER - allowed* 0 Sensor resolution or contact resolution selection, according to the table.
NumberOfShots INTEGER - allowed* 0 Number of shots produced by the component.
ExtraHTK INTEGER - allowed* 0 Additional hits-to-kill allowance selected for the component.
ComponentSize Double - allowed* 0 Label only. Component Size value for ship component template.
EnginePowerMod Double - allowed* 1 Engine power modifier selected for the component.
ComponentName TEXT - allowed* none Label only. Component Name text for ship component template.
TurretWeaponTemplateID INTEGER - allowed* 0 Label only. Turret Weapon Template ID identifier or catalogue selection for ship component template.
TrackingSpeed INTEGER - allowed* 0 Weapon or fire-control tracking speed.
ComponentValue Double - allowed* 0 Label only. Component Value value for ship component template.

FCT_ShipDesignComponents

Section titled “FCT_ShipDesignComponents”

Individual component designs, ratings, technology inputs and mineral costs.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in component design.

Column SQL type Key NULL Default Meaning and relationships
SDComponentID INTEGER PK 1 allowed* 0 Ship component design identifier.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
Name TEXT - allowed* NULL Name stored for the row. Name text is distinct from numeric identity.
NoScrap Boolean - allowed* NULL Whether component scrapping is disabled.
MilitarySystem Boolean - allowed* 0 Whether the component is military equipment.
ShippingLineSystem Boolean - allowed* NULL Whether the component belongs to a civilian shipping line design.
BeamWeapon Boolean - allowed* 0 Whether the component is treated as a beam weapon.
Crew INTEGER - allowed* 0 Crew count. Designs hold a requirement while survivor records hold a surviving group.
Size Double - allowed* 0 Component size in hull spaces. One hull space is 50 tons.
Cost Double - allowed* 0 Build or development cost for the design or definition.
ComponentTypeID INTEGER - allowed* NULL Component category identifier. Ground equipment and ship equipment use different catalogues.
ComponentValue Double - allowed* 1 Primary component rating. Its meaning depends on ComponentTypeID.
PowerRequirement Double - allowed* 0 Power required by the component.
RechargeRate Double - allowed* 0 Component recharge rate.
ElectronicSystem Boolean - allowed* NULL Whether the component is electronic equipment.
ElectronicCTD INTEGER - allowed* 100 Electronic damage-selection contribution.
TrackingSpeed INTEGER - allowed* 0 Weapon or fire-control tracking speed.
SpecialFunction INTEGER - allowed* NULL Label only. Special Function value for ship design components.
MaxSensorRange Double - allowed* 0 Maximum sensor range.
Resolution Double - allowed* 0 Sensor resolution or contact resolution selection, according to the table.
HTK INTEGER - allowed* 1 Hits to kill for the component.
FuelUse Double - allowed* 0 Component fuel consumption rating.
NoMaintFailure Boolean - allowed* 0 Whether the component is excluded from ordinary maintenance failures.
HangarReloadOnly Boolean - allowed* NULL Whether reloading requires a hangar.
ExplosionChance Double - allowed* 0 Component explosion chance selection.
MaxExplosionSize INTEGER - allowed* 0 Maximum explosion size associated with the component.
DamageOutput INTEGER - allowed* 0 Component damage output per hit.
NumberOfShots INTEGER - allowed* 1 Number of shots produced by the component.
RangeModifier Double - allowed* 0 Weapon range modifier.
MaxWeaponRange INTEGER - allowed* 0 Maximum weapon range.
SpinalWeapon Boolean - allowed* 0 Whether the component is a spinal weapon.
JumpDistance INTEGER - allowed* 0 Label only. Jump Distance value for ship design components.
JumpRating INTEGER - allowed* 0 Label only. Jump Rating value for ship design components.
RateOfFire INTEGER - allowed* 0 Weapon firing interval or rate selection.
MaxPercentage INTEGER - allowed* 0 Label only. Max Percentage value for ship design components.
FuelEfficiency Double - allowed* 0 Label only. Fuel Efficiency value for ship design components.
IgnoreShields Boolean - allowed* 0 Whether the weapon bypasses shields.
IgnoreArmour Boolean - allowed* 0 Whether the weapon bypasses armour.
ElectronicOnly Boolean - allowed* NULL Whether the weapon attacks electronics only.
StealthRating Double - allowed* 0 Component stealth rating.
CloakRating Double - allowed* 0 Component cloaking rating.
Weapon Boolean - allowed* NULL Whether the component is treated as a weapon.
BGTech1 INTEGER - allowed* 0 First background technology input. Its role depends on the component category.
BGTech2 INTEGER - allowed* 0 Second background technology input. Its role depends on the component category.
BGTech3 INTEGER - allowed* 0 Third background technology input. Its role depends on the component category.
BGTech4 INTEGER - allowed* 0 Fourth background technology input. Its role depends on the component category.
BGTech5 INTEGER - allowed* 0 Fifth background technology input. Its role depends on the component category.
BGTech6 INTEGER - allowed* 0 Sixth background technology input. Its role depends on the component category.
Duranium Double - allowed* 0 Duranium mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Neutronium Double - allowed* 0 Neutronium mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Corbomite Double - allowed* 0 Corbomite mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Tritanium Double - allowed* 0 Tritanium mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Boronide Double - allowed* 0 Boronide mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Mercassium Double - allowed* 0 Mercassium mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Vendarite Double - allowed* 0 Vendarite mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Sorium Double - allowed* 0 Sorium mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Uridium Double - allowed* 0 Uridium mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Corundium Double - allowed* 0 Corundium mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Gallicite Double - allowed* 0 Gallicite mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
SingleSystemOnly INTEGER - allowed* none Whether only one instance of the component design is allowed in a class.
ShipyardRepairOnly Boolean - allowed* False Whether component repair requires a shipyard.
ECCM Double - allowed* 0 Label only. ECCM value for ship design components.
ArmourRetardation Double - allowed* 0 Label only. Armour Retardation value for ship design components.
WeaponToHitModifier Double - allowed* 1 Label only. Weapon To Hit Modifier value for ship design components.
Prototype INTEGER - allowed* 0 Prototype state. 0 is ordinary, 1 is prototype, 2 is future-tech prototype and 3 is research prototype.
TurretWeaponID INTEGER - allowed* 0 Weapon component design fitted in the turret.
ShipComponentTemplateID INTEGER - allowed* 0 Reusable ship component template identifier.
BGTech7 INTEGER - allowed* 0 Seventh background technology input. Its role depends on the component category.
EnginePowerMod Double - allowed* 1 Engine power modifier selected for the component.
ExtraHTK INTEGER - allowed* 0 Additional hits-to-kill allowance selected for the component.
FCRangeModifier Double - allowed* 1 Fire-control range modifier.
FCSpeedModifier Double - allowed* 1 Fire-control tracking speed modifier.

FCT_TechSystem

Section titled “FCT_TechSystem”

Technology definitions, prerequisites, research costs and component design data.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in research and scientific personnel.

Column SQL type Key NULL Default Meaning and relationships
TechSystemID INTEGER PK 1 allowed* none Technology identifier.
Name TEXT - allowed* NULL Name stored for the row. Name text is distinct from numeric identity.
ComponentName TEXT - allowed* NULL Label only. Component Name text for tech system.
CategoryID INTEGER - allowed* NULL Label only. Category ID identifier or catalogue selection for tech system.
RaceID INTEGER - allowed* 0 Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
TechTypeID INTEGER - allowed* 0 Label only. Tech Type ID identifier or catalogue selection for tech system.
NoTechScan Boolean - allowed* 0 Label only. No Tech Scan selection for tech system.
RuinOnly Boolean - allowed* 0 Label only. Ruin Only selection for tech system.
Prerequisite1 INTEGER - allowed* 0 First prerequisite technology identifier.
Prerequisite2 INTEGER - allowed* 0 Second prerequisite technology identifier.
StartingSystem Boolean - allowed* NULL Label only. Starting System selection for tech system.
ConventionalSystem Boolean - allowed* NULL Label only. Conventional System selection for tech system.
DevelopCost INTEGER - allowed* 0 Research points required to develop the technology.
AdditionalInfo Double - allowed* 0 First technology-specific numeric parameter. Its meaning depends on TechTypeID and the design category.
AdditionalInfo2 Double - allowed* 0 Second technology-specific numeric parameter. Its meaning depends on TechTypeID and the design category.
AdditionalInfo3 Double - allowed* 0 Third technology-specific numeric parameter. Its meaning depends on TechTypeID and the design category.
AdditionalInfo4 Double - allowed* 0 Fourth technology-specific numeric parameter. Its meaning depends on TechTypeID and the design category.
TechDescription TEXT - allowed* NULL Technology description shown to the player.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
AutomaticResearch Boolean - allowed* FALSE Label only. Automatic Research selection for tech system.

Fleets, movement and orders

Section titled “Fleets, movement and orders”

DIM_Condition / DIM_MoveAction / DIM_NavalAdminCommandType / DIM_StandingOrders / FCT_BannedBodies / FCT_Fleet / FCT_FleetConditionalOrder / FCT_FleetHistory / FCT_FleetStandingOrder / FCT_MoveOrderTemplate / FCT_MoveOrders / FCT_NavalAdminCommand / FCT_OrderTemplate / FCT_Squadron / FCT_StandingOrderTemplate / FCT_StandingOrderTemplateOrder / FCT_SubFleets / FCT_Waypoint / Formation

DIM_Condition

Section titled “DIM_Condition”

Conditions available to conditional fleet orders.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in standing orders conditions and move actions.

Column SQL type Key NULL Default Meaning and relationships
ConditionID INTEGER PK 1 allowed* NULL Label only. Condition ID identifier or catalogue selection for condition.
Description VARCHAR(50) - allowed* NULL Descriptive text for the row.
DisplayOrder INTEGER - allowed* NULL Ordering value for the related game display.

DIM_MoveAction

Section titled “DIM_MoveAction”

Movement action definitions and permitted destinations or order options.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in move action catalogue and executors.

Column SQL type Key NULL Default Meaning and relationships
MoveActionID INTEGER PK 1 NOT NULL 0 Label only. Move Action ID identifier or catalogue selection for move action.
Description TEXT - allowed* NULL Descriptive text for the row.
Completed Numeric - allowed* 0 Label only. Completed value for move action.
MoveRequirementID INTEGER - allowed* 0 Label only. Move Requirement ID identifier or catalogue selection for move action.
DestinationItemType INTEGER - allowed* 0 Category used to interpret the selected destination item.
DisplayOrder INTEGER - allowed* NULL Ordering value for the related game display.
TransitOrder Numeric - allowed* NULL Label only. Transit Order value for move action.
MinDistanceOption Numeric - allowed* 0 Label only. Min Distance Option value for move action.
SpecifyQuanitity Numeric - allowed* 0 Label only. Specify Quanitity value for move action.
NoOrderChange Numeric - allowed* NULL Label only. No Order Change value for move action.
MinQuantity Numeric - allowed* NULL Label only. Min Quantity value for move action.
LoadGroundUnit Numeric - allowed* 0 Label only. Load Ground Unit value for move action.
NoGasGiants Numeric - allowed* NULL Label only. No Gas Giants value for move action.
ReserveLevel Numeric - allowed* NULL Label only. Reserve Level value for move action.
WarpPoint Numeric - allowed* NULL Label only. Warp Point value for move action.
SystemBody Numeric - allowed* NULL Label only. System Body value for move action.
SurveyLocation Numeric - allowed* NULL Label only. Survey Location value for move action.
Fleet Numeric - allowed* NULL Label only. Fleet value for move action.
Waypoint Numeric - allowed* NULL Label only. Waypoint value for move action.
Contact Numeric - allowed* NULL Label only. Contact value for move action.
Lifepod Numeric - allowed* NULL Label only. Lifepod value for move action.
Wreck Numeric - allowed* NULL Label only. Wreck value for move action.
LagrangePoint Numeric - allowed* NULL Label only. Lagrange Point value for move action.
Wormhole Numeric - allowed* NULL Label only. Wormhole value for move action.
DesignModeOnly Numeric - allowed* NULL Label only. Design Mode Only value for move action.
Numeric - allowed* 0 Label only.
DeepSpaceLocation INTEGER - allowed* 0 Label only. Deep Space Location value for move action.
StationaryAction Boolean - allowed* FALSE Label only. Stationary Action selection for move action.

DIM_NavalAdminCommandType

Section titled “DIM_NavalAdminCommandType”

Naval administration command types, command radii and supported bonuses.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in naval administration and command.

Column SQL type Key NULL Default Meaning and relationships
CommandTypeID INTEGER - allowed* 0 Label only. Command Type ID identifier or catalogue selection for naval admin command type.
Description TEXT - allowed* none Descriptive text for the row.
Abbrev TEXT - allowed* none Short display name or abbreviation.
Radius Double - allowed* none Label only. Radius value for naval admin command type.
Survey Double - allowed* none Label only. Survey value for naval admin command type.
Industrial Double - allowed* none Label only. Industrial value for naval admin command type.
FleetTraining Double - allowed* none Label only. Fleet Training value for naval admin command type.
Engineering Double - allowed* 0 Label only. Engineering value for naval admin command type.
CrewTraining Double - allowed* 0 Label only. Crew Training value for naval admin command type.
Tactical Double - allowed* 0 Label only. Tactical value for naval admin command type.
Reaction Double - allowed* 0 Label only. Reaction value for naval admin command type.
Logistics Double - allowed* none Label only. Logistics value for naval admin command type.
DisplayOrder INTEGER - allowed* 0 Ordering value for the related game display.

DIM_StandingOrders

Section titled “DIM_StandingOrders”

Standing and conditional order definitions and category flags.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in standing orders conditions and move actions.

Column SQL type Key NULL Default Meaning and relationships
Description TEXT - allowed* NULL Descriptive text for the row.
DisplayOrder INTEGER - allowed* NULL Ordering value for the related game display.
NPROnly Numeric - allowed* NULL Label only. NPR Only value for standing orders.
SystemCheck TEXT - allowed* S Label only. System Check text for standing orders.
Standing INTEGER - allowed* True Label only. Standing value for standing orders.
Conditional INTEGER - allowed* false Label only. Conditional value for standing orders.
OrderID INTEGER PK 1 allowed* NULL Label only. Order ID identifier or catalogue selection for standing orders.
OrderGroupID INTEGER - allowed* 0 Label only. Order Group ID identifier or catalogue selection for standing orders.

FCT_BannedBodies

Section titled “FCT_BannedBodies”

Bodies excluded for a race’s automatic use.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in standing orders conditions and move actions.

Column SQL type Key NULL Default Meaning and relationships
SystemBodyID INTEGER - allowed* 0 System body identifier. Bodies include planets, moons, asteroids and comets. Related identity domain FCT_SystemBody.SystemBodyID.
RaceID INTEGER - allowed* 0 Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.

FCT_Fleet

Section titled “FCT_Fleet”

Fleet identity, location, movement settings, grouping and automatic behaviour.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in movement and logistics.

Column SQL type Key NULL Default Meaning and relationships
FleetID INTEGER PK 1 allowed* none Fleet identifier.
GameID INTEGER - allowed* NULL Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
FleetName TEXT - allowed* NULL Fleet name.
AssignedPopulationID INTEGER - allowed* 0 Label only. Assigned Population ID identifier or catalogue selection for fleet.
ParentCommandID INTEGER - allowed* 0 Label only. Parent Command ID identifier or catalogue selection for fleet.
OrbitBodyID INTEGER - allowed* 0 Label only. Orbit Body ID identifier or catalogue selection for fleet.
OrbitDistance INTEGER - allowed* 0 Label only. Orbit Distance value for fleet.
OrbitBearing Double - allowed* 0 Label only. Orbit Bearing value for fleet.
RaceID INTEGER - allowed* NULL Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
SystemID INTEGER - allowed* 0 Star system identifier. Related identity domain FCT_System.SystemID.
TradeLocation INTEGER - allowed* 0 Label only. Trade Location value for fleet.
CivilianFunction INTEGER - allowed* 0 Label only. Civilian Function value for fleet.
NPRHomeGuard Boolean - allowed* NULL Label only. NPR Home Guard selection for fleet.
TFTraining Boolean - allowed* NULL Label only. TF Training selection for fleet.
Speed INTEGER - allowed* 1 Label only. Speed value for fleet.
MaxNebulaSpeed INTEGER - allowed* 1 Label only. Max Nebula Speed value for fleet.
Xcor Double - allowed* 0 X coordinate. System-space and map-space coordinates must be interpreted in the context of this table.
Ycor Double - allowed* 0 Y coordinate. System-space and map-space coordinates must be interpreted in the context of this table.
LastXcor Double - allowed* 0 Previous X coordinate used to track movement.
LastYcor Double - allowed* 0 Previous Y coordinate used to track movement.
LastMoveTime Double - allowed* 0 Label only. Last Move Time value for fleet.
IncrementStartX Double - allowed* 0 X coordinate at the start of the simulation increment.
IncrementStartY Double - allowed* 0 Y coordinate at the start of the simulation increment.
EntryJPID INTEGER - allowed* 0 Label only. Entry JPID identifier or catalogue selection for fleet.
CycleMoves INTEGER - allowed* 0 Label only. Cycle Moves value for fleet.
JustDivided INTEGER - allowed* 0 Label only. Just Divided value for fleet.
AxisContactID INTEGER - allowed* 0 Label only. Axis Contact ID identifier or catalogue selection for fleet.
Distance INTEGER - allowed* 0 Label only. Distance value for fleet.
OffsetBearing INTEGER - allowed* 0 Label only. Offset Bearing value for fleet.
ConditionOne INTEGER - allowed* 0 Label only. Condition One value for fleet.
ConditionTwo INTEGER - allowed* 0 Label only. Condition Two value for fleet.
ConditionalOrderOne INTEGER - allowed* 0 Label only. Conditional Order One value for fleet.
ConditionalOrderTwo INTEGER - allowed* 0 Label only. Conditional Order Two value for fleet.
AvoidDanger Boolean - allowed* none Label only. Avoid Danger selection for fleet.
AvoidAlienSystems Boolean - allowed* none Label only. Avoid Alien Systems selection for fleet.
NPROperationalGroupID INTEGER - allowed* 0 Label only. NPR Operational Group ID identifier or catalogue selection for fleet.
DisplaySensors Boolean - allowed* none Label only. Display Sensors selection for fleet.
DisplayWeapons Boolean - allowed* none Label only. Display Weapons selection for fleet.
AssignedFormationID INTEGER - allowed* 0 Label only. Assigned Formation ID identifier or catalogue selection for fleet.
ShippingLine INTEGER - allowed* 0 Label only. Shipping Line value for fleet.
UseMaximumSpeed Boolean - allowed* TRUE Label only. Use Maximum Speed selection for fleet.
RedeployOrderGiven Boolean - allowed* FALSE Label only. Redeploy Order Given selection for fleet.
MaxStandingOrderDistance INTEGER - allowed* 0 Label only. Max Standing Order Distance value for fleet.
NoSurrender Boolean - allowed* FALSE Label only. No Surrender selection for fleet.
SpecificThreatID INTEGER - allowed* 0 Label only. Specific Threat ID identifier or catalogue selection for fleet.
AnchorFleetID INTEGER - allowed* 0 Label only. Anchor Fleet ID identifier or catalogue selection for fleet.
AnchorFleetDistance Double - allowed* 0 Label only. Anchor Fleet Distance value for fleet.
AnchorFleetBearingOffset Double - allowed* 0 Label only. Anchor Fleet Bearing Offset value for fleet.
GuardNearestHostileContact Boolean - allowed* FALSE Label only. Guard Nearest Hostile Contact selection for fleet.
UseAnchorDestination Boolean - allowed* FALSE Label only. Use Anchor Destination selection for fleet.
GuardNearestKnownWarship Boolean - allowed* FALSE Label only. Guard Nearest Known Warship selection for fleet.
AssumeJumpCapable Boolean - allowed* FALSE Label only. Assume Jump Capable selection for fleet.
LastTransitTime Double - allowed* 0 Simulation time of the last jump transit.
EscapeTimeRemaining Double - allowed* 0 Label only. Escape Time Remaining value for fleet.
LastFleetDamageTime Double - allowed* 0 Label only. Last Fleet Damage Time value for fleet.
DetachedStanding Boolean - NOT NULL FALSE Label only. Detached Standing selection for fleet.
DetachedConditional Boolean - allowed* FALSE Label only. Detached Conditional selection for fleet.
IncludeSquadrons Boolean - allowed* FALSE Label only. Include Squadrons selection for fleet.
IgnoreStanding Boolean - allowed* FALSE Label only. Ignore Standing selection for fleet.
IgnoreConditional Boolean - allowed* FALSE Label only. Ignore Conditional selection for fleet.
AutoLP Boolean - allowed* TRUE Label only. Auto LP selection for fleet.

FCT_FleetConditionalOrder

Section titled “FCT_FleetConditionalOrder”

Prioritised fleet conditional orders and triggering conditions.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in standing orders conditions and move actions.

Column SQL type Key NULL Default Meaning and relationships
FleetID INTEGER - allowed* 0 Fleet identifier. Related identity domain FCT_Fleet.FleetID.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
ConditionalOrderID INTEGER - allowed* 0 Conditional order in DIM_StandingOrders.
ConditionID INTEGER - allowed* 0 Triggering condition in DIM_Condition.
Priority INTEGER - allowed* 0 Priority value. Its ordering and scale belong to the activity described by this table.
CreateFWP INTEGER - allowed* 0 Label only. Create FWP value for fleet conditional order.

FCT_FleetHistory

Section titled “FCT_FleetHistory”

Dated narrative entries for fleets.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in history records.

Column SQL type Key NULL Default Meaning and relationships
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
FleetID INTEGER - allowed* NULL Fleet identifier. Related identity domain FCT_Fleet.FleetID.
Description TEXT - allowed* NULL Descriptive text for the row.
GameTime Double - allowed* NULL Simulation clock in seconds since the beginning of the game.

FCT_FleetStandingOrder

Section titled “FCT_FleetStandingOrder”

Prioritised standing orders assigned to fleets.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in standing orders conditions and move actions.

Column SQL type Key NULL Default Meaning and relationships
FleetID INTEGER - allowed* 0 Fleet identifier. Related identity domain FCT_Fleet.FleetID.
StandingOrderID INTEGER - allowed* 0 Standing order in DIM_StandingOrders.
Priority INTEGER - allowed* 0 Priority value. Its ordering and scale belong to the activity described by this table.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.

FCT_MoveOrderTemplate

Section titled “FCT_MoveOrderTemplate”

Individual movement instructions within reusable order templates.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in movement order templates.

Column SQL type Key NULL Default Meaning and relationships
OrderTemplateID INTEGER - allowed* NULL Parent movement order template in FCT_OrderTemplate.
PopulationID INTEGER - allowed* 0 Colony identifier. A population is a race-and-species colony on a system body. Related identity domain FCT_Population.PopulationID.
MinDistance Double - allowed* 0 Label only. Min Distance value for move order template.
OrbDistance INTEGER - allowed* 0 Label only. Orb Distance value for move order template.
MoveActionID INTEGER - allowed* 1 Action category in DIM_MoveAction.
NewSystemID INTEGER - allowed* 0 Label only. New System ID identifier or catalogue selection for move order template.
Description TEXT - allowed* NULL Descriptive text for the row.
OrderDelay INTEGER - allowed* NULL Label only. Order Delay value for move order template.
DestinationType INTEGER - allowed* NULL Destination category. It determines which kind of object DestinationID identifies.
DestinationID INTEGER - allowed* 0 Destination identifier interpreted together with DestinationType.
NewJumpPointID INTEGER - allowed* 0 Arrival-side jump point identifier for the movement template.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
DestinationItemID INTEGER - allowed* 0 Selected cargo or destination item identifier interpreted with DestinationItemType.
MaxItems INTEGER - allowed* 0 Label only. Max Items value for move order template.
MessageText TEXT - allowed* 0 Event or order message text.
LoadSubUnits Boolean - allowed* FALSE Label only. Load Sub Units selection for move order template.
MinQuantity Double - allowed* none Label only. Min Quantity value for move order template.
StartSystemID INTEGER - allowed* 0 Label only. Start System ID identifier or catalogue selection for move order template.
MoveIndex INTEGER - allowed* 0 Label only. Move Index value for move order template.
DestinationItemType INTEGER - allowed* none Category used to interpret the selected destination item.
SurveyPointsRequired Double - allowed* 0 Label only. Survey Points Required value for move order template.

FCT_MoveOrders

Section titled “FCT_MoveOrders”

Fleet movement orders, destination references, quantities and progress.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in movement and logistics.

Column SQL type Key NULL Default Meaning and relationships
MoveOrderID INTEGER PK 1 allowed* none Label only. Move Order ID identifier or catalogue selection for move orders.
GameID INTEGER - allowed* NULL Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
RaceID INTEGER - allowed* 0 Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
FleetID INTEGER - allowed* 0 Fleet identifier. Related identity domain FCT_Fleet.FleetID.
MoveActionID INTEGER - allowed* 1 Action category in DIM_MoveAction.
MoveOrder INTEGER - allowed* 0 Order sequence position within the fleet orders.
StartSystemID INTEGER - allowed* 0 Label only. Start System ID identifier or catalogue selection for move orders.
DestinationType INTEGER - allowed* NULL Destination category. It determines which kind of object DestinationID identifies.
DestinationID INTEGER - allowed* 0 Destination identifier interpreted together with DestinationType.
PopulationID INTEGER - allowed* 0 Colony identifier. A population is a race-and-species colony on a system body. Related identity domain FCT_Population.PopulationID.
DestinationItemType INTEGER - allowed* 0 Category used to interpret the selected destination item.
DestinationItemID INTEGER - allowed* 0 Selected cargo or destination item identifier interpreted with DestinationItemType.
MaxItems Double - allowed* 0 Label only. Max Items value for move orders.
OrderDelay INTEGER - allowed* 0 Label only. Order Delay value for move orders.
OrbDistance INTEGER - allowed* 0 Label only. Orb Distance value for move orders.
MinDistance Double - allowed* 0 Label only. Min Distance value for move orders.
NewSystemID INTEGER - allowed* 0 Label only. New System ID identifier or catalogue selection for move orders.
NewWarpPointID INTEGER - allowed* 0 Arrival-side jump point identifier for the movement order.
Description TEXT - allowed* NULL Descriptive text for the row.
Arrived Boolean - allowed* 0 Arrival state retained for the movement order.
SurveyPointsRequired Double - allowed* 0 Label only. Survey Points Required value for move orders.
TimeRequired INTEGER - allowed* 0 Label only. Time Required value for move orders.
MessageText TEXT - allowed* NULL Event or order message text.
LoadSubUnits Boolean - allowed* 0 Label only. Load Sub Units selection for move orders.
MinQuantity Double - allowed* 0 Label only. Min Quantity value for move orders.
OrderDelayRemaining INTEGER - allowed* 0 Label only. Order Delay Remaining value for move orders.

FCT_NavalAdminCommand

Section titled “FCT_NavalAdminCommand”

Naval administration hierarchy, location and assignment settings.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in naval administration and command.

Column SQL type Key NULL Default Meaning and relationships
NavalAdminCommandID INTEGER PK 1 NOT NULL 0 Label only. Naval Admin Command ID identifier or catalogue selection for naval admin command.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
RaceID INTEGER - allowed* 0 Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
PopulationID INTEGER - allowed* 0 Colony identifier. A population is a race-and-species colony on a system body. Related identity domain FCT_Population.PopulationID.
ParentAdminCommandID INTEGER - allowed* 0 Label only. Parent Admin Command ID identifier or catalogue selection for naval admin command.
AdminCommandName TEXT - allowed* NULL Label only. Admin Command Name text for naval admin command.
AdminCommandTypeID INTEGER - allowed* 0 Label only. Admin Command Type ID identifier or catalogue selection for naval admin command.
BonusOne INTEGER - allowed* 1 Label only. Bonus One value for naval admin command.
BonusTwo INTEGER - allowed* 13 Label only. Bonus Two value for naval admin command.
BonusThree INTEGER - allowed* 28 Label only. Bonus Three value for naval admin command.
AutoAssign Boolean - allowed* FALSE Label only. Auto Assign selection for naval admin command.
CommandPriority INTEGER - allowed* 1 Label only. Command Priority value for naval admin command.
MinimumRankPriority INTEGER - allowed* 10 Label only. Minimum Rank Priority value for naval admin command.
FleetNodeExpanded Boolean - allowed* TRUE Label only. Fleet Node Expanded selection for naval admin command.
ShipID INTEGER - allowed* 0 Individual ship identifier. Related identity domain FCT_Ship.ShipID.

FCT_OrderTemplate

Section titled “FCT_OrderTemplate”

Reusable movement order template identity and ownership.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in movement order templates.

Column SQL type Key NULL Default Meaning and relationships
OrderTemplateID INTEGER PK 1 allowed* none Label only. Order Template ID identifier or catalogue selection for order template.
TemplateName TEXT - allowed* NULL Reusable template name.
StartSystemID INTEGER - allowed* NULL Label only. Start System ID identifier or catalogue selection for order template.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
RaceID INTEGER - allowed* 0 Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.

FCT_Squadron

Section titled “FCT_Squadron”

Squadron identity and parent ship.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in fleet organisation subfleets squadrons and detachment.

Column SQL type Key NULL Default Meaning and relationships
SquadronID INTEGER - allowed* 0 Label only. Squadron ID identifier or catalogue selection for squadron.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
SquadronName TEXT - allowed* none Label only. Squadron Name text for squadron.
ParentShipID INTEGER - allowed* 0 Parent ship identifier.

FCT_StandingOrderTemplate

Section titled “FCT_StandingOrderTemplate”

Reusable standing order template identity and ownership.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in movement order templates.

Column SQL type Key NULL Default Meaning and relationships
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
RaceID INTEGER - allowed* 0 Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
TemplateName TEXT - allowed* none Reusable template name.
TemplateID INTEGER - allowed* 0 Label only. Template ID identifier or catalogue selection for standing order template.

FCT_StandingOrderTemplateOrder

Section titled “FCT_StandingOrderTemplateOrder”

Prioritised standing or conditional instructions within a reusable template.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in movement order templates.

Column SQL type Key NULL Default Meaning and relationships
TemplateID INTEGER - allowed* 0 Parent template in FCT_StandingOrderTemplate.
Priority INTEGER - allowed* 1 Priority value. Its ordering and scale belong to the activity described by this table.
OrderID INTEGER - allowed* 0 Standing or conditional order in DIM_StandingOrders.
ConditionID INTEGER - allowed* 0 Triggering condition in DIM_Condition.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
RaceID INTEGER - allowed* 0 Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
CreateFWP INTEGER - allowed* 0 Label only. Create FWP value for standing order template order.

FCT_SubFleets

Section titled “FCT_SubFleets”

Sub-fleet hierarchy and escort or anchor settings.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in fleet organisation subfleets squadrons and detachment.

Column SQL type Key NULL Default Meaning and relationships
SubFleetID INTEGER PK 1 NOT NULL 0 Sub-fleet identifier.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
RaceID INTEGER - allowed* 0 Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
ParentFleetID INTEGER - allowed* 0 Parent fleet identifier.
ParentSubFleetID INTEGER - allowed* 0 Parent sub-fleet identifier.
SubFleetName TEXT - allowed* NULL Label only. Sub Fleet Name text for sub fleets.
AnchorFleetID INTEGER - allowed* 0 Label only. Anchor Fleet ID identifier or catalogue selection for sub fleets.
SpecificThreatID INTEGER - allowed* 0 Label only. Specific Threat ID identifier or catalogue selection for sub fleets.
AnchorFleetDistance Double - allowed* 0 Label only. Anchor Fleet Distance value for sub fleets.
AnchorFleetBearingOffset INTEGER - allowed* 0 Label only. Anchor Fleet Bearing Offset value for sub fleets.
GuardNearestHostileContact Boolean - allowed* FALSE Label only. Guard Nearest Hostile Contact selection for sub fleets.
GuardNearestKnownWarship Boolean - allowed* FALSE Label only. Guard Nearest Known Warship selection for sub fleets.
UseAnchorDestination Boolean - allowed* FALSE Label only. Use Anchor Destination selection for sub fleets.

FCT_Waypoint

Section titled “FCT_Waypoint”

Waypoint identity, location and related fleet or jump point.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in waypoints points of interest and patrol routes.

Column SQL type Key NULL Default Meaning and relationships
WaypointID INTEGER PK 1 allowed* none Label only. Waypoint ID identifier or catalogue selection for waypoint.
GameID INTEGER - allowed* NULL Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
RaceID INTEGER - allowed* NULL Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
SystemID INTEGER - allowed* NULL Star system identifier. Related identity domain FCT_System.SystemID.
OrbitBodyID INTEGER - allowed* 0 Label only. Orbit Body ID identifier or catalogue selection for waypoint.
CreationTime Double - allowed* 0 Label only. Creation Time value for waypoint.
Xcor Double - allowed* NULL X coordinate. System-space and map-space coordinates must be interpreted in the context of this table.
Ycor Double - allowed* NULL Y coordinate. System-space and map-space coordinates must be interpreted in the context of this table.
Number INTEGER - allowed* 0 Stored number or count. The table purpose determines whether it is a label or a quantity.
WaypointType INTEGER - allowed* 0 Label only. Waypoint Type value for waypoint.
Name TEXT - allowed* none Name stored for the row. Name text is distinct from numeric identity.
JumpPointID INTEGER - allowed* 0 Jump point identifier.
FleetID INTEGER - allowed* 0 Fleet identifier. Related identity domain FCT_Fleet.FleetID.

Formation

Section titled “Formation”

Escort formation positions associated with ships and fleets.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in movement and logistics.

Column SQL type Key NULL Default Meaning and relationships
FormationID INTEGER PK 1 allowed* none Ground formation identifier.
EscortFleetID INTEGER - allowed* NULL Label only. Escort Fleet ID identifier or catalogue selection for formation.
ShipID INTEGER - allowed* NULL Individual ship identifier.
ProtectedFleetID INTEGER - allowed* NULL Label only. Protected Fleet ID identifier or catalogue selection for formation.
Distance INTEGER - allowed* NULL Label only. Distance value for formation.
OffsetBearing INTEGER - allowed* NULL Label only. Offset Bearing value for formation.
FleetName VARCHAR(50) - allowed* NULL Fleet name.

Ships, combat and recovery

Section titled “Ships, combat and recovery”

FCT_AcidAttack / FCT_ArmourDamage / FCT_DamageControlQueue / FCT_DamagedComponent / FCT_DecoyAssignment / FCT_ECCMAssignment / FCT_FireControlAssignment / FCT_Lifepods / FCT_Missile / FCT_MissileAssignment / FCT_MissileSalvo / FCT_Ship / FCT_ShipCargo / FCT_ShipHistory / FCT_ShipMeasurement / FCT_ShipMeasurementOld / FCT_ShipOrdnanceTemplate / FCT_ShipTechData / FCT_ShipWeapon / FCT_Survivors / FCT_WeaponAssignment / FCT_WeaponRecharge / FCT_WreckComponents / FCT_WreckTech / FCT_Wrecks

FCT_AcidAttack

Section titled “FCT_AcidAttack”

Continuing armour damage assigned to a ship and an armour column.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in space combat resolution.

Column SQL type Key NULL Default Meaning and relationships
TargetShipID INTEGER - allowed* 0 Label only. Target Ship ID identifier or catalogue selection for acid attack.
ArmourColumn INTEGER - allowed* 0 Armour grid column receiving or retaining damage.
PointOfDamageTime INTEGER - allowed* 0 Label only. Point Of Damage Time value for acid attack.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
RemainingDamage INTEGER - allowed* 0 Label only. Remaining Damage value for acid attack.
LastDamageTime Double - allowed* 0 Label only. Last Damage Time value for acid attack.

FCT_ArmourDamage

Section titled “FCT_ArmourDamage”

Armour damage recorded per ship and armour column.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in space combat resolution.

Column SQL type Key NULL Default Meaning and relationships
ShipID INTEGER PK 1 allowed* NULL Individual ship identifier. Related identity domain FCT_Ship.ShipID.
ArmourColumn INTEGER PK 2 allowed* NULL Armour grid column receiving or retaining damage.
Damage INTEGER - allowed* NULL Label only. Damage value for armour damage.
GameID INTEGER - allowed* 16 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.

Indexes. sqlite_autoindex_FCT_ArmourDamage_1 (unique, ShipID, ArmourColumn).

FCT_DamageControlQueue

Section titled “FCT_DamageControlQueue”

The ordered component repair queue for a ship.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in ship readiness and recovery.

Column SQL type Key NULL Default Meaning and relationships
ShipID INTEGER - allowed* NULL Individual ship identifier. Related identity domain FCT_Ship.ShipID.
RepairOrder INTEGER - allowed* NULL Label only. Repair Order value for damage control queue.
GameID INTEGER - allowed* 16 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
ComponentID INTEGER - allowed* NULL Ship component design identifier. Related identity domain FCT_ShipDesignComponents.SDComponentID.

FCT_DamagedComponent

Section titled “FCT_DamagedComponent”

Damaged component quantities on individual ships.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in ship readiness and recovery.

Column SQL type Key NULL Default Meaning and relationships
ShipID INTEGER PK 1 NOT NULL 0 Individual ship identifier. Related identity domain FCT_Ship.ShipID.
ComponentID INTEGER PK 2 NOT NULL 0 Ship component design identifier. Related identity domain FCT_ShipDesignComponents.SDComponentID.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
Number INTEGER - allowed* 1 Number of damaged components of this design aboard the ship.

Indexes. sqlite_autoindex_FCT_DamagedComponent_1 (unique, ShipID, ComponentID).

FCT_DecoyAssignment

Section titled “FCT_DecoyAssignment”

Decoy launcher assignments on individual ships.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in point defence modes allocation and interception.

Column SQL type Key NULL Default Meaning and relationships
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
ShipID INTEGER - allowed* 0 Individual ship identifier. Related identity domain FCT_Ship.ShipID.
LauncherID INTEGER - allowed* 0 Label only. Launcher ID identifier or catalogue selection for decoy assignment.
LauncherNum INTEGER - allowed* 0 Label only. Launcher Num value for decoy assignment.

FCT_ECCMAssignment

Section titled “FCT_ECCMAssignment”

Electronic counter-countermeasure equipment assigned to fire controls.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in space combat resolution.

Column SQL type Key NULL Default Meaning and relationships
ShipID INTEGER - allowed* NULL Individual ship identifier. Related identity domain FCT_Ship.ShipID.
ECCMID INTEGER - allowed* NULL Label only. ECCMID identifier or catalogue selection for eccm assignment.
ECCMNum INTEGER - allowed* NULL Label only. ECCM Num value for eccm assignment.
FCTypeID INTEGER - allowed* 0 Fire control component design identifier.
FCNum INTEGER - allowed* NULL Instance number of that fire control aboard the ship.
GameID TEXT - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.

FCT_FireControlAssignment

Section titled “FCT_FireControlAssignment”

Fire control targets, open-fire settings and point defence settings.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in point defence modes allocation and interception.

Column SQL type Key NULL Default Meaning and relationships
ShipID INTEGER - allowed* NULL Individual ship identifier. Related identity domain FCT_Ship.ShipID.
GameID INTEGER - allowed* NULL Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
FCTypeID INTEGER - allowed* 0 Fire control component design identifier.
FCNum INTEGER - allowed* NULL Instance number of that fire control aboard the ship.
TargetID INTEGER - allowed* NULL Target identifier interpreted together with TargetType.
TargetType INTEGER - allowed* NULL Target category. It determines which kind of object TargetID identifies.
OpenFire Boolean - allowed* 0 Open-fire selection for the assigned fire control.
NodeExpand Boolean - allowed* 1 Label only. Node Expand selection for fire control assignment.
PointDefenceMode INTEGER - allowed* 0 Label only. Point Defence Mode value for fire control assignment.
PointDefenceRange INTEGER - allowed* 0 Label only. Point Defence Range value for fire control assignment.
FiredThisPhase Boolean - allowed* 0 Label only. Fired This Phase selection for fire control assignment.
PointDefencePriority INTEGER - allowed* 3 Label only. Point Defence Priority value for fire control assignment.
PDFireConcentration INTEGER - allowed* 3 Label only. PD Fire Concentration value for fire control assignment.
MinimumAMMRange Double - allowed* 0 Label only. Minimum AMM Range value for fire control assignment.

FCT_Lifepods

Section titled “FCT_Lifepods”

Lifepod locations, survivors and the originating ship’s identity.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in fleet recovery lifecycle.

Column SQL type Key NULL Default Meaning and relationships
LifepodID INTEGER PK 1 allowed* none Label only. Lifepod ID identifier or catalogue selection for lifepods.
GameID INTEGER - allowed* NULL Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
RaceID INTEGER - allowed* NULL Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
SpeciesID INTEGER - allowed* NULL Species identifier. Related identity domain FCT_Species.SpeciesID.
SystemID INTEGER - allowed* NULL Star system identifier. Related identity domain FCT_System.SystemID.
ClassID INTEGER - allowed* 0 Ship class identifier in FCT_ShipClass.
ShipName VARCHAR(50) - allowed* NULL Ship name.
Crew INTEGER - allowed* NULL Crew count. Designs hold a requirement while survivor records hold a surviving group.
Xcor DOUBLE - allowed* NULL X coordinate. System-space and map-space coordinates must be interpreted in the context of this table.
Ycor DOUBLE - allowed* NULL Y coordinate. System-space and map-space coordinates must be interpreted in the context of this table.
CreationTime DOUBLE - allowed* NULL Label only. Creation Time value for lifepods.
GradePoints DOUBLE - allowed* NULL Label only. Grade Points value for lifepods.

FCT_Missile

Section titled “FCT_Missile”

Individual missile numbering and remaining decoys within a salvo.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in space combat resolution.

Column SQL type Key NULL Default Meaning and relationships
MissileNumber INTEGER - allowed* 0 Label only. Missile Number value for missile.
RemainingDecoys INTEGER - allowed* 0 Label only. Remaining Decoys value for missile.
SalvoID INTEGER - allowed* 0 Missile salvo identifier.
GameID INTEGER - allowed* none Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.

FCT_MissileAssignment

Section titled “FCT_MissileAssignment”

Missile designs assigned to particular launchers.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in space combat resolution.

Column SQL type Key NULL Default Meaning and relationships
ShipID INTEGER - allowed* NULL Individual ship identifier. Related identity domain FCT_Ship.ShipID.
MissileID INTEGER - allowed* NULL Missile design identifier. Related identity domain FCT_MissileType.MissileID.
WeaponID INTEGER - allowed* NULL Weapon component design identifier.
WeaponNum INTEGER - allowed* NULL Instance number of that weapon aboard the ship.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.

FCT_MissileSalvo

Section titled “FCT_MissileSalvo”

Missile salvo identity, launch, target, guidance and movement state.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in space combat resolution.

Column SQL type Key NULL Default Meaning and relationships
MissileSalvoID INTEGER PK 1 allowed* none Missile salvo identifier.
GameID INTEGER - allowed* NULL Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
ShipID INTEGER - allowed* 0 Individual ship identifier. Related identity domain FCT_Ship.ShipID.
RaceID INTEGER - allowed* 0 Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
SystemID INTEGER - allowed* NULL Star system identifier. Related identity domain FCT_System.SystemID.
OrbitBodyID INTEGER - allowed* 0 Label only. Orbit Body ID identifier or catalogue selection for missile salvo.
MissileID INTEGER - allowed* NULL Missile design identifier. Related identity domain FCT_MissileType.MissileID.
MissileNum INTEGER - allowed* NULL Label only. Missile Num value for missile salvo.
LaunchTime Double - allowed* 1 Label only. Launch Time value for missile salvo.
FireControlID INTEGER - allowed* 0 Label only. Fire Control ID identifier or catalogue selection for missile salvo.
FCNum INTEGER - allowed* 0 Instance number of that fire control aboard the ship.
TargetID INTEGER - allowed* 0 Target identifier interpreted together with TargetType.
TargetType INTEGER - allowed* 0 Target category. It determines which kind of object TargetID identifies.
MissileSpeed INTEGER - allowed* 0 Label only. Missile Speed value for missile salvo.
ModifierToHit Double - allowed* 1 Label only. Modifier To Hit value for missile salvo.
Endurance Double - allowed* NULL Label only. Endurance value for missile salvo.
Xcor Double - allowed* NULL X coordinate. System-space and map-space coordinates must be interpreted in the context of this table.
Ycor Double - allowed* NULL Y coordinate. System-space and map-space coordinates must be interpreted in the context of this table.
LastXcor Double - allowed* NULL Previous X coordinate used to track movement.
LastYcor Double - allowed* NULL Previous Y coordinate used to track movement.
LastTargetX Double - allowed* 0 Label only. Last Target X value for missile salvo.
LastTargetY Double - allowed* 0 Label only. Last Target Y value for missile salvo.
IncrementStartX Double - allowed* 0 X coordinate at the start of the simulation increment.
IncrementStartY Double - allowed* 0 Y coordinate at the start of the simulation increment.
HomingMethod INTEGER - allowed* 0 Label only. Homing Method value for missile salvo.
CurrentDetonationRange Double - allowed* 0 Label only. Current Detonation Range value for missile salvo.

FCT_Ship

Section titled “FCT_Ship”

Individual ship identity, class, fleet, crew, fuel, damage and readiness state.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in ship readiness and recovery.

Column SQL type Key NULL Default Meaning and relationships
ShipID INTEGER PK 1 allowed* none Individual ship identifier.
GameID INTEGER - allowed* NULL Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
FleetID INTEGER - allowed* NULL Fleet identifier. Related identity domain FCT_Fleet.FleetID.
ShipName TEXT - allowed* NULL Ship name.
SubFleetID INTEGER - allowed* 0 Sub-fleet identifier. Related identity domain FCT_SubFleets.SubFleetID.
ActiveSensorsOn Boolean - allowed* 0 Whether active sensors are switched on.
AssignedMSID INTEGER - allowed* 0 Assigned mothership identifier.
Autofire INTEGER - allowed* 0 Automatic firing selection.
BoardingCombatClock INTEGER - allowed* 0 Accumulated boarding combat clock for the ship.
Constructed Double - allowed* 1 Ship construction date as simulation seconds, with 0 available for starting ships.
CrewMorale Double - allowed* 1 Current crew morale multiplier. A newly created ship starts at 1.
CurrentCrew INTEGER - allowed* 0 Crew currently aboard the ship.
CurrentShieldStrength Double - allowed* NULL Shield strength currently available on the individual ship.
DamageControlID INTEGER - allowed* 0 Label only. Damage Control ID identifier or catalogue selection for ship.
Destroyed Boolean - allowed* 0 Recorded destruction state. Its persistence depends on the type of record.
FireDelay INTEGER - allowed* 0 Firing delay retained after events such as a jump transit.
Fuel Double - allowed* 0 Fuel quantity.
GradePoints Double - allowed* 0 Accumulated crew grade points.
HoldTechData INTEGER - allowed* 0 Whether the ship holds recoverable technology information.
KillTonnageCommercial INTEGER - allowed* 0 Label only. Kill Tonnage Commercial value for ship.
KillTonnageMilitary INTEGER - allowed* 0 Label only. Kill Tonnage Military value for ship.
LastLaunchTime Double - allowed* 0 Simulation time of the last small-craft launch.
LastOverhaul Double - allowed* 0 Simulation time used as the maintenance-age baseline. Maintenance can advance it without replacing the ship.
LastShoreLeave Double - allowed* 0 Simulation time used as the crew deployment baseline.
LaunchMorale Double - allowed* 0 Crew morale retained when the craft launches.
MaintenanceState INTEGER - allowed* 0 Maintenance state selection. Operational is 0 and under maintenance is 2.
MothershipID INTEGER - allowed* 0 Mothership identifier.
RaceID INTEGER - allowed* NULL Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
RefuelPriority INTEGER - allowed* 0 Refuelling priority selection.
RefuelStatus INTEGER - allowed* 0 Refuelling eligibility or status selection.
ScrapFlag Boolean - allowed* 0 Whether the ship is marked for scrapping.
SensorDelay INTEGER - allowed* 0 Sensor delay retained after events such as a jump transit.
ShieldsActive Boolean - allowed* 0 Whether the ship has its shields switched on.
ShipClassID INTEGER - allowed* NULL Ship class identifier. Related identity domain FCT_ShipClass.ShipClassID.
ShipFuelEfficiency Double - allowed* NULL Stored ship fuel-efficiency value. Ship class fuel efficiency is recorded separately.
ShipNotes TEXT - allowed* none Free-text notes for the individual ship.
ShippingLineID INTEGER - allowed* 0 Civilian shipping line identifier. Related identity domain FCT_ShippingLines.ShippingLineID.
SpeciesID INTEGER - allowed* NULL Species identifier. Related identity domain FCT_Species.SpeciesID.
SyncFire INTEGER - allowed* 0 Synchronised firing selection.
TFPoints Double - allowed* 0 Fleet training points carried by this ship.
TransponderActive INTEGER - allowed* 0 Transponder mode selection.
OrdnanceTransferStatus INTEGER - allowed* 0 Ordnance transfer eligibility or status selection.
HangarLoadType INTEGER - allowed* 0 Small-craft hangar loading selection.
ResupplyPriority INTEGER - allowed* 0 Maintenance resupply priority selection.
CurrentMaintSupplies Double - allowed* 0 Maintenance supplies currently carried by the ship, in MSP.
AutomatedDamageControl Boolean - allowed* 1 Whether automatic damage control is enabled.
TractorTargetShipID INTEGER - allowed* 0 Ship being towed.
TractorTargetShipyardID INTEGER - allowed* 0 Shipyard being towed.
TractorParentShipID INTEGER - allowed* 0 Ship providing the tow.
OverhaulFactor Double - allowed* 1 Overhaul capability factor. This is separate from maintenance age, damage and operational state.
BioEnergy Double - allowed* 0 Bioenergy currently held by the ship.
LastMissileHitTime Double - allowed* 0 Simulation time of the last missile hit.
LastBeamHitTime Double - allowed* 0 Simulation time of the last beam hit.
LastShipDamageTime Double - allowed* 0 Simulation time of the last damage to the ship.
LastPenetratingDamageTime Double - allowed* 0 Simulation time of the last penetrating damage.
AssignedFormationID INTEGER - allowed* 0 Label only. Assigned Formation ID identifier or catalogue selection for ship.
DistanceTravelled Double - allowed* 0 Distance accumulated by the individual ship.
HullNumber INTEGER - allowed* 0 Display hull number. This is separate from ShipID.
ParentSquadronID INTEGER - allowed* 0 Parent squadron identifier.
AssignedSquadronID INTEGER - allowed* 0 Squadron assignment identifier.
LastTransitTime Double - allowed* 0 Simulation time of the last jump transit.
LastFiringTime Double - allowed* 0 Simulation time of the last firing.
ResupplyStatus INTEGER - allowed* 0 Maintenance resupply eligibility or status selection.
ActiveJammerOn Boolean - allowed* FALSE Stored active jammer selection.
DecoyThreshold INTEGER - allowed* 100 Label only. Decoy Threshold value for ship.
DesignateAsTarget INTEGER - allowed* 0 Label only. Designate As Target value for ship.
LoadDistance Double - allowed* 0 Label only. Load Distance value for ship.
SLRetire Boolean - allowed* FALSE Pending civilian shipping line replacement and scrapping selection.
MaxActiveResolution INTEGER - allowed* 1000 Label only. Max Active Resolution value for ship.

FCT_ShipCargo

Section titled “FCT_ShipCargo”

Cargo lots aboard ships and their cargo category or origin.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in movement and logistics.

Column SQL type Key NULL Default Meaning and relationships
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
ShipID INTEGER - allowed* 0 Individual ship identifier. Related identity domain FCT_Ship.ShipID.
CargoTypeID Numeric - allowed* NULL Cargo category. It determines the meaning of CargoID and Amount.
CargoID INTEGER - allowed* 0 Cargo item identifier interpreted together with CargoTypeID.
Amount Double - allowed* 0 Quantity or measured value. The table purpose and any type selector determine what is counted.
SpeciesID INTEGER - allowed* 0 Species identifier. Related identity domain FCT_Species.SpeciesID.
StartingPop INTEGER - allowed* 0 Origin colony identifier recorded for this cargo lot.
Neutral Boolean - allowed* 0 Neutral cargo selection retained with this cargo lot.

FCT_ShipHistory

Section titled “FCT_ShipHistory”

Dated narrative entries for ships.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in history records.

Column SQL type Key NULL Default Meaning and relationships
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
ShipID INTEGER - allowed* NULL Individual ship identifier. Related identity domain FCT_Ship.ShipID.
Description TEXT - allowed* NULL Descriptive text for the row.
GameTime Double - allowed* NULL Simulation clock in seconds since the beginning of the game.

FCT_ShipMeasurement

Section titled “FCT_ShipMeasurement”

Recorded ship achievement measurements.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in medals and achievement conditions.

Column SQL type Key NULL Default Meaning and relationships
ShipID INTEGER - allowed* 0 Individual ship identifier. Related identity domain FCT_Ship.ShipID.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
MeasurementType INTEGER - allowed* 0 Achievement measurement category. The amount is interpreted within that category.
Amount Double - allowed* 0 Quantity or measured value. The table purpose and any type selector determine what is counted.
StrikeGroup Boolean - allowed* FALSE Label only. Strike Group selection for ship measurement.

FCT_ShipMeasurementOld

Section titled “FCT_ShipMeasurementOld”

An older ship measurement layout retained alongside FCT_ShipMeasurement.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in space combat resolution.

Column SQL type Key NULL Default Meaning and relationships
ShipID INTEGER - allowed* 0 Individual ship identifier. Related identity domain FCT_Ship.ShipID.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
MeasurementType INTEGER - allowed* 0 Achievement measurement category. The amount is interpreted within that category.
Amount Double - allowed* 0 Quantity or measured value. The table purpose and any type selector determine what is counted.
StrikeGroup Boolean - allowed* FALSE Label only. Strike Group selection for ship measurement old.

FCT_ShipOrdnanceTemplate

Section titled “FCT_ShipOrdnanceTemplate”

Desired ordnance quantities assigned to individual ships.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in movement and logistics.

Column SQL type Key NULL Default Meaning and relationships
ShipID INTEGER - allowed* 0 Individual ship identifier. Related identity domain FCT_Ship.ShipID.
MissileID INTEGER - allowed* 0 Missile design identifier. Related identity domain FCT_MissileType.MissileID.
Amount INTEGER - allowed* 0 Quantity or measured value. The table purpose and any type selector determine what is counted.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.

FCT_ShipTechData

Section titled “FCT_ShipTechData”

Recoverable technology data carried by ships.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in salvage and archaeology.

Column SQL type Key NULL Default Meaning and relationships
ShipID INTEGER PK 1 allowed* NULL Individual ship identifier. Related identity domain FCT_Ship.ShipID.
TechID INTEGER PK 2 allowed* NULL Technology identifier. Related identity domain FCT_TechSystem.TechSystemID.
GameID INTEGER - allowed* NULL Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
TechPoints Double - allowed* NULL Label only. Tech Points value for ship tech data.

Indexes. sqlite_autoindex_FCT_ShipTechData_1 (unique, ShipID, TechID).

FCT_ShipWeapon

Section titled “FCT_ShipWeapon”

Missile stockpiles aboard individual ships.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in space combat resolution.

Column SQL type Key NULL Default Meaning and relationships
GameID INTEGER - allowed* NULL Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
ShipID INTEGER - allowed* NULL Individual ship identifier. Related identity domain FCT_Ship.ShipID.
MissileID INTEGER - allowed* NULL Missile design identifier. Related identity domain FCT_MissileType.MissileID.
Amount INTEGER - allowed* NULL Number of missiles of the selected design aboard the ship.

FCT_Survivors

Section titled “FCT_Survivors”

Survivor groups carried by rescue ships.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in fleet recovery lifecycle.

Column SQL type Key NULL Default Meaning and relationships
GameID INTEGER - allowed* NULL Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
RaceID INTEGER - allowed* NULL Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
SpeciesID INTEGER - allowed* NULL Species identifier. Related identity domain FCT_Species.SpeciesID.
ShipID INTEGER - allowed* NULL Individual ship identifier. Related identity domain FCT_Ship.ShipID.
Crew INTEGER - allowed* 0 Crew count. Designs hold a requirement while survivor records hold a surviving group.

FCT_WeaponAssignment

Section titled “FCT_WeaponAssignment”

Weapons assigned to particular fire controls.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in space combat resolution.

Column SQL type Key NULL Default Meaning and relationships
ShipID INTEGER - allowed* NULL Individual ship identifier. Related identity domain FCT_Ship.ShipID.
WeaponID INTEGER - allowed* NULL Weapon component design identifier.
WeaponNum INTEGER - allowed* NULL Instance number of that weapon aboard the ship.
FCTypeID INTEGER - allowed* 0 Fire control component design identifier.
FCNum INTEGER - allowed* NULL Instance number of that fire control aboard the ship.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.

FCT_WeaponRecharge

Section titled “FCT_WeaponRecharge”

Recharge time remaining for individual ship weapons.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in space combat resolution.

Column SQL type Key NULL Default Meaning and relationships
GameID INTEGER - allowed* NULL Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
ShipID INTEGER - allowed* NULL Individual ship identifier. Related identity domain FCT_Ship.ShipID.
WeaponID INTEGER - allowed* NULL Weapon component design identifier.
WeaponNumber INTEGER - allowed* 1 Instance number of that weapon aboard the ship.
RechargeRemaining Double - allowed* 0 Recharge time still required before the weapon or element can fire again.

FCT_WreckComponents

Section titled “FCT_WreckComponents”

Recoverable components remaining in wrecks.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in salvage and archaeology.

Column SQL type Key NULL Default Meaning and relationships
WreckID INTEGER PK 1 NOT NULL none Wreck identifier. Related identity domain FCT_Wrecks.WreckID.
ComponentID INTEGER PK 2 NOT NULL none Ship component design identifier. Related identity domain FCT_ShipDesignComponents.SDComponentID.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
Amount INTEGER - allowed* NULL Quantity or measured value. The table purpose and any type selector determine what is counted.

Indexes. sqlite_autoindex_FCT_WreckComponents_1 (unique, WreckID, ComponentID).

FCT_WreckTech

Section titled “FCT_WreckTech”

Recoverable technology information remaining in wrecks.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in salvage and archaeology.

Column SQL type Key NULL Default Meaning and relationships
GameID INTEGER - allowed* NULL Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
WreckID INTEGER - allowed* NULL Wreck identifier. Related identity domain FCT_Wrecks.WreckID.
TechID INTEGER - allowed* NULL Technology identifier. Related identity domain FCT_TechSystem.TechSystemID.
Percentage INTEGER - allowed* NULL Allocation percentage for the activity.

FCT_Wrecks

Section titled “FCT_Wrecks”

Wreck identity, location, size and recoverable minerals.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in salvage and archaeology.

Column SQL type Key NULL Default Meaning and relationships
WreckID INTEGER PK 1 allowed* none Wreck identifier.
GameID INTEGER - allowed* NULL Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
RaceID INTEGER - allowed* NULL Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
SystemID INTEGER - allowed* NULL Star system identifier. Related identity domain FCT_System.SystemID.
OrbitBodyID INTEGER - allowed* 0 Label only. Orbit Body ID identifier or catalogue selection for wrecks.
ClassID INTEGER - allowed* NULL Ship class identifier in FCT_ShipClass.
Size Double - allowed* 0 Label only. Size value for wrecks.
EffectiveSize INTEGER - allowed* 0 Label only. Effective Size value for wrecks.
INTEGER - allowed* 0 Label only.
QueenStatus INTEGER - allowed* 0 Label only. Queen Status value for wrecks.
Xcor Double - allowed* NULL X coordinate. System-space and map-space coordinates must be interpreted in the context of this table.
Ycor Double - allowed* NULL Y coordinate. System-space and map-space coordinates must be interpreted in the context of this table.
Duranium Double - allowed* 0 Duranium quantity in tons.
Neutronium Double - allowed* 0 Neutronium quantity in tons.
Corbomite Double - allowed* 0 Corbomite quantity in tons.
Tritanium Double - allowed* 0 Tritanium quantity in tons.
Boronide Double - allowed* 0 Boronide quantity in tons.
Mercassium Double - allowed* 0 Mercassium quantity in tons.
Vendarite Double - allowed* 0 Vendarite quantity in tons.
Sorium Double - allowed* 0 Sorium quantity in tons.
Uridium Double - allowed* 0 Uridium quantity in tons.
Corundium Double - allowed* 0 Corundium quantity in tons.
Gallicite Double - allowed* 0 Gallicite quantity in tons.
ShipID INTEGER - allowed* 0 Individual ship identifier. Related identity domain FCT_Ship.ShipID.

Ground forces

Section titled “Ground forces”

DIM_GroundComponentType / DIM_GroundUnitArmour / DIM_GroundUnitBaseType / DIM_GroundUnitCapability / FCT_ElementRecharge / FCT_GroundUnitCapability / FCT_GroundUnitClass / FCT_GroundUnitFormation / FCT_GroundUnitFormationElement / FCT_GroundUnitFormationElementTemplates / FCT_GroundUnitFormationTemplate / FCT_GroundUnitSeries / FCT_GroundUnitSeriesClass / FCT_GroundUnitTraining / FCT_GroundUnitTrainingQueue / FCT_OrganizationNode / FCT_RaceGroundCombat

DIM_GroundComponentType

Section titled “DIM_GroundComponentType”

Ground equipment definitions and eligible chassis types.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in ground force organisation.

Column SQL type Key NULL Default Meaning and relationships
Size Double - allowed* 0 Label only. Size value for ground component type.
Static Boolean - allowed* False Label only. Static selection for ground component type.
Infantry Boolean - allowed* False Label only. Infantry selection for ground component type.
Vehicle Boolean - allowed* False Label only. Vehicle selection for ground component type.
SuperHeavyVehicle Boolean - allowed* False Label only. Super Heavy Vehicle selection for ground component type.
Penetration Double - allowed* 0 Label only. Penetration value for ground component type.
Damage Double - allowed* 0 Label only. Damage value for ground component type.
Shots INTEGER - allowed* 0 Label only. Shots value for ground component type.
TechSystemID INTEGER - allowed* 0 Technology identifier.
ComponentName TEXT - allowed* none Label only. Component Name text for ground component type.
ComponentTypeID INTEGER PK 1 allowed* 0 Component category identifier. Ground equipment and ship equipment use different catalogues.
Abbreviation TEXT - allowed* none Short display name or abbreviation.
HeavyVehicle Boolean - allowed* none Label only. Heavy Vehicle selection for ground component type.
UltraHeavyVehicle Boolean - allowed* none Label only. Ultra Heavy Vehicle selection for ground component type.
STO INTEGER - allowed* none Label only. STO value for ground component type.
Construction Double - allowed* none Label only. Construction value for ground component type.
FireDirection INTEGER - allowed* none Label only. Fire Direction value for ground component type.
HQMaxSize INTEGER - allowed* none Label only. HQ Max Size value for ground component type.
LightVehicle Boolean - allowed* False Label only. Light Vehicle selection for ground component type.
BombardmentWeapon INTEGER - allowed* False Label only. Bombardment Weapon value for ground component type.
Geosurvey Double - allowed* 0 Label only. Geosurvey value for ground component type.
LogisticsPoints INTEGER - allowed* 0 Label only. Logistics Points value for ground component type.
SupplyUse Double - allowed* 0 Label only. Supply Use value for ground component type.
AAWeapon INTEGER - allowed* 0 Label only. AA Weapon value for ground component type.
DisplayOrder INTEGER - allowed* 0 Ordering value for the related game display.
Xenoarchaeology Double - allowed* 0 Label only. Xenoarchaeology value for ground component type.
Decontamination Double - allowed* 0 Label only. Decontamination value for ground component type.
GroundWeapon Boolean - allowed* FALSE Label only. Ground Weapon selection for ground component type.

DIM_GroundUnitArmour

Section titled “DIM_GroundUnitArmour”

Ground armour definitions and their technology requirements.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in ground force organisation.

Column SQL type Key NULL Default Meaning and relationships
TechSystemID INTEGER - allowed* 0 Technology identifier.
Name TEXT - allowed* none Name stored for the row. Name text is distinct from numeric identity.
ArmourStrength Double - allowed* 0 Label only. Armour Strength value for ground unit armour.
BaseUnitType INTEGER - allowed* 0 Label only. Base Unit Type value for ground unit armour.
ArmourTypeID INTEGER - allowed* 0 Label only. Armour Type ID identifier or catalogue selection for ground unit armour.

DIM_GroundUnitBaseType

Section titled “DIM_GroundUnitBaseType”

Ground chassis definitions, size, hit points and equipment slots.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in ground force organisation.

Column SQL type Key NULL Default Meaning and relationships
Name TEXT - allowed* none Name stored for the row. Name text is distinct from numeric identity.
HitPoints INTEGER - allowed* 1 Label only. Hit Points value for ground unit base type.
MaxSelfFortification Double - allowed* 1 Label only. Max Self Fortification value for ground unit base type.
MaxFortification Double - allowed* 1 Label only. Max Fortification value for ground unit base type.
UnitBaseTypeID INTEGER - allowed* 0 Label only. Unit Base Type ID identifier or catalogue selection for ground unit base type.
Size INTEGER - allowed* 0 Label only. Size value for ground unit base type.
TechSystemID INTEGER - allowed* none Technology identifier.
Abbreviation TEXT - allowed* none Short display name or abbreviation.
ToHitModifier Double - allowed* 1 Label only. To Hit Modifier value for ground unit base type.
ComponentSlots INTEGER - allowed* 1 Label only. Component Slots value for ground unit base type.
DisplayOrder INTEGER - allowed* 0 Ordering value for the related game display.

DIM_GroundUnitCapability

Section titled “DIM_GroundUnitCapability”

Additional ground unit capabilities and their cost and hit-point effects.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in ground force organisation.

Column SQL type Key NULL Default Meaning and relationships
CapabilityID INTEGER - allowed* none Label only. Capability ID identifier or catalogue selection for ground unit capability.
CapabilityName TEXT - allowed* none Label only. Capability Name text for ground unit capability.
TechSystemID INTEGER - allowed* none Technology identifier.
InfantryOnly Boolean - allowed* none Label only. Infantry Only selection for ground unit capability.
CostMultiplier Double - allowed* 1 Label only. Cost Multiplier value for ground unit capability.
HPEnhancement Double - allowed* 0 Label only. HP Enhancement value for ground unit capability.

FCT_ElementRecharge

Section titled “FCT_ElementRecharge”

Recharge time remaining for a ground formation element.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in ground combat and conquest.

Column SQL type Key NULL Default Meaning and relationships
GameID INTEGER - allowed* none Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
ElementID INTEGER - allowed* 0 Ground formation element identifier. Related identity domain FCT_GroundUnitFormationElement.ElementID.
RechargeRemaining INTEGER - allowed* 0 Recharge time still required before the weapon or element can fire again.

FCT_GroundUnitCapability

Section titled “FCT_GroundUnitCapability”

Additional capabilities assigned to ground unit classes.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in ground force organisation.

Column SQL type Key NULL Default Meaning and relationships
GroundUnitClassID INTEGER - allowed* none Ground unit class identifier. Related identity domain FCT_GroundUnitClass.GroundUnitClassID.
CapabilityID INTEGER - allowed* 0 Label only. Capability ID identifier or catalogue selection for ground unit capability.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.

FCT_GroundUnitClass

Section titled “FCT_GroundUnitClass”

Ground unit designs, equipment, costs and combat statistics.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in ground force organisation.

Column SQL type Key NULL Default Meaning and relationships
BaseType INTEGER - allowed* none Label only. Base Type value for ground unit class.
GroundUnitClassID INTEGER PK 1 allowed* 0 Ground unit class identifier.
TechSystemID INTEGER - allowed* 0 Technology identifier. Related identity domain FCT_TechSystem.TechSystemID.
ClassName TEXT - allowed* none Design class name.
ArmourType INTEGER - allowed* 0 Label only. Armour Type value for ground unit class.
ComponentA INTEGER - allowed* -1 Label only. Component A value for ground unit class.
ComponentB INTEGER - allowed* -1 Label only. Component B value for ground unit class.
ComponentC INTEGER - allowed* -1 Label only. Component C value for ground unit class.
ArmourStrengthModifier Double - allowed* 1 Label only. Armour Strength Modifier value for ground unit class.
WeaponStrengthModifier Double - allowed* 1 Label only. Weapon Strength Modifier value for ground unit class.
Size Double - allowed* 0 Label only. Size value for ground unit class.
Cost Double - allowed* 0 Build or development cost for the design or definition.
GameID INTEGER - allowed* none Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
STOWeapon INTEGER - allowed* -1 Label only. STO Weapon value for ground unit class.
ComponentD INTEGER - allowed* -1 Label only. Component D value for ground unit class.
TrackingSpeed INTEGER - allowed* 0 Weapon or fire-control tracking speed.
Duranium Double - allowed* 0 Duranium mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Neutronium Double - allowed* 0 Neutronium mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Corbomite Double - allowed* 0 Corbomite mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Tritanium Double - allowed* 0 Tritanium mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Boronide Double - allowed* 0 Boronide mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Mercassium Double - allowed* 0 Mercassium mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Vendarite Double - allowed* 0 Vendarite mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Sorium Double - allowed* 0 Sorium mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Uridium Double - allowed* 0 Uridium mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Corundium Double - allowed* 0 Corundium mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
Gallicite Double - allowed* 0 Gallicite mineral requirement or accounting quantity for this row. See the table’s related guide for the activity’s scale.
ECCM INTEGER - allowed* 0 Label only. ECCM value for ground unit class.
GUClassType INTEGER - allowed* 0 Label only. GU Class Type value for ground unit class.
UnitSupplyCost Double - allowed* 0 Label only. Unit Supply Cost value for ground unit class.
ActiveSensorRange INTEGER - allowed* 0 Label only. Active Sensor Range value for ground unit class.
SensorStrength Double - allowed* 0 Sensor strength rating.
RechargeTime INTEGER - allowed* 0 Label only. Recharge Time value for ground unit class.
MaxWeaponRange INTEGER - allowed* 0 Maximum weapon range.
MaxFireControlRange INTEGER - allowed* 0 Label only. Max Fire Control Range value for ground unit class.
ConstructionRating Double - allowed* 0 Label only. Construction Rating value for ground unit class.
HQCapacity INTEGER - allowed* 0 Label only. HQ Capacity value for ground unit class.
NonCombatClass Boolean - allowed* FALSE Label only. Non Combat Class selection for ground unit class.
ClassGroundUnitSeriesPriority INTEGER - allowed* 0 Label only. Class Ground Unit Series Priority value for ground unit class.
ClassGroundUnitSeries INTEGER - allowed* 0 Label only. Class Ground Unit Series value for ground unit class.
PointDefenceWeapon Boolean - allowed* FALSE Label only. Point Defence Weapon selection for ground unit class.

FCT_GroundUnitFormation

Section titled “FCT_GroundUnitFormation”

Ground formation identity, location, hierarchy and replacement settings.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in ground force organisation.

Column SQL type Key NULL Default Meaning and relationships
FormationID INTEGER PK 1 allowed* none Ground formation identifier.
Name TEXT - allowed* none Name stored for the row. Name text is distinct from numeric identity.
Abbreviation TEXT - allowed* none Short display name or abbreviation.
RaceID INTEGER - allowed* none Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
GameID INTEGER - allowed* none Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
OriginalTemplateID INTEGER - allowed* 0 Original formation template identifier.
PopulationID INTEGER - allowed* 0 Colony identifier. A population is a race-and-species colony on a system body. Related identity domain FCT_Population.PopulationID.
ShipID INTEGER - allowed* 0 Individual ship identifier. Related identity domain FCT_Ship.ShipID.
ParentFormationID INTEGER - allowed* 0 Parent ground formation identifier.
BoardingStatus INTEGER - allowed* 0 Label only. Boarding Status value for ground unit formation.
HideSubUnits Boolean - allowed* False Whether subordinate ground units are hidden in the display.
FieldPosition INTEGER - allowed* 0 Ground battlefield position selection.
RequiredRank INTEGER - allowed* 0 Label only. Required Rank value for ground unit formation.
AssignedFormationID INTEGER - allowed* 0 Label only. Assigned Formation ID identifier or catalogue selection for ground unit formation.
ActiveSensorsOn Boolean - allowed* false Whether active sensors are switched on.
Civilian Boolean - allowed* FALSE Label only. Civilian selection for ground unit formation.
ReplacementTemplateID INTEGER - allowed* 0 Template selected for ground formation replacements.
UseForReplacements Boolean - allowed* FALSE Whether the formation supplies replacement units.
ReplacementPriority INTEGER - allowed* 10 Ground formation replacement priority.
OrgLinkID INTEGER - allowed* 0 Label only. Org Link ID identifier or catalogue selection for ground unit formation.
DoNotRecover INTEGER - allowed* 0 Whether automatic recovery of this formation is disabled.

FCT_GroundUnitFormationElement

Section titled “FCT_GroundUnitFormationElement”

Unit quantities, supply, morale and combat settings within a formation.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in ground force organisation.

Column SQL type Key NULL Default Meaning and relationships
GameID INTEGER - allowed* none Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
FormationID INTEGER - allowed* none Ground formation identifier. Related identity domain FCT_GroundUnitFormation.FormationID.
Units INTEGER - allowed* none Number of units of the selected ground class.
ClassID INTEGER - allowed* none Ground unit class identifier in FCT_GroundUnitClass.
TemplateID INTEGER - allowed* none Formation template associated with this element, in FCT_GroundUnitFormationTemplate.
SpeciesID INTEGER - allowed* 0 Species identifier. Related identity domain FCT_Species.SpeciesID.
Morale INTEGER - allowed* 0 Current ground unit morale.
FortificationLevel Double - allowed* 1 Current fortification level of the ground element.
CurrentSupply INTEGER - allowed* 10 Supply points currently held by the ground element.
TargetSelection INTEGER - allowed* 0 Ground combat target-selection setting.
FiringDistribution INTEGER - allowed* 0 Ground combat distribution-of-fire setting.
ElementID INTEGER - allowed* 0 Ground formation element identifier.

FCT_GroundUnitFormationElementTemplates

Section titled “FCT_GroundUnitFormationElementTemplates”

Ground unit class quantities in formation templates.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in ground force organisation.

Column SQL type Key NULL Default Meaning and relationships
FormationTemplateID INTEGER - allowed* none Ground formation template identifier.
GameID INTEGER - allowed* none Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
ClassID INTEGER - allowed* none Ground unit class identifier in FCT_GroundUnitClass.
Units INTEGER - allowed* none Number of units of the selected ground class.

FCT_GroundUnitFormationTemplate

Section titled “FCT_GroundUnitFormationTemplate”

Reusable formation templates and their ownership or training history.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in ground force organisation.

Column SQL type Key NULL Default Meaning and relationships
GameID INTEGER - allowed* none Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
RaceID INTEGER - allowed* none Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
Name TEXT - allowed* none Name stored for the row. Name text is distinct from numeric identity.
Abbreviation TEXT - allowed* none Short display name or abbreviation.
TemplateID INTEGER - allowed* none Label only. Template ID identifier or catalogue selection for ground unit formation template.
RequiredRank INTEGER - allowed* 0 Label only. Required Rank value for ground unit formation template.
AutomatedTemplateID INTEGER - allowed* 0 Label only. Automated Template ID identifier or catalogue selection for ground unit formation template.
FormationsTrained INTEGER - allowed* 0 Label only. Formations Trained value for ground unit formation template.
Obsolete INTEGER - allowed* 0 Obsolete selection for this design or technology.

FCT_GroundUnitSeries

Section titled “FCT_GroundUnitSeries”

Ground unit design series names and ownership.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in ground force organisation.

Column SQL type Key NULL Default Meaning and relationships
GroundUnitSeriesID INTEGER - allowed* 0 Label only. Ground Unit Series ID identifier or catalogue selection for ground unit series.
Description TEXT - allowed* none Descriptive text for the row.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
RaceID INTEGER - allowed* 0 Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.

FCT_GroundUnitSeriesClass

Section titled “FCT_GroundUnitSeriesClass”

Prioritised ground unit classes belonging to a design series.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in ground force organisation.

Column SQL type Key NULL Default Meaning and relationships
GroundUnitSeriesID INTEGER - allowed* 0 Label only. Ground Unit Series ID identifier or catalogue selection for ground unit series class.
GroundUnitClassID INTEGER - allowed* 0 Ground unit class identifier. Related identity domain FCT_GroundUnitClass.GroundUnitClassID.
RaceID INTEGER - allowed* 0 Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
Priority INTEGER - allowed* 0 Priority value. Its ordering and scale belong to the activity described by this table.

FCT_GroundUnitTraining

Section titled “FCT_GroundUnitTraining”

Active ground formation training tasks and progress.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in production mechanics.

Column SQL type Key NULL Default Meaning and relationships
TaskID INTEGER PK 1 allowed* none Label only. Task ID identifier or catalogue selection for ground unit training.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
RaceID INTEGER - allowed* 0 Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
PopulationID INTEGER - allowed* 0 Colony identifier. A population is a race-and-species colony on a system body. Related identity domain FCT_Population.PopulationID.
TotalBP Double - allowed* 0 Total build points required for the task.
CompletedBP Double - allowed* 0 Build points already completed on the task.
FormationTemplateID INTEGER - allowed* 0 Ground formation template identifier.
FormationName TEXT - allowed* NULL Label only. Formation Name text for ground unit training.
TaskPercentage Double - allowed* 100 Assigned share of training capacity.
OrganizationLinkID INTEGER - allowed* 0 Label only. Organisation Link ID identifier or catalogue selection for ground unit training.
ParentLinkID INTEGER - allowed* 0 Label only. Parent Link ID identifier or catalogue selection for ground unit training.
FieldPosition INTEGER - allowed* 0 Ground battlefield position selection.

FCT_GroundUnitTrainingQueue

Section titled “FCT_GroundUnitTrainingQueue”

Queued ground formation training tasks.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in production mechanics.

Column SQL type Key NULL Default Meaning and relationships
FormationName TEXT - allowed* none Label only. Formation Name text for ground unit training queue.
FormationTemplateID INTEGER - allowed* 0 Ground formation template identifier.
GameID INTEGER - allowed* none Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
PopulationID INTEGER - allowed* none Colony identifier. A population is a race-and-species colony on a system body. Related identity domain FCT_Population.PopulationID.
QueueID INTEGER - allowed* none Label only. Queue ID identifier or catalogue selection for ground unit training queue.
TaskPercentage Double - allowed* 100 Assigned share of training capacity.
OrganizationLinkID INTEGER - allowed* 0 Label only. Organisation Link ID identifier or catalogue selection for ground unit training queue.
ParentLinkID INTEGER - allowed* 0 Label only. Parent Link ID identifier or catalogue selection for ground unit training queue.
FieldPosition INTEGER - allowed* 0 Ground battlefield position selection.

FCT_OrganizationNode

Section titled “FCT_OrganizationNode”

Ground organisation tree nodes and their parent or template links.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in ground force organisation.

Column SQL type Key NULL Default Meaning and relationships
OrganizationID INTEGER - allowed* 0 Label only. Organisation ID identifier or catalogue selection for organisation node.
OrganizationName TEXT - allowed* none Label only. Organisation Name text for organisation node.
RaceID INTEGER - allowed* 0 Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
ParentOrganizationID INTEGER - allowed* 0 Label only. Parent Organisation ID identifier or catalogue selection for organisation node.
FormationTemplateID INTEGER - allowed* 0 Ground formation template identifier.
NodeExpanded Boolean - allowed* FALSE Saved tree expansion selection.
FieldPosition INTEGER - allowed* 0 Ground battlefield position selection.

FCT_RaceGroundCombat

Section titled “FCT_RaceGroundCombat”

A race’s consecutive ground combat rounds on a body.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in ground combat and conquest.

Column SQL type Key NULL Default Meaning and relationships
RaceID INTEGER - allowed* none Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
SystemBodyID INTEGER - allowed* none System body identifier. Bodies include planets, moons, asteroids and comets. Related identity domain FCT_SystemBody.SystemBodyID.
ConsecutiveCombatRounds INTEGER - allowed* 1 Label only. Consecutive Combat Rounds value for race ground combat.
GameID INTEGER - allowed* none Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.

Commanders and honours

Section titled “Commanders and honours”

DIM_AssignmentTypeFilter / DIM_CommanderBonusType / DIM_MedalCondition / DIM_TraitGroup / DIM_TraitsList / FCT_Commander / FCT_CommanderBonuses / FCT_CommanderHistory / FCT_CommanderMeasurement / FCT_CommanderMedal / FCT_CommanderTraits / FCT_MedalConditionAssignment / FCT_RaceMedals / FCT_Ranks

DIM_AssignmentTypeFilter

Section titled “DIM_AssignmentTypeFilter”

Commander assignment categories and the kinds of post each category includes.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in commander lifecycle.

Column SQL type Key NULL Default Meaning and relationships
AssignmentTypeID INTEGER PK 1 allowed* NULL Label only. Assignment Type ID identifier or catalogue selection for assignment type filter.
LeaderType INTEGER - allowed* NULL Label only. Leader Type value for assignment type filter.
Description TEXT - allowed* NULL Descriptive text for the row.
DisplayOrder INTEGER - allowed* NULL Ordering value for the related game display.
Ship Numeric - allowed* NULL Label only. Ship value for assignment type filter.
Team Numeric - allowed* NULL Label only. Team value for assignment type filter.
Population Numeric - allowed* NULL Population amount. In FCT_Population this is measured in millions of people.
Sector Numeric - allowed* NULL Label only. Sector value for assignment type filter.
Ground Numeric - allowed* NULL Label only. Ground value for assignment type filter.
Fighter Numeric - allowed* NULL Label only. Fighter value for assignment type filter.
Armed Numeric - allowed* NULL Label only. Armed value for assignment type filter.
Freighters Numeric - allowed* NULL Label only. Freighters value for assignment type filter.
NavalAdmin Numeric - allowed* NULL Label only. Naval Admin value for assignment type filter.
Survey INTEGER - allowed* none Label only. Survey value for assignment type filter.
RankPriorityModifier INTEGER - allowed* none Label only. Rank Priority Modifier value for assignment type filter.
ShipCommandType INTEGER - allowed* none Label only. Ship Command Type value for assignment type filter.
Academy INTEGER - allowed* 0 Label only. Academy value for assignment type filter.

DIM_CommanderBonusType

Section titled “DIM_CommanderBonusType”

Commander bonus categories, eligible professions, display labels and bonus limits.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in commander lifecycle.

Column SQL type Key NULL Default Meaning and relationships
BonusID INTEGER - allowed* 0 Commander bonus category identifier.
Description TEXT - allowed* NULL Descriptive text for the row.
Percentage Numeric - allowed* NULL Allocation percentage for the activity.
Naval Numeric - allowed* NULL Label only. Naval value for commander bonus type.
Ground Numeric - allowed* NULL Label only. Ground value for commander bonus type.
Civilian Numeric - allowed* NULL Label only. Civilian value for commander bonus type.
Scientist Numeric - allowed* NULL Label only. Scientist value for commander bonus type.
DisplayOrder INTEGER - allowed* none Ordering value for the related game display.
BonusAbbrev TEXT - allowed* none Label only. Bonus Abbrev text for commander bonus type.
MaximumBonus Double - allowed* 0 Label only. Maximum Bonus value for commander bonus type.

DIM_MedalCondition

Section titled “DIM_MedalCondition”

Achievement conditions, measurement categories and required amounts.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in medals and achievement conditions.

Column SQL type Key NULL Default Meaning and relationships
MedalConditionID INTEGER - allowed* 0 Medal achievement condition identifier.
Description TEXT - allowed* none Descriptive text for the row.
MeasurementType INTEGER - allowed* 0 Achievement measurement category. The amount is interpreted within that category.
AmountRequired INTEGER - allowed* 1 Label only. Amount Required value for medal condition.
DisplayOrder INTEGER - allowed* 0 Ordering value for the related game display.

DIM_TraitGroup

Section titled “DIM_TraitGroup”

Commander trait groups and mutually opposed groups.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in commander lifecycle.

Column SQL type Key NULL Default Meaning and relationships
TraitGroupID INTEGER PK 1 allowed* NULL Commander trait group identifier.
Description VARCHAR(50) - allowed* NULL Descriptive text for the row.
Opposite1 INTEGER - allowed* NULL Label only. Opposite1 value for trait group.
Opposite2 INTEGER - allowed* NULL Label only. Opposite2 value for trait group.

DIM_TraitsList

Section titled “DIM_TraitsList”

Commander traits and their trait groups.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in commander lifecycle.

Column SQL type Key NULL Default Meaning and relationships
TraitID INTEGER PK 1 allowed* none Commander trait identifier.
GroupID INTEGER - allowed* 2 Label only. Group ID identifier or catalogue selection for traits list.
Name TEXT - allowed* NULL Name stored for the row. Name text is distinct from numeric identity.

FCT_Commander

Section titled “FCT_Commander”

Commander identity, service, rank, posting, retirement and prisoner state.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in commander lifecycle.

Column SQL type Key NULL Default Meaning and relationships
CommanderID INTEGER PK 1 allowed* none Commander identifier.
GameID INTEGER - allowed* NULL Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
RaceID INTEGER - allowed* NULL Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
SpeciesID INTEGER - allowed* NULL Species identifier. Related identity domain FCT_Species.SpeciesID.
Name TEXT - allowed* NULL Name stored for the row. Name text is distinct from numeric identity.
ResSpecID INTEGER - allowed* 0 Research field specialisation identifier.
CommanderType INTEGER - allowed* 0 Label only. Commander Type value for commander.
Title TEXT - allowed* NULL Label only. Title text for commander.
RankID INTEGER - allowed* 0 Commander rank identifier. Related identity domain FCT_Ranks.RankID.
PromotionScore INTEGER - allowed* 0 Label only. Promotion Score value for commander.
PopPromotionScore INTEGER - allowed* 0 Label only. Pop Promotion Score value for commander.
GameTimePromoted Double - allowed* 0 Simulation time of the commander’s last promotion.
GameTimeAssigned Double - allowed* 0 Simulation time of the commander’s current assignment.
DoNotRelieve INTEGER - allowed* 0 Whether automatic relief from the current posting is disabled.
CommandType INTEGER - allowed* 0 Posting category. It determines what CommandID identifies.
CommandID INTEGER - allowed* 0 Posting identifier interpreted together with CommandType.
PopLocationID INTEGER - allowed* 0 Colony where the commander is located.
TransportShipID INTEGER - allowed* 0 Ship transporting the commander.
Seniority INTEGER - allowed* 0 Label only. Seniority value for commander.
RetireStatus INTEGER - allowed* 0 Commander retirement status.
LifepodID INTEGER - allowed* 0 Label only. Lifepod ID identifier or catalogue selection for commander.
Orders TEXT - allowed* none Label only. Orders text for commander.
Notes TEXT - allowed* none Free-text notes associated with the row.
HomeworldID INTEGER - allowed* NULL Homeworld system body identifier.
POWRaceID INTEGER - allowed* 0 Race holding the commander as a prisoner.
CareerStart Double - allowed* 1 Commander career baseline as simulation seconds. This can be negative and is distinct from a birth date.
Deceased Boolean - allowed* 0 Whether the commander is deceased.
Loyalty INTEGER - allowed* 100 Label only. Loyalty value for commander.
HealthRisk INTEGER - allowed* NULL Label only. Health Risk value for commander.
Female Boolean - allowed* 0 Female name or commander selection.
KillTonnageCommercial INTEGER - allowed* 0 Label only. Kill Tonnage Commercial value for commander.
KillTonnageMilitary INTEGER - allowed* 0 Label only. Kill Tonnage Military value for commander.
EducationColony INTEGER - allowed* none Label only. Education Colony value for commander.
StoryCharacter Boolean - allowed* FALSE Whether the commander is marked as a story character.
DoNotPromote Boolean - allowed* FALSE Whether automatic promotion is disabled for this commander.
RetainRetired Boolean - allowed* FALSE Whether to retain this retired commander when saving.
Prisoner Boolean - allowed* FALSE Whether the commander is held as a prisoner.
Processed Boolean - allowed* FALSE Label only. Processed selection for commander.

FCT_CommanderBonuses

Section titled “FCT_CommanderBonuses”

Bonus values assigned to individual commanders.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in commander lifecycle.

Column SQL type Key NULL Default Meaning and relationships
CommanderID INTEGER - allowed* none Commander identifier. Related identity domain FCT_Commander.CommanderID.
BonusID INTEGER - allowed* none Commander bonus category identifier. Related identity domain DIM_CommanderBonusType.BonusID.
BonusValue Double - allowed* none Label only. Bonus Value value for commander bonuses.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.

FCT_CommanderHistory

Section titled “FCT_CommanderHistory”

Dated narrative entries in a commander’s career.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in history records.

Column SQL type Key NULL Default Meaning and relationships
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
CommanderID INTEGER - allowed* 0 Commander identifier. Related identity domain FCT_Commander.CommanderID.
HistoryText TEXT - allowed* NULL Narrative commander history text.
GameTime Double - allowed* none Simulation clock in seconds since the beginning of the game.

FCT_CommanderMeasurement

Section titled “FCT_CommanderMeasurement”

Recorded commander achievement measurements.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in medals and achievement conditions.

Column SQL type Key NULL Default Meaning and relationships
CommanderID INTEGER - allowed* none Commander identifier. Related identity domain FCT_Commander.CommanderID.
MeasurementType INTEGER - allowed* 0 Achievement measurement category. The amount is interpreted within that category.
Amount Double - allowed* 0 Quantity or measured value. The table purpose and any type selector determine what is counted.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.

FCT_CommanderMedal

Section titled “FCT_CommanderMedal”

Medals awarded to commanders and recorded reasons.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in medals and achievement conditions.

Column SQL type Key NULL Default Meaning and relationships
NumAwarded INTEGER - allowed* 1 Label only. Num Awarded value for commander medal.
MedalID INTEGER PK 1 allowed* NULL Race-defined medal identifier. Related identity domain FCT_RaceMedals.MedalID.
CommanderID INTEGER PK 2 allowed* NULL Commander identifier. Related identity domain FCT_Commander.CommanderID.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
AwardReason TEXT - allowed* none Label only. Award Reason text for commander medal.

Indexes. sqlite_autoindex_FCT_CommanderMedal_1 (unique, MedalID, CommanderID).

FCT_CommanderTraits

Section titled “FCT_CommanderTraits”

Traits assigned to commanders.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in commander lifecycle.

Column SQL type Key NULL Default Meaning and relationships
CmdrID INTEGER PK 1 allowed* NULL Commander identifier, using the shorter database spelling. Related identity domain FCT_Commander.CommanderID.
TraitID INTEGER PK 2 allowed* NULL Commander trait identifier. Related identity domain DIM_TraitsList.TraitID.
GameID INTEGER - allowed* 16 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.

Indexes. sqlite_autoindex_FCT_CommanderTraits_1 (unique, CmdrID, TraitID).

FCT_MedalConditionAssignment

Section titled “FCT_MedalConditionAssignment”

Achievement conditions attached to race-defined medals.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in medals and achievement conditions.

Column SQL type Key NULL Default Meaning and relationships
MedalConditionID INTEGER - allowed* 0 Medal achievement condition identifier. Related identity domain DIM_MedalCondition.MedalConditionID.
MedalID INTEGER - allowed* 0 Race-defined medal identifier. Related identity domain FCT_RaceMedals.MedalID.
GameID INTEGER - allowed* none Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.

FCT_RaceMedals

Section titled “FCT_RaceMedals”

Race-defined medals, names, points and presentation.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in medals and achievement conditions.

Column SQL type Key NULL Default Meaning and relationships
RaceID INTEGER - allowed* NULL Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
MedalFileName TEXT - allowed* NULL Label only. Medal File Name text for race medals.
MedalName TEXT - allowed* NULL Label only. Medal Name text for race medals.
MedalDescription TEXT - allowed* 'Award Details' Label only. Medal Description text for race medals.
MedalPoints INTEGER - allowed* 0 Label only. Medal Points value for race medals.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
MultipleAwards Boolean - allowed* 0 Label only. Multiple Awards selection for race medals.
MedalID INTEGER - allowed* 0 Race-defined medal identifier.
Abbreviation TEXT - allowed* none Short display name or abbreviation.

Indexes. RaceMedals_RaceID (non-unique, RaceID).

FCT_Ranks

Section titled “FCT_Ranks”

Race-defined commander ranks, priorities and professions.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in commander lifecycle.

Column SQL type Key NULL Default Meaning and relationships
RankID INTEGER PK 1 allowed* none Commander rank identifier.
RaceID INTEGER - allowed* 0 Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
RankName TEXT - allowed* NULL Label only. Rank Name text for ranks.
Priority INTEGER - allowed* 0 Priority value. Its ordering and scale belong to the activity described by this table.
RankType INTEGER - allowed* 0 Label only. Rank Type value for ranks.
RankAbbrev TEXT - allowed* NULL Label only. Rank Abbrev text for ranks.
GameID INTEGER - allowed* none Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.

Observation and intelligence

Section titled “Observation and intelligence”

FCT_AlienClass / FCT_AlienClassSensor / FCT_AlienClassTech / FCT_AlienClassWeapon / FCT_AlienGroundUnitClass / FCT_AlienPopulation / FCT_AlienRace / FCT_AlienRaceSensor / FCT_AlienRaceSpecies / FCT_AlienRaceSystemStatus / FCT_AlienShip / FCT_AlienSystem / FCT_Contacts / FCT_KnownRuinRace / FCT_KnownSpecies / FCT_RaceJumpPointSurvey / FCT_RaceSurveyLocation / FCT_RaceSysSurvey / FCT_STODetected / FCT_SystemBodyName / FCT_SystemBodySurveys

FCT_AlienClass

Section titled “FCT_AlienClass”

A viewing race’s knowledge and estimates of another race’s ship class.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in intelligence mechanics.

Column SQL type Key NULL Default Meaning and relationships
AlienClassID INTEGER - allowed* 0 Label only. Alien Class ID identifier or catalogue selection for alien class.
ActualClassID INTEGER - allowed* none Label only. Actual Class ID identifier or catalogue selection for alien class.
AlienRaceID INTEGER - allowed* 0 Label only. Alien Race ID identifier or catalogue selection for alien class.
ArmourStrength INTEGER - allowed* 0 Label only. Armour Strength value for alien class.
AverageDamage INTEGER - allowed* 0 Label only. Average Damage value for alien class.
ClassName TEXT - allowed* none Design class name.
FirstDetected Double - allowed* 0 Label only. First Detected value for alien class.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
HullID INTEGER - allowed* 0 Label only. Hull ID identifier or catalogue selection for alien class.
JumpDistance INTEGER - allowed* 0 Label only. Jump Distance value for alien class.
MaxSpeed INTEGER - allowed* 0 Label only. Max Speed value for alien class.
Notes TEXT - allowed* none Free-text notes associated with the row.
ShieldRecharge Double - allowed* 0 Label only. Shield Recharge value for alien class.
ShieldStrength INTEGER - allowed* 0 Shield capacity for the class or observed class.
ShipCount INTEGER - allowed* 0 Label only. Ship Count value for alien class.
Summary TEXT - allowed* none Label only. Summary text for alien class.
TCS INTEGER - allowed* 0 Observed target cross section.
ThermalSignature Double - allowed* 0 Label only. Thermal Signature value for alien class.
ViewRaceID INTEGER - allowed* 0 Viewing race. This row describes that race’s knowledge rather than universal information. Related identity domain FCT_Race.RaceID.
MaxEnergyPDShots INTEGER - allowed* 0 Label only. Max Energy PD Shots value for alien class.
AlienClassRole INTEGER - allowed* 0 Label only. Alien Class Role value for alien class.
ObservedMissileDefence Boolean - allowed* False Label only. Observed Missile Defence selection for alien class.
TotalEnergyPDHits INTEGER - allowed* 0 Label only. Total Energy PD Hits value for alien class.
TotalEnergyPDShots INTEGER - allowed* 0 Label only. Total Energy PD Shots value for alien class.
DiplomaticShip Boolean - allowed* FALSE Label only. Diplomatic Ship selection for alien class.
EngineType INTEGER - allowed* 0 Label only. Engine Type value for alien class.
ActiveJammerStrength Double - allowed* 0 Active-sensor jamming strength.
FireControlJammerStrength Double - allowed* 0 Fire-control jamming strength.
MissileJammerStrength Double - allowed* 0 Missile jamming strength.

FCT_AlienClassSensor

Section titled “FCT_AlienClassSensor”

Sensors associated with a known alien class.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in intelligence mechanics.

Column SQL type Key NULL Default Meaning and relationships
AlienClassID INTEGER - allowed* 0 Label only. Alien Class ID identifier or catalogue selection for alien class sensor.
AlienSensorID INTEGER - allowed* 0 Label only. Alien Sensor ID identifier or catalogue selection for alien class sensor.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.

FCT_AlienClassTech

Section titled “FCT_AlienClassTech”

Technology knowledge associated with a known alien class.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in intelligence mechanics.

Column SQL type Key NULL Default Meaning and relationships
AlienClassID INTEGER - allowed* NULL Label only. Alien Class ID identifier or catalogue selection for alien class tech.
TechID INTEGER - allowed* NULL Technology identifier.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows.

FCT_AlienClassWeapon

Section titled “FCT_AlienClassWeapon”

Observed weapons and weapon performance associated with a known alien class.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in intelligence mechanics.

Column SQL type Key NULL Default Meaning and relationships
GameID INTEGER - allowed* NULL Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
AlienClassID INTEGER - allowed* NULL Label only. Alien Class ID identifier or catalogue selection for alien class weapon.
WeaponID INTEGER - allowed* NULL Weapon component design identifier.
Amount INTEGER - allowed* NULL Quantity or measured value. The table purpose and any type selector determine what is counted.
Range Double - allowed* NULL Label only. Range value for alien class weapon.
ROF INTEGER - allowed* NULL Label only. ROF value for alien class weapon.
LastFired Double - allowed* 0 Label only. Last Fired value for alien class weapon.

FCT_AlienGroundUnitClass

Section titled “FCT_AlienGroundUnitClass”

A viewing race’s knowledge of an alien ground unit class.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in intelligence mechanics.

Column SQL type Key NULL Default Meaning and relationships
AlienRaceID INTEGER - allowed* 0 Label only. Alien Race ID identifier or catalogue selection for alien ground unit class.
ActualUnitClassID INTEGER - allowed* 0 Label only. Actual Unit Class ID identifier or catalogue selection for alien ground unit class.
ViewRaceID INTEGER - allowed* 0 Viewing race. This row describes that race’s knowledge rather than universal information. Related identity domain FCT_Race.RaceID.
Name TEXT - allowed* none Name stored for the row. Name text is distinct from numeric identity.
Hits INTEGER - allowed* 0 Label only. Hits value for alien ground unit class.
Penetrated INTEGER - allowed* 0 Label only. Penetrated value for alien ground unit class.
Destroyed INTEGER - allowed* 0 Recorded destruction state. Its persistence depends on the type of record.
AlienGroundUnitClassID INTEGER - allowed* none Label only. Alien Ground Unit Class ID identifier or catalogue selection for alien ground unit class.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
WeaponsKnown Boolean - allowed* FALSE Label only. Weapons Known selection for alien ground unit class.

FCT_AlienPopulation

Section titled “FCT_AlienPopulation”

A viewing race’s population and installation intelligence about a colony.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in intelligence mechanics.

Column SQL type Key NULL Default Meaning and relationships
ViewingRaceID INTEGER - allowed* 0 Viewing race. This row describes that race’s knowledge rather than universal information. Related identity domain FCT_Race.RaceID.
AlienRaceID INTEGER - allowed* 0 Label only. Alien Race ID identifier or catalogue selection for alien population.
PopulationID INTEGER - allowed* none Colony identifier. A population is a race-and-species colony on a system body. Related identity domain FCT_Population.PopulationID.
Installations INTEGER - allowed* 0 Label only. Installations value for alien population.
Mines INTEGER - allowed* 0 Label only. Mines value for alien population.
Factories INTEGER - allowed* 0 Label only. Factories value for alien population.
Refineries INTEGER - allowed* 0 Label only. Refineries value for alien population.
ResearchFacilities INTEGER - allowed* 0 Label only. Research Facilities value for alien population.
MaintenanceFacilities INTEGER - allowed* 0 Label only. Maintenance Facilities value for alien population.
GFTF INTEGER - allowed* 0 Label only. GFTF value for alien population.
Spaceport Boolean - allowed* none Label only. Spaceport selection for alien population.
NavalHeadquarters Boolean - allowed* none Label only. Naval Headquarters selection for alien population.
SectorCommand Boolean - allowed* none Label only. Sector Command selection for alien population.
RefuellingStation Boolean - allowed* none Label only. Refuelling Station selection for alien population.
OrdnanceTransfer Boolean - allowed* none Label only. Ordnance Transfer selection for alien population.
CargoStation Boolean - allowed* none Label only. Cargo Station selection for alien population.
AlienPopulationIntelligencePoints Double - allowed* 0 Label only. Alien Population Intelligence Points value for alien population.
PopulationAmount Double - allowed* 0 Population amount held in the observer’s colony intelligence.
PopulationName TEXT - allowed* none Label only. Population Name text for alien population.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
MaxIntelligence Double - allowed* 0 Label only. Max Intelligence value for alien population.
PreviousMaxIntelligence Double - allowed* 0 Label only. Previous Max Intelligence value for alien population.
ThermalSignature Double - allowed* 0 Label only. Thermal Signature value for alien population.
EMSignature Double - allowed* 0 Label only. EM Signature value for alien population.
WeaponRange Double - allowed* 0 Label only. Weapon Range value for alien population.

FCT_AlienRace

Section titled “FCT_AlienRace”

A viewing race’s diplomatic relationship and knowledge of another race.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in intelligence mechanics.

Column SQL type Key NULL Default Meaning and relationships
AlienRaceID INTEGER PK 1 allowed* 0 Label only. Alien Race ID identifier or catalogue selection for alien race.
ViewRaceID INTEGER PK 2 allowed* NULL Viewing race. This row describes that race’s knowledge rather than universal information. Related identity domain FCT_Race.RaceID.
GameID INTEGER - allowed* NULL Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
AlienRaceName TEXT - allowed* NULL Label only. Alien Race Name text for alien race.
FixedRelationship INTEGER - allowed* 0 Label only. Fixed Relationship value for alien race.
ClassThemeID INTEGER - allowed* 0 Label only. Class Theme ID identifier or catalogue selection for alien race.
FirstDetected Double - allowed* NULL Label only. First Detected value for alien race.
ContactStatus INTEGER - allowed* 0 Label only. Contact Status value for alien race.
Abbrev TEXT - allowed* NULL Short display name or abbreviation.
CommStatus INTEGER - allowed* 0 Label only. Comm Status value for alien race.
CommModifier Double - allowed* 0 Label only. Comm Modifier value for alien race.
CommEstablished Double - allowed* 0 Label only. Comm Established value for alien race.
DiplomaticPoints Double - allowed* 0 Label only. Diplomatic Points value for alien race.
TradeTreaty Boolean - allowed* NULL Label only. Trade Treaty selection for alien race.
TechTreaty Boolean - allowed* NULL Label only. Tech Treaty selection for alien race.
GeoTreaty Boolean - allowed* NULL Label only. Geo Treaty selection for alien race.
GravTreaty Boolean - allowed* NULL Label only. Grav Treaty selection for alien race.
RealClassNames INTEGER - allowed* 0 Label only. Real Class Names value for alien race.
AlienRaceIntelligencePoints Double - allowed* 0 Label only. Alien Race Intelligence Points value for alien race.
DamageCausedByAlienRace Double - allowed* 0 Label only. Damage Caused By Alien Race value for alien race.
RandomNameOrder INTEGER - allowed* 1 Label only. Random Name Order value for alien race.
PortraitShown Boolean - allowed* TRUE Label only. Portrait Shown selection for alien race.

Indexes. sqlite_autoindex_FCT_AlienRace_1 (unique, AlienRaceID, ViewRaceID).

FCT_AlienRaceSensor

Section titled “FCT_AlienRaceSensor”

Sensor intelligence held by a viewing race.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in intelligence mechanics.

Column SQL type Key NULL Default Meaning and relationships
GameID INTEGER - allowed* NULL Saved game identifier. Select the same game before combining game-specific rows.
Strength INTEGER - allowed* NULL Label only. Strength value for alien race sensor.
Resolution INTEGER - allowed* NULL Sensor resolution or contact resolution selection, according to the table.
Range Double - allowed* 0 Label only. Range value for alien race sensor.
IntelligencePoints Double - allowed* 0 Label only. Intelligence Points value for alien race sensor.
ActualSensor INTEGER - allowed* 0 Label only. Actual Sensor value for alien race sensor.
ActualMissile INTEGER - allowed* 0 Label only. Actual Missile value for alien race sensor.
AlienRaceID INTEGER - allowed* 0 Label only. Alien Race ID identifier or catalogue selection for alien race sensor.
ViewingRaceID INTEGER - allowed* 0 Viewing race. This row describes that race’s knowledge rather than universal information.
AlienSensorID INTEGER - allowed* 0 Label only. Alien Sensor ID identifier or catalogue selection for alien race sensor.
Name TEXT - allowed* none Name stored for the row. Name text is distinct from numeric identity.
ActualGroundUnitClass INTEGER - allowed* 0 Label only. Actual Ground Unit Class value for alien race sensor.

FCT_AlienRaceSpecies

Section titled “FCT_AlienRaceSpecies”

Species known through a race’s alien contacts.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in intelligence mechanics.

Column SQL type Key NULL Default Meaning and relationships
AlienRaceID INTEGER - allowed* NULL Label only. Alien Race ID identifier or catalogue selection for alien race species.
SpeciesID INTEGER - allowed* NULL Species identifier. Related identity domain FCT_Species.SpeciesID.
DetectRaceID INTEGER - allowed* NULL Detecting race whose observations or knowledge this row records. Related identity domain FCT_Race.RaceID.
GameID INTEGER - allowed* none Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.

FCT_AlienRaceSystemStatus

Section titled “FCT_AlienRaceSystemStatus”

System protection status associated with an alien race.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in intelligence mechanics.

Column SQL type Key NULL Default Meaning and relationships
AlienRaceID INTEGER - allowed* 0 Label only. Alien Race ID identifier or catalogue selection for alien race system status.
ProtectionStatusID INTEGER - allowed* 0 Label only. Protection Status ID identifier or catalogue selection for alien race system status.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
SystemID INTEGER - allowed* 0 Star system identifier. Related identity domain FCT_System.SystemID.
ViewingRaceID INTEGER - allowed* 0 Viewing race. This row describes that race’s knowledge rather than universal information. Related identity domain FCT_Race.RaceID.

FCT_AlienShip

Section titled “FCT_AlienShip”

Ship identity, observations and accumulated damage intelligence held by a viewing race.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in intelligence mechanics.

Column SQL type Key NULL Default Meaning and relationships
GameID INTEGER - allowed* NULL Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
AlienRaceID INTEGER - allowed* NULL Label only. Alien Race ID identifier or catalogue selection for alien ship.
AlienClassID INTEGER - allowed* NULL Label only. Alien Class ID identifier or catalogue selection for alien ship.
ViewRaceID INTEGER - allowed* 0 Viewing race. This row describes that race’s knowledge rather than universal information. Related identity domain FCT_Race.RaceID.
ShipID INTEGER - allowed* 0 Individual ship identifier. Related identity domain FCT_Ship.ShipID.
Name TEXT - allowed* ' ' Name stored for the row. Name text is distinct from numeric identity.
Speed INTEGER - allowed* 0 Label only. Speed value for alien ship.
LastX Double - allowed* 0 Label only. Last X value for alien ship.
LastY Double - allowed* 0 Label only. Last Y value for alien ship.
LastSysID INTEGER - allowed* 0 Label only. Last Sys ID identifier or catalogue selection for alien ship.
LastContactTime Double - allowed* 0 Label only. Last Contact Time value for alien ship.
FirstDetected Double - allowed* 0 Label only. First Detected value for alien ship.
Destroyed Boolean - allowed* NULL Recorded destruction state. Its persistence depends on the type of record.
DamageTaken Double - allowed* 0 Label only. Damage Taken value for alien ship.
GameTimeDamaged Double - allowed* 0 Label only. Game Time Damaged value for alien ship.
ShieldDamage Double - allowed* 0 Label only. Shield Damage value for alien ship.
ArmourDamage INTEGER - allowed* 0 Label only. Armour Damage value for alien ship.
PenetratingDamage INTEGER - allowed* 0 Label only. Penetrating Damage value for alien ship.
Salvaged Boolean - allowed* FALSE Label only. Salvaged selection for alien ship.

FCT_AlienSystem

Section titled “FCT_AlienSystem”

Systems associated with a detected alien race.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in intelligence mechanics.

Column SQL type Key NULL Default Meaning and relationships
GameID INTEGER - allowed* NULL Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
SystemID INTEGER - allowed* NULL Star system identifier. Related identity domain FCT_System.SystemID.
AlienRaceID INTEGER - allowed* NULL Label only. Alien Race ID identifier or catalogue selection for alien system.
DetectRaceID INTEGER - allowed* NULL Detecting race whose observations or knowledge this row records. Related identity domain FCT_Race.RaceID.

FCT_Contacts

Section titled “FCT_Contacts”

Sensor contact tracks, detecting and target races, positions and update times.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in observation and knowledge lifecycle.

Column SQL type Key NULL Default Meaning and relationships
UniqueID INTEGER PK 1 allowed* none Contact track identifier. This is separate from the identifier of the tracked object.
ContactID INTEGER - allowed* NULL Tracked object identifier interpreted together with ContactType.
GameID INTEGER - allowed* NULL Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
SystemID INTEGER - allowed* NULL Star system identifier. Related identity domain FCT_System.SystemID.
DetectRaceID INTEGER - allowed* NULL Detecting race whose observations or knowledge this row records. Related identity domain FCT_Race.RaceID.
ContactRaceID INTEGER - allowed* 0 Label only. Contact Race ID identifier or catalogue selection for contacts.
ContactName TEXT - allowed* NULL Label only. Contact Name text for contacts.
CreationTime Double - allowed* NULL Label only. Creation Time value for contacts.
Reestablished Double - allowed* 0 Label only. Reestablished value for contacts.
LastUpdate Double - allowed* NULL Label only. Last Update value for contacts.
ContactMethod INTEGER - allowed* 0 Sensor or observation category for this contact.
ContactType INTEGER - allowed* NULL Tracked object category. It determines which kind of object ContactID identifies.
ContactStrength Double - allowed* NULL Label only. Contact Strength value for contacts.
ContactNumber INTEGER - allowed* 1 Contact display number.
Resolution INTEGER - allowed* 0 Sensor resolution or contact resolution selection, according to the table.
ContinualContactTime INTEGER - allowed* 0 Label only. Continual Contact Time value for contacts.
Xcor Double - allowed* NULL X coordinate. System-space and map-space coordinates must be interpreted in the context of this table.
Ycor Double - allowed* NULL Y coordinate. System-space and map-space coordinates must be interpreted in the context of this table.
LastXcor Double - allowed* NULL Previous X coordinate used to track movement.
LastYcor Double - allowed* NULL Previous Y coordinate used to track movement.
Speed INTEGER - allowed* 0 Label only. Speed value for contacts.
Msg Boolean - allowed* NULL Label only. Msg selection for contacts.
IncrementStartX Double - allowed* 0 X coordinate at the start of the simulation increment.
IncrementStartY Double - allowed* 0 Y coordinate at the start of the simulation increment.

FCT_KnownRuinRace

Section titled “FCT_KnownRuinRace”

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in salvage and archaeology.

Column SQL type Key NULL Default Meaning and relationships
RuinRaceID INTEGER PK 1 NOT NULL none
RaceID INTEGER PK 2 NOT NULL none Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.

Indexes. sqlite_autoindex_FCT_KnownRuinRace_1 (unique, RuinRaceID, RaceID).

FCT_KnownSpecies

Section titled “FCT_KnownSpecies”

Species knowledge held by a viewing race.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in intelligence mechanics.

Column SQL type Key NULL Default Meaning and relationships
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
SpeciesID INTEGER - allowed* 0 Species identifier. Related identity domain FCT_Species.SpeciesID.
ViewRaceID INTEGER - allowed* 0 Viewing race. This row describes that race’s knowledge rather than universal information. Related identity domain FCT_Race.RaceID.
Status INTEGER - allowed* 0 Label only. Status value for known species.

FCT_RaceJumpPointSurvey

Section titled “FCT_RaceJumpPointSurvey”

A race’s exploration, charting and restriction state for a jump point.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in jump point network and galaxy topology.

Column SQL type Key NULL Default Meaning and relationships
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
RaceID INTEGER - NOT NULL none Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
WarpPointID INTEGER - NOT NULL none Jump point identifier, using the database’s warp point spelling. Related identity domain FCT_JumpPoint.WarpPointID.
Explored INTEGER - allowed* 0 Label only. Explored value for race jump point survey.
Charted INTEGER - allowed* 0 Label only. Charted value for race jump point survey.
AlienUnits Boolean - allowed* NULL Label only. Alien Units selection for race jump point survey.
Hide INTEGER - allowed* 0 Label only. Hide value for race jump point survey.
MilitaryRestricted INTEGER - allowed* 0 Label only. Military Restricted value for race jump point survey.
IgnoreForDistance INTEGER - allowed* 0 Label only. Ignore For Distance value for race jump point survey.

FCT_RaceSurveyLocation

Section titled “FCT_RaceSurveyLocation”

Survey locations completed by a race.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in exploration surveys and discovery.

Column SQL type Key NULL Default Meaning and relationships
RaceID INTEGER - allowed* NULL Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
SystemID INTEGER - allowed* NULL Star system identifier. Related identity domain FCT_System.SystemID.
LocationNumber INTEGER - allowed* NULL Label only. Location Number value for race survey location.

FCT_RaceSysSurvey

Section titled “FCT_RaceSysSurvey”

A race’s knowledge, naming, security state and map view of a system.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in system lifecycle.

Column SQL type Key NULL Default Meaning and relationships
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
RaceID INTEGER PK 1 NOT NULL none Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
SystemID INTEGER PK 2 NOT NULL none Star system identifier. Related identity domain FCT_System.SystemID.
Name TEXT - NOT NULL 'Not Yet Named' Name stored for the row. Name text is distinct from numeric identity.
DangerRating INTEGER - allowed* 0 Label only. Danger Rating value for race sys survey.
SysTPStatus Boolean - allowed* 0 Label only. Sys TP Status selection for race sys survey.
ControlRaceID INTEGER - allowed* 0 Label only. Control Race ID identifier or catalogue selection for race sys survey.
ForeignFleetRaceID INTEGER - allowed* 0 Label only. Foreign Fleet Race ID identifier or catalogue selection for race sys survey.
SectorID INTEGER - allowed* 0 Label only. Sector ID identifier or catalogue selection for race sys survey.
NameThemeID INTEGER - allowed* 0 Naming theme selection. The table purpose determines which naming catalogue applies.
Discovered TEXT - allowed* '0' Label only. Discovered text for race sys survey.
Xcor INTEGER - NOT NULL 2000 X coordinate. System-space and map-space coordinates must be interpreted in the context of this table.
Ycor INTEGER - NOT NULL 2000 Y coordinate. System-space and map-space coordinates must be interpreted in the context of this table.
ClosedWP INTEGER - allowed* 0 Label only. Closed WP value for race sys survey.
SurveyDone Boolean - allowed* 0 Label only. Survey Done selection for race sys survey.
SelectedBodyXcor Double - allowed* 0 Label only. Selected Body Xcor value for race sys survey.
SelectedBodyYcor Double - allowed* 0 Label only. Selected Body Ycor value for race sys survey.
KmPerPixel Double - allowed* 0 Label only. Km Per Pixel value for race sys survey.
GeoSurveyDefaultDone Boolean - allowed* 0 Label only. Geo Survey Default Done selection for race sys survey.
DiscoveredTime Double - allowed* 0 Label only. Discovered Time value for race sys survey.
NoAutoRoute Boolean - allowed* False Label only. No Auto Route selection for race sys survey.
MilitaryRestrictedSystem Boolean - allowed* FALSE Label only. Military Restricted System selection for race sys survey.
SystemValue INTEGER - allowed* 1 Label only. System Value value for race sys survey.
AutoProtectionStatus INTEGER - allowed* 0 Label only. Auto Protection Status value for race sys survey.
MineralSearchFlag Boolean - allowed* FALSE Label only. Mineral Search Flag selection for race sys survey.
RaidRating INTEGER - allowed* 0 Label only. Raid Rating value for race sys survey.

Indexes. sqlite_autoindex_FCT_RaceSysSurvey_1 (unique, RaceID, SystemID).

FCT_STODetected

Section titled “FCT_STODetected”

Ground weapon elements detected by a race.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in ground combat and conquest.

Column SQL type Key NULL Default Meaning and relationships
GameID INTEGER - allowed* none Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
ElementID INTEGER - allowed* none Ground formation element identifier. Related identity domain FCT_GroundUnitFormationElement.ElementID.
DetectingRaceID INTEGER - allowed* none Detecting race whose observations or knowledge this row records. Related identity domain FCT_Race.RaceID.

FCT_SystemBodyName

Section titled “FCT_SystemBodyName”

Body names assigned by individual races.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in exploration surveys and discovery.

Column SQL type Key NULL Default Meaning and relationships
RaceID INTEGER PK 1 allowed* NULL Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
SystemBodyID INTEGER PK 2 allowed* NULL System body identifier. Bodies include planets, moons, asteroids and comets. Related identity domain FCT_SystemBody.SystemBodyID.
GameID INTEGER - allowed* NULL Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
SystemID INTEGER - allowed* NULL Star system identifier. Related identity domain FCT_System.SystemID.
Name VARCHAR(50) - allowed* NULL Name stored for the row. Name text is distinct from numeric identity.

Indexes. sqlite_autoindex_FCT_SystemBodyName_1 (unique, RaceID, SystemBodyID).

FCT_SystemBodySurveys

Section titled “FCT_SystemBodySurveys”

Geological survey completion records by race and body.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in exploration surveys and discovery.

Column SQL type Key NULL Default Meaning and relationships
GameID INTEGER - allowed* NULL Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
RaceID INTEGER - allowed* NULL Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
SystemBodyID INTEGER - allowed* NULL System body identifier. Bodies include planets, moons, asteroids and comets. Related identity domain FCT_SystemBody.SystemBodyID.

Automated planning

Section titled “Automated planning”

DIM_AutomatedClassDesign / DIM_AutomatedGroundTemplateDesign / DIM_AutomatedGroundTemplateElements / DIM_DesignPhilosophyGroundForceDeployments / DIM_DesignPhilosophyTechProgression / DIM_OperationalGroup / DIM_OperationalGroupElement / DIM_OperationalGroupProgression / FCT_DesignPhilosophy / FCT_DesignPhilosophyTechProgressionCategories / FCT_RaceOperationalGroupElements / FCT_TechProgressionRace

DIM_AutomatedClassDesign

Section titled “DIM_AutomatedClassDesign”

Recipes for automatically generated ship classes, including equipment choices and proportions.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in npr race generation and automated design.

Column SQL type Key NULL Default Meaning and relationships
AutomatedClassID INTEGER PK 1 allowed* NULL Label only. Automated Class ID identifier or catalogue selection for automated class design.
DesignID TEXT - allowed* NULL Label only. Design ID text for automated class design.
DefaultClassName TEXT - allowed* NULL Label only. Default Class Name text for automated class design.
ShippingLineName TEXT - allowed* NULL Label only. Shipping Line Name text for automated class design.
KeyTechA INTEGER - allowed* 0 Label only. Key Tech A value for automated class design.
KeyTechB INTEGER - allowed* 0 Label only. Key Tech B value for automated class design.
HullID INTEGER - allowed* 0 Label only. Hull ID identifier or catalogue selection for automated class design.
HullSize Double - allowed* 0 Label only. Hull Size value for automated class design.
WeaponType INTEGER - allowed* 0 Label only. Weapon Type value for automated class design.
MissileType INTEGER - allowed* 0 Label only. Missile Type value for automated class design.
EngineType INTEGER - allowed* 0 Label only. Engine Type value for automated class design.
EngineNumberType INTEGER - allowed* 0 Label only. Engine Number Type value for automated class design.
EngineNumber INTEGER - allowed* 0 Label only. Engine Number value for automated class design.
RandomEngineElement INTEGER - allowed* 0 Label only. Random Engine Element value for automated class design.
EngineeringType INTEGER - allowed* 0 Label only. Engineering Type value for automated class design.
Engineering INTEGER - allowed* 0 Label only. Engineering value for automated class design.
DeploymentDuration Double - allowed* 0 Label only. Deployment Duration value for automated class design.
FuelDuration Double - allowed* 0 Label only. Fuel Duration value for automated class design.
AdditionalArmour Numeric - allowed* NULL Label only. Additional Armour value for automated class design.
ArmourAdjustment INTEGER - allowed* 0 Label only. Armour Adjustment value for automated class design.
Hangar INTEGER - allowed* 0 Label only. Hangar value for automated class design.
Shields INTEGER - allowed* 0 Label only. Shields value for automated class design.
SecondaryActive INTEGER - allowed* 0 Label only. Secondary Active value for automated class design.
NumFireControls INTEGER - allowed* 0 Label only. Num Fire Controls value for automated class design.
MissileFireControl INTEGER - allowed* 0 Label only. Missile Fire Control value for automated class design.
ThermalFixed INTEGER - allowed* 0 Label only. Thermal Fixed value for automated class design.
ThermalRandom INTEGER - allowed* 0 Label only. Thermal Random value for automated class design.
EMFixed INTEGER - allowed* 0 Label only. EM Fixed value for automated class design.
EMRandom INTEGER - allowed* 0 Label only. EM Random value for automated class design.
CargoHolds INTEGER - allowed* 0 Label only. Cargo Holds value for automated class design.
CargoHandling INTEGER - allowed* 0 Label only. Cargo Handling value for automated class design.
CryogenicModules INTEGER - allowed* 0 Label only. Cryogenic Modules value for automated class design.
LuxuryAccomodation INTEGER - allowed* 0 Label only. Luxury Accomodation value for automated class design.
SalvageModules INTEGER - allowed* 0 Label only. Salvage Modules value for automated class design.
JGCS Numeric - allowed* 0 Label only. JGCS value for automated class design.
CIWSFixed INTEGER - allowed* 0 Label only. CIWS Fixed value for automated class design.
CIWSRandom INTEGER - allowed* 0 Label only. CIWS Random value for automated class design.
JumpDriveType INTEGER - allowed* 0 Label only. Jump Drive Type value for automated class design.
RoleType INTEGER - allowed* 0 Label only. Role Type value for automated class design.
HullClass TEXT - allowed* none Label only. Hull Class text for automated class design.
BeamFireControl INTEGER - allowed* 0 Label only. Beam Fire Control value for automated class design.
AuxiliaryControl INTEGER - allowed* 0 Label only. Auxiliary Control value for automated class design.
ScienceDepartment INTEGER - allowed* 0 Label only. Science Department value for automated class design.
MainEngineering INTEGER - allowed* 0 Label only. Main Engineering value for automated class design.
CIC INTEGER - allowed* 0 Label only. CIC value for automated class design.
PrimaryFlightControl INTEGER - allowed* 0 Label only. Primary Flight Control value for automated class design.
SpinalLaser INTEGER - allowed* 0 Label only. Spinal Laser value for automated class design.
ECCM INTEGER - allowed* 0 Label only. ECCM value for automated class design.
FuelTransferSystem INTEGER - allowed* 0 Label only. Fuel Transfer System value for automated class design.
AssignAsTanker INTEGER - allowed* 0 Label only. Assign As Tanker value for automated class design.
AssignAsCollier INTEGER - allowed* 0 Label only. Assign As Collier value for automated class design.
GeoSurvey INTEGER - allowed* 0 Label only. Geo Survey value for automated class design.
GravSurvey INTEGER - allowed* 0 Label only. Grav Survey value for automated class design.
TroopTransportBase INTEGER - allowed* 0 Label only. Troop Transport Base value for automated class design.
TroopTransportRandom INTEGER - allowed* 0 Label only. Troop Transport Random value for automated class design.
Notes TEXT - allowed* none Free-text notes associated with the row.
AlternativeWeapon Boolean - allowed* FALSE Label only. Alternative Weapon selection for automated class design.
PrimaryActive INTEGER - allowed* 0 Label only. Primary Active value for automated class design.
FillSpace Boolean - allowed* TRUE Label only. Fill Space selection for automated class design.
BioEnergyStorage INTEGER - allowed* 0 Label only. Bio Energy Storage value for automated class design.
HullSizeType INTEGER - allowed* 0 Label only. Hull Size Type value for automated class design.
Boolean - allowed* 0 Label only.
INTEGER - allowed* FALSE Label only.
EnergyEscort INTEGER - allowed* 0 Label only. Energy Escort value for automated class design.
SurrenderStatus INTEGER - allowed* 0 Label only. Surrender Status value for automated class design.
MaxFuelHullPercentage Double - allowed* 0 Label only. Max Fuel Hull Percentage value for automated class design.
StealthDesign INTEGER - allowed* 0 Label only. Stealth Design value for automated class design.
DecoyLaunchers INTEGER - allowed* 0 Label only. Decoy Launchers value for automated class design.
SecondaryWeaponProportion Double - allowed* 1 Label only. Secondary Weapon Proportion value for automated class design.

DIM_AutomatedGroundTemplateDesign

Section titled “DIM_AutomatedGroundTemplateDesign”

Automatic ground formation template definitions and selection requirements.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in npr race generation and automated design.

Column SQL type Key NULL Default Meaning and relationships
AutomatedTemplateID INTEGER - allowed* 0 Label only. Automated Template ID identifier or catalogue selection for automated ground template design.
Name TEXT - allowed* none Name stored for the row. Name text is distinct from numeric identity.
Abbreviation TEXT - allowed* none Short display name or abbreviation.
StandardProportion Double - allowed* 0 Label only. Standard Proportion value for automated ground template design.
Priority INTEGER - allowed* 0 Priority value. Its ordering and scale belong to the activity described by this table.
SpecialNPR INTEGER - allowed* 0 Label only. Special NPR value for automated ground template design.
FieldPosition INTEGER - allowed* 0 Ground battlefield position selection.
PrimaryFunction INTEGER - allowed* 0 Label only. Primary Function value for automated ground template design.
RequiredTechID INTEGER - allowed* 0 Label only. Required Tech ID identifier or catalogue selection for automated ground template design.

DIM_AutomatedGroundTemplateElements

Section titled “DIM_AutomatedGroundTemplateElements”

Element quantities and roles within automatic ground formation templates.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in npr race generation and automated design.

Column SQL type Key NULL Default Meaning and relationships
AutomatedTemplateID INTEGER - allowed* none Label only. Automated Template ID identifier or catalogue selection for automated ground template elements.
BaseAmount INTEGER - allowed* none Label only. Base Amount value for automated ground template elements.
DiceAmount INTEGER - allowed* none Label only. Dice Amount value for automated ground template elements.
Multiple INTEGER - allowed* none Label only. Multiple value for automated ground template elements.
DiceSize INTEGER - allowed* none Label only. Dice Size value for automated ground template elements.
GUClassType INTEGER - allowed* none Label only. GU Class Type value for automated ground template elements.
PrimaryClass Boolean - allowed* none Label only. Primary Class selection for automated ground template elements.
ClassName TEXT - allowed* none Design class name.
HQ Boolean - allowed* FALSE Label only. HQ selection for automated ground template elements.
Logistics Boolean - allowed* FALSE Label only. Logistics selection for automated ground template elements.
Construction Boolean - allowed* 0 Label only. Construction selection for automated ground template elements.

DIM_DesignPhilosophyGroundForceDeployments

Section titled “DIM_DesignPhilosophyGroundForceDeployments”

Ground deployment themes that choose template quantities by population value.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in npr colony and economic ai.

Column SQL type Key NULL Default Meaning and relationships
GroundForceDeploymentThemeID INTEGER - allowed* 0 Label only. Ground Force Deployment Theme ID identifier or catalogue selection for design philosophy ground force deployments.
AutomatedTemplateID INTEGER - allowed* 0 Label only. Automated Template ID identifier or catalogue selection for design philosophy ground force deployments.
NumberRequired INTEGER - allowed* 0 Label only. Number Required value for design philosophy ground force deployments.
PopulationValue INTEGER - allowed* 0 Label only. Population Value value for design philosophy ground force deployments.
Priority INTEGER - allowed* 0 Priority value. Its ordering and scale belong to the activity described by this table.

DIM_DesignPhilosophyTechProgression

Section titled “DIM_DesignPhilosophyTechProgression”

Automatic technology progression entries and research requirements.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in npr race generation and automated design.

Column SQL type Key NULL Default Meaning and relationships
TechTypeID INTEGER - allowed* none Label only. Tech Type ID identifier or catalogue selection for design philosophy tech progression.
TechGroupID INTEGER - allowed* none Label only. Tech Group ID identifier or catalogue selection for design philosophy tech progression.
ProgressionOrder Double - allowed* none Label only. Progression Order value for design philosophy tech progression.
Description TEXT - allowed* none Descriptive text for the row.
Notes TEXT - allowed* none Free-text notes associated with the row.
ResearchField INTEGER - allowed* 0 Research field selection.
EstimatedRP INTEGER - allowed* 0 Label only. Estimated RP value for design philosophy tech progression.
TechProgressionCategoryID INTEGER - allowed* 0 Label only. Tech Progression Category ID identifier or catalogue selection for design philosophy tech progression.
Mandatory Boolean - allowed* FALSE Label only. Mandatory selection for design philosophy tech progression.
CheckList Boolean - allowed* FALSE Label only. Check List selection for design philosophy tech progression.

DIM_OperationalGroup

Section titled “DIM_OperationalGroup”

Automatic fleet group roles, standing orders and requirements.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in npr fleet readiness and recovery.

Column SQL type Key NULL Default Meaning and relationships
Description TEXT - allowed* none Descriptive text for the row.
TechRequirementA INTEGER - allowed* 0 Label only. Tech Requirement A value for operational group.
PrimaryStandingOrder INTEGER - allowed* none Label only. Primary Standing Order value for operational group.
SecondaryStandingOrder INTEGER - allowed* none Label only. Secondary Standing Order value for operational group.
MainFunction INTEGER - allowed* 0 Label only. Main Function value for operational group.
AvoidDanger Boolean - allowed* none Label only. Avoid Danger selection for operational group.
OperationalGroupID INTEGER - allowed* none Label only. Operational Group ID identifier or catalogue selection for operational group.
ChangeStandingToFuel Boolean - allowed* FALSE Label only. Change Standing To Fuel selection for operational group.
MainFunctionPriority INTEGER - allowed* 0 Label only. Main Function Priority value for operational group.
MobileMilitary INTEGER - allowed* 0 Label only. Mobile Military value for operational group.
OffensiveForce Boolean - allowed* FALSE Label only. Offensive Force selection for operational group.
StaticForce Boolean - allowed* FALSE Label only. Static Force selection for operational group.

DIM_OperationalGroupElement

Section titled “DIM_OperationalGroupElement”

Ship design recipes and ship counts within automatic fleet groups.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in npr fleet readiness and recovery.

Column SQL type Key NULL Default Meaning and relationships
AutomatedDesignID INTEGER - allowed* none Label only. Automated Design ID identifier or catalogue selection for operational group element.
NumShips INTEGER - allowed* none Label only. Num Ships value for operational group element.
KeyElement Boolean - allowed* false Label only. Key Element selection for operational group element.
OperationalGroupID INTEGER - allowed* none Label only. Operational Group ID identifier or catalogue selection for operational group element.
Description TEXT - allowed* none Descriptive text for the row.
RandomNumShips INTEGER - allowed* 0 Label only. Random Num Ships value for operational group element.
ChanceOfElement INTEGER - allowed* 100 Label only. Chance Of Element value for operational group element.

DIM_OperationalGroupProgression

Section titled “DIM_OperationalGroupProgression”

Automatic fleet group progression order and group quantity requirements.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in npr strategic planning.

Column SQL type Key NULL Default Meaning and relationships
OpGroupProgressionType INTEGER - allowed* none Label only. Op Group Progression Type value for operational group progression.
ProgressionOrder INTEGER - allowed* none Label only. Progression Order value for operational group progression.
NumGroups INTEGER - allowed* none Label only. Num Groups value for operational group progression.
CountGroupType INTEGER - allowed* 0 Label only. Count Group Type value for operational group progression.
OperationalGroupID INTEGER - allowed* 1 Label only. Operational Group ID identifier or catalogue selection for operational group progression.
Description TEXT - allowed* none Descriptive text for the row.
Mandatory Boolean - allowed* FALSE Label only. Mandatory selection for operational group progression.

FCT_DesignPhilosophy

Section titled “FCT_DesignPhilosophy”

Per-race automatic design choices, technology selections and fleet equipment proportions.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in npr race generation and automated design.

Column SQL type Key NULL Default Meaning and relationships
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
ActiveAntiFAC INTEGER - allowed* 0 Label only. Active Anti FAC value for design philosophy.
ActiveAntiFighter INTEGER - allowed* 0 Label only. Active Anti Fighter value for design philosophy.
ActiveLarge INTEGER - allowed* 0 Label only. Active Large value for design philosophy.
ActiveVeryLarge INTEGER - allowed* 0 Label only. Active Very Large value for design philosophy.
ActiveResolution INTEGER - allowed* 0 Label only. Active Resolution value for design philosophy.
PrimaryBeamPreference INTEGER - allowed* 0 Label only. Primary Beam Preference value for design philosophy.
LauncherSize INTEGER - allowed* 0 Label only. Launcher Size value for design philosophy.
NumSalvos INTEGER - allowed* 0 Label only. Num Salvos value for design philosophy.
WarshipArmour INTEGER - allowed* 0 Label only. Warship Armour value for design philosophy.
WarshipEngineering INTEGER - allowed* 0 Label only. Warship Engineering value for design philosophy.
WarshipHullSize INTEGER - allowed* 0 Label only. Warship Hull Size value for design philosophy.
ActiveAntiMissile INTEGER - allowed* 0 Label only. Active Anti Missile value for design philosophy.
FireControlAntiMissile INTEGER - allowed* 0 Label only. Fire Control Anti Missile value for design philosophy.
FireControlAntiFAC INTEGER - allowed* 0 Label only. Fire Control Anti FAC value for design philosophy.
FireControlAntiFighter INTEGER - allowed* 0 Label only. Fire Control Anti Fighter value for design philosophy.
FireControlStandardMissile INTEGER - allowed* 0 Label only. Fire Control Standard Missile value for design philosophy.
JumpDriveBattlecruiser INTEGER - allowed* 0 Label only. Jump Drive Battlecruiser value for design philosophy.
FireControlBeamRange INTEGER - allowed* 0 Label only. Fire Control Beam Range value for design philosophy.
FireControlBeamSpeed INTEGER - allowed* 0 Label only. Fire Control Beam Speed value for design philosophy.
JumpDriveCruiser INTEGER - allowed* 0 Label only. Jump Drive Cruiser value for design philosophy.
JumpDriveDestroyer INTEGER - allowed* 0 Label only. Jump Drive Destroyer value for design philosophy.
NumCommercialEngines INTEGER - allowed* 0 Label only. Num Commercial Engines value for design philosophy.
JumpDriveSurvey INTEGER - allowed* 0 Label only. Jump Drive Survey value for design philosophy.
EMSensorSize1 INTEGER - allowed* 0 Label only. EM Sensor Size1 value for design philosophy.
EMSensorSize2 INTEGER - allowed* 0 Label only. EM Sensor Size2 value for design philosophy.
EMSensorSize3 INTEGER - allowed* 0 Label only. EM Sensor Size3 value for design philosophy.
EMSensorSize6 INTEGER - allowed* 0 Label only. EM Sensor Size6 value for design philosophy.
EngineCommercial INTEGER - allowed* 0 Label only. Engine Commercial value for design philosophy.
EngineMilitary INTEGER - allowed* 0 Label only. Engine Military value for design philosophy.
EngineFAC INTEGER - allowed* 0 Label only. Engine FAC value for design philosophy.
EngineFighter INTEGER - allowed* 0 Label only. Engine Fighter value for design philosophy.
MissileCaptorMine INTEGER - allowed* 0 Label only. Missile Captor Mine value for design philosophy.
LauncherFAC INTEGER - allowed* 0 Label only. Launcher FAC value for design philosophy.
FireControlFACMissile INTEGER - allowed* 0 Label only. Fire Control FAC Missile value for design philosophy.
Gauss INTEGER - allowed* 0 Label only. Gauss value for design philosophy.
LaserLarge INTEGER - allowed* 0 Label only. Laser Large value for design philosophy.
LauncherStandard INTEGER - allowed* 0 Label only. Launcher Standard value for design philosophy.
Meson INTEGER - allowed* 0 Label only. Meson value for design philosophy.
LauncherMine INTEGER - allowed* 0 Label only. Launcher Mine value for design philosophy.
LauncherMineSize INTEGER - allowed* 0 Label only. Launcher Mine Size value for design philosophy.
MissileMineSecondStage INTEGER - allowed* 0 Label only. Missile Mine Second Stage value for design philosophy.
LaserPointDefence INTEGER - allowed* 0 Label only. Laser Point Defence value for design philosophy.
LauncherPointDefence INTEGER - allowed* 0 Label only. Launcher Point Defence value for design philosophy.
MesonPointDefence INTEGER - allowed* 0 Label only. Meson Point Defence value for design philosophy.
MissilePointDefence INTEGER - allowed* 0 Label only. Missile Point Defence value for design philosophy.
PointDefencePreference INTEGER - allowed* 0 Label only. Point Defence Preference value for design philosophy.
PointDefenceWeapon INTEGER - allowed* 0 Label only. Point Defence Weapon value for design philosophy.
Railgun INTEGER - allowed* 0 Label only. Railgun value for design philosophy.
MissileStandard INTEGER - allowed* 0 Label only. Missile Standard value for design philosophy.
EngineSurvey INTEGER - allowed* 0 Label only. Engine Survey value for design philosophy.
ParticleBeam INTEGER - allowed* 0 Label only. Particle Beam value for design philosophy.
RaceID INTEGER PK 1 allowed* NULL Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
Carronade INTEGER - allowed* 0 Label only. Carronade value for design philosophy.
CIWS INTEGER - allowed* 0 Label only. CIWS value for design philosophy.
Cloak INTEGER - allowed* 0 Label only. Cloak value for design philosophy.
ActiveStandard INTEGER - allowed* 0 Label only. Active Standard value for design philosophy.
EngineSizeMilitary INTEGER - allowed* 0 Label only. Engine Size Military value for design philosophy.
EngineSizeCommercial INTEGER - allowed* 25 Label only. Engine Size Commercial value for design philosophy.
MissileFAC INTEGER - allowed* 0 Label only. Missile FAC value for design philosophy.
LaserSpinal INTEGER - allowed* 0 Label only. Laser Spinal value for design philosophy.
ThermalSensorSize1 INTEGER - allowed* 0 Label only. Thermal Sensor Size1 value for design philosophy.
ThermalSensorSize2 INTEGER - allowed* 0 Label only. Thermal Sensor Size2 value for design philosophy.
ThermalSensorSize3 INTEGER - allowed* 0 Label only. Thermal Sensor Size3 value for design philosophy.
ThermalSensorSize6 INTEGER - allowed* 0 Label only. Thermal Sensor Size6 value for design philosophy.
ShieldProportion Double - allowed* 0 Label only. Shield Proportion value for design philosophy.
NumWarshipEngines INTEGER - allowed* 2 Label only. Num Warship Engines value for design philosophy.
WarshipEngineProportion INTEGER - allowed* 0 Label only. Warship Engine Proportion value for design philosophy.
AlternativeBeamPreference INTEGER - allowed* 0 Label only. Alternative Beam Preference value for design philosophy.
SurveyEngineBoost Double - allowed* 0.7 Label only. Survey Engine Boost value for design philosophy.
SurveySensors INTEGER - allowed* 2 Label only. Survey Sensors value for design philosophy.
TerraformModules INTEGER - allowed* 0 Label only. Terraform Modules value for design philosophy.
HarvesterModules INTEGER - allowed* 0 Label only. Harvester Modules value for design philosophy.
MiningModules INTEGER - allowed* 0 Label only. Mining Modules value for design philosophy.
HighPowerMicrowaveLarge INTEGER - allowed* 0 Label only. High Power Microwave Large value for design philosophy.
HighPowerMicrowaveSmall INTEGER - allowed* 0 Label only. High Power Microwave Small value for design philosophy.
ActiveSmall INTEGER - allowed* none Label only. Active Small value for design philosophy.
ActiveNavigation INTEGER - allowed* 0 Label only. Active Navigation value for design philosophy.
JumpDriveMediumHive INTEGER - allowed* 0 Label only. Jump Drive Medium Hive value for design philosophy.
JumpDriveLargeHive INTEGER - allowed* 0 Label only. Jump Drive Large Hive value for design philosophy.
JumpDriveVeryLargeHive INTEGER - allowed* 0 Label only. Jump Drive Very Large Hive value for design philosophy.
RailgunPointDefence INTEGER - allowed* 0 Label only. Railgun Point Defence value for design philosophy.
FireControlBeamShortRange INTEGER - allowed* 0 Label only. Fire Control Beam Short Range value for design philosophy.
ActiveAntiMissileSmall INTEGER - allowed* 0 Label only. Active Anti Missile Small value for design philosophy.
CloakDD INTEGER - allowed* 0 Label only. Cloak DD value for design philosophy.
CloakCA INTEGER - allowed* 0 Label only. Cloak CA value for design philosophy.
CloakBC INTEGER - allowed* 0 Label only. Cloak BC value for design philosophy.
LauncherSizeModifier INTEGER - allowed* 0 Label only. Launcher Size Modifier value for design philosophy.
NumSalvosAMM INTEGER - allowed* 0 Label only. Num Salvos AMM value for design philosophy.
NPRMissileStrategy INTEGER - allowed* 0 Label only. NPR Missile Strategy value for design philosophy.
MaxGeo INTEGER - allowed* 0 Label only. Max Geo value for design philosophy.
MaxGrav INTEGER - allowed* 0 Label only. Max Grav value for design philosophy.
MaxScout INTEGER - allowed* 0 Label only. Max Scout value for design philosophy.
MaxDiplomatic INTEGER - allowed* 0 Label only. Max Diplomatic value for design philosophy.
MaxStabilisation INTEGER - allowed* 0 Label only. Max Stabilisation value for design philosophy.
MaxSalvage INTEGER - allowed* 0 Label only. Max Salvage value for design philosophy.
MaxTanker INTEGER - allowed* 0 Label only. Max Tanker value for design philosophy.
MilitaryEngineBoost Double - allowed* 1 Label only. Military Engine Boost value for design philosophy.
UseJumpDrives Boolean - allowed* FALSE Label only. Use Jump Drives selection for design philosophy.
OrdnanceFactories Boolean - allowed* FALSE Label only. Ordnance Factories selection for design philosophy.
FighterFactories Boolean - allowed* FALSE Label only. Fighter Factories selection for design philosophy.
ArmourMultiplier Double - allowed* 1 Label only. Armour Multiplier value for design philosophy.
GroundForceDeploymentThemeID INTEGER - allowed* 1 Label only. Ground Force Deployment Theme ID identifier or catalogue selection for design philosophy.
OpGroupProgressionType INTEGER - allowed* 0 Label only. Op Group Progression Type value for design philosophy.
LauncherDecoy INTEGER - allowed* 0 Label only. Launcher Decoy value for design philosophy.
LauncherDecoySize INTEGER - allowed* 0 Label only. Launcher Decoy Size value for design philosophy.
DecoyMissile INTEGER - allowed* 0 Label only. Decoy Missile value for design philosophy.
LauncherAMMSize Double - allowed* 1 Label only. Launcher AMM Size value for design philosophy.
JumpDriveDreadnought INTEGER - allowed* 0 Label only. Jump Drive Dreadnought value for design philosophy.
ActiveFighterMissile INTEGER - allowed* 0 Label only. Active Fighter Missile value for design philosophy.
ActiveFighterBeam INTEGER - allowed* 0 Label only. Active Fighter Beam value for design philosophy.
FireControlFighterMissile INTEGER - allowed* 0 Label only. Fire Control Fighter Missile value for design philosophy.
FireControlFighterBeam INTEGER - allowed* 0 Label only. Fire Control Fighter Beam value for design philosophy.
FighterBeamWeapon INTEGER - allowed* 0 Label only. Fighter Beam Weapon value for design philosophy.
FighterEngineSize Double - allowed* 2 Label only. Fighter Engine Size value for design philosophy.
HybridCarriers Boolean - allowed* FALSE Label only. Hybrid Carriers selection for design philosophy.
MaintenanceModules INTEGER - allowed* 0 Label only. Maintenance Modules value for design philosophy.

FCT_DesignPhilosophyTechProgressionCategories

Section titled “FCT_DesignPhilosophyTechProgressionCategories”

Research progression categories assigned to a race.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in npr race generation and automated design.

Column SQL type Key NULL Default Meaning and relationships
RaceID INTEGER - allowed* 0 Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
TechProgressionCategoryID INTEGER - allowed* 0 Label only. Tech Progression Category ID identifier or catalogue selection for design philosophy tech progression categories.

FCT_RaceOperationalGroupElements

Section titled “FCT_RaceOperationalGroupElements”

Race-specific automatic fleet group composition.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in npr fleet readiness and recovery.

Column SQL type Key NULL Default Meaning and relationships
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.
RaceID INTEGER - allowed* 0 Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
OperationalGroupID INTEGER - allowed* 0 Label only. Operational Group ID identifier or catalogue selection for race operational group elements.
NumShips INTEGER - allowed* 0 Label only. Num Ships value for race operational group elements.
AutomatedDesignID INTEGER - allowed* 0 Label only. Automated Design ID identifier or catalogue selection for race operational group elements.
KeyElement Boolean - allowed* FALSE Label only. Key Element selection for race operational group elements.

FCT_Research

Section titled “FCT_SwarmResearch”

FCT_TechProgressionRace

Section titled “FCT_TechProgressionRace”

Technology progression entries assigned to individual races.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in npr race generation and automated design.

Column SQL type Key NULL Default Meaning and relationships
ProgressionOrder INTEGER - allowed* none Label only. Progression Order value for tech progression race.
RaceID INTEGER - allowed* none Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
GameID INTEGER - allowed* none Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.

Names and themes

Section titled “Names and themes”

DIM_CommanderNameTheme / DIM_CommanderNames / DIM_CompanyNames / DIM_EmpireTitles / DIM_LineNames / DIM_MiningNames / DIM_NamingTheme / DIM_NamingThemeTypes / DIM_RankThemeTypes / DIM_RankThemes / DIM_ShipyardCompanies / FCT_HullDescription / FCT_HullNumber / FCT_RaceNameThemes / FGNicknames / MissileSeries / PhoneticNames

DIM_CommanderNameTheme

Section titled “DIM_CommanderNameTheme”

Commander naming patterns and the name lists used by each pattern.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in naming themes automatic naming and hull numbers.

Column SQL type Key NULL Default Meaning and relationships
NameThemeID INTEGER PK 1 allowed* none Naming theme selection. The table purpose determines which naming catalogue applies.
Description TEXT - allowed* NULL Descriptive text for the row.
NameOne INTEGER - allowed* 0 Label only. Name One value for commander name theme.
NameTwo INTEGER - allowed* 0 Label only. Name Two value for commander name theme.
NameThree INTEGER - allowed* 0 Label only. Name Three value for commander name theme.
SpecialRule INTEGER - allowed* 0 Label only. Special Rule value for commander name theme.
NameOneAddition TEXT - allowed* none Label only. Name One Addition text for commander name theme.
NameOneAdditionChance INTEGER - allowed* 0 Label only. Name One Addition Chance value for commander name theme.

DIM_CommanderNames

Section titled “DIM_CommanderNames”

Personal names, family names and gender selections within commander name themes.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in naming themes automatic naming and hull numbers.

Column SQL type Key NULL Default Meaning and relationships
NameThemeID INTEGER - allowed* NULL Naming theme selection. The table purpose determines which naming catalogue applies.
FirstName Boolean - allowed* NULL Label only. First Name selection for commander names.
Name TEXT - allowed* NULL Name stored for the row. Name text is distinct from numeric identity.
Female Boolean - allowed* 0 Female name or commander selection.
ThirdName Boolean - allowed* none Label only. Third Name selection for commander names.
FamilyName Boolean - allowed* none Label only. Family Name selection for commander names.

DIM_CompanyNames

Section titled “DIM_CompanyNames”

Company suffixes grouped by company type.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in naming themes automatic naming and hull numbers.

Column SQL type Key NULL Default Meaning and relationships
ID INTEGER PK 1 allowed* none Label only. ID identifier or catalogue selection for company names.
CompanySuffix VARCHAR(255) - allowed* NULL Label only. Company Suffix text for company names.
CompanyType INTEGER - allowed* 1 Label only. Company Type value for company names.

DIM_EmpireTitles

Section titled “DIM_EmpireTitles”

Empire title choices and prefix or suffix presentation.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in naming themes automatic naming and hull numbers.

Column SQL type Key NULL Default Meaning and relationships
EmpireTitleID INTEGER PK 1 allowed* none Label only. Empire Title ID identifier or catalogue selection for empire titles.
Title TEXT - allowed* NULL Label only. Title text for empire titles.
Prefix Numeric - allowed* NULL Label only. Prefix value for empire titles.
Suffix Numeric - allowed* NULL Label only. Suffix value for empire titles.
MaxChance INTEGER - allowed* NULL Selection threshold or limit. Its interpretation depends on this catalogue and is not a universal percentage.

DIM_LineNames

Section titled “DIM_LineNames”

Shipping line name choices.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in naming themes automatic naming and hull numbers.

Column SQL type Key NULL Default Meaning and relationships
LineNameID INTEGER - allowed* none Label only. Line Name ID identifier or catalogue selection for line names.
LineNames VARCHAR(50) - allowed* NULL Label only. Line Names text for line names.

DIM_MiningNames

Section titled “DIM_MiningNames”

Civilian mining company name choices.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in naming themes automatic naming and hull numbers.

Column SQL type Key NULL Default Meaning and relationships
MNID INTEGER PK 1 allowed* none Label only. MNID identifier or catalogue selection for mining names.
MiningName VARCHAR(50) - allowed* NULL Label only. Mining Name text for mining names.

DIM_NamingTheme

Section titled “DIM_NamingTheme”

Ship and system name-theme definitions.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in naming themes automatic naming and hull numbers.

Column SQL type Key NULL Default Meaning and relationships
NameThemeID INTEGER - allowed* NULL Naming theme selection. The table purpose determines which naming catalogue applies.
Name VARCHAR(255) - allowed* NULL Name stored for the row. Name text is distinct from numeric identity.

DIM_NamingThemeTypes

Section titled “DIM_NamingThemeTypes”

Naming theme categories and race-name eligibility.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in naming themes automatic naming and hull numbers.

Column SQL type Key NULL Default Meaning and relationships
ThemeID INTEGER PK 1 allowed* NULL Label only. Theme ID identifier or catalogue selection for naming theme types.
Description TEXT - allowed* NULL Descriptive text for the row.
RaceNameEligible Boolean - allowed* False Label only. Race Name Eligible selection for naming theme types.

DIM_RankThemeTypes

Section titled “DIM_RankThemeTypes”

Rank naming theme categories.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in naming themes automatic naming and hull numbers.

Column SQL type Key NULL Default Meaning and relationships
ThemeID INTEGER PK 1 allowed* none Label only. Theme ID identifier or catalogue selection for rank theme types.
ThemeName TEXT - allowed* NULL Label only. Theme Name text for rank theme types.
RankDone Numeric - allowed* NULL Label only. Rank Done value for rank theme types.

DIM_RankThemes

Section titled “DIM_RankThemes”

Naval, ground and civilian rank names within rank themes.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in naming themes automatic naming and hull numbers.

Column SQL type Key NULL Default Meaning and relationships
ThemeID INTEGER PK 1 NOT NULL 0 Label only. Theme ID identifier or catalogue selection for rank themes.
ThemeRankID INTEGER PK 2 NOT NULL 0 Label only. Theme Rank ID identifier or catalogue selection for rank themes.
RankName TEXT - NOT NULL none Label only. Rank Name text for rank themes.
GFRankName TEXT - allowed* NULL Label only. GF Rank Name text for rank themes.
CivilianRank Boolean - allowed* NULL Label only. Civilian Rank selection for rank themes.
NavalRankAbbrev TEXT - allowed* NULL Label only. Naval Rank Abbrev text for rank themes.
GroundRankAbbrev TEXT - allowed* NULL Label only. Ground Rank Abbrev text for rank themes.

Indexes. sqlite_autoindex_DIM_RankThemes_1 (unique, ThemeID, ThemeRankID).

DIM_ShipyardCompanies

Section titled “DIM_ShipyardCompanies”

Shipyard company suffix choices.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in naming themes automatic naming and hull numbers.

Column SQL type Key NULL Default Meaning and relationships
NameID INTEGER PK 1 allowed* none Label only. Name ID identifier or catalogue selection for shipyard companies.
Suffix VARCHAR(150) - allowed* NULL Label only. Suffix text for shipyard companies.

FCT_HullDescription

Section titled “FCT_HullDescription”

Hull type names and abbreviations.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in naming themes automatic naming and hull numbers.

Column SQL type Key NULL Default Meaning and relationships
HullDescriptionID INTEGER PK 1 allowed* none Label only. Hull Description ID identifier or catalogue selection for hull description.
Description VARCHAR(50) - allowed* NULL Descriptive text for the row.
HullAbbr VARCHAR(10) - allowed* NULL Label only. Hull Abbr text for hull description.

FCT_HullNumber

Section titled “FCT_HullNumber”

Per-race running hull counts by hull type.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in naming themes automatic naming and hull numbers.

Column SQL type Key NULL Default Meaning and relationships
HullTypeID INTEGER - allowed* 0 Label only. Hull Type ID identifier or catalogue selection for hull number.
HullCount INTEGER - allowed* 0 Running count for this race and hull type.
RaceID INTEGER - allowed* 0 Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
GameID INTEGER - allowed* 0 Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.

FCT_RaceNameThemes

Section titled “FCT_RaceNameThemes”

Name themes assigned to a race and their selection chances.

Scope. Contains GameID. Preserve that game context when reading or joining rows.

Related mechanics are covered in naming themes automatic naming and hull numbers.

Column SQL type Key NULL Default Meaning and relationships
RaceID INTEGER PK 1 allowed* NULL Race identifier. The table purpose determines whether this is an owner, subject or observer. Related identity domain FCT_Race.RaceID.
NameThemeID INTEGER PK 2 allowed* NULL Naming theme selection. The table purpose determines which naming catalogue applies.
Chance INTEGER - allowed* NULL Label only. Chance value for race name themes.
GameID INTEGER - allowed* none Saved game identifier. Select the same game before combining game-specific rows. Related identity domain FCT_Game.GameID.

Indexes. sqlite_autoindex_FCT_RaceNameThemes_1 (unique, RaceID, NameThemeID).

FGNicknames

Section titled “FGNicknames”

Nickname entries retained in the database.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in naming themes automatic naming and hull numbers.

Column SQL type Key NULL Default Meaning and relationships
NicknameID INTEGER PK 1 allowed* none Label only. Nickname ID identifier or catalogue selection for fg nicknames.
Nickname VARCHAR(22) - allowed* NULL Label only. Nickname text for fg nicknames.

MissileSeries

Section titled “MissileSeries”

Race-owned missile series names.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in naming themes automatic naming and hull numbers.

Column SQL type Key NULL Default Meaning and relationships
SeriesID INTEGER PK 1 allowed* none Label only. Series ID identifier or catalogue selection for missile series.
RaceID INTEGER - allowed* NULL Race identifier. The table purpose determines whether this is an owner, subject or observer.
SeriesName VARCHAR(50) - allowed* NULL Label only. Series Name text for missile series.

PhoneticNames

Section titled “PhoneticNames”

Phonetic naming entries.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in naming themes automatic naming and hull numbers.

Column SQL type Key NULL Default Meaning and relationships
PhoneticID INTEGER PK 1 allowed* none Label only. Phonetic ID identifier or catalogue selection for phonetic names.
PhoneticName VARCHAR(50) - allowed* NULL Label only. Phonetic Name text for phonetic names.

SQLite housekeeping

Section titled “SQLite housekeeping”

sqlite_sequence / sqlite_stat1 / sqlite_stat4

sqlite_sequence

Section titled “sqlite_sequence”

SQLite AUTOINCREMENT sequence values by table.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in object identity reload.

Column SQL type Key NULL Default Meaning and relationships
name (none) - allowed* none Name of the table using AUTOINCREMENT.
seq (none) - allowed* none Largest sequence value recorded for that table. This is SQLite bookkeeping, distinct from game-managed ID counters.

sqlite_stat1

Section titled “sqlite_stat1”

SQLite query planner statistics for tables and indexes.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in object identity reload.

Column SQL type Key NULL Default Meaning and relationships
tbl (none) - allowed* none Table name.
idx (none) - allowed* none Index name, or NULL for a table statistic.
stat (none) - allowed* none Space-separated query planner statistics.

sqlite_stat4

Section titled “sqlite_stat4”

SQLite index samples and distribution statistics.

Scope. No GameID column. The row is shared, selected through another identity, or used for database bookkeeping.

Related mechanics are covered in object identity reload.

Column SQL type Key NULL Default Meaning and relationships
tbl (none) - allowed* none Table name.
idx (none) - allowed* none Index name.
neq (none) - allowed* none Estimated equal-key row counts for the index sample.
nlt (none) - allowed* none Estimated smaller-key row counts for the index sample.
ndlt (none) - allowed* none Estimated distinct smaller keys for the index sample.
sample (none) - allowed* none Binary sample of an index key.

Database indexes

Section titled “Database indexes”

The database also contains 20 indexes. An index is an access structure for table rows rather than another saved-game table. Unique indexes additionally constrain duplicate indexed values. Each table’s index columns appear with its dictionary entry.

Index Table
DefaultEventColour_EventTypeID DefaultEventColour
RaceMedals_RaceID FCT_RaceMedals
sqlite_autoindex_DIM_RankThemes_1 DIM_RankThemes
sqlite_autoindex_DefaultEventColour_1 DefaultEventColour
sqlite_autoindex_FCT_AlienRace_1 FCT_AlienRace
sqlite_autoindex_FCT_ArmourDamage_1 FCT_ArmourDamage
sqlite_autoindex_FCT_CommanderMedal_1 FCT_CommanderMedal
sqlite_autoindex_FCT_CommanderTraits_1 FCT_CommanderTraits
sqlite_autoindex_FCT_DamagedComponent_1 FCT_DamagedComponent
sqlite_autoindex_FCT_EventColour_1 FCT_EventColour
sqlite_autoindex_FCT_KnownRuinRace_1 FCT_KnownRuinRace
sqlite_autoindex_FCT_MissileGeoSurvey_1 FCT_MissileGeoSurvey
sqlite_autoindex_FCT_PopComponent_1 FCT_PopComponent
sqlite_autoindex_FCT_PopTradeBalance_1 FCT_PopTradeBalance
sqlite_autoindex_FCT_RaceNameThemes_1 FCT_RaceNameThemes
sqlite_autoindex_FCT_RaceSysSurvey_1 FCT_RaceSysSurvey
sqlite_autoindex_FCT_ShipTechData_1 FCT_ShipTechData
sqlite_autoindex_FCT_SystemBodyName_1 FCT_SystemBodyName
sqlite_autoindex_FCT_WreckComponents_1 FCT_WreckComponents
sqlite_autoindex_ForeignAid_1 ForeignAid

Concept map

Section titled “Concept map”

The NULL column describes explicit SQL nullability. Primary key and rowid behaviour is explained under Storage notation and relationships.

Resources

Section titled “Resources”

Related community documentation and developer posts. These may describe a different game version.

Column name directory

Section titled “Column name directory”

Some column names occur in several tables. Choose the table that matches the record described in the article; the same name does not imply the same meaning or identity domain.

Abbrev — 2 tables
Abbreviation — 9 tables
ActiveJammerStrength — 2 tables
ActiveSensorsOn — 2 tables
Albedo — 2 tables
AlertColour — 2 tables
AlienClassID — 5 tables
AlienRaceID — 9 tables
AlienSensorID — 2 tables
Amount — 20 tables
AnchorFleetBearingOffset — 2 tables
AnchorFleetDistance — 2 tables
AnchorFleetID — 2 tables
ArmourColumn — 2 tables
ArmourStrength — 2 tables
ArmourThickness — 2 tables
AssignedFormationID — 3 tables
AtmosPress — 2 tables
AutoAssign — 2 tables
AutomatedDesignID — 3 tables
AutomatedTemplateID — 4 tables
AvoidDanger — 2 tables
BaseTemp — 2 tables
Bearing — 5 tables
BGTech1 — 2 tables
BGTech2 — 2 tables
BGTech3 — 2 tables
BGTech4 — 2 tables
BGTech5 — 2 tables
BGTech6 — 2 tables
BGTech7 — 2 tables
Blue — 2 tables
BodyClass — 2 tables
BodyTypeID — 2 tables
BonusID — 2 tables
BonusOne — 2 tables
BonusThree — 2 tables
BonusTwo — 2 tables
Boronide — 10 tables
C2Orbit — 2 tables
C3Orbit — 2 tables
C3OrbitType — 2 tables
C4Orbit — 2 tables
C4OrbitType — 2 tables
CapabilityID — 2 tables
CategoryID — 2 tables
Civilian — 4 tables
ClassID — 7 tables
ClassName — 4 tables
ClassSummaryTypeID — 2 tables
ClassThemeID — 2 tables
Collier — 2 tables
Colour — 3 tables
CommanderID — 5 tables
CommanderPriority — 2 tables
Commercial — 2 tables
CompletedBP — 3 tables
Component1ID — 2 tables
Component2ID — 2 tables
Component3ID — 2 tables
Component4ID — 2 tables
ComponentID — 5 tables
ComponentName — 3 tables
ComponentTypeID — 4 tables
ComponentValue — 2 tables
ConditionID — 3 tables
ConscriptOnly — 2 tables
ConstellationName — 2 tables
Construction — 3 tables
Corbomite — 10 tables
Corundium — 9 tables
Cost — 5 tables
CreateFWP — 2 tables
CreationTime — 4 tables
Crew — 4 tables
CrewDesignEfficiency — 3 tables
CurrentOrbitalSpeed — 2 tables
Damage — 2 tables
Density — 2 tables
Description — 30 tables
DestinationID — 2 tables
DestinationItemID — 2 tables
DestinationItemType — 3 tables
DestinationType — 2 tables
Destroyed — 3 tables
DetectRaceID — 3 tables
DisplayOrder — 12 tables
Distance — 6 tables
DistanceToOrbitCentre — 2 tables
DistanceToParent — 2 tables
DominantTerrain — 2 tables
Duranium — 9 tables
Eccentricity — 3 tables
EccentricityDirection — 2 tables
ECCM — 4 tables
ElementID — 3 tables
Endurance — 2 tables
Engineering — 2 tables
EnginePowerMod — 2 tables
EngineType — 2 tables
EventTypeID — 3 tables
ExtraHTK — 2 tables
Factories — 2 tables
FCNum — 4 tables
FCTypeID — 3 tables
Female — 2 tables
FieldPosition — 5 tables
FireControlJammerStrength — 2 tables
FirstDetected — 3 tables
FlagPic — 2 tables
Fleet — 2 tables
FleetID — 8 tables
FleetName — 2 tables
FormationID — 3 tables
FormationName — 2 tables
FormationTemplateID — 5 tables
Fuel — 3 tables
FuelEfficiency — 2 tables
FuelRequired — 2 tables
FuelTanker — 2 tables
Gallicite — 10 tables
GameID — 148 tables
GameTime — 5 tables
GeoSurvey — 2 tables
GHFactor — 2 tables
GovTypeID — 2 tables
GradePoints — 2 tables
Gravity — 3 tables
GravSurvey — 2 tables
Green — 2 tables
Ground — 2 tables
GroundForceDeploymentThemeID — 2 tables
GroundUnitClassID — 3 tables
GroundUnitSeriesID — 2 tables
GuardNearestHostileContact — 2 tables
GuardNearestKnownWarship — 2 tables
GUClassType — 2 tables
HomeworldID — 2 tables
HullDescriptionID — 2 tables
HullID — 3 tables
HydroExt — 2 tables
HydroID — 2 tables
idx — 2 tables
Income — 2 tables
IncrementID — 2 tables
IncrementStartX — 4 tables
IncrementStartY — 4 tables
JumpDistance — 3 tables
JumpRating — 2 tables
KeyElement — 2 tables
KillTonnageCommercial — 2 tables
KillTonnageMilitary — 2 tables
KnownSystemID — 2 tables
LastTransitTime — 2 tables
LastXcor — 4 tables
LastYcor — 4 tables
LifepodID — 2 tables
LoadSubUnits — 2 tables
LocationNumber — 2 tables
Logistics — 2 tables
Luminosity — 2 tables
MagneticField — 2 tables
MainFunction — 2 tables
MaintPriority — 2 tables
Mandatory — 2 tables
Mass — 3 tables
MaterialID — 2 tables
MaxChance — 7 tables
MaxItems — 2 tables
MaxSpeed — 2 tables
MaxWeaponRange — 2 tables
MeanOrbitalSpeed — 2 tables
MeasurementType — 4 tables
MedalConditionID — 2 tables
MedalID — 3 tables
Mercassium — 9 tables
MessageText — 3 tables
MinDistance — 2 tables
MineralDataType — 2 tables
Mines — 3 tables
MinimumFuel — 2 tables
MinimumSupplies — 2 tables
MiningModules — 2 tables
MinQuantity — 3 tables
MissileID — 7 tables
MissileJammerStrength — 2 tables
MoveActionID — 3 tables
Name — 28 tables
NameThemeID — 7 tables
Naval — 2 tables
Neutral — 2 tables
Neutronium — 9 tables
NewSystemID — 2 tables
NoArmour — 2 tables
NoOfficers — 2 tables
Notes — 5 tables
Number — 4 tables
NumberOfShots — 2 tables
NumComponent — 2 tables
NumGroups — 2 tables
NumShips — 2 tables
Obsolete — 3 tables
OffsetBearing — 2 tables
OperationalGroupID — 5 tables
OpGroupProgressionType — 2 tables
OrbDistance — 2 tables
OrbitalDistance — 3 tables
OrbitBodyID — 4 tables
OrbitNumber — 2 tables
OrderDelay — 2 tables
OrderID — 2 tables
OrderTemplateID — 2 tables
OrganizationLinkID — 2 tables
ParentBodyType — 2 tables
ParentLinkID — 2 tables
ParentShipID — 2 tables
Pause — 2 tables
PDProtectionPriority — 2 tables
Percentage — 3 tables
PlanetaryInstallationID — 2 tables
PlanetIcon — 2 tables
PlanetNumber — 2 tables
PlannedDeployment — 2 tables
PointDefenceWeapon — 2 tables
Population — 2 tables
PopulationID — 22 tables
PreTNT — 2 tables
PrimaryName — 2 tables
Priority — 7 tables
ProgressionOrder — 3 tables
ProjectID — 2 tables
RaceID — 62 tables
RaceName — 2 tables
RacePic — 2 tables
Radius — 4 tables
Range — 2 tables
RankID — 2 tables
RankName — 2 tables
RechargeRemaining — 2 tables
Red — 2 tables
Refineries — 3 tables
RefuelPriority — 3 tables
RequiredRank — 2 tables
RequiredTechID — 2 tables
Research — 2 tables
ResearchField — 2 tables
Resolution — 4 tables
ResSpecID — 2 tables
ResupplyPriority — 3 tables
RGE — 2 tables
Ring — 2 tables
Roche — 2 tables
RuinID — 2 tables
RuinRaceID — 3 tables
SeniorCO — 2 tables
SensorStrength — 2 tables
ShieldStrength — 2 tables
ShipClassID — 5 tables
ShipClassTemplateID — 2 tables
ShipComponentTemplateID — 3 tables
ShipID — 26 tables
ShipName — 2 tables
ShippingLineID — 3 tables
ShipyardID — 2 tables
ShortName — 2 tables
Size — 7 tables
Sorium — 9 tables
SpecialNPRID — 2 tables
SpeciesID — 11 tables
SpecificThreatID — 2 tables
SpectralClass — 2 tables
Speed — 5 tables
StarID — 3 tables
StartSystemID — 3 tables
STO — 2 tables
StrikeGroup — 2 tables
SubFleetID — 2 tables
Suffix — 2 tables
SupplyShip — 2 tables
SurfaceTemp — 2 tables
Survey — 2 tables
SurveyPointsRequired — 2 tables
SystemBodyID — 12 tables
SystemID — 23 tables
TargetID — 2 tables
TargetType — 2 tables
TaskID — 2 tables
TaskPercentage — 2 tables
tbl — 2 tables
TechID — 5 tables
TechProgressionCategoryID — 2 tables
TechSystemID — 11 tables
TechTypeID — 3 tables
TectonicActivity — 2 tables
Temperature — 2 tables
TemplateID — 5 tables
TemplateName — 2 tables
TextColour — 2 tables
ThemeID — 4 tables
ThermalSignature — 3 tables
TidalForce — 2 tables
TidalLock — 2 tables
Tilt — 2 tables
Time — 2 tables
Title — 3 tables
ToHitModifier — 2 tables
TotalBP — 2 tables
TrackingSpeed — 3 tables
TractorParentShipID — 2 tables
TradeGoodID — 2 tables
TrainingLevel — 2 tables
TraitID — 2 tables
Tritanium — 10 tables
Units — 2 tables
Uridium — 10 tables
UseAnchorDestination — 2 tables
Vendarite — 9 tables
ViewingRaceID — 3 tables
ViewRaceID — 5 tables
WarpPointID — 2 tables
WeaponID — 4 tables
WeaponNum — 2 tables
WreckID — 3 tables
X — 2 tables
Xcor — 20 tables
Y — 2 tables
Ycor — 20 tables
Year — 2 tables
Z — 2 tables