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

<div class="section">

<p>
  This table is the output for one run. It is probably in a different database, and has a name defined in the runs table entry for that run. It has two fields for each resource; a totals field and an exceeds field.
</p>
<table class="database">

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

  <tr class="group"><td colspan=3><center>Any-Exceeded Fields</center></td></tr>

  <tr>
    <td>any_exceeded_inc</td>
    <td>boolean</td>
    <td>Whether any of the increment-length resources exceeded</td>
  </tr>
  
  <tr>
    <td>any_exceeded_simul</td>
    <td>boolean</td>
    <td>Whether any of the simultaneous resources exceeded</td>
  </tr>
  
  <tr class="group"><td colspan=3><center>Low-Temperature Loop Fields</center></td></tr>
  
  <tr>
    <td>LTL_ttl_AIR</td>
    <td>number</td>
    <td>The total LTL usage for each module</td>
  </tr>

<tr>
  <td>LTL_ttl_APM</td>
  <td>number</td>
  <td></td>
</tr>

<tr>
  <td>LTL_ttl_CAM</td>
  <td>number</td>
  <td></td>
</tr>

<tr>
  <td>LTL_ttl_HAB</td>
  <td>number</td>
  <td></td>
</tr>

<tr>
  <td>LTL_ttl_JEM</td>
  <td>number</td>
  <td></td>
</tr>

<tr>
  <td>LTL_ttl_JEMEF</td>
  <td>number</td>
  <td></td>
</tr>

<tr>
  <td>LTL_ttl_JEMELMPS</td>
  <td>number</td>
  <td></td>
</tr>

<tr>
  <td>LTL_ttl_LAB</td>
  <td>number</td>
  <td></td>
</tr>

<tr>
  <td>LTL_ttl_NOD1</td>
  <td>number</td>
  <td></td>
</tr>

<tr>
  <td>LTL_ttl_NOD2</td>
  <td>number</td>
  <td></td>
</tr>

<tr>
  <td>LTL_ttl_NOD3</td>
  <td>number</td>
  <td></td>
</tr>

<tr>
  <td>LTL_ttl_TRUSS</td>
  <td>number</td>
  <td></td>
</tr>

<tr>
  <td>LTL_xcd_AIR</td>
  <td>boolean</td>
  <td>Whether the LTL usage for a module exceeds that module's capability</td>
</tr>

<tr>
  <td>LTL_xcd_APM</td>
  <td>boolean</td>
  <td></td>
</tr>

<tr>
  <td>LTL_xcd_CAM</td>
  <td>boolean</td>
  <td></td>
</tr>

<tr>
  <td>LTL_xcd_HAB</td>
  <td>boolean</td>
  <td></td>
</tr>

<tr>
  <td>LTL_xcd_JEM</td>
  <td>boolean</td>
  <td></td>
</tr>

<tr>
  <td>LTL_xcd_JEMEF</td>
  <td>boolean</td>
  <td></td>
</tr>

<tr>
  <td>LTL_xcd_JEMELMPS</td>
  <td>boolean</td>
  <td></td>
</tr>

<tr>
  <td>LTL_xcd_LAB</td>
  <td>boolean</td>
  <td></td>
</tr>

<tr>
  <td>LTL_xcd_NOD1</td>
  <td>boolean</td>
  <td></td>
</tr>

<tr>
  <td>LTL_xcd_NOD2</td>
  <td>boolean</td>
  <td></td>
</tr>

<tr>
  <td>LTL_xcd_NOD3</td>
  <td>boolean</td>
  <td></td>
</tr>

<tr>
  <td>LTL_xcd_TRUSS</td>
  <td>boolean</td>
  <td></td>
</tr>

<tr>
  <td>LTL_xcd</td>
  <td>number</td>
  <td>True if any module exceeded LTL.</td>
</tr>


LTL_crewtend_ttl_AIR number
LTL_crewtend_ttl_APM number
LTL_crewtend_ttl_CAM number
LTL_crewtend_ttl_HAB number
LTL_crewtend_ttl_JEM number
LTL_crewtend_ttl_JEMEF number
LTL_crewtend_ttl_JEMELMPS number
LTL_crewtend_ttl_LAB number
LTL_crewtend_ttl_NOD1 number
LTL_crewtend_ttl_NOD2 number
LTL_crewtend_ttl_NOD3 number
LTL_crewtend_ttl_TRUSS number
LTL_crewtend_xcd_AIR boolean
LTL_crewtend_xcd_APM boolean
LTL_crewtend_xcd_CAM boolean
LTL_crewtend_xcd_HAB boolean
LTL_crewtend_xcd_JEM boolean
LTL_crewtend_xcd_JEMEF boolean
LTL_crewtend_xcd_JEMELMPS boolean
LTL_crewtend_xcd_LAB boolean
LTL_crewtend_xcd_NOD1 boolean
LTL_crewtend_xcd_NOD2 boolean
LTL_crewtend_xcd_NOD3 boolean
LTL_crewtend_xcd_TRUSS boolean
LTL_crewtend_xcd number

