Rack Database Structure: Output table

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.

Fields
Structural Fields
idx integer Auto-incrementing index
selects string A string of 1s and 0s denoting which racks are selected
combonum integer
selectednum integer The number of racks selected
finished boolean Whether this row has been calculated or not; used for tracking progress of a run.
needssams boolean Whether this row needs SAMS active.
Any-Exceeded Fields
any_exceeded_inc boolean Whether any of the increment-length resources exceeded
any_exceeded_simul boolean Whether any of the simultaneous resources exceeded
Low-Temperature Loop Fields
LTL_ttl_AIR number The total LTL usage for each module
LTL_ttl_APM number
LTL_ttl_CAM number
LTL_ttl_HAB number
LTL_ttl_JEM number
LTL_ttl_JEMEF number
LTL_ttl_JEMELMPS number
LTL_ttl_LAB number
LTL_ttl_NOD1 number
LTL_ttl_NOD2 number
LTL_ttl_NOD3 number
LTL_ttl_TRUSS number
LTL_xcd_AIR boolean Whether the LTL usage for a module exceeds that module's capability
LTL_xcd_APM boolean
LTL_xcd_CAM boolean
LTL_xcd_HAB boolean
LTL_xcd_JEM boolean
LTL_xcd_JEMEF boolean
LTL_xcd_JEMELMPS boolean
LTL_xcd_LAB boolean
LTL_xcd_NOD1 boolean
LTL_xcd_NOD2 boolean
LTL_xcd_NOD3 boolean
LTL_xcd_TRUSS boolean
LTL_xcd number True if any module exceeded LTL.
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
Moderate-Temperature Loop Fields
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 Fields
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
Cold-Stowage Fields
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 Fields
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
Networking Fields
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 Fields
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
Other Resources
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