<html>
<head>
<title>PLUM: Database Structure: Racks table</title>
<link rel="stylesheet" type="text/css" href="../style.css">
</head>
<body>
<div class="section"><h1>Rack Database Structure: Racks table</h1></div>

<div class="section">
<table class="database">

  <tr class="group"><td colspan=3><center>Structural fields</center></td></tr>

  <tr>
    <td>idx</td>
    <td>integer</td>
    <td>This is the primary key field. Each rack has a unique idx.</td>
  </tr>
  
  <tr>
    <td>location</td>
    <td>integer</td>
    <td>Linked to idx in locations table. Shows what location the rack is in.</td>
  </tr>

  <tr>
    <td>attached</td>
    <td>boolean</td>
    <td>Whether this rack is attached or pressurized.</td>
  </tr>

  <tr class="group"><td colspan=3><center>Identification fields</center></td></tr>

  <tr>
    <td>name</td>
    <td>string</td>
    <td></td>
  </tr>
  
  <tr>
    <td>acronym</td>
    <td>string</td>
    <td>A shorter version of the name, used for display.</td>
  </tr>

  <tr class="group"><td colspan=3><center>Launch fields</center></td></tr>

  <tr>
    <td>partner</td>
    <td>string</td>
    <td>The name of the international partner who made the rack</td>
  </tr>

  <tr>
    <td>launch_date</td>
    <td>string</td>
    <td>The date the rack was/will be launched</td>
  </tr>

  <tr>
    <td>flight_launched</td>
    <td>string</td>
    <td>The name of the flight that launched the rack</td>
  </tr>

  <tr class="group"><td colspan=3><center>Resource fields</center></td></tr>

  <tr>
    <td>cycles_per_increment</td>
    <td>number</td>
    <td>The number of times in an increment this rack will run</td>
  </tr>

  <tr>
    <td>hrs_per_cycle</td>
    <td>number</td>
    <td>The number of hours in each run. hrs_per_cycle*cycles_per_increment=runtime</td>
  </tr>

  <tr>
    <td>upmass_resupply</td>
    <td>number</td>
    <td>The mass in kg of upmass needed to supply this rack.</td>
  </tr>

  <tr>
    <td>mid_resupply</td>
    <td>number</td>
    <td>The number of MLEs needed to supply this rack</td>
  </tr>

  <tr>
    <td>stowage</td>
    <td>number</td>
    <td>The volume of stowage this rack needs</td>
  </tr>

  <tr>
    <td>power</td>
    <td>number</td>
    <td>kW of power needed for running</td>
  </tr>

  <tr>
    <td>keepalive_power</td>
    <td>number</td>
    <td>kW of power needed for keepalive</td>
  </tr>

  <tr>
    <td>crew_training</td>
    <td>number</td>
    <td>Hrs needed to train the crew to use this rack.</td>
  </tr>

  <tr>
    <td>crew_time</td>
    <td>number</td>
    <td>Hrs per week the crew needs to use this rack</td>
  </tr>

  <tr>
    <td>sams</td>
    <td>integer</td>
    <td>The SAMS status of the rack. 0: no SAMS req'd, 1: SAMS req'd, 2: contains SAMS.</td>
  </tr>

  <tr class="group"><td colspan=3><center>MTL/LTL fields</center></td></tr>

  <tr>
    <td>MTL_flow</td>
    <td>number</td>
    <td>The flow rate of MTL through this rack</td>
  </tr>

  <tr>
    <td>MTL_flow_keepalive</td>
    <td>number</td>
    <td>The MTL flow rate during keepalive mode.</td>
  </tr>

  <tr>
    <td>MTL_inlet</td>
    <td>number</td>
    <td>The temperature of coolant going into the rack.</td>
  </tr>

  <tr>
    <td>MTL_outlet</td>
    <td>number</td>
    <td>The temperature of coolant leaving the rack</td>
  </tr>

  <tr>
    <td>MTL_calc</td>
    <td>boolean</td>
    <td>True if the flow should be calculated from the inlet/outlet temps, false if given.</td>
  </tr>

  <tr>
    <td>LTL_flow</td>
    <td>number</td>
    <td>The flow rate of LTL through this rack</td>
  </tr>

  <tr>
    <td>LTL_flow_keepalive</td>
    <td>number</td>
    <td>The LTL flow rate during keepalive mode.</td>
  </tr>

  <tr>
    <td>LTL_inlet</td>
    <td>number</td>
    <td>The temperature of coolant going into the rack.</td>
  </tr>

  <tr>
    <td>LTL_outlet</td>
    <td>number</td>
    <td>The temperature of coolant leaving the rack</td>
  </tr>

  <tr>
    <td>LTL_calc</td>
    <td>boolean</td>
    <td>True if the flow should be calculated from the inlet/outlet temps, false if given.</td>
  </tr>

  <tr class="group"><td colspan=3><center>Networking fields</center></td></tr>

  <tr>
    <td>video_uplink</td>
    <td>number</td>
    <td></td>
  </tr>

  <tr>
    <td>video_downlink</td>
    <td>number</td>
    <td></td>
  </tr>

  <tr>
    <td>video_rate</td>
    <td>number</td>
    <td></td>
  </tr>

  <tr>
    <td>nominal_uplink</td>
    <td>number</td>
    <td></td>
  </tr>
  
  <tr>
    <td>peak_uplink</td>
    <td>number</td>
    <td></td>
  </tr>

  <tr>
    <td>peak_uplink_duration</td>
    <td>number</td>
    <td></td>
  </tr>

  <tr>
    <td>nominal_downlink</td>
    <td>number</td>
    <td></td>
  </tr>

  <tr>
    <td>peak_downlink</td>
    <td>number</td>
    <td></td>
  </tr>

  <tr>
    <td>peak_downlink_duration</td>
    <td>number</td>
    <td></td>
  </tr>

  <tr>
    <td>nominal_1553</td>
    <td>number</td>
    <td></td>
  </tr>

  <tr>
    <td>peak_1553</td>
    <td>number</td>
    <td></td>
  </tr>

  <tr>
    <td>peak_1553_duration</td>
    <td>number</td>
    <td></td>
  </tr>

  <tr>
    <td>nominal_ethernet</td>
    <td>number</td>
    <td></td>
  </tr>

  <tr>
    <td>peak_ethernet</td>
    <td>number</td>
    <td></td>
  </tr>

  <tr>
    <td>peak_ethernet_duration</td>
    <td>number</td>
    <td></td>
  </tr>

  <tr>
    <td>nominal_HRL</td>
    <td>number</td>
    <td></td>
  </tr>

  <tr>
    <td>peak_HRL</td>
    <td>number</td>
    <td></td>
  </tr>

  <tr>
    <td>peak_HRL_duration</td>
    <td>number</td>
    <td></td>
  </tr>

  <tr class="group"><td colspan=3><center>Interface fields</center></td></tr>

  <tr>
    <td>interface_LTL</td>
    <td>boolean</td>
    <td>These fields are all whether or not this rack requires this interface.</td>
  </tr>

  <tr>
    <td>interface_MTL</td>
    <td>boolean</td>
    <td></td>
  </tr>

  <tr>
    <td>interface_ARIS</td>
    <td>boolean</td>
    <td>Active Rack Isolation System</td>
  </tr>

  <tr>
    <td>interface_VacuumR</td>
    <td>boolean</td>
    <td>Vacuum resource</td>
  </tr>

  <tr>
    <td>interface_VacuumE</td>
    <td>boolean</td>
    <td>Vacuum exhaust</td>
  </tr>

  <tr>
    <td>interface_RFCA</td>
    <td>boolean</td>
    <td>Rack Flow Control Assembly</td>
  </tr>

  <tr>
    <td>interface_He</td>
    <td>boolean</td>
    <td></td>
  </tr>

  <tr>
    <td>interface_N2</td>
    <td>boolean</td>
    <td></td>
  </tr>

  <tr>
    <td>interface_CO2</td>
    <td>boolean</td>
    <td></td>
  </tr>

  <tr>
    <td>interface_Ar</td>
    <td>boolean</td>
    <td></td>
  </tr>

  <tr class="group"><td colspan=3><center>Outfitting fields</center></td></tr>

  <tr>
    <td>outfitting_upmass</td>
    <td>number</td>
    <td></td>
  </tr>

  <tr>
    <td>outfitting_MDLs</td>
    <td>number</td>
    <td>Middeck lockers</td>
  </tr>

  <tr class="group"><td colspan=3><center>Outfitting fields</center></td></tr>

  <tr>
    <td>cs_p4_asc</td>
    <td>number</td>
    <td>Cold stowage requirements. p4 means +4 degrees C. asc means ascent</td>
  </tr>

  <tr>
    <td>cs_p4_orb</td>
    <td>number</td>
    <td>orb means on-orbit</td>
  </tr>

  <tr>
    <td>cs_p4_desc</td>
    <td>number</td>
    <td>desc means descent</td>
  </tr>

  <tr>
    <td>cs_m20_asc</td>
    <td>number</td>
    <td>m20 is -20 degrees C.</td>
  </tr>

  <tr>
    <td>cs_m20_orb</td>
    <td>number</td>
    <td></td>
  </tr>

  <tr>
    <td>cs_m20_desc</td>
    <td>number</td>
    <td></td>
  </tr>

  <tr>
    <td>cs_m80_asc</td>
    <td>number</td>
    <td></td>
  </tr>

  <tr>
    <td>cs_m80_orb</td>
    <td>number</td>
    <td></td>
  </tr>

  <tr>
    <td>cs_m80_desc</td>
    <td>number</td>
    <td></td>
  </tr>

  <tr>
    <td>cs_m180_asc</td>
    <td>number</td>
    <td></td>
  </tr>

  <tr>
    <td>cs_m180_orb</td>
    <td>number</td>
    <td></td>
  </tr>

  <tr>
    <td>cs_m180_desc</td>
    <td>number</td>
    <td></td>
  </tr>

</table>

</div>

<div class="section">
<img src="../img/nasa.jpg">
</div>
</body>
</html>
