<html>
<head>
<title>PLUM: Database Structure: Runs table</title>
<link rel="stylesheet" type="text/css" href="../style.css">
</head>
<body>
<div class="section"><h1>Rack Database Structure: Runs 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>Unique index numner for each run, automatically assigned</td>
  </tr>

<tr>
    <td>name</td>
    <td>string</td>
    <td>Descriptive name for this scenario</td>
  </tr>


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

  <tr>
    <td>comment</td>
    <td>string</td>
    <td>These fields have all been replaced with new ways of doing things.</td>
  </tr>

<tr>
  <td>constraints</td>
  <td>integer</td>
  <td></td>
</tr>

<tr>
  <td>oldcons</td>
  <td>integer</td>
  <td></td>
</tr>

<tr>
  <td>newsams</td>
  <td>integer</td>
  <td></td>
</tr>


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

<tr>
  <td>min</td>
  <td>integer</td>
  <td>minimum number of racks/facilities to select</td>
</tr>

<tr>
  <td>max</td>
  <td>integer</td>
  <td>maximum number of racks/facilities to select</td>
</tr>

<tr>
  <td>numcombos</td>
  <td>integer</td>
  <td>number of combinations at each number of racks/facilities, usually 1000</td>
</tr>

<tr>
  <td>tblname</td>
  <td>string</td>
  <td>name of the table to store the output data in</td>
</tr>

<tr>
  <td>outputdb</td>
  <td>string</td>
  <td>name of the database tblname is in</td>
</tr>

<tr>
  <td>outputpath</td>
  <td>string</td>
  <td>where to put the charts for this run inside the PLUM output directory.</td>
</tr>

<tr>
  <td>topology</td>
  <td>string</td>
  <td>name of the rack topology to use, links to name in topology table</td>
</tr>

<tr>
  <td>ignorezeros</td>
  <td>boolean</td>
  <td>if this is true, then resources with a zero capability never exceed no matter what the total usage is.</td>
</tr>


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

<tr>
  <td>MLE</td>
  <td>number</td>
  <td></td>
</tr>

<tr>
  <td>stowage</td>
  <td>number</td>
  <td></td>
</tr>

<tr>
  <td>upmass</td>
  <td>number</td>
  <td></td>
</tr>

<tr>
  <td>bulk</td>
  <td>number</td>
  <td></td>
</tr>

<tr>
  <td>rack_overhead</td>
  <td>number</td>
  <td></td>
</tr>

<tr>
  <td>crewtrng</td>
  <td>number</td>
  <td></td>
</tr>

<tr>
  <td>crewtime</td>
  <td>number</td>
  <td></td>
</tr>

<tr>
  <td>power</td>
  <td>number</td>
  <td></td>
</tr>

<tr>
  <td>keepalive</td>
  <td>number</td>
  <td></td>
</tr>


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

<tr>
  <td>avg_uplink</td>
  <td>number</td>
  <td></td>
</tr>

<tr>
  <td>avg_ethernet</td>
  <td>number</td>
  <td></td>
</tr>

<tr>
  <td>avg_1553</td>
  <td>number</td>
  <td></td>
</tr>

<tr>
  <td>avg_HRL</td>
  <td>number</td>
  <td></td>
</tr>

<tr>
  <td>avg_downlink</td>
  <td>number</td>
  <td></td>
</tr>

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

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

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

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

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

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

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

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

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

<tr>
  <td>peak_HRL_duration</td>
  <td>number</td>
  <td></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 class="group"><td colspan=3><center>Constant fields</center></td></tr>

<tr>
  <td>inclength</td>
  <td>number</td>
  <td>the number of days in an increment. Usually 90 or 180.</td>
</tr>

<tr>
  <td>middeckmass</td>
  <td>number</td>
  <td></td>
</tr>

<tr>
  <td>passiveMLE</td>
  <td>number</td>
  <td></td>
</tr>

<tr>
  <td>passive_middeck_mass</td>
  <td>number</td>
  <td></td>
</tr>

<tr>
  <td>sams_power</td>
  <td>number</td>
  <td>The power usage of SAMS. Added to the power requirement of the rack containing SAMS.</td>
</tr>

<tr>
  <td>hskpg</td>
  <td>number</td>
  <td></td>
</tr>

<tr>
  <td>ku_power</td>
  <td>number</td>
  <td></td>
</tr>

<tr>
  <td>pl_power</td>
  <td>number</td>
  <td></td>
</tr>

<tr>
  <td>stowage_MLEs</td>
  <td>number</td>
  <td></td>
</tr>


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

<tr>
  <td>cs_p4_asc</td>
  <td>number</td>
  <td></td>
</tr>

<tr>
  <td>cs_p4_orb</td>
  <td>number</td>
  <td></td>
</tr>

<tr>
  <td>cs_p4_desc</td>
  <td>number</td>
  <td></td>
</tr>

<tr>
  <td>cs_m20_asc</td>
  <td>number</td>
  <td></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>