LTL_ttl_simul_AIR number
LTL_ttl_simul_APM number
LTL_ttl_simul_CAM number
LTL_ttl_simul_HAB number
LTL_ttl_simul_JEM number
LTL_ttl_simul_JEMEF number
LTL_ttl_simul_JEMELMPS number
LTL_ttl_simul_LAB number
LTL_ttl_simul_NOD1 number
LTL_ttl_simul_NOD2 number
LTL_ttl_simul_NOD3 number
LTL_ttl_simul_TRUSS number
LTL_xcd_simul_AIR boolean
LTL_xcd_simul_APM boolean
LTL_xcd_simul_CAM boolean
LTL_xcd_simul_HAB boolean
LTL_xcd_simul_JEM boolean
LTL_xcd_simul_JEMEF boolean
LTL_xcd_simul_JEMELMPS boolean
LTL_xcd_simul_LAB boolean
LTL_xcd_simul_NOD1 boolean
LTL_xcd_simul_NOD2 boolean
LTL_xcd_simul_NOD3 boolean
LTL_xcd_simul_TRUSS boolean
LTL_simul_xcd number

MTL_ttl_AIR number
MTL_ttl_APM number
MTL_ttl_CAM number
MTL_ttl_HAB number
MTL_ttl_JEM number
MTL_ttl_JEMEF number
MTL_ttl_JEMELMPS number
MTL_ttl_LAB number
MTL_ttl_NOD1 number
MTL_ttl_NOD2 number
MTL_ttl_NOD3 number
MTL_ttl_TRUSS number
MTL_xcd_AIR boolean
MTL_xcd_APM boolean
MTL_xcd_CAM boolean
MTL_xcd_HAB boolean
MTL_xcd_JEM boolean
MTL_xcd_JEMEF boolean
MTL_xcd_JEMELMPS boolean
MTL_xcd_LAB boolean
MTL_xcd_NOD1 boolean
MTL_xcd_NOD2 boolean
MTL_xcd_NOD3 boolean
MTL_xcd_TRUSS boolean
MTL_xcd number

MTL_crewtend_ttl_AIR number
MTL_crewtend_ttl_APM number
MTL_crewtend_ttl_CAM number
MTL_crewtend_ttl_HAB number
MTL_crewtend_ttl_JEM number
MTL_crewtend_ttl_JEMEF number
MTL_crewtend_ttl_JEMELMPS number
MTL_crewtend_ttl_LAB number
MTL_crewtend_ttl_NOD1 number
MTL_crewtend_ttl_NOD2 number
MTL_crewtend_ttl_NOD3 number
MTL_crewtend_ttl_TRUSS number
MTL_crewtend_xcd_AIR boolean
MTL_crewtend_xcd_APM boolean
MTL_crewtend_xcd_CAM boolean
MTL_crewtend_xcd_HAB boolean
MTL_crewtend_xcd_JEM boolean
MTL_crewtend_xcd_JEMEF boolean
MTL_crewtend_xcd_JEMELMPS boolean
MTL_crewtend_xcd_LAB boolean
MTL_crewtend_xcd_NOD1 boolean
MTL_crewtend_xcd_NOD2 boolean
MTL_crewtend_xcd_NOD3 boolean
MTL_crewtend_xcd_TRUSS boolean
MTL_crewtend_xcd number

MTL_ttl_simul_AIR number
MTL_ttl_simul_APM number
MTL_ttl_simul_CAM number
MTL_ttl_simul_HAB number
MTL_ttl_simul_JEM number
MTL_ttl_simul_JEMEF number
MTL_ttl_simul_JEMELMPS number
MTL_ttl_simul_LAB number
MTL_ttl_simul_NOD1 number
MTL_ttl_simul_NOD2 number
MTL_ttl_simul_NOD3 number
MTL_ttl_simul_TRUSS number
MTL_xcd_simul_AIR boolean
MTL_xcd_simul_APM boolean
MTL_xcd_simul_CAM boolean
MTL_xcd_simul_HAB boolean
MTL_xcd_simul_JEM boolean
MTL_xcd_simul_JEMEF boolean
MTL_xcd_simul_JEMELMPS boolean
MTL_xcd_simul_LAB boolean
MTL_xcd_simul_NOD1 boolean
MTL_xcd_simul_NOD2 boolean
MTL_xcd_simul_NOD3 boolean
MTL_xcd_simul_TRUSS boolean
MTL_simul_xcd number

acoustics_ttl_AIR number
acoustics_ttl_APM number
acoustics_ttl_CAM number
acoustics_ttl_HAB number
acoustics_ttl_JEM number
acoustics_ttl_JEMEF number
acoustics_ttl_JEMELMPS number
acoustics_ttl_LAB number
acoustics_ttl_NOD1 number
acoustics_ttl_NOD2 number
acoustics_ttl_NOD3 number
acoustics_ttl_TRUSS number
acoustics_xcd_AIR boolean
acoustics_xcd_APM boolean
acoustics_xcd_CAM boolean
acoustics_xcd_HAB boolean
acoustics_xcd_JEM boolean
acoustics_xcd_JEMEF boolean
acoustics_xcd_JEMELMPS boolean
acoustics_xcd_LAB boolean
acoustics_xcd_NOD1 boolean
acoustics_xcd_NOD2 boolean
acoustics_xcd_NOD3 boolean
acoustics_xcd_TRUSS boolean
acoustics_xcd boolean

acoustics_crewtend_ttl_AIR number
acoustics_crewtend_ttl_APM number
acoustics_crewtend_ttl_CAM number
acoustics_crewtend_ttl_HAB number
acoustics_crewtend_ttl_JEM number
acoustics_crewtend_ttl_JEMEF number
acoustics_crewtend_ttl_JEMELMPS number
acoustics_crewtend_ttl_LAB number
acoustics_crewtend_ttl_NOD1 number
acoustics_crewtend_ttl_NOD2 number
acoustics_crewtend_ttl_NOD3 number
acoustics_crewtend_ttl_TRUSS number
acoustics_crewtend_xcd boolean
acoustics_crewtend_xcd_AIR boolean
acoustics_crewtend_xcd_APM boolean
acoustics_crewtend_xcd_CAM boolean
acoustics_crewtend_xcd_HAB boolean
acoustics_crewtend_xcd_JEM boolean
acoustics_crewtend_xcd_JEMEF boolean
acoustics_crewtend_xcd_JEMELMPS boolean
acoustics_crewtend_xcd_LAB boolean
acoustics_crewtend_xcd_NOD1 boolean
acoustics_crewtend_xcd_NOD2 boolean
acoustics_crewtend_xcd_NOD3 boolean
acoustics_crewtend_xcd_TRUSS boolean

acoustics_ttl_simul_AIR number
acoustics_ttl_simul_APM number
acoustics_ttl_simul_CAM number
acoustics_ttl_simul_HAB number
acoustics_ttl_simul_JEM number
acoustics_ttl_simul_JEMEF number
acoustics_ttl_simul_JEMELMPS number
acoustics_ttl_simul_LAB number
acoustics_ttl_simul_NOD1 number
acoustics_ttl_simul_NOD2 number
acoustics_ttl_simul_NOD3 number
acoustics_ttl_simul_TRUSS number
acoustics_xcd_simul_AIR boolean
acoustics_xcd_simul_APM boolean
acoustics_xcd_simul_CAM boolean
acoustics_xcd_simul_HAB boolean
acoustics_xcd_simul_JEM boolean
acoustics_xcd_simul_JEMEF boolean
acoustics_xcd_simul_JEMELMPS boolean
acoustics_xcd_simul_LAB boolean
acoustics_xcd_simul_NOD1 boolean
acoustics_xcd_simul_NOD2 boolean
acoustics_xcd_simul_NOD3 boolean
acoustics_xcd_simul_TRUSS boolean
acoustics_xcd_simul boolean

cs_m180_asc_ttl number
cs_m180_asc_xcd boolean
cs_m180_desc_ttl number
cs_m180_desc_xcd boolean
cs_m180_orb_ttl number
cs_m180_orb_xcd boolean

cs_m20_asc_ttl number
cs_m20_asc_xcd boolean
cs_m20_desc_ttl number
cs_m20_desc_xcd boolean
cs_m20_orb_ttl number
cs_m20_orb_xcd boolean

cs_m80_asc_ttl number
cs_m80_asc_xcd boolean
cs_m80_desc_ttl number
cs_m80_desc_xcd boolean
cs_m80_orb_ttl number
cs_m80_orb_xcd boolean

cs_p4_asc_ttl number
cs_p4_asc_xcd boolean
cs_p4_desc_ttl number
cs_p4_desc_xcd boolean
cs_p4_orb_ttl number
cs_p4_orb_xcd boolean

energy_ttl_AIR number
energy_ttl_APM number
energy_ttl_CAM number
energy_ttl_HAB number
energy_ttl_JEM number
energy_ttl_JEMEF number
energy_ttl_JEMELMPS number
energy_ttl_LAB number
energy_ttl_NOD1 number
energy_ttl_NOD2 number
energy_ttl_NOD3 number
energy_ttl_TRUSS number
energy_xcd_AIR boolean
energy_xcd_APM boolean
energy_xcd_CAM boolean
energy_xcd_HAB boolean
energy_xcd_JEM boolean
energy_xcd_JEMEF boolean
energy_xcd_JEMELMPS boolean
energy_xcd_LAB boolean
energy_xcd_NOD1 boolean
energy_xcd_NOD2 boolean
energy_xcd_NOD3 boolean
energy_xcd_TRUSS boolean
energy_xcd boolean
energy_ttl number

energy_crewtend_ttl_AIR number
energy_crewtend_ttl_APM number
energy_crewtend_ttl_CAM number
energy_crewtend_ttl_HAB number
energy_crewtend_ttl_JEM number
energy_crewtend_ttl_JEMEF number
energy_crewtend_ttl_JEMELMPS number
energy_crewtend_ttl_LAB number
energy_crewtend_ttl_NOD1 number
energy_crewtend_ttl_NOD2 number
energy_crewtend_ttl_NOD3 number
energy_crewtend_ttl_TRUSS number
energy_crewtend_xcd_AIR boolean
energy_crewtend_xcd_APM boolean
energy_crewtend_xcd_CAM boolean
energy_crewtend_xcd_HAB boolean
energy_crewtend_xcd_JEM boolean
energy_crewtend_xcd_JEMEF boolean
energy_crewtend_xcd_JEMELMPS boolean
energy_crewtend_xcd_LAB boolean
energy_crewtend_xcd_NOD1 boolean
energy_crewtend_xcd_NOD2 boolean
energy_crewtend_xcd_NOD3 boolean
energy_crewtend_xcd_TRUSS boolean
energy_crewtend_ttl number
energy_crewtend_xcd number

nominal_1553_ttl number
nominal_1553_xcd boolean
nominal_HRL_ttl number
nominal_HRL_xcd boolean
nominal_downlink_ttl number
nominal_downlink_xcd boolean
nominal_ethernet_ttl number
nominal_ethernet_xcd boolean
nominal_uplink_ttl number
nominal_uplink_xcd boolean
peak_1553_duration_ttl number
peak_1553_duration_xcd boolean
peak_1553_ttl number
peak_1553_xcd boolean
peak_HRL_duration_ttl number
peak_HRL_duration_xcd boolean
peak_HRL_ttl number
peak_HRL_xcd boolean
peak_downlink_duration_ttl number
peak_downlink_duration_xcd boolean
peak_downlink_ttl number
peak_downlink_xcd boolean
peak_ethernet_duration_ttl number
peak_ethernet_duration_xcd boolean
peak_ethernet_ttl number
peak_ethernet_xcd boolean
peak_uplink_duration_ttl number
peak_uplink_duration_xcd boolean
peak_uplink_ttl number
peak_uplink_xcd boolean
video_downlink_ttl number
video_downlink_xcd boolean
video_rate_ttl number
video_rate_xcd boolean
video_uplink_ttl number
video_uplink_xcd boolean

power_ttl_AIR number
power_ttl_APM number
power_ttl_CAM number
power_ttl_HAB number
power_ttl_JEM number
power_ttl_JEMEF number
power_ttl_JEMELMPS number
power_ttl_LAB number
power_ttl_NOD1 number
power_ttl_NOD2 number
power_ttl_NOD3 number
power_ttl_TRUSS number
power_xcd_AIR boolean
power_xcd_APM boolean
power_xcd_CAM boolean
power_xcd_HAB boolean
power_xcd_JEM boolean
power_xcd_JEMEF boolean
power_xcd_JEMELMPS boolean
power_xcd_LAB boolean
power_xcd_NOD1 boolean
power_xcd_NOD2 boolean
power_xcd_NOD3 boolean
power_xcd_TRUSS boolean
power_ttl number
power_xcd boolean

crewtime_ttl number
crewtime_xcd boolean

crewtrng_ttl number
crewtrng_xcd boolean

keepalive_ttl number
keepalive_xcd boolean

middecks_ttl number
middecks_xcd boolean

runtime_ttl number

stowage_ttl number
stowage_xcd boolean

upmass_ttl number
upmass_xcd boolean

</table>

</div>

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