SchemaSpy Analysis of topp.wc - Columns | Generated by SchemaSpy |
Generated by SchemaSpy on Wed Dec 27 13:27 PST 2017 |
| ||||||
|
topp.wc contains 741 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | Comments |
---|---|---|---|---|---|---|---|
all | altitude | int4 | 10 | √ | null | ||
all | best_level | int4 | 10 | √ | null | ||
all | comp_ | int4 | 10 | √ | null | ||
all | delta_freq. | float8 | 17,17 | √ | null | ||
all | deployid | text | 2147483647 | √ | null | ||
all | ellipse_orientation | int4 | 10 | √ | null | ||
all | error_radius | int4 | 10 | √ | null | ||
all | frequency | float8 | 17,17 | √ | null | ||
all | gdop | int4 | 10 | √ | null | ||
all | lat_.sol..1 | float8 | 17,17 | √ | null | ||
all | lat_.sol..2 | float8 | 17,17 | √ | null | ||
all | latitude | float8 | 17,17 | √ | null | ||
all | loc_.date | timestamptz | 35,6 | √ | null | ||
all | loc_.idx | int4 | 10 | √ | null | ||
all | loc_.quality | text | 2147483647 | √ | null | ||
all | loc_.type | text | 2147483647 | √ | null | ||
all | long_.1 | float8 | 17,17 | √ | null | ||
all | long_.2 | float8 | 17,17 | √ | null | ||
all | longitude | float8 | 17,17 | √ | null | ||
all | mote_id | bool | 1 | √ | null | ||
all | msg | int4 | 10 | √ | null | ||
all | msg_date | timestamptz | 35,6 | √ | null | ||
all | nopc | int4 | 10 | √ | null | ||
all | pass | int4 | 10 | √ | null | ||
all | platform_id.no. | int4 | 10 | √ | null | ||
all | prg_no. | int4 | 10 | √ | null | ||
all | sat_ | text | 2147483647 | √ | null | ||
all | semi_major.axis | int4 | 10 | √ | null | ||
all | semi_minor.axis | int4 | 10 | √ | null | ||
all | sensor_.01 | int4 | 10 | √ | null | ||
all | sensor_.02 | int4 | 10 | √ | null | ||
all | sensor_.03 | int4 | 10 | √ | null | ||
all | sensor_.04 | int4 | 10 | √ | null | ||
all | sensor_.05 | int4 | 10 | √ | null | ||
all | sensor_.06 | int4 | 10 | √ | null | ||
all | sensor_.07 | int4 | 10 | √ | null | ||
all | sensor_.08 | int4 | 10 | √ | null | ||
all | sensor_.09 | int4 | 10 | √ | null | ||
all | sensor_.10 | int4 | 10 | √ | null | ||
all | sensor_.11 | int4 | 10 | √ | null | ||
all | sensor_.12 | int4 | 10 | √ | null | ||
all | sensor_.13 | int4 | 10 | √ | null | ||
all | sensor_.14 | int4 | 10 | √ | null | ||
all | sensor_.15 | int4 | 10 | √ | null | ||
all | sensor_.16 | int4 | 10 | √ | null | ||
all | sensor_.17 | int4 | 10 | √ | null | ||
all | sensor_.18 | int4 | 10 | √ | null | ||
all | sensor_.19 | int4 | 10 | √ | null | ||
all | sensor_.20 | int4 | 10 | √ | null | ||
all | sensor_.21 | int4 | 10 | √ | null | ||
all | sensor_.22 | int4 | 10 | √ | null | ||
all | sensor_.23 | int4 | 10 | √ | null | ||
all | sensor_.24 | int4 | 10 | √ | null | ||
all | sensor_.25 | int4 | 10 | √ | null | ||
all | sensor_.26 | int4 | 10 | √ | null | ||
all | sensor_.27 | int4 | 10 | √ | null | ||
all | sensor_.28 | int4 | 10 | √ | null | ||
all | sensor_.29 | int4 | 10 | √ | null | ||
all | sensor_.30 | int4 | 10 | √ | null | ||
all | sensor_.31 | int4 | 10 | √ | null | ||
all | sensor_.32 | bool | 1 | √ | null | ||
all | wc_id | text | 2147483647 | √ | null | ||
all | x_...120.db | int4 | 10 | √ | null | ||
argos | avginterval | int4 | 10 | √ | null | ||
argos | corrupt | int4 | 10 | √ | null | ||
argos | date | timestamptz | 35,6 | √ | null | ||
argos | deployid | text | 2147483647 | √ | null | ||
argos | duplicates | int4 | 10 | √ | null | ||
argos | duration | bool | 1 | √ | null | ||
argos | frequency | int4 | 10 | √ | null | ||
argos | instr | text | 2147483647 | √ | null | ||
argos | iq | int4 | 10 | √ | null | ||
argos | latitude | float8 | 17,17 | √ | null | ||
argos | latitude2 | float8 | 17,17 | √ | null | ||
argos | locationquality | text | 2147483647 | √ | null | ||
argos | longitude | float8 | 17,17 | √ | null | ||
argos | longitude2 | float8 | 17,17 | √ | null | ||
argos | mininterval | int4 | 10 | √ | null | ||
argos | msgcount | int4 | 10 | √ | null | ||
argos | power | int4 | 10 | √ | null | ||
argos | ptt | int4 | 10 | √ | null | ||
argos | recordtype | text | 2147483647 | √ | null | ||
argos | satellite | text | 2147483647 | √ | null | ||
argos | wc_id | text | 2147483647 | √ | null | ||
argos_diag_history | alarm | text | 2147483647 | √ | null | ||
argos_diag_history | altitude | int4 | 10 | √ | null | ||
argos_diag_history | date | timestamptz | 35,6 | √ | null | ||
argos_diag_history | format_name | text | 2147483647 | √ | null | ||
argos_diag_history | latitude | float8 | 17,17 | √ | null | ||
argos_diag_history | loc_date | timestamptz | 35,6 | √ | null | ||
argos_diag_history | locationquality | text | 2147483647 | √ | null | ||
argos_diag_history | longitude | float8 | 17,17 | √ | null | ||
argos_diag_history | msg_date | timestamptz | 35,6 | √ | null | ||
argos_diag_history | pass_dur_s | int4 | 10 | √ | null | ||
argos_diag_history | platform | text | 2147483647 | √ | null | ||
argos_diag_history | platform_id_no | int4 | 10 | √ | null | ||
argos_diag_history | prg_no | int4 | 10 | √ | null | ||
argos_diag_history | ptt | int4 | 10 | √ | null | ||
argos_diag_history | sat | text | 2147483647 | √ | null | ||
argos_diag_history | sealid | text | 2147483647 | √ | null | ||
argos_diag_history | serialnum | text | 2147483647 | √ | null | ||
argos_diag_history | species | text | 2147483647 | √ | null | ||
bar | date | timestamptz | 35,6 | √ | null | ||
bar | latitude | float8 | 17,17 | √ | null | ||
bar | locationquality | text | 2147483647 | √ | null | ||
bar | longitude | float8 | 17,17 | √ | null | ||
bar | ptt | int4 | 10 | √ | null | ||
bar | sealid | text | 2147483647 | √ | null | ||
bar | serialnum | text | 2147483647 | √ | null | ||
bar | species | text | 2147483647 | √ | null | ||
behavior | count | int4 | 10 | √ | null | ||
behavior | deep | int4 | 10 | √ | null | ||
behavior | deployid | text | 2147483647 | √ | null | ||
behavior | depthmax | float8 | 17,17 | √ | null | ||
behavior | depthmax_1 | bool | 1 | √ | null | ||
behavior | depthmax_2 | bool | 1 | √ | null | ||
behavior | depthmin | float8 | 17,17 | √ | null | ||
behavior | depthmin_1 | bool | 1 | √ | null | ||
behavior | depthmin_2 | bool | 1 | √ | null | ||
behavior | depthsensor | float8 | 17,17 | √ | null | ||
behavior | durationmax | float8 | 17,17 | √ | null | ||
behavior | durationmax_1 | bool | 1 | √ | null | ||
behavior | durationmax_2 | bool | 1 | √ | null | ||
behavior | durationmin | float8 | 17,17 | √ | null | ||
behavior | durationmin_1 | bool | 1 | √ | null | ||
behavior | durationmin_2 | bool | 1 | √ | null | ||
behavior | end | text | 2147483647 | √ | null | ||
behavior | instr | text | 2147483647 | √ | null | ||
behavior | number | int4 | 10 | √ | null | ||
behavior | number_1 | bool | 1 | √ | null | ||
behavior | number_2 | bool | 1 | √ | null | ||
behavior | ptt | int4 | 10 | √ | null | ||
behavior | shallow | int4 | 10 | √ | null | ||
behavior | shape | text | 2147483647 | √ | null | ||
behavior | shape_1 | bool | 1 | √ | null | ||
behavior | shape_2 | bool | 1 | √ | null | ||
behavior | source | text | 2147483647 | √ | null | ||
behavior | start | text | 2147483647 | √ | null | ||
behavior | wc_id | text | 2147483647 | √ | null | ||
behavior | what | text | 2147483647 | √ | null | ||
columns | serialized_col_names | text | 2147483647 | √ | null | ||
columns | serialized_col_types | text | 2147483647 | √ | null | ||
columns | table_name | text | 2147483647 | √ | null | ||
corrupt | byte_0 | int4 | 10 | √ | null | ||
corrupt | byte_1 | int4 | 10 | √ | null | ||
corrupt | byte_10 | int4 | 10 | √ | null | ||
corrupt | byte_11 | int4 | 10 | √ | null | ||
corrupt | byte_12 | int4 | 10 | √ | null | ||
corrupt | byte_13 | int4 | 10 | √ | null | ||
corrupt | byte_14 | int4 | 10 | √ | null | ||
corrupt | byte_15 | int4 | 10 | √ | null | ||
corrupt | byte_16 | int4 | 10 | √ | null | ||
corrupt | byte_17 | int4 | 10 | √ | null | ||
corrupt | byte_18 | int4 | 10 | √ | null | ||
corrupt | byte_19 | int4 | 10 | √ | null | ||
corrupt | byte_2 | int4 | 10 | √ | null | ||
corrupt | byte_20 | int4 | 10 | √ | null | ||
corrupt | byte_21 | int4 | 10 | √ | null | ||
corrupt | byte_22 | int4 | 10 | √ | null | ||
corrupt | byte_23 | int4 | 10 | √ | null | ||
corrupt | byte_24 | int4 | 10 | √ | null | ||
corrupt | byte_25 | int4 | 10 | √ | null | ||
corrupt | byte_26 | int4 | 10 | √ | null | ||
corrupt | byte_27 | int4 | 10 | √ | null | ||
corrupt | byte_28 | int4 | 10 | √ | null | ||
corrupt | byte_29 | int4 | 10 | √ | null | ||
corrupt | byte_3 | int4 | 10 | √ | null | ||
corrupt | byte_30 | int4 | 10 | √ | null | ||
corrupt | byte_31 | bool | 1 | √ | null | ||
corrupt | byte_4 | int4 | 10 | √ | null | ||
corrupt | byte_5 | int4 | 10 | √ | null | ||
corrupt | byte_6 | int4 | 10 | √ | null | ||
corrupt | byte_7 | int4 | 10 | √ | null | ||
corrupt | byte_8 | int4 | 10 | √ | null | ||
corrupt | byte_9 | int4 | 10 | √ | null | ||
corrupt | date | timestamptz | 35,6 | √ | null | ||
corrupt | deployid | text | 2147483647 | √ | null | ||
corrupt | duplicates | bool | 1 | √ | null | ||
corrupt | instr | text | 2147483647 | √ | null | ||
corrupt | latitude | float8 | 17,17 | √ | null | ||
corrupt | locationquality | text | 2147483647 | √ | null | ||
corrupt | longitude | float8 | 17,17 | √ | null | ||
corrupt | possible_timestamp | timestamptz | 35,6 | √ | null | ||
corrupt | possible_type | text | 2147483647 | √ | null | ||
corrupt | ptt | int4 | 10 | √ | null | ||
corrupt | reason | text | 2147483647 | √ | null | ||
corrupt | satellite | bool | 1 | √ | null | ||
corrupt | wc_id | text | 2147483647 | √ | null | ||
deployment | cl_nn | text | 2147483647 | √ | null | ||
deployment | default_location_process | bool | 1 | √ | null | ||
deployment | deploy_id | text | 2147483647 | √ | null | ||
deployment | fastloc | int4 | 10 | √ | null | ||
deployment | first_uplink_date | text | 2147483647 | √ | null | ||
deployment | last_location_latitude | float8 | 17,17 | √ | null | ||
deployment | last_location_location_date | text | 2147483647 | √ | null | ||
deployment | last_location_longitude | float8 | 17,17 | √ | null | ||
deployment | last_update_date | text | 2147483647 | √ | null | ||
deployment | last_uplink_date | text | 2147483647 | √ | null | ||
deployment | local_tag.id | text | 2147483647 | √ | null | ||
deployment | locality | text | 2147483647 | √ | null | ||
deployment | owner | text | 2147483647 | √ | null | ||
deployment | program_number | int4 | 10 | √ | null | ||
deployment | ptt_decimal | int4 | 10 | √ | null | ||
deployment | serial_number | text | 2147483647 | √ | null | ||
deployment | source | text | 2147483647 | √ | null | ||
deployment | species | text | 2147483647 | √ | null | ||
deployment | status | text | 2147483647 | √ | null | ||
deployment | tag_type | text | 2147483647 | √ | null | ||
deployment | tagtype | text | 2147483647 | √ | null | ||
deployment | wc_id | text | 2147483647 | √ | null | ||
dtag_metadata | animal_name | text | 2147483647 | √ | null | ||
dtag_metadata | data_wrangler_email | text | 2147483647 | √ | null | ||
dtag_metadata | deployment_date | timestamptz | 35,6 | √ | null | ||
dtag_metadata | deployment_latitude | float8 | 17,17 | √ | null | ||
dtag_metadata | deployment_longitude | float8 | 17,17 | √ | null | ||
dtag_metadata | embargo_until_date | timestamptz | 35,6 | √ | null | ||
dtag_metadata | genus | text | 2147483647 | √ | null | ||
dtag_metadata | local_deployment_name | text | 2147483647 | √ | null | ||
dtag_metadata | principal_investigator_email | text | 2147483647 | √ | null | ||
dtag_metadata | species | text | 2147483647 | √ | null | ||
dtag_metadata | tag_manufacturer | text | 2147483647 | √ | null | ||
dtag_metadata | tag_model | text | 2147483647 | √ | null | ||
dtag_metadata | tag_serial_number | float8 | 17,17 | √ | null | ||
fastgps | bad_sats | int4 | 10 | √ | null | ||
fastgps | cnr | bool | 1 | √ | null | ||
fastgps | cnr_1 | bool | 1 | √ | null | ||
fastgps | cnr_10 | bool | 1 | √ | null | ||
fastgps | cnr_11 | bool | 1 | √ | null | ||
fastgps | cnr_12 | bool | 1 | √ | null | ||
fastgps | cnr_13 | bool | 1 | √ | null | ||
fastgps | cnr_14 | bool | 1 | √ | null | ||
fastgps | cnr_2 | bool | 1 | √ | null | ||
fastgps | cnr_3 | bool | 1 | √ | null | ||
fastgps | cnr_4 | bool | 1 | √ | null | ||
fastgps | cnr_5 | bool | 1 | √ | null | ||
fastgps | cnr_6 | bool | 1 | √ | null | ||
fastgps | cnr_7 | bool | 1 | √ | null | ||
fastgps | cnr_8 | bool | 1 | √ | null | ||
fastgps | cnr_9 | bool | 1 | √ | null | ||
fastgps | count | int4 | 10 | √ | null | ||
fastgps | day | text | 2147483647 | √ | null | ||
fastgps | doppler | bool | 1 | √ | null | ||
fastgps | doppler_1 | bool | 1 | √ | null | ||
fastgps | doppler_10 | bool | 1 | √ | null | ||
fastgps | doppler_11 | bool | 1 | √ | null | ||
fastgps | doppler_12 | bool | 1 | √ | null | ||
fastgps | doppler_13 | bool | 1 | √ | null | ||
fastgps | doppler_14 | bool | 1 | √ | null | ||
fastgps | doppler_2 | bool | 1 | √ | null | ||
fastgps | doppler_3 | bool | 1 | √ | null | ||
fastgps | doppler_4 | bool | 1 | √ | null | ||
fastgps | doppler_5 | bool | 1 | √ | null | ||
fastgps | doppler_6 | bool | 1 | √ | null | ||
fastgps | doppler_7 | bool | 1 | √ | null | ||
fastgps | doppler_8 | bool | 1 | √ | null | ||
fastgps | doppler_9 | bool | 1 | √ | null | ||
fastgps | failures | int4 | 10 | √ | null | ||
fastgps | fastloc_power | bool | 1 | √ | null | ||
fastgps | hauled_out | int4 | 10 | √ | null | ||
fastgps | height | bool | 1 | √ | null | ||
fastgps | id | int4 | 10 | √ | null | ||
fastgps | id_1 | int4 | 10 | √ | null | ||
fastgps | id_10 | int4 | 10 | √ | null | ||
fastgps | id_11 | int4 | 10 | √ | null | ||
fastgps | id_12 | int4 | 10 | √ | null | ||
fastgps | id_13 | bool | 1 | √ | null | ||
fastgps | id_14 | bool | 1 | √ | null | ||
fastgps | id_2 | int4 | 10 | √ | null | ||
fastgps | id_3 | int4 | 10 | √ | null | ||
fastgps | id_4 | int4 | 10 | √ | null | ||
fastgps | id_5 | int4 | 10 | √ | null | ||
fastgps | id_6 | int4 | 10 | √ | null | ||
fastgps | id_7 | int4 | 10 | √ | null | ||
fastgps | id_8 | int4 | 10 | √ | null | ||
fastgps | id_9 | int4 | 10 | √ | null | ||
fastgps | initlat | float8 | 17,17 | √ | null | ||
fastgps | initlon | float8 | 17,17 | √ | null | ||
fastgps | inittime | timestamptz | 35,6 | √ | null | ||
fastgps | inittype | text | 2147483647 | √ | null | ||
fastgps | latitude | float8 | 17,17 | √ | null | ||
fastgps | locnumber | int4 | 10 | √ | null | ||
fastgps | longitude | float8 | 17,17 | √ | null | ||
fastgps | name | int4 | 10 | √ | null | ||
fastgps | noise | bool | 1 | √ | null | ||
fastgps | range | int4 | 10 | √ | null | ||
fastgps | range_1 | int4 | 10 | √ | null | ||
fastgps | range_10 | int4 | 10 | √ | null | ||
fastgps | range_11 | int4 | 10 | √ | null | ||
fastgps | range_12 | int4 | 10 | √ | null | ||
fastgps | range_13 | bool | 1 | √ | null | ||
fastgps | range_14 | bool | 1 | √ | null | ||
fastgps | range_2 | int4 | 10 | √ | null | ||
fastgps | range_3 | int4 | 10 | √ | null | ||
fastgps | range_4 | int4 | 10 | √ | null | ||
fastgps | range_5 | int4 | 10 | √ | null | ||
fastgps | range_6 | int4 | 10 | √ | null | ||
fastgps | range_7 | int4 | 10 | √ | null | ||
fastgps | range_8 | int4 | 10 | √ | null | ||
fastgps | range_9 | int4 | 10 | √ | null | ||
fastgps | range_bits | int4 | 10 | √ | null | ||
fastgps | residual | float8 | 17,17 | √ | null | ||
fastgps | satellites | int4 | 10 | √ | null | ||
fastgps | signal | bool | 1 | √ | null | ||
fastgps | signal_1 | bool | 1 | √ | null | ||
fastgps | signal_10 | bool | 1 | √ | null | ||
fastgps | signal_11 | bool | 1 | √ | null | ||
fastgps | signal_12 | bool | 1 | √ | null | ||
fastgps | signal_13 | bool | 1 | √ | null | ||
fastgps | signal_14 | bool | 1 | √ | null | ||
fastgps | signal_2 | bool | 1 | √ | null | ||
fastgps | signal_3 | bool | 1 | √ | null | ||
fastgps | signal_4 | bool | 1 | √ | null | ||
fastgps | signal_5 | bool | 1 | √ | null | ||
fastgps | signal_6 | bool | 1 | √ | null | ||
fastgps | signal_7 | bool | 1 | √ | null | ||
fastgps | signal_8 | bool | 1 | √ | null | ||
fastgps | signal_9 | bool | 1 | √ | null | ||
fastgps | time | timestamptz | 35,6 | √ | null | ||
fastgps | time_error | timestamptz | 35,6 | √ | null | ||
fastgps | time_offset | timestamptz | 35,6 | √ | null | ||
fastgps | twic_power | bool | 1 | √ | null | ||
fastgps | wc_id | text | 2147483647 | √ | null | ||
haulout | deployid | int4 | 10 | √ | null | ||
haulout | duration | int4 | 10 | √ | null | ||
haulout | end | text | 2147483647 | √ | null | ||
haulout | id | int4 | 10 | √ | null | ||
haulout | instr | text | 2147483647 | √ | null | ||
haulout | latitude | bool | 1 | √ | null | ||
haulout | locationquality | bool | 1 | √ | null | ||
haulout | longitude | bool | 1 | √ | null | ||
haulout | ptt | int4 | 10 | √ | null | ||
haulout | start | text | 2147483647 | √ | null | ||
haulout | wc_id | text | 2147483647 | √ | null | ||
histos | badtherm | int4 | 10 | √ | null | ||
histos | bin1 | float8 | 17,17 | √ | null | ||
histos | bin10 | float8 | 17,17 | √ | null | ||
histos | bin11 | float8 | 17,17 | √ | null | ||
histos | bin12 | float8 | 17,17 | √ | null | ||
histos | bin13 | float8 | 17,17 | √ | null | ||
histos | bin14 | float8 | 17,17 | √ | null | ||
histos | bin15 | bool | 1 | √ | null | ||
histos | bin16 | bool | 1 | √ | null | ||
histos | bin17 | bool | 1 | √ | null | ||
histos | bin18 | bool | 1 | √ | null | ||
histos | bin19 | bool | 1 | √ | null | ||
histos | bin2 | float8 | 17,17 | √ | null | ||
histos | bin20 | bool | 1 | √ | null | ||
histos | bin21 | bool | 1 | √ | null | ||
histos | bin22 | bool | 1 | √ | null | ||
histos | bin23 | bool | 1 | √ | null | ||
histos | bin24 | bool | 1 | √ | null | ||
histos | bin25 | bool | 1 | √ | null | ||
histos | bin26 | bool | 1 | √ | null | ||
histos | bin27 | bool | 1 | √ | null | ||
histos | bin28 | bool | 1 | √ | null | ||
histos | bin29 | bool | 1 | √ | null | ||
histos | bin3 | float8 | 17,17 | √ | null | ||
histos | bin30 | bool | 1 | √ | null | ||
histos | bin31 | bool | 1 | √ | null | ||
histos | bin32 | bool | 1 | √ | null | ||
histos | bin33 | bool | 1 | √ | null | ||
histos | bin34 | bool | 1 | √ | null | ||
histos | bin35 | bool | 1 | √ | null | ||
histos | bin36 | bool | 1 | √ | null | ||
histos | bin37 | bool | 1 | √ | null | ||
histos | bin38 | bool | 1 | √ | null | ||
histos | bin39 | bool | 1 | √ | null | ||
histos | bin4 | float8 | 17,17 | √ | null | ||
histos | bin40 | bool | 1 | √ | null | ||
histos | bin41 | bool | 1 | √ | null | ||
histos | bin42 | bool | 1 | √ | null | ||
histos | bin43 | bool | 1 | √ | null | ||
histos | bin44 | bool | 1 | √ | null | ||
histos | bin45 | bool | 1 | √ | null | ||
histos | bin46 | bool | 1 | √ | null | ||
histos | bin47 | bool | 1 | √ | null | ||
histos | bin48 | bool | 1 | √ | null | ||
histos | bin49 | bool | 1 | √ | null | ||
histos | bin5 | float8 | 17,17 | √ | null | ||
histos | bin50 | bool | 1 | √ | null | ||
histos | bin51 | bool | 1 | √ | null | ||
histos | bin52 | bool | 1 | √ | null | ||
histos | bin53 | bool | 1 | √ | null | ||
histos | bin54 | bool | 1 | √ | null | ||
histos | bin55 | bool | 1 | √ | null | ||
histos | bin56 | bool | 1 | √ | null | ||
histos | bin57 | bool | 1 | √ | null | ||
histos | bin58 | bool | 1 | √ | null | ||
histos | bin59 | bool | 1 | √ | null | ||
histos | bin6 | float8 | 17,17 | √ | null | ||
histos | bin60 | bool | 1 | √ | null | ||
histos | bin61 | bool | 1 | √ | null | ||
histos | bin62 | bool | 1 | √ | null | ||
histos | bin63 | bool | 1 | √ | null | ||
histos | bin64 | bool | 1 | √ | null | ||
histos | bin65 | bool | 1 | √ | null | ||
histos | bin66 | bool | 1 | √ | null | ||
histos | bin67 | bool | 1 | √ | null | ||
histos | bin68 | bool | 1 | √ | null | ||
histos | bin69 | bool | 1 | √ | null | ||
histos | bin7 | float8 | 17,17 | √ | null | ||
histos | bin70 | bool | 1 | √ | null | ||
histos | bin71 | bool | 1 | √ | null | ||
histos | bin72 | bool | 1 | √ | null | ||
histos | bin8 | float8 | 17,17 | √ | null | ||
histos | bin9 | float8 | 17,17 | √ | null | ||
histos | count | int4 | 10 | √ | null | ||
histos | date | timestamptz | 35,6 | √ | null | ||
histos | deployid | text | 2147483647 | √ | null | ||
histos | depthsensor | float8 | 17,17 | √ | null | ||
histos | histtype | text | 2147483647 | √ | null | ||
histos | instr | text | 2147483647 | √ | null | ||
histos | latitude | bool | 1 | √ | null | ||
histos | locationquality | bool | 1 | √ | null | ||
histos | longitude | bool | 1 | √ | null | ||
histos | numbins | int4 | 10 | √ | null | ||
histos | ptt | int4 | 10 | √ | null | ||
histos | source | text | 2147483647 | √ | null | ||
histos | sum | int4 | 10 | √ | null | ||
histos | time_offset | timestamptz | 35,6 | √ | null | ||
histos | wc_id | text | 2147483647 | √ | null | ||
justin_2017_metadata | data_wrangler_email | text | 2147483647 | √ | null | ||
justin_2017_metadata | deployment_date | date | 13 | √ | null | ||
justin_2017_metadata | deployment_latitude | float8 | 17,17 | √ | null | ||
justin_2017_metadata | deployment_longitude | float8 | 17,17 | √ | null | ||
justin_2017_metadata | local_deployment_name | text | 2147483647 | √ | null | ||
justin_2017_metadata | portal_username | text | 2147483647 | √ | null | ||
justin_2017_metadata | principal_investigator_email | text | 2147483647 | √ | null | ||
justin_2017_metadata | ptt | int4 | 10 | √ | null | ||
justin_2017_metadata | species_code | int4 | 10 | √ | null | ||
justin_2017_metadata | tag_model | text | 2147483647 | √ | null | ||
justin_metadata | data_wrangler_email | text | 2147483647 | √ | null | ||
justin_metadata | deployment_date | date | 13 | √ | null | ||
justin_metadata | deployment_latitude | float8 | 17,17 | √ | null | ||
justin_metadata | deployment_longitude | float8 | 17,17 | √ | null | ||
justin_metadata | local_deployment_name | text | 2147483647 | √ | null | ||
justin_metadata | portal_username | text | 2147483647 | √ | null | ||
justin_metadata | principal_investigator_email | text | 2147483647 | √ | null | ||
justin_metadata | ptt | int4 | 10 | √ | null | ||
justin_metadata | Species | text | 2147483647 | √ | null | ||
justin_metadata | species_code | int4 | 10 | √ | null | ||
justin_metadata | tag_model | text | 2147483647 | √ | null | ||
labels | key | text | 2147483647 | √ | null | ||
labels | value_s. | text | 2147483647 | √ | null | ||
labels | wc_id | text | 2147483647 | √ | null | ||
locations | comment | text | 2147483647 | √ | null | ||
locations | count | bool | 1 | √ | null | ||
locations | date | timestamptz | 35,6 | √ | null | ||
locations | deployid | text | 2147483647 | √ | null | ||
locations | error_ellipse.orientation | int4 | 10 | √ | null | ||
locations | error_radius | int4 | 10 | √ | null | ||
locations | error_semi.major.axis | int4 | 10 | √ | null | ||
locations | error_semi.minor.axis | int4 | 10 | √ | null | ||
locations | gpe_msd | bool | 1 | √ | null | ||
locations | gpe_u | bool | 1 | √ | null | ||
locations | instr | text | 2147483647 | √ | null | ||
locations | latitude | float8 | 17,17 | √ | null | ||
locations | longitude | float8 | 17,17 | √ | null | ||
locations | offset | bool | 1 | √ | null | ||
locations | offset_orientation | bool | 1 | √ | null | ||
locations | ptt | int4 | 10 | √ | null | ||
locations | quality | text | 2147483647 | √ | null | ||
locations | type | text | 2147483647 | √ | null | ||
locations | wc_id | text | 2147483647 | √ | null | ||
metadata | animal_name | bool | 1 | √ | null | ||
metadata | data_wrangler_email | text | 2147483647 | √ | null | ||
metadata | deployment_date | timestamptz | 35,6 | √ | null | ||
metadata | deployment_latitude | float8 | 17,17 | √ | null | ||
metadata | deployment_longitude | float8 | 17,17 | √ | null | ||
metadata | embargo_until_date | timestamptz | 35,6 | √ | null | ||
metadata | genus | text | 2147483647 | √ | null | ||
metadata | local_deployment_name | text | 2147483647 | √ | null | ||
metadata | portal | text | 2147483647 | √ | null | ||
metadata | portal_username | text | 2147483647 | √ | null | ||
metadata | principal_investigator_email | text | 2147483647 | √ | null | ||
metadata | ptt | int4 | 10 | √ | null | ||
metadata | species | text | 2147483647 | √ | null | ||
metadata | tag_manufacturer | text | 2147483647 | √ | null | ||
metadata | tag_model | text | 2147483647 | √ | null | ||
metadata | tag_serial_number | text | 2147483647 | √ | null | ||
minmaxdepth | date | timestamptz | 35,6 | √ | null | ||
minmaxdepth | deployid | text | 2147483647 | √ | null | ||
minmaxdepth | depthsensor | float8 | 17,17 | √ | null | ||
minmaxdepth | instr | text | 2147483647 | √ | null | ||
minmaxdepth | latitude | bool | 1 | √ | null | ||
minmaxdepth | locationquality | bool | 1 | √ | null | ||
minmaxdepth | longitude | bool | 1 | √ | null | ||
minmaxdepth | maxaccuracy | float8 | 17,17 | √ | null | ||
minmaxdepth | maxdepth | float8 | 17,17 | √ | null | ||
minmaxdepth | maxsource | text | 2147483647 | √ | null | ||
minmaxdepth | minaccuracy | float8 | 17,17 | √ | null | ||
minmaxdepth | mindepth | float8 | 17,17 | √ | null | ||
minmaxdepth | minsource | text | 2147483647 | √ | null | ||
minmaxdepth | ptt | int4 | 10 | √ | null | ||
minmaxdepth | wc_id | text | 2147483647 | √ | null | ||
patrick_metadata | data_wrangler_email | text | 2147483647 | √ | null | ||
patrick_metadata | deployment_date | timestamptz | 35,6 | √ | null | ||
patrick_metadata | deployment_latitude | float8 | 17,17 | √ | null | ||
patrick_metadata | deployment_longitude | float8 | 17,17 | √ | null | ||
patrick_metadata | embargo_until_date | timestamptz | 35,6 | √ | null | ||
patrick_metadata | genus | text | 2147483647 | √ | null | ||
patrick_metadata | local_deployment_name | text | 2147483647 | √ | null | ||
patrick_metadata | principal_investigator_email | text | 2147483647 | √ | null | ||
patrick_metadata | ptt | float8 | 17,17 | √ | null | ||
patrick_metadata | species | text | 2147483647 | √ | null | ||
patrick_metadata | tag_manufacturer | text | 2147483647 | √ | null | ||
patrick_metadata | tag_model | text | 2147483647 | √ | null | ||
patrick_metadata | tag_serial_number | text | 2147483647 | √ | null | ||
prev_argos_metadata | animal_name | bool | 1 | √ | null | ||
prev_argos_metadata | data_wrangler_email | text | 2147483647 | √ | null | ||
prev_argos_metadata | deployment_date | timestamptz | 35,6 | √ | null | ||
prev_argos_metadata | deployment_latitude | float8 | 17,17 | √ | null | ||
prev_argos_metadata | deployment_longitude | float8 | 17,17 | √ | null | ||
prev_argos_metadata | embargo_until_date | timestamptz | 35,6 | √ | null | ||
prev_argos_metadata | genus | text | 2147483647 | √ | null | ||
prev_argos_metadata | local_deployment_name | text | 2147483647 | √ | null | ||
prev_argos_metadata | portal | text | 2147483647 | √ | null | ||
prev_argos_metadata | portal_username | text | 2147483647 | √ | null | ||
prev_argos_metadata | principal_investigator_email | text | 2147483647 | √ | null | ||
prev_argos_metadata | ptt | int4 | 10 | √ | null | ||
prev_argos_metadata | species | text | 2147483647 | √ | null | ||
prev_argos_metadata | tag_manufacturer | text | 2147483647 | √ | null | ||
prev_argos_metadata | tag_model | text | 2147483647 | √ | null | ||
prev_argos_metadata | tag_serial_number | text | 2147483647 | √ | null | ||
previous_metadata | animal_name | bool | 1 | √ | null | ||
previous_metadata | data_wrangler_email | text | 2147483647 | √ | null | ||
previous_metadata | deployment_date | timestamptz | 35,6 | √ | null | ||
previous_metadata | deployment_latitude | float8 | 17,17 | √ | null | ||
previous_metadata | deployment_longitude | float8 | 17,17 | √ | null | ||
previous_metadata | embargo_until_date | timestamptz | 35,6 | √ | null | ||
previous_metadata | genus | text | 2147483647 | √ | null | ||
previous_metadata | local_deployment_name | text | 2147483647 | √ | null | ||
previous_metadata | portal | text | 2147483647 | √ | null | ||
previous_metadata | portal_username | text | 2147483647 | √ | null | ||
previous_metadata | principal_investigator_email | text | 2147483647 | √ | null | ||
previous_metadata | ptt | int4 | 10 | √ | null | ||
previous_metadata | species | text | 2147483647 | √ | null | ||
previous_metadata | tag_manufacturer | text | 2147483647 | √ | null | ||
previous_metadata | tag_model | text | 2147483647 | √ | null | ||
previous_metadata | tag_serial_number | text | 2147483647 | √ | null | ||
rawargos | class | text | 2147483647 | √ | null | ||
rawargos | comment | text | 2147483647 | √ | null | ||
rawargos | dups | int4 | 10 | √ | null | ||
rawargos | duration | int4 | 10 | √ | null | ||
rawargos | error_ellipse.orientation | int4 | 10 | √ | null | ||
rawargos | error_radius | int4 | 10 | √ | null | ||
rawargos | error_semi.major.axis | int4 | 10 | √ | null | ||
rawargos | error_semi.minor.axis | int4 | 10 | √ | null | ||
rawargos | frequency | int4 | 10 | √ | null | ||
rawargos | iq | int4 | 10 | √ | null | ||
rawargos | latitude | float8 | 17,17 | √ | null | ||
rawargos | latitude2 | float8 | 17,17 | √ | null | ||
rawargos | len | text | 2147483647 | √ | null | ||
rawargos | longitude | float8 | 17,17 | √ | null | ||
rawargos | longitude2 | float8 | 17,17 | √ | null | ||
rawargos | msgdate | timestamptz | 35,6 | √ | null | ||
rawargos | msgtime | timestamptz | 35,6 | √ | null | ||
rawargos | offset | bool | 1 | √ | null | ||
rawargos | offset_orientation | bool | 1 | √ | null | ||
rawargos | pass | int4 | 10 | √ | null | ||
rawargos | passdate | timestamptz | 35,6 | √ | null | ||
rawargos | passtime | timestamptz | 35,6 | √ | null | ||
rawargos | power | int4 | 10 | √ | null | ||
rawargos | prog | text | 2147483647 | √ | null | ||
rawargos | ptt | text | 2147483647 | √ | null | ||
rawargos | satellite | text | 2147483647 | √ | null | ||
rawargos | sensor_.01 | int4 | 10 | √ | null | ||
rawargos | sensor_.02 | int4 | 10 | √ | null | ||
rawargos | sensor_.03 | int4 | 10 | √ | null | ||
rawargos | sensor_.04 | int4 | 10 | √ | null | ||
rawargos | sensor_.05 | int4 | 10 | √ | null | ||
rawargos | sensor_.06 | int4 | 10 | √ | null | ||
rawargos | sensor_.07 | int4 | 10 | √ | null | ||
rawargos | sensor_.08 | int4 | 10 | √ | null | ||
rawargos | sensor_.09 | int4 | 10 | √ | null | ||
rawargos | sensor_.10 | int4 | 10 | √ | null | ||
rawargos | sensor_.11 | int4 | 10 | √ | null | ||
rawargos | sensor_.12 | int4 | 10 | √ | null | ||
rawargos | sensor_.13 | int4 | 10 | √ | null | ||
rawargos | sensor_.14 | int4 | 10 | √ | null | ||
rawargos | sensor_.15 | int4 | 10 | √ | null | ||
rawargos | sensor_.16 | int4 | 10 | √ | null | ||
rawargos | sensor_.17 | int4 | 10 | √ | null | ||
rawargos | sensor_.18 | int4 | 10 | √ | null | ||
rawargos | sensor_.19 | int4 | 10 | √ | null | ||
rawargos | sensor_.20 | int4 | 10 | √ | null | ||
rawargos | sensor_.21 | int4 | 10 | √ | null | ||
rawargos | sensor_.22 | int4 | 10 | √ | null | ||
rawargos | sensor_.23 | int4 | 10 | √ | null | ||
rawargos | sensor_.24 | int4 | 10 | √ | null | ||
rawargos | sensor_.25 | int4 | 10 | √ | null | ||
rawargos | sensor_.26 | int4 | 10 | √ | null | ||
rawargos | sensor_.27 | int4 | 10 | √ | null | ||
rawargos | sensor_.28 | int4 | 10 | √ | null | ||
rawargos | sensor_.29 | int4 | 10 | √ | null | ||
rawargos | sensor_.30 | int4 | 10 | √ | null | ||
rawargos | sensor_.31 | int4 | 10 | √ | null | ||
rawargos | sensor_.32 | bool | 1 | √ | null | ||
rawargos | wc_id | text | 2147483647 | √ | null | ||
rtc | correctiontype | text | 2147483647 | √ | null | ||
rtc | deployid | text | 2147483647 | √ | null | ||
rtc | instr | text | 2147483647 | √ | null | ||
rtc | ptt | int4 | 10 | √ | null | ||
rtc | realdate | timestamptz | 35,6 | √ | null | ||
rtc | realtime | timestamptz | 35,6 | √ | null | ||
rtc | tagdate | timestamptz | 35,6 | √ | null | ||
rtc | tagtime | timestamptz | 35,6 | √ | null | ||
rtc | wc_id | text | 2147483647 | √ | null | ||
series | day | text | 2147483647 | √ | null | ||
series | deployid | text | 2147483647 | √ | null | ||
series | depth | float8 | 17,17 | √ | null | ||
series | depthsensor | float8 | 17,17 | √ | null | ||
series | drange | float8 | 17,17 | √ | null | ||
series | instr | text | 2147483647 | √ | null | ||
series | latitude | bool | 1 | √ | null | ||
series | locationquality | bool | 1 | √ | null | ||
series | longitude | bool | 1 | √ | null | ||
series | ptt | int4 | 10 | √ | null | ||
series | source | text | 2147483647 | √ | null | ||
series | temperature | bool | 1 | √ | null | ||
series | time | timestamptz | 35,6 | √ | null | ||
series | trange | bool | 1 | √ | null | ||
series | wc_id | text | 2147483647 | √ | null | ||
seriesrange | count | int4 | 10 | √ | null | ||
seriesrange | deployid | text | 2147483647 | √ | null | ||
seriesrange | depthsensor | float8 | 17,17 | √ | null | ||
seriesrange | end | text | 2147483647 | √ | null | ||
seriesrange | instr | text | 2147483647 | √ | null | ||
seriesrange | latitude | bool | 1 | √ | null | ||
seriesrange | locationquality | bool | 1 | √ | null | ||
seriesrange | longitude | bool | 1 | √ | null | ||
seriesrange | maxdepth | float8 | 17,17 | √ | null | ||
seriesrange | maxdepthaccuracy | float8 | 17,17 | √ | null | ||
seriesrange | maxtemp | bool | 1 | √ | null | ||
seriesrange | maxtempaccuracy | bool | 1 | √ | null | ||
seriesrange | mindepth | float8 | 17,17 | √ | null | ||
seriesrange | mindepthaccuracy | float8 | 17,17 | √ | null | ||
seriesrange | mintemp | bool | 1 | √ | null | ||
seriesrange | mintempaccuracy | bool | 1 | √ | null | ||
seriesrange | ptt | int4 | 10 | √ | null | ||
seriesrange | source | text | 2147483647 | √ | null | ||
seriesrange | start | text | 2147483647 | √ | null | ||
seriesrange | wc_id | text | 2147483647 | √ | null | ||
sst | date | timestamptz | 35,6 | √ | null | ||
sst | deployid | text | 2147483647 | √ | null | ||
sst | depth | int4 | 10 | √ | null | ||
sst | depthsensor | float8 | 17,17 | √ | null | ||
sst | instr | text | 2147483647 | √ | null | ||
sst | latitude | bool | 1 | √ | null | ||
sst | locationquality | bool | 1 | √ | null | ||
sst | longitude | bool | 1 | √ | null | ||
sst | ptt | int4 | 10 | √ | null | ||
sst | source | text | 2147483647 | √ | null | ||
sst | temperature | float8 | 17,17 | √ | null | ||
sst | wc_id | text | 2147483647 | √ | null | ||
status | battdiscon | bool | 1 | √ | null | ||
status | battvoltage | float8 | 17,17 | √ | null | ||
status | brokenlink | bool | 1 | √ | null | ||
status | brokenthermistor | int4 | 10 | √ | null | ||
status | burnminutes | bool | 1 | √ | null | ||
status | deployid | text | 2147483647 | √ | null | ||
status | depth | float8 | 17,17 | √ | null | ||
status | depthsensor | float8 | 17,17 | √ | null | ||
status | fastgpsfailures | int4 | 10 | √ | null | ||
status | fastgpslocnumber | int4 | 10 | √ | null | ||
status | fastgpspower | bool | 1 | √ | null | ||
status | hauledout | int4 | 10 | √ | null | ||
status | initiallybroken | bool | 1 | √ | null | ||
status | instr | text | 2147483647 | √ | null | ||
status | latitude | float8 | 17,17 | √ | null | ||
status | lightlevel | bool | 1 | √ | null | ||
status | locationquality | text | 2147483647 | √ | null | ||
status | longitude | float8 | 17,17 | √ | null | ||
status | maxdepth | int4 | 10 | √ | null | ||
status | maxwetdry | int4 | 10 | √ | null | ||
status | minwetdry | int4 | 10 | √ | null | ||
status | nodawndusk | bool | 1 | √ | null | ||
status | powerlimit | bool | 1 | √ | null | ||
status | prereleasetilt | bool | 1 | √ | null | ||
status | prereleasetiltcount | bool | 1 | √ | null | ||
status | prereleasetiltsd | bool | 1 | √ | null | ||
status | ptt | int4 | 10 | √ | null | ||
status | received | text | 2147483647 | √ | null | ||
status | releasedepth | bool | 1 | √ | null | ||
status | releasetime | timestamptz | 35,6 | √ | null | ||
status | releasetype | bool | 1 | √ | null | ||
status | resets | bool | 1 | √ | null | ||
status | rtc | text | 2147483647 | √ | null | ||
status | statusword | int4 | 10 | √ | null | ||
status | sw | text | 2147483647 | √ | null | ||
status | temperature | float8 | 17,17 | √ | null | ||
status | time_offset | timestamptz | 35,6 | √ | null | ||
status | transmitcurrent | float8 | 17,17 | √ | null | ||
status | transmitpower | bool | 1 | √ | null | ||
status | transmits | int4 | 10 | √ | null | ||
status | transmitvoltage | float8 | 17,17 | √ | null | ||
status | twicpower | bool | 1 | √ | null | ||
status | type | text | 2147483647 | √ | null | ||
status | wc_id | text | 2147483647 | √ | null | ||
status | wetdry | int4 | 10 | √ | null | ||
status | wetdrythreshold | int4 | 10 | √ | null | ||
status | xmitqueue | int4 | 10 | √ | null | ||
status | zerodepthoffset | int4 | 10 | √ | null | ||
summary | avgpower | bool | 1 | √ | null | ||
summary | datadays | int4 | 10 | √ | null | ||
summary | deploydate | timestamptz | 35,6 | √ | null | ||
summary | deployid | text | 2147483647 | √ | null | ||
summary | di | bool | 1 | √ | null | ||
summary | ds | int4 | 10 | √ | null | ||
summary | earliestdatatime | timestamptz | 35,6 | √ | null | ||
summary | earliestxmittime | timestamptz | 35,6 | √ | null | ||
summary | instr | text | 2147483647 | √ | null | ||
summary | latestdatatime | timestamptz | 35,6 | √ | null | ||
summary | latestxmittime | timestamptz | 35,6 | √ | null | ||
summary | maxpower | bool | 1 | √ | null | ||
summary | mininterval | int4 | 10 | √ | null | ||
summary | minpower | bool | 1 | √ | null | ||
summary | msgperpass | int4 | 10 | √ | null | ||
summary | passes | int4 | 10 | √ | null | ||
summary | percentargosloc | int4 | 10 | √ | null | ||
summary | percentdecoded | int4 | 10 | √ | null | ||
summary | ptt | int4 | 10 | √ | null | ||
summary | releasedate | timestamptz | 35,6 | √ | null | ||
summary | releasetype | bool | 1 | √ | null | ||
summary | sw | text | 2147483647 | √ | null | ||
summary | wc_id | text | 2147483647 | √ | null | ||
summary | xmitdays | int4 | 10 | √ | null | ||
uga_metadata | animal_name | text | 2147483647 | √ | null | ||
uga_metadata | data_wrangler_email | text | 2147483647 | √ | null | ||
uga_metadata | deployment_date | timestamptz | 35,6 | √ | null | ||
uga_metadata | deployment_latitude | float8 | 17,17 | √ | null | ||
uga_metadata | deployment_longitude | float8 | 17,17 | √ | null | ||
uga_metadata | embargo_until_date | timestamp | 29,6 | √ | null | ||
uga_metadata | genus | text | 2147483647 | √ | null | ||
uga_metadata | local_deployment_name | text | 2147483647 | √ | null | ||
uga_metadata | principal_investigator_email | text | 2147483647 | √ | null | ||
uga_metadata | ptt | int4 | 10 | √ | null | ||
uga_metadata | species | text | 2147483647 | √ | null | ||
uga_metadata | tag_manufacturer | text | 2147483647 | √ | null | ||
uga_metadata | tag_model | text | 2147483647 | √ | null | ||
uga_metadata | tag_serial_number | float8 | 17,17 | √ | null |