| 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 |
|---|---|---|---|---|---|---|---|
| metadata | animal_name | bool | 1 | √ | null | ||
| prev_argos_metadata | animal_name | bool | 1 | √ | null | ||
| previous_metadata | animal_name | bool | 1 | √ | null | ||
| summary | avgpower | bool | 1 | √ | null | ||
| status | battdiscon | bool | 1 | √ | 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 | 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 | 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 | 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 | 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 | 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 | bin70 | bool | 1 | √ | null | ||
| histos | bin71 | bool | 1 | √ | null | ||
| histos | bin72 | bool | 1 | √ | null | ||
| status | brokenlink | bool | 1 | √ | null | ||
| status | burnminutes | bool | 1 | √ | null | ||
| corrupt | byte_31 | bool | 1 | √ | 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 | ||
| locations | count | bool | 1 | √ | null | ||
| deployment | default_location_process | bool | 1 | √ | null | ||
| behavior | depthmax_1 | bool | 1 | √ | null | ||
| behavior | depthmax_2 | bool | 1 | √ | null | ||
| behavior | depthmin_1 | bool | 1 | √ | null | ||
| behavior | depthmin_2 | bool | 1 | √ | null | ||
| summary | di | bool | 1 | √ | 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 | ||
| corrupt | duplicates | bool | 1 | √ | null | ||
| argos | duration | bool | 1 | √ | null | ||
| behavior | durationmax_1 | bool | 1 | √ | null | ||
| behavior | durationmax_2 | bool | 1 | √ | null | ||
| behavior | durationmin_1 | bool | 1 | √ | null | ||
| behavior | durationmin_2 | bool | 1 | √ | null | ||
| status | fastgpspower | bool | 1 | √ | null | ||
| fastgps | fastloc_power | bool | 1 | √ | null | ||
| locations | gpe_msd | bool | 1 | √ | null | ||
| locations | gpe_u | bool | 1 | √ | null | ||
| fastgps | height | bool | 1 | √ | null | ||
| fastgps | id_13 | bool | 1 | √ | null | ||
| fastgps | id_14 | bool | 1 | √ | null | ||
| status | initiallybroken | bool | 1 | √ | null | ||
| haulout | latitude | bool | 1 | √ | null | ||
| histos | latitude | bool | 1 | √ | null | ||
| minmaxdepth | latitude | bool | 1 | √ | null | ||
| series | latitude | bool | 1 | √ | null | ||
| seriesrange | latitude | bool | 1 | √ | null | ||
| sst | latitude | bool | 1 | √ | null | ||
| status | lightlevel | bool | 1 | √ | null | ||
| haulout | locationquality | bool | 1 | √ | null | ||
| histos | locationquality | bool | 1 | √ | null | ||
| minmaxdepth | locationquality | bool | 1 | √ | null | ||
| series | locationquality | bool | 1 | √ | null | ||
| seriesrange | locationquality | bool | 1 | √ | null | ||
| sst | locationquality | bool | 1 | √ | null | ||
| haulout | longitude | bool | 1 | √ | null | ||
| histos | longitude | bool | 1 | √ | null | ||
| minmaxdepth | longitude | bool | 1 | √ | null | ||
| series | longitude | bool | 1 | √ | null | ||
| seriesrange | longitude | bool | 1 | √ | null | ||
| sst | longitude | bool | 1 | √ | null | ||
| summary | maxpower | bool | 1 | √ | null | ||
| seriesrange | maxtemp | bool | 1 | √ | null | ||
| seriesrange | maxtempaccuracy | bool | 1 | √ | null | ||
| summary | minpower | bool | 1 | √ | null | ||
| seriesrange | mintemp | bool | 1 | √ | null | ||
| seriesrange | mintempaccuracy | bool | 1 | √ | null | ||
| all | mote_id | bool | 1 | √ | null | ||
| status | nodawndusk | bool | 1 | √ | null | ||
| fastgps | noise | bool | 1 | √ | null | ||
| behavior | number_1 | bool | 1 | √ | null | ||
| behavior | number_2 | bool | 1 | √ | null | ||
| locations | offset | bool | 1 | √ | null | ||
| rawargos | offset | bool | 1 | √ | null | ||
| locations | offset_orientation | bool | 1 | √ | null | ||
| rawargos | offset_orientation | bool | 1 | √ | null | ||
| status | powerlimit | bool | 1 | √ | null | ||
| status | prereleasetilt | bool | 1 | √ | null | ||
| status | prereleasetiltcount | bool | 1 | √ | null | ||
| status | prereleasetiltsd | bool | 1 | √ | null | ||
| fastgps | range_13 | bool | 1 | √ | null | ||
| fastgps | range_14 | bool | 1 | √ | null | ||
| status | releasedepth | bool | 1 | √ | null | ||
| status | releasetype | bool | 1 | √ | null | ||
| summary | releasetype | bool | 1 | √ | null | ||
| status | resets | bool | 1 | √ | null | ||
| corrupt | satellite | bool | 1 | √ | null | ||
| all | sensor_.32 | bool | 1 | √ | null | ||
| rawargos | sensor_.32 | bool | 1 | √ | null | ||
| behavior | shape_1 | bool | 1 | √ | null | ||
| behavior | shape_2 | bool | 1 | √ | 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 | ||
| series | temperature | bool | 1 | √ | null | ||
| series | trange | bool | 1 | √ | null | ||
| status | transmitpower | bool | 1 | √ | null | ||
| fastgps | twic_power | bool | 1 | √ | null | ||
| status | twicpower | bool | 1 | √ | null | ||
| justin_2017_metadata | deployment_date | date | 13 | √ | null | ||
| justin_metadata | deployment_date | date | 13 | √ | null | ||
| status | battvoltage | float8 | 17,17 | √ | 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 | bin2 | float8 | 17,17 | √ | null | ||
| histos | bin3 | float8 | 17,17 | √ | null | ||
| histos | bin4 | float8 | 17,17 | √ | null | ||
| histos | bin5 | float8 | 17,17 | √ | null | ||
| histos | bin6 | float8 | 17,17 | √ | null | ||
| histos | bin7 | float8 | 17,17 | √ | null | ||
| histos | bin8 | float8 | 17,17 | √ | null | ||
| histos | bin9 | float8 | 17,17 | √ | null | ||
| all | delta_freq. | float8 | 17,17 | √ | null | ||
| dtag_metadata | deployment_latitude | float8 | 17,17 | √ | null | ||
| justin_2017_metadata | deployment_latitude | float8 | 17,17 | √ | null | ||
| justin_metadata | deployment_latitude | float8 | 17,17 | √ | null | ||
| metadata | deployment_latitude | float8 | 17,17 | √ | null | ||
| patrick_metadata | deployment_latitude | float8 | 17,17 | √ | null | ||
| prev_argos_metadata | deployment_latitude | float8 | 17,17 | √ | null | ||
| previous_metadata | deployment_latitude | float8 | 17,17 | √ | null | ||
| uga_metadata | deployment_latitude | float8 | 17,17 | √ | null | ||
| dtag_metadata | deployment_longitude | float8 | 17,17 | √ | null | ||
| justin_2017_metadata | deployment_longitude | float8 | 17,17 | √ | null | ||
| justin_metadata | deployment_longitude | float8 | 17,17 | √ | null | ||
| metadata | deployment_longitude | float8 | 17,17 | √ | null | ||
| patrick_metadata | deployment_longitude | float8 | 17,17 | √ | null | ||
| prev_argos_metadata | deployment_longitude | float8 | 17,17 | √ | null | ||
| previous_metadata | deployment_longitude | float8 | 17,17 | √ | null | ||
| uga_metadata | deployment_longitude | float8 | 17,17 | √ | null | ||
| series | depth | float8 | 17,17 | √ | null | ||
| status | depth | float8 | 17,17 | √ | null | ||
| behavior | depthmax | float8 | 17,17 | √ | null | ||
| behavior | depthmin | float8 | 17,17 | √ | null | ||
| behavior | depthsensor | float8 | 17,17 | √ | null | ||
| histos | depthsensor | float8 | 17,17 | √ | null | ||
| minmaxdepth | depthsensor | float8 | 17,17 | √ | null | ||
| series | depthsensor | float8 | 17,17 | √ | null | ||
| seriesrange | depthsensor | float8 | 17,17 | √ | null | ||
| sst | depthsensor | float8 | 17,17 | √ | null | ||
| status | depthsensor | float8 | 17,17 | √ | null | ||
| series | drange | float8 | 17,17 | √ | null | ||
| behavior | durationmax | float8 | 17,17 | √ | null | ||
| behavior | durationmin | float8 | 17,17 | √ | null | ||
| all | frequency | float8 | 17,17 | √ | null | ||
| fastgps | initlat | float8 | 17,17 | √ | null | ||
| fastgps | initlon | float8 | 17,17 | √ | null | ||
| deployment | last_location_latitude | float8 | 17,17 | √ | null | ||
| deployment | last_location_longitude | float8 | 17,17 | √ | null | ||
| all | lat_.sol..1 | float8 | 17,17 | √ | null | ||
| all | lat_.sol..2 | float8 | 17,17 | √ | null | ||
| all | latitude | float8 | 17,17 | √ | null | ||
| argos | latitude | float8 | 17,17 | √ | null | ||
| argos_diag_history | latitude | float8 | 17,17 | √ | null | ||
| bar | latitude | float8 | 17,17 | √ | null | ||
| corrupt | latitude | float8 | 17,17 | √ | null | ||
| fastgps | latitude | float8 | 17,17 | √ | null | ||
| locations | latitude | float8 | 17,17 | √ | null | ||
| rawargos | latitude | float8 | 17,17 | √ | null | ||
| status | latitude | float8 | 17,17 | √ | null | ||
| argos | latitude2 | float8 | 17,17 | √ | null | ||
| rawargos | latitude2 | float8 | 17,17 | √ | null | ||
| all | long_.1 | float8 | 17,17 | √ | null | ||
| all | long_.2 | float8 | 17,17 | √ | null | ||
| all | longitude | float8 | 17,17 | √ | null | ||
| argos | longitude | float8 | 17,17 | √ | null | ||
| argos_diag_history | longitude | float8 | 17,17 | √ | null | ||
| bar | longitude | float8 | 17,17 | √ | null | ||
| corrupt | longitude | float8 | 17,17 | √ | null | ||
| fastgps | longitude | float8 | 17,17 | √ | null | ||
| locations | longitude | float8 | 17,17 | √ | null | ||
| rawargos | longitude | float8 | 17,17 | √ | null | ||
| status | longitude | float8 | 17,17 | √ | null | ||
| argos | longitude2 | float8 | 17,17 | √ | null | ||
| rawargos | longitude2 | float8 | 17,17 | √ | null | ||
| minmaxdepth | maxaccuracy | float8 | 17,17 | √ | null | ||
| minmaxdepth | maxdepth | float8 | 17,17 | √ | null | ||
| seriesrange | maxdepth | float8 | 17,17 | √ | null | ||
| seriesrange | maxdepthaccuracy | float8 | 17,17 | √ | null | ||
| minmaxdepth | minaccuracy | float8 | 17,17 | √ | null | ||
| minmaxdepth | mindepth | float8 | 17,17 | √ | null | ||
| seriesrange | mindepth | float8 | 17,17 | √ | null | ||
| seriesrange | mindepthaccuracy | float8 | 17,17 | √ | null | ||
| patrick_metadata | ptt | float8 | 17,17 | √ | null | ||
| fastgps | residual | float8 | 17,17 | √ | null | ||
| dtag_metadata | tag_serial_number | float8 | 17,17 | √ | null | ||
| uga_metadata | tag_serial_number | float8 | 17,17 | √ | null | ||
| sst | temperature | float8 | 17,17 | √ | null | ||
| status | temperature | float8 | 17,17 | √ | null | ||
| status | transmitcurrent | float8 | 17,17 | √ | null | ||
| status | transmitvoltage | float8 | 17,17 | √ | null | ||
| all | altitude | int4 | 10 | √ | null | ||
| argos_diag_history | altitude | int4 | 10 | √ | null | ||
| argos | avginterval | int4 | 10 | √ | null | ||
| fastgps | bad_sats | int4 | 10 | √ | null | ||
| histos | badtherm | int4 | 10 | √ | null | ||
| all | best_level | int4 | 10 | √ | null | ||
| status | brokenthermistor | int4 | 10 | √ | 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_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 | ||
| all | comp_ | int4 | 10 | √ | null | ||
| argos | corrupt | int4 | 10 | √ | null | ||
| behavior | count | int4 | 10 | √ | null | ||
| fastgps | count | int4 | 10 | √ | null | ||
| histos | count | int4 | 10 | √ | null | ||
| seriesrange | count | int4 | 10 | √ | null | ||
| summary | datadays | int4 | 10 | √ | null | ||
| behavior | deep | int4 | 10 | √ | null | ||
| haulout | deployid | int4 | 10 | √ | null | ||
| sst | depth | int4 | 10 | √ | null | ||
| summary | ds | int4 | 10 | √ | null | ||
| argos | duplicates | int4 | 10 | √ | null | ||
| rawargos | dups | int4 | 10 | √ | null | ||
| haulout | duration | int4 | 10 | √ | null | ||
| rawargos | duration | int4 | 10 | √ | null | ||
| all | ellipse_orientation | int4 | 10 | √ | null | ||
| locations | error_ellipse.orientation | int4 | 10 | √ | null | ||
| rawargos | error_ellipse.orientation | int4 | 10 | √ | null | ||
| all | error_radius | int4 | 10 | √ | null | ||
| locations | error_radius | int4 | 10 | √ | null | ||
| rawargos | error_radius | int4 | 10 | √ | null | ||
| locations | error_semi.major.axis | int4 | 10 | √ | null | ||
| rawargos | error_semi.major.axis | int4 | 10 | √ | null | ||
| locations | error_semi.minor.axis | int4 | 10 | √ | null | ||
| rawargos | error_semi.minor.axis | int4 | 10 | √ | null | ||
| fastgps | failures | int4 | 10 | √ | null | ||
| status | fastgpsfailures | int4 | 10 | √ | null | ||
| status | fastgpslocnumber | int4 | 10 | √ | null | ||
| deployment | fastloc | int4 | 10 | √ | null | ||
| argos | frequency | int4 | 10 | √ | null | ||
| rawargos | frequency | int4 | 10 | √ | null | ||
| all | gdop | int4 | 10 | √ | null | ||
| fastgps | hauled_out | int4 | 10 | √ | null | ||
| status | hauledout | int4 | 10 | √ | null | ||
| fastgps | id | int4 | 10 | √ | null | ||
| haulout | 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_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 | ||
| argos | iq | int4 | 10 | √ | null | ||
| rawargos | iq | int4 | 10 | √ | null | ||
| all | loc_.idx | int4 | 10 | √ | null | ||
| fastgps | locnumber | int4 | 10 | √ | null | ||
| status | maxdepth | int4 | 10 | √ | null | ||
| status | maxwetdry | int4 | 10 | √ | null | ||
| argos | mininterval | int4 | 10 | √ | null | ||
| summary | mininterval | int4 | 10 | √ | null | ||
| status | minwetdry | int4 | 10 | √ | null | ||
| all | msg | int4 | 10 | √ | null | ||
| argos | msgcount | int4 | 10 | √ | null | ||
| summary | msgperpass | int4 | 10 | √ | null | ||
| fastgps | name | int4 | 10 | √ | null | ||
| all | nopc | int4 | 10 | √ | null | ||
| behavior | number | int4 | 10 | √ | null | ||
| histos | numbins | int4 | 10 | √ | null | ||
| all | pass | int4 | 10 | √ | null | ||
| rawargos | pass | int4 | 10 | √ | null | ||
| argos_diag_history | pass_dur_s | int4 | 10 | √ | null | ||
| summary | passes | int4 | 10 | √ | null | ||
| summary | percentargosloc | int4 | 10 | √ | null | ||
| summary | percentdecoded | int4 | 10 | √ | null | ||
| all | platform_id.no. | int4 | 10 | √ | null | ||
| argos_diag_history | platform_id_no | int4 | 10 | √ | null | ||
| argos | power | int4 | 10 | √ | null | ||
| rawargos | power | int4 | 10 | √ | null | ||
| argos_diag_history | prg_no | int4 | 10 | √ | null | ||
| all | prg_no. | int4 | 10 | √ | null | ||
| deployment | program_number | int4 | 10 | √ | null | ||
| argos | ptt | int4 | 10 | √ | null | ||
| argos_diag_history | ptt | int4 | 10 | √ | null | ||
| bar | ptt | int4 | 10 | √ | null | ||
| behavior | ptt | int4 | 10 | √ | null | ||
| corrupt | ptt | int4 | 10 | √ | null | ||
| haulout | ptt | int4 | 10 | √ | null | ||
| histos | ptt | int4 | 10 | √ | null | ||
| justin_2017_metadata | ptt | int4 | 10 | √ | null | ||
| justin_metadata | ptt | int4 | 10 | √ | null | ||
| locations | ptt | int4 | 10 | √ | null | ||
| metadata | ptt | int4 | 10 | √ | null | ||
| minmaxdepth | ptt | int4 | 10 | √ | null | ||
| prev_argos_metadata | ptt | int4 | 10 | √ | null | ||
| previous_metadata | ptt | int4 | 10 | √ | null | ||
| rtc | ptt | int4 | 10 | √ | null | ||
| series | ptt | int4 | 10 | √ | null | ||
| seriesrange | ptt | int4 | 10 | √ | null | ||
| sst | ptt | int4 | 10 | √ | null | ||
| status | ptt | int4 | 10 | √ | null | ||
| summary | ptt | int4 | 10 | √ | null | ||
| uga_metadata | ptt | int4 | 10 | √ | null | ||
| deployment | ptt_decimal | int4 | 10 | √ | 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_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 | satellites | int4 | 10 | √ | null | ||
| all | semi_major.axis | int4 | 10 | √ | null | ||
| all | semi_minor.axis | int4 | 10 | √ | null | ||
| all | sensor_.01 | int4 | 10 | √ | null | ||
| rawargos | sensor_.01 | int4 | 10 | √ | null | ||
| all | sensor_.02 | int4 | 10 | √ | null | ||
| rawargos | sensor_.02 | int4 | 10 | √ | null | ||
| all | sensor_.03 | int4 | 10 | √ | null | ||
| rawargos | sensor_.03 | int4 | 10 | √ | null | ||
| all | sensor_.04 | int4 | 10 | √ | null | ||
| rawargos | sensor_.04 | int4 | 10 | √ | null | ||
| all | sensor_.05 | int4 | 10 | √ | null | ||
| rawargos | sensor_.05 | int4 | 10 | √ | null | ||
| all | sensor_.06 | int4 | 10 | √ | null | ||
| rawargos | sensor_.06 | int4 | 10 | √ | null | ||
| all | sensor_.07 | int4 | 10 | √ | null | ||
| rawargos | sensor_.07 | int4 | 10 | √ | null | ||
| all | sensor_.08 | int4 | 10 | √ | null | ||
| rawargos | sensor_.08 | int4 | 10 | √ | null | ||
| all | sensor_.09 | int4 | 10 | √ | null | ||
| rawargos | sensor_.09 | int4 | 10 | √ | null | ||
| all | sensor_.10 | int4 | 10 | √ | null | ||
| rawargos | sensor_.10 | int4 | 10 | √ | null | ||
| all | sensor_.11 | int4 | 10 | √ | null | ||
| rawargos | sensor_.11 | int4 | 10 | √ | null | ||
| all | sensor_.12 | int4 | 10 | √ | null | ||
| rawargos | sensor_.12 | int4 | 10 | √ | null | ||
| all | sensor_.13 | int4 | 10 | √ | null | ||
| rawargos | sensor_.13 | int4 | 10 | √ | null | ||
| all | sensor_.14 | int4 | 10 | √ | null | ||
| rawargos | sensor_.14 | int4 | 10 | √ | null | ||
| all | sensor_.15 | int4 | 10 | √ | null | ||
| rawargos | sensor_.15 | int4 | 10 | √ | null | ||
| all | sensor_.16 | int4 | 10 | √ | null | ||
| rawargos | sensor_.16 | int4 | 10 | √ | null | ||
| all | sensor_.17 | int4 | 10 | √ | null | ||
| rawargos | sensor_.17 | int4 | 10 | √ | null | ||
| all | sensor_.18 | int4 | 10 | √ | null | ||
| rawargos | sensor_.18 | int4 | 10 | √ | null | ||
| all | sensor_.19 | int4 | 10 | √ | null | ||
| rawargos | sensor_.19 | int4 | 10 | √ | null | ||
| all | sensor_.20 | int4 | 10 | √ | null | ||
| rawargos | sensor_.20 | int4 | 10 | √ | null | ||
| all | sensor_.21 | int4 | 10 | √ | null | ||
| rawargos | sensor_.21 | int4 | 10 | √ | null | ||
| all | sensor_.22 | int4 | 10 | √ | null | ||
| rawargos | sensor_.22 | int4 | 10 | √ | null | ||
| all | sensor_.23 | int4 | 10 | √ | null | ||
| rawargos | sensor_.23 | int4 | 10 | √ | null | ||
| all | sensor_.24 | int4 | 10 | √ | null | ||
| rawargos | sensor_.24 | int4 | 10 | √ | null | ||
| all | sensor_.25 | int4 | 10 | √ | null | ||
| rawargos | sensor_.25 | int4 | 10 | √ | null | ||
| all | sensor_.26 | int4 | 10 | √ | null | ||
| rawargos | sensor_.26 | int4 | 10 | √ | null | ||
| all | sensor_.27 | int4 | 10 | √ | null | ||
| rawargos | sensor_.27 | int4 | 10 | √ | null | ||
| all | sensor_.28 | int4 | 10 | √ | null | ||
| rawargos | sensor_.28 | int4 | 10 | √ | null | ||
| all | sensor_.29 | int4 | 10 | √ | null | ||
| rawargos | sensor_.29 | int4 | 10 | √ | null | ||
| all | sensor_.30 | int4 | 10 | √ | null | ||
| rawargos | sensor_.30 | int4 | 10 | √ | null | ||
| all | sensor_.31 | int4 | 10 | √ | null | ||
| rawargos | sensor_.31 | int4 | 10 | √ | null | ||
| behavior | shallow | int4 | 10 | √ | null | ||
| justin_2017_metadata | species_code | int4 | 10 | √ | null | ||
| justin_metadata | species_code | int4 | 10 | √ | null | ||
| status | statusword | int4 | 10 | √ | null | ||
| histos | sum | int4 | 10 | √ | null | ||
| status | transmits | int4 | 10 | √ | null | ||
| status | wetdry | int4 | 10 | √ | null | ||
| status | wetdrythreshold | int4 | 10 | √ | null | ||
| all | x_...120.db | int4 | 10 | √ | null | ||
| summary | xmitdays | int4 | 10 | √ | null | ||
| status | xmitqueue | int4 | 10 | √ | null | ||
| status | zerodepthoffset | int4 | 10 | √ | null | ||
| argos_diag_history | alarm | text | 2147483647 | √ | null | ||
| dtag_metadata | animal_name | text | 2147483647 | √ | null | ||
| uga_metadata | animal_name | text | 2147483647 | √ | null | ||
| deployment | cl_nn | text | 2147483647 | √ | null | ||
| rawargos | class | text | 2147483647 | √ | null | ||
| locations | comment | text | 2147483647 | √ | null | ||
| rawargos | comment | text | 2147483647 | √ | null | ||
| rtc | correctiontype | text | 2147483647 | √ | null | ||
| dtag_metadata | data_wrangler_email | text | 2147483647 | √ | null | ||
| justin_2017_metadata | data_wrangler_email | text | 2147483647 | √ | null | ||
| justin_metadata | data_wrangler_email | text | 2147483647 | √ | null | ||
| metadata | data_wrangler_email | text | 2147483647 | √ | null | ||
| patrick_metadata | data_wrangler_email | text | 2147483647 | √ | null | ||
| prev_argos_metadata | data_wrangler_email | text | 2147483647 | √ | null | ||
| previous_metadata | data_wrangler_email | text | 2147483647 | √ | null | ||
| uga_metadata | data_wrangler_email | text | 2147483647 | √ | null | ||
| fastgps | day | text | 2147483647 | √ | null | ||
| series | day | text | 2147483647 | √ | null | ||
| deployment | deploy_id | text | 2147483647 | √ | null | ||
| all | deployid | text | 2147483647 | √ | null | ||
| argos | deployid | text | 2147483647 | √ | null | ||
| behavior | deployid | text | 2147483647 | √ | null | ||
| corrupt | deployid | text | 2147483647 | √ | null | ||
| histos | deployid | text | 2147483647 | √ | null | ||
| locations | deployid | text | 2147483647 | √ | null | ||
| minmaxdepth | deployid | text | 2147483647 | √ | null | ||
| rtc | deployid | text | 2147483647 | √ | null | ||
| series | deployid | text | 2147483647 | √ | null | ||
| seriesrange | deployid | text | 2147483647 | √ | null | ||
| sst | deployid | text | 2147483647 | √ | null | ||
| status | deployid | text | 2147483647 | √ | null | ||
| summary | deployid | text | 2147483647 | √ | null | ||
| behavior | end | text | 2147483647 | √ | null | ||
| haulout | end | text | 2147483647 | √ | null | ||
| seriesrange | end | text | 2147483647 | √ | null | ||
| deployment | first_uplink_date | text | 2147483647 | √ | null | ||
| argos_diag_history | format_name | text | 2147483647 | √ | null | ||
| dtag_metadata | genus | text | 2147483647 | √ | null | ||
| metadata | genus | text | 2147483647 | √ | null | ||
| patrick_metadata | genus | text | 2147483647 | √ | null | ||
| prev_argos_metadata | genus | text | 2147483647 | √ | null | ||
| previous_metadata | genus | text | 2147483647 | √ | null | ||
| uga_metadata | genus | text | 2147483647 | √ | null | ||
| histos | histtype | text | 2147483647 | √ | null | ||
| fastgps | inittype | text | 2147483647 | √ | null | ||
| argos | instr | text | 2147483647 | √ | null | ||
| behavior | instr | text | 2147483647 | √ | null | ||
| corrupt | instr | text | 2147483647 | √ | null | ||
| haulout | instr | text | 2147483647 | √ | null | ||
| histos | instr | text | 2147483647 | √ | null | ||
| locations | instr | text | 2147483647 | √ | null | ||
| minmaxdepth | instr | text | 2147483647 | √ | null | ||
| rtc | instr | text | 2147483647 | √ | null | ||
| series | instr | text | 2147483647 | √ | null | ||
| seriesrange | instr | text | 2147483647 | √ | null | ||
| sst | instr | text | 2147483647 | √ | null | ||
| status | instr | text | 2147483647 | √ | null | ||
| summary | instr | text | 2147483647 | √ | null | ||
| labels | key | text | 2147483647 | √ | null | ||
| deployment | last_location_location_date | text | 2147483647 | √ | null | ||
| deployment | last_update_date | text | 2147483647 | √ | null | ||
| deployment | last_uplink_date | text | 2147483647 | √ | null | ||
| rawargos | len | text | 2147483647 | √ | null | ||
| all | loc_.quality | text | 2147483647 | √ | null | ||
| all | loc_.type | text | 2147483647 | √ | null | ||
| dtag_metadata | local_deployment_name | text | 2147483647 | √ | null | ||
| justin_2017_metadata | local_deployment_name | text | 2147483647 | √ | null | ||
| justin_metadata | local_deployment_name | text | 2147483647 | √ | null | ||
| metadata | local_deployment_name | text | 2147483647 | √ | null | ||
| patrick_metadata | local_deployment_name | text | 2147483647 | √ | null | ||
| prev_argos_metadata | local_deployment_name | text | 2147483647 | √ | null | ||
| previous_metadata | local_deployment_name | text | 2147483647 | √ | null | ||
| uga_metadata | local_deployment_name | text | 2147483647 | √ | null | ||
| deployment | local_tag.id | text | 2147483647 | √ | null | ||
| deployment | locality | text | 2147483647 | √ | null | ||
| argos | locationquality | text | 2147483647 | √ | null | ||
| argos_diag_history | locationquality | text | 2147483647 | √ | null | ||
| bar | locationquality | text | 2147483647 | √ | null | ||
| corrupt | locationquality | text | 2147483647 | √ | null | ||
| status | locationquality | text | 2147483647 | √ | null | ||
| minmaxdepth | maxsource | text | 2147483647 | √ | null | ||
| minmaxdepth | minsource | text | 2147483647 | √ | null | ||
| deployment | owner | text | 2147483647 | √ | null | ||
| argos_diag_history | platform | text | 2147483647 | √ | null | ||
| metadata | portal | text | 2147483647 | √ | null | ||
| prev_argos_metadata | portal | text | 2147483647 | √ | null | ||
| previous_metadata | portal | text | 2147483647 | √ | null | ||
| justin_2017_metadata | portal_username | text | 2147483647 | √ | null | ||
| justin_metadata | portal_username | text | 2147483647 | √ | null | ||
| metadata | portal_username | text | 2147483647 | √ | null | ||
| prev_argos_metadata | portal_username | text | 2147483647 | √ | null | ||
| previous_metadata | portal_username | text | 2147483647 | √ | null | ||
| corrupt | possible_type | text | 2147483647 | √ | null | ||
| dtag_metadata | principal_investigator_email | text | 2147483647 | √ | null | ||
| justin_2017_metadata | principal_investigator_email | text | 2147483647 | √ | null | ||
| justin_metadata | principal_investigator_email | text | 2147483647 | √ | null | ||
| metadata | principal_investigator_email | text | 2147483647 | √ | null | ||
| patrick_metadata | principal_investigator_email | text | 2147483647 | √ | null | ||
| prev_argos_metadata | principal_investigator_email | text | 2147483647 | √ | null | ||
| previous_metadata | principal_investigator_email | text | 2147483647 | √ | null | ||
| uga_metadata | principal_investigator_email | text | 2147483647 | √ | null | ||
| rawargos | prog | text | 2147483647 | √ | null | ||
| rawargos | ptt | text | 2147483647 | √ | null | ||
| locations | quality | text | 2147483647 | √ | null | ||
| corrupt | reason | text | 2147483647 | √ | null | ||
| status | received | text | 2147483647 | √ | null | ||
| argos | recordtype | text | 2147483647 | √ | null | ||
| status | rtc | text | 2147483647 | √ | null | ||
| argos_diag_history | sat | text | 2147483647 | √ | null | ||
| all | sat_ | text | 2147483647 | √ | null | ||
| argos | satellite | text | 2147483647 | √ | null | ||
| rawargos | satellite | text | 2147483647 | √ | null | ||
| argos_diag_history | sealid | text | 2147483647 | √ | null | ||
| bar | sealid | text | 2147483647 | √ | null | ||
| deployment | serial_number | text | 2147483647 | √ | null | ||
| columns | serialized_col_names | text | 2147483647 | √ | null | ||
| columns | serialized_col_types | text | 2147483647 | √ | null | ||
| argos_diag_history | serialnum | text | 2147483647 | √ | null | ||
| bar | serialnum | text | 2147483647 | √ | null | ||
| behavior | shape | text | 2147483647 | √ | null | ||
| behavior | source | text | 2147483647 | √ | null | ||
| deployment | source | text | 2147483647 | √ | null | ||
| histos | source | text | 2147483647 | √ | null | ||
| series | source | text | 2147483647 | √ | null | ||
| seriesrange | source | text | 2147483647 | √ | null | ||
| sst | source | text | 2147483647 | √ | null | ||
| argos_diag_history | species | text | 2147483647 | √ | null | ||
| bar | species | text | 2147483647 | √ | null | ||
| deployment | species | text | 2147483647 | √ | null | ||
| dtag_metadata | species | text | 2147483647 | √ | null | ||
| justin_metadata | Species | text | 2147483647 | √ | null | ||
| metadata | species | text | 2147483647 | √ | null | ||
| patrick_metadata | species | text | 2147483647 | √ | null | ||
| prev_argos_metadata | species | text | 2147483647 | √ | null | ||
| previous_metadata | species | text | 2147483647 | √ | null | ||
| uga_metadata | species | text | 2147483647 | √ | null | ||
| behavior | start | text | 2147483647 | √ | null | ||
| haulout | start | text | 2147483647 | √ | null | ||
| seriesrange | start | text | 2147483647 | √ | null | ||
| deployment | status | text | 2147483647 | √ | null | ||
| status | sw | text | 2147483647 | √ | null | ||
| summary | sw | text | 2147483647 | √ | null | ||
| columns | table_name | text | 2147483647 | √ | null | ||
| dtag_metadata | tag_manufacturer | text | 2147483647 | √ | null | ||
| metadata | tag_manufacturer | text | 2147483647 | √ | null | ||
| patrick_metadata | tag_manufacturer | text | 2147483647 | √ | null | ||
| prev_argos_metadata | tag_manufacturer | text | 2147483647 | √ | null | ||
| previous_metadata | tag_manufacturer | text | 2147483647 | √ | null | ||
| uga_metadata | tag_manufacturer | text | 2147483647 | √ | null | ||
| dtag_metadata | tag_model | text | 2147483647 | √ | null | ||
| justin_2017_metadata | tag_model | text | 2147483647 | √ | null | ||
| justin_metadata | tag_model | text | 2147483647 | √ | null | ||
| metadata | tag_model | text | 2147483647 | √ | null | ||
| patrick_metadata | tag_model | text | 2147483647 | √ | null | ||
| prev_argos_metadata | tag_model | text | 2147483647 | √ | null | ||
| previous_metadata | tag_model | text | 2147483647 | √ | null | ||
| uga_metadata | tag_model | text | 2147483647 | √ | null | ||
| metadata | tag_serial_number | text | 2147483647 | √ | null | ||
| patrick_metadata | tag_serial_number | text | 2147483647 | √ | null | ||
| prev_argos_metadata | tag_serial_number | text | 2147483647 | √ | null | ||
| previous_metadata | tag_serial_number | text | 2147483647 | √ | null | ||
| deployment | tag_type | text | 2147483647 | √ | null | ||
| deployment | tagtype | text | 2147483647 | √ | null | ||
| locations | type | text | 2147483647 | √ | null | ||
| status | type | text | 2147483647 | √ | null | ||
| labels | value_s. | text | 2147483647 | √ | null | ||
| all | wc_id | text | 2147483647 | √ | null | ||
| argos | wc_id | text | 2147483647 | √ | null | ||
| behavior | wc_id | text | 2147483647 | √ | null | ||
| corrupt | wc_id | text | 2147483647 | √ | null | ||
| deployment | wc_id | text | 2147483647 | √ | null | ||
| fastgps | wc_id | text | 2147483647 | √ | null | ||
| haulout | wc_id | text | 2147483647 | √ | null | ||
| histos | wc_id | text | 2147483647 | √ | null | ||
| labels | wc_id | text | 2147483647 | √ | null | ||
| locations | wc_id | text | 2147483647 | √ | null | ||
| minmaxdepth | wc_id | text | 2147483647 | √ | null | ||
| rawargos | wc_id | text | 2147483647 | √ | null | ||
| rtc | wc_id | text | 2147483647 | √ | null | ||
| series | wc_id | text | 2147483647 | √ | null | ||
| seriesrange | wc_id | text | 2147483647 | √ | null | ||
| sst | wc_id | text | 2147483647 | √ | null | ||
| status | wc_id | text | 2147483647 | √ | null | ||
| summary | wc_id | text | 2147483647 | √ | null | ||
| behavior | what | text | 2147483647 | √ | null | ||
| uga_metadata | embargo_until_date | timestamp | 29,6 | √ | null | ||
| argos | date | timestamptz | 35,6 | √ | null | ||
| argos_diag_history | date | timestamptz | 35,6 | √ | null | ||
| bar | date | timestamptz | 35,6 | √ | null | ||
| corrupt | date | timestamptz | 35,6 | √ | null | ||
| histos | date | timestamptz | 35,6 | √ | null | ||
| locations | date | timestamptz | 35,6 | √ | null | ||
| minmaxdepth | date | timestamptz | 35,6 | √ | null | ||
| sst | date | timestamptz | 35,6 | √ | null | ||
| summary | deploydate | timestamptz | 35,6 | √ | null | ||
| dtag_metadata | deployment_date | timestamptz | 35,6 | √ | null | ||
| metadata | deployment_date | timestamptz | 35,6 | √ | null | ||
| patrick_metadata | deployment_date | timestamptz | 35,6 | √ | null | ||
| prev_argos_metadata | deployment_date | timestamptz | 35,6 | √ | null | ||
| previous_metadata | deployment_date | timestamptz | 35,6 | √ | null | ||
| uga_metadata | deployment_date | timestamptz | 35,6 | √ | null | ||
| summary | earliestdatatime | timestamptz | 35,6 | √ | null | ||
| summary | earliestxmittime | timestamptz | 35,6 | √ | null | ||
| dtag_metadata | embargo_until_date | timestamptz | 35,6 | √ | null | ||
| metadata | embargo_until_date | timestamptz | 35,6 | √ | null | ||
| patrick_metadata | embargo_until_date | timestamptz | 35,6 | √ | null | ||
| prev_argos_metadata | embargo_until_date | timestamptz | 35,6 | √ | null | ||
| previous_metadata | embargo_until_date | timestamptz | 35,6 | √ | null | ||
| fastgps | inittime | timestamptz | 35,6 | √ | null | ||
| summary | latestdatatime | timestamptz | 35,6 | √ | null | ||
| summary | latestxmittime | timestamptz | 35,6 | √ | null | ||
| all | loc_.date | timestamptz | 35,6 | √ | null | ||
| argos_diag_history | loc_date | timestamptz | 35,6 | √ | null | ||
| all | msg_date | timestamptz | 35,6 | √ | null | ||
| argos_diag_history | msg_date | timestamptz | 35,6 | √ | null | ||
| rawargos | msgdate | timestamptz | 35,6 | √ | null | ||
| rawargos | msgtime | timestamptz | 35,6 | √ | null | ||
| rawargos | passdate | timestamptz | 35,6 | √ | null | ||
| rawargos | passtime | timestamptz | 35,6 | √ | null | ||
| corrupt | possible_timestamp | timestamptz | 35,6 | √ | null | ||
| rtc | realdate | timestamptz | 35,6 | √ | null | ||
| rtc | realtime | timestamptz | 35,6 | √ | null | ||
| summary | releasedate | timestamptz | 35,6 | √ | null | ||
| status | releasetime | timestamptz | 35,6 | √ | null | ||
| rtc | tagdate | timestamptz | 35,6 | √ | null | ||
| rtc | tagtime | timestamptz | 35,6 | √ | null | ||
| fastgps | time | timestamptz | 35,6 | √ | null | ||
| series | time | timestamptz | 35,6 | √ | null | ||
| fastgps | time_error | timestamptz | 35,6 | √ | null | ||
| fastgps | time_offset | timestamptz | 35,6 | √ | null | ||
| histos | time_offset | timestamptz | 35,6 | √ | null | ||
| status | time_offset | timestamptz | 35,6 | √ | null |