Table topp.deprecated.psat_program_data Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
programid int4 10  √  null
tagprograms.programid Implied Constraint R
progdatacomment varchar 255  √  null
repetition_rate float4 8,8  √  null
shrink_rate float4 8,8  √  null
shrink_id varchar 40  √  null
hardware_version varchar 40  √  null
software_version varchar 40  √  null
programming_software varchar 160  √  null
pin_type varchar 40  √  null
datetime timestamptz 35,6  √  null
depth_reading float4 8,8  √  null
depth_button_pressed bool 1  √  null
temperature float4 8,8  √  null
light_level float4 8,8  √  null
rtc_temp float4 8,8  √  null
depth_temp float4 8,8  √  null
battery_voltage float4 8,8  √  null
depth_interval float4 8,8  √  null
light_interval float4 8,8  √  null
temp_interval float4 8,8  √  null
depthtemp_interval float4 8,8  √  null
rtc_temp_interval float4 8,8  √  null
battery_voltage_interval float4 8,8  √  null
programmed_release_datetime timestamptz 35,6  √  null
location_priority varchar 40  √  null
pdt_priority varchar 40  √  null
histogram_priority varchar 40  √  null
three_days_loc_data bool 1  √  null
data_collection_interval float4 8,8  √  null
histogram_type varchar 40  √  null
histogramid int4 10  √  null
histogramtemplates.histogramid Implied Constraint R
depth_correction float4 8,8  √  null
hours_at_depth_before_pop_off float4 8,8  √  null
assume_constant_depth_if_varies_by float4 8,8  √  null
number_of_consecutive_outliers int4 10  √  null
detection_start varchar 40  √  null
histo_kb1 float4 8,8  √  null
pdt_kp1 float4 8,8  √  null
location_kb1 float4 8,8  √  null
archival_kb1 float4 8,8  √  null
memory_allocation_button_clicked bool 1  √  null
light_blinking bool 1  √  null

Table contained 0 rows at Wed Dec 27 13:21 PST 2017


Close relationships: