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