# Rack Database Structure: Racks table

Structural fields
idx | integer | This is the primary key field. Each rack has a unique idx.
location | integer | Linked to idx in locations table. Shows what location the rack is in.
attached | boolean | Whether this rack is attached or pressurized.
Identification fields
name | string |
acronym | string | A shorter version of the name, used for display.
Launch fields
partner | string | The name of the international partner who made the rack
launch_date | string | The date the rack was/will be launched
flight_launched | string | The name of the flight that launched the rack
Resource fields
cycles_per_increment | number | The number of times in an increment this rack will run
hrs_per_cycle | number | The number of hours in each run. hrs_per_cycle*cycles_per_increment=runtime
upmass_resupply | number | The mass in kg of upmass needed to supply this rack.
mid_resupply | number | The number of MLEs needed to supply this rack
stowage | number | The volume of stowage this rack needs
power | number | kW of power needed for running
keepalive_power | number | kW of power needed for keepalive
crew_training | number | Hrs needed to train the crew to use this rack.
crew_time | number | Hrs per week the crew needs to use this rack
sams | integer | The SAMS status of the rack. 0: no SAMS req'd, 1: SAMS req'd, 2: contains SAMS.
MTL/LTL fields
MTL_flow | number | The flow rate of MTL through this rack
MTL_flow_keepalive | number | The MTL flow rate during keepalive mode.
MTL_inlet | number | The temperature of coolant going into the rack.
MTL_outlet | number | The temperature of coolant leaving the rack
MTL_calc | boolean | True if the flow should be calculated from the inlet/outlet temps, false if given.
LTL_flow | number | The flow rate of LTL through this rack
LTL_flow_keepalive | number | The LTL flow rate during keepalive mode.
LTL_inlet | number | The temperature of coolant going into the rack.
LTL_outlet | number | The temperature of coolant leaving the rack
LTL_calc | boolean | True if the flow should be calculated from the inlet/outlet temps, false if given.
Networking fields
video_uplink | number |
video_downlink | number |
video_rate | number |
nominal_uplink | number |
peak_uplink | number |
peak_uplink_duration | number |
nominal_downlink | number |
peak_downlink | number |
peak_downlink_duration | number |
nominal_1553 | number |
peak_1553 | number |
peak_1553_duration | number |
nominal_ethernet | number |
peak_ethernet | number |
peak_ethernet_duration | number |
nominal_HRL | number |
peak_HRL | number |
peak_HRL_duration | number |
Interface fields
interface_LTL | boolean | These fields are all whether or not this rack requires this interface.
interface_MTL | boolean |
interface_ARIS | boolean | Active Rack Isolation System
interface_VacuumR | boolean | Vacuum resource
interface_VacuumE | boolean | Vacuum exhaust
interface_RFCA | boolean | Rack Flow Control Assembly
interface_He | boolean |
interface_N2 | boolean |
interface_CO2 | boolean |
interface_Ar | boolean |
Outfitting fields
outfitting_upmass | number |
outfitting_MDLs | number | Middeck lockers
Cold stowage fields
cs_p4_asc | number | Cold stowage requirements. p4 means +4 degrees C. asc means ascent
cs_p4_orb | number | orb means on-orbit
cs_p4_desc | number | desc means descent
cs_m20_asc | number | m20 is -20 degrees C.
cs_m20_orb | number |
cs_m20_desc | number |
cs_m80_asc | number |
cs_m80_orb | number |
cs_m80_desc | number |
cs_m180_asc | number |
cs_m180_orb | number |
cs_m180_desc | number |