SchemaSpy Analysis of topp.junk - Columns | Generated by SchemaSpy |
Generated by SchemaSpy on Wed Dec 27 13:25 PST 2017 |
| ||||||
|
topp.junk contains 557 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | Comments |
---|---|---|---|---|---|---|---|
argos_diag_materialized | actualpopupdate | date | 13 | √ | null | ||
argos_diag_materialized | comment | text | 2147483647 | √ | null | ||
argos_diag_materialized | contact | text | 2147483647 | √ | null | ||
argos_diag_materialized | enddate | date | 13 | √ | null | ||
argos_diag_materialized | endtime | time | 15,6 | √ | null | ||
argos_diag_materialized | est_end_date | date | 13 | √ | null | ||
argos_diag_materialized | eventid | int4 | 10 | √ | null | ||
argos_diag_materialized | hit_ptt | int4 | 10 | √ | null | ||
argos_diag_materialized | hit_t | timestamptz | 35,6 | √ | null | ||
argos_diag_materialized | las | text | 2147483647 | √ | null | ||
argos_diag_materialized | modelname | text | 2147483647 | √ | null | ||
argos_diag_materialized | owner | text | 2147483647 | √ | null | ||
argos_diag_materialized | projectname | text | 2147483647 | √ | null | ||
argos_diag_materialized | ptt | int4 | 10 | √ | null | ||
argos_diag_materialized | pttnumber | int4 | 10 | √ | null | ||
argos_diag_materialized | satdeploymentid | int4 | 10 | √ | null | ||
argos_diag_materialized | speciesname | text | 2147483647 | √ | null | ||
argos_diag_materialized | startdate | date | 13 | √ | null | ||
argos_diag_materialized | starttime | time | 15,6 | √ | null | ||
argos_diag_materialized | t | timestamp | 29,6 | √ | null | ||
argos_diag_materialized | tagcode | varchar | 50 | √ | null | ||
argos_diag_materialized | tagnumber | text | 2147483647 | √ | null | ||
argos_diag_materialized | testingnote | text | 2147483647 | √ | null | ||
argos_diag_materialized | toppid | text | 2147483647 | √ | null | ||
argos_diag_test | contents | text | 2147483647 | √ | null | ||
argos_diag_test | ptt | int4 | 10 | √ | null | ||
argos_diag_test | t | timestamptz | 35,6 | √ | null | ||
argos_diag_view | actualpopupdate | date | 13 | √ | null | ||
argos_diag_view | comment | text | 2147483647 | √ | null | ||
argos_diag_view | contact | text | 2147483647 | √ | null | ||
argos_diag_view | enddate | date | 13 | √ | null | ||
argos_diag_view | endtime | time | 15,6 | √ | null | ||
argos_diag_view | est_end_date | date | 13 | √ | null | ||
argos_diag_view | eventid | int4 | 10 | √ | null | ||
argos_diag_view | hit_ptt | int4 | 10 | √ | null | ||
argos_diag_view | hit_t | timestamptz | 35,6 | √ | null | ||
argos_diag_view | las | text | 2147483647 | √ | null | ||
argos_diag_view | modelname | text | 2147483647 | √ | null | ||
argos_diag_view | owner | text | 2147483647 | √ | null | ||
argos_diag_view | projectname | text | 2147483647 | √ | null | ||
argos_diag_view | ptt | int4 | 10 | √ | null | ||
argos_diag_view | pttnumber | int4 | 10 | √ | null | ||
argos_diag_view | satdeploymentid | int4 | 10 | √ | null | ||
argos_diag_view | speciesname | text | 2147483647 | √ | null | ||
argos_diag_view | startdate | date | 13 | √ | null | ||
argos_diag_view | starttime | time | 15,6 | √ | null | ||
argos_diag_view | t | timestamp | 29,6 | √ | null | ||
argos_diag_view | tagcode | varchar | 50 | √ | null | ||
argos_diag_view | tagnumber | text | 2147483647 | √ | null | ||
argos_diag_view | testingnote | text | 2147483647 | √ | null | ||
argos_diag_view | toppid | text | 2147483647 | √ | null | ||
atn_track_qc_bak | atn_replaced | int4 | 10 | √ | null | ||
atn_track_qc_bak | comments | text | 2147483647 | √ | null | ||
atn_track_qc_bak | contact | text | 2147483647 | √ | null | ||
atn_track_qc_bak | embargolat | float4 | 8,8 | √ | null | ||
atn_track_qc_bak | embargolon | float4 | 8,8 | √ | null | ||
atn_track_qc_bak | embargountil | date | 13 | √ | null | ||
atn_track_qc_bak | eventid | int4 | 10 | √ | null | ||
atn_track_qc_bak | plot_dashes | int4 | 10 | √ | null | ||
atn_track_qc_bak | plot_icon | int4 | 10 | √ | null | ||
atn_track_qc_bak | plot_points | int4 | 10 | √ | null | ||
atn_track_qc_bak | priority | int4 | 10 | √ | null | ||
atn_track_qc_bak | ptt | int4 | 10 | √ | null | ||
atn_track_qc_bak | rerun | int4 | 10 | √ | null | ||
atn_track_qc_bak | ssm_tr | int4 | 10 | √ | null | ||
atn_track_qc_bak | tkey | int4 | 10 | √ | null | ||
atn_track_qc_bak | toppid | int4 | 10 | √ | null | ||
atn_track_qc_bak | vis_filter | int4 | 10 | √ | null | ||
atn_track_qc_bak | vis_prob | int4 | 10 | √ | null | ||
b | d | int4 | 10 | √ | null | ||
b | id | int4 | 10 | √ | null | ||
b | r | int4 | 10 | √ | null | ||
bar | a | int4 | 10 | √ | null | ||
bar | b | int4 | 10 | √ | null | ||
bar | row.names | text | 2147483647 | √ | null | ||
barbar | foo | timestamp | 29,6 | √ | null | ||
baz | animal_name | bool | 1 | √ | null | ||
baz | data_wrangler_email | text | 2147483647 | √ | null | ||
baz | deployment_date | timestamptz | 35,6 | √ | null | ||
baz | deployment_latitude | float8 | 17,17 | √ | null | ||
baz | deployment_longitude | float8 | 17,17 | √ | null | ||
baz | embargo_until_date | timestamptz | 35,6 | √ | null | ||
baz | genus | text | 2147483647 | √ | null | ||
baz | local_deployment_name | text | 2147483647 | √ | null | ||
baz | portal | text | 2147483647 | √ | null | ||
baz | portal_username | text | 2147483647 | √ | null | ||
baz | principal_investigator_email | text | 2147483647 | √ | null | ||
baz | ptt | int4 | 10 | √ | null | ||
baz | species | text | 2147483647 | √ | null | ||
baz | tag_manufacturer | text | 2147483647 | √ | null | ||
baz | tag_model | text | 2147483647 | √ | null | ||
baz | tag_serial_number | text | 2147483647 | √ | null | ||
bb | d | int4 | 10 | √ | null | ||
bb | id | int4 | 10 | √ | null | ||
bb | r | int4 | 10 | √ | null | ||
bowhead | abbrev | text | 2147483647 | √ | null | ||
bowhead | comments | text | 2147483647 | √ | null | ||
bowhead | commercial | int4 | 10 | √ | null | ||
bowhead | commonname | text | 2147483647 | √ | null | ||
bowhead | contact | text | 2147483647 | √ | null | ||
bowhead | filter | text | 2147483647 | √ | null | ||
bowhead | genus | text | 2147483647 | √ | null | ||
bowhead | lsdname | text | 2147483647 | √ | null | ||
bowhead | pagename | text | 2147483647 | √ | null | ||
bowhead | project | int4 | 10 | √ | null | ||
bowhead | species | text | 2147483647 | √ | null | ||
bowhead | speciescode | int4 | 10 | √ | null | ||
bowhead | taxon | text | 2147483647 | √ | null | ||
bowhead | workgroup | text | 2147483647 | √ | null | ||
c | d | int4 | 10 | √ | null | ||
candidates | atn_replaced | int4 | 10 | √ | null | ||
candidates | comments | text | 2147483647 | √ | null | ||
candidates | contact | text | 2147483647 | √ | null | ||
candidates | embargolat | float4 | 8,8 | √ | null | ||
candidates | embargolon | float4 | 8,8 | √ | null | ||
candidates | embargountil | date | 13 | √ | null | ||
candidates | eventid | int4 | 10 | √ | null | ||
candidates | plot_dashes | int4 | 10 | √ | null | ||
candidates | plot_points | int4 | 10 | √ | null | ||
candidates | priority | int4 | 10 | √ | null | ||
candidates | rerun | int4 | 10 | √ | null | ||
candidates | ssm_tr | int4 | 10 | √ | null | ||
candidates | vis_filter | int4 | 10 | √ | null | ||
candidates | vis_prob | int4 | 10 | √ | null | ||
changed_eseals | eventid | int4 | 10 | √ | null | ||
dc | animal_name | text | 2147483647 | √ | null | ||
dc | data_wrangler_email | text | 2147483647 | √ | null | ||
dc | deployment_date | timestamptz | 35,6 | √ | null | ||
dc | deployment_id | int4 | 10 | √ | null | ||
dc | deployment_latitude | numeric | 131089 | √ | null | ||
dc | deployment_longitude | numeric | 131089 | √ | null | ||
dc | genus | text | 2147483647 | √ | null | ||
dc | local_deployment_name | text | 2147483647 | √ | null | ||
dc | principal_investigator_email | text | 2147483647 | √ | null | ||
dc | species | text | 2147483647 | √ | null | ||
dc | species_code | int4 | 10 | √ | null | ||
dc | species_year_serial | int4 | 10 | √ | null | ||
dc | userid | int4 | 10 | √ | null | ||
dcs | animal_name | text | 2147483647 | √ | null | ||
dcs | data_wrangler_email | text | 2147483647 | √ | null | ||
dcs | deployment_date | timestamptz | 35,6 | √ | null | ||
dcs | deployment_id | int4 | 10 | √ | null | ||
dcs | deployment_latitude | numeric | 131089 | √ | null | ||
dcs | deployment_longitude | numeric | 131089 | √ | null | ||
dcs | genus | text | 2147483647 | √ | null | ||
dcs | local_deployment_name | text | 2147483647 | √ | null | ||
dcs | principal_investigator_email | text | 2147483647 | √ | null | ||
dcs | species | text | 2147483647 | √ | null | ||
dcs | species_code | int4 | 10 | √ | null | ||
dcs | species_year_serial | int4 | 10 | √ | null | ||
dcs | userid | int4 | 10 | √ | null | ||
deleteme | cl.nn | text | 2147483647 | √ | null | ||
deleteme | default_location_process | bool | 1 | √ | null | ||
deleteme | deploy_id | int4 | 10 | √ | null | ||
deleteme | fastloc | int4 | 10 | √ | null | ||
deleteme | first_uplink_date | timestamptz | 35,6 | √ | null | ||
deleteme | last_location.latitude | float8 | 17,17 | √ | null | ||
deleteme | last_location.location_date | timestamptz | 35,6 | √ | null | ||
deleteme | last_location.longitude | float8 | 17,17 | √ | null | ||
deleteme | last_update_date | timestamptz | 35,6 | √ | null | ||
deleteme | last_uplink_date | timestamptz | 35,6 | √ | null | ||
deleteme | local.tag.id | text | 2147483647 | √ | null | ||
deleteme | owner | text | 2147483647 | √ | null | ||
deleteme | program_number | int4 | 10 | √ | null | ||
deleteme | ptt_decimal | int4 | 10 | √ | null | ||
deleteme | row.names | text | 2147483647 | √ | null | ||
deleteme | serial_number | text | 2147483647 | √ | null | ||
deleteme | source | text | 2147483647 | √ | null | ||
deleteme | species | text | 2147483647 | √ | null | ||
deleteme | status | text | 2147483647 | √ | null | ||
deleteme | tag_type | text | 2147483647 | √ | null | ||
deleteme | wc_id | text | 2147483647 | √ | null | ||
e | animal_name | text | 2147483647 | √ | null | ||
e | atn_name | text | 2147483647 | √ | null | ||
e | atn_replaced | int4 | 10 | √ | null | ||
e | column_name | text | 2147483647 | √ | null | ||
e | comments | text | 2147483647 | √ | null | ||
e | contact | text | 2147483647 | √ | null | ||
e | deployment_date | timestamp | 29,6 | √ | null | ||
e | embargolat | float4 | 8,8 | √ | null | ||
e | embargolon | float4 | 8,8 | √ | null | ||
e | embargountil | date | 13 | √ | null | ||
e | eventid | int4 | 10 | √ | null | ||
e | local_deployment_name | text | 2147483647 | √ | null | ||
e | multi_tag_serial | int4 | 10 | √ | null | ||
e | ownerid | int4 | 10 | √ | null | ||
e | plot_points | int4 | 10 | √ | null | ||
e | priority | int4 | 10 | √ | null | ||
e | ptt | int4 | 10 | √ | null | ||
e | rerun | int4 | 10 | √ | null | ||
e | species_code | int4 | 10 | √ | null | ||
e | species_year_serial | int4 | 10 | √ | null | ||
e | ssm_tr | int4 | 10 | √ | null | ||
e | table_name | text | 2147483647 | √ | null | ||
e | table_schema | text | 2147483647 | √ | null | ||
e | tag_description | text | 2147483647 | √ | null | ||
e | tag_model | text | 2147483647 | √ | null | ||
e | toppid | int4 | 10 | √ | null | ||
e | two_digit_year | int4 | 10 | √ | null | ||
e | vis_filter | int4 | 10 | √ | null | ||
e | vis_prob | int4 | 10 | √ | null | ||
e | wc_id | text | 2147483647 | √ | null | ||
eseal | eventid | int4 | 10 | √ | null | ||
f | x | int4 | 10 | √ | null | ||
f | y | int4 | 10 | √ | null | ||
foo | atn_replaced | int4 | 10 | √ | null | ||
foo | comments | text | 2147483647 | √ | null | ||
foo | contact | text | 2147483647 | √ | null | ||
foo | embargolat | float4 | 8,8 | √ | null | ||
foo | embargolon | float4 | 8,8 | √ | null | ||
foo | embargountil | date | 13 | √ | null | ||
foo | eventid | int4 | 10 | √ | null | ||
foo | plot_dashes | int4 | 10 | √ | null | ||
foo | plot_points | int4 | 10 | √ | null | ||
foo | priority | int4 | 10 | √ | null | ||
foo | ptt | int4 | 10 | √ | null | ||
foo | rerun | int4 | 10 | √ | null | ||
foo | ssm_tr | int4 | 10 | √ | null | ||
foo | tkey | int4 | 10 | √ | null | ||
foo | toppid | int4 | 10 | √ | null | ||
foo | vis_filter | int4 | 10 | √ | null | ||
foo | vis_prob | int4 | 10 | √ | null | ||
g | x | int4 | 10 | √ | null | ||
h | x | int4 | 10 | √ | null | ||
hits | t | int4 | 10 | √ | null | ||
id | eventid | int4 | 10 | √ | null | ||
input | id | int4 | 10 | √ | null | ||
input | ptt | int4 | 10 | √ | null | ||
input | t | timestamp | 29,6 | √ | null | ||
lackys | table_name | "information_schema"."sql_identifier" | 2147483647 | √ | null | ||
main | id | serial | 10 | √ | nextval('junk.main_id_seq'::regclass) | ||
main | ptt | int4 | 10 | √ | null | ||
main | t | timestamp | 29,6 | √ | null | ||
match_rows | id | int4 | 10 | √ | null | ||
match_rows | ptt | int4 | 10 | √ | null | ||
match_rows | t | timestamp | 29,6 | √ | null | ||
metadata | animal_name | bool | 1 | √ | 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 | principal_investigator_email | text | 2147483647 | √ | null | ||
metadata | ptt | float8 | 17,17 | √ | 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 | ||
misc | eventid | int4 | 10 | √ | null | ||
now_and_them | now | timestamp | 29,6 | √ | null | ||
now_and_them | them | timestamptz | 35,6 | √ | null | ||
sample | atn_replaced | int4 | 10 | √ | null | ||
sample | comments | text | 2147483647 | √ | null | ||
sample | contact | text | 2147483647 | √ | null | ||
sample | embargolat | float4 | 8,8 | √ | null | ||
sample | embargolon | float4 | 8,8 | √ | null | ||
sample | embargountil | date | 13 | √ | null | ||
sample | plot_dashes | int4 | 10 | √ | null | ||
sample | plot_points | int4 | 10 | √ | null | ||
sample | priority | int4 | 10 | √ | null | ||
sample | rerun | int4 | 10 | √ | null | ||
sample | ssm_tr | int4 | 10 | √ | null | ||
sample | vis_prob | int4 | 10 | √ | null | ||
satdeployments_bak | actualpopupdate | date | 13 | √ | null | ||
satdeployments_bak | comment | text | 2147483647 | √ | null | ||
satdeployments_bak | contact | text | 2147483647 | √ | null | ||
satdeployments_bak | enddate | date | 13 | √ | null | ||
satdeployments_bak | endtime | time | 15,6 | √ | null | ||
satdeployments_bak | est_end_date | date | 13 | √ | null | ||
satdeployments_bak | eventid | int4 | 10 | √ | null | ||
satdeployments_bak | las | text | 2147483647 | √ | null | ||
satdeployments_bak | modelname | text | 2147483647 | √ | null | ||
satdeployments_bak | owner | text | 2147483647 | √ | null | ||
satdeployments_bak | projectname | text | 2147483647 | √ | null | ||
satdeployments_bak | pttnumber | int4 | 10 | √ | null | ||
satdeployments_bak | satdeploymentid | int4 | 10 | √ | null | ||
satdeployments_bak | speciesname | text | 2147483647 | √ | null | ||
satdeployments_bak | startdate | date | 13 | √ | null | ||
satdeployments_bak | starttime | time | 15,6 | √ | null | ||
satdeployments_bak | tagcode | varchar | 50 | √ | null | ||
satdeployments_bak | tagnumber | text | 2147483647 | √ | null | ||
satdeployments_bak | testingnote | text | 2147483647 | √ | null | ||
satdeployments_bak | toppid | text | 2147483647 | √ | null | ||
satdeployments_test | actualpopupdate | date | 13 | √ | null | ||
satdeployments_test | comment | text | 2147483647 | √ | null | ||
satdeployments_test | contact | text | 2147483647 | √ | null | ||
satdeployments_test | enddate | date | 13 | √ | null | ||
satdeployments_test | endtime | time | 15,6 | √ | null | ||
satdeployments_test | est_end_date | date | 13 | √ | null | ||
satdeployments_test | eventid | int4 | 10 | √ | null | ||
satdeployments_test | las | text | 2147483647 | √ | null | ||
satdeployments_test | modelname | text | 2147483647 | √ | null | ||
satdeployments_test | owner | text | 2147483647 | √ | null | ||
satdeployments_test | projectname | text | 2147483647 | √ | null | ||
satdeployments_test | ptt | int4 | 10 | √ | null | ||
satdeployments_test | pttnumber | int4 | 10 | √ | null | ||
satdeployments_test | satdeploymentid | int4 | 10 | √ | null | ||
satdeployments_test | speciesname | text | 2147483647 | √ | null | ||
satdeployments_test | startdate | date | 13 | √ | null | ||
satdeployments_test | starttime | time | 15,6 | √ | null | ||
satdeployments_test | t | timestamp | 29,6 | √ | null | ||
satdeployments_test | tagcode | varchar | 50 | √ | null | ||
satdeployments_test | tagnumber | text | 2147483647 | √ | null | ||
satdeployments_test | testingnote | text | 2147483647 | √ | null | ||
satdeployments_test | toppid | text | 2147483647 | √ | null | ||
saved_eseal_atn_track_qc | atn_replaced | int4 | 10 | √ | null | ||
saved_eseal_atn_track_qc | comments | text | 2147483647 | √ | null | ||
saved_eseal_atn_track_qc | contact | text | 2147483647 | √ | null | ||
saved_eseal_atn_track_qc | embargolat | float4 | 8,8 | √ | null | ||
saved_eseal_atn_track_qc | embargolon | float4 | 8,8 | √ | null | ||
saved_eseal_atn_track_qc | embargountil | date | 13 | √ | null | ||
saved_eseal_atn_track_qc | eventid | int4 | 10 | √ | null | ||
saved_eseal_atn_track_qc | plot_dashes | int4 | 10 | √ | null | ||
saved_eseal_atn_track_qc | plot_points | int4 | 10 | √ | null | ||
saved_eseal_atn_track_qc | priority | int4 | 10 | √ | null | ||
saved_eseal_atn_track_qc | ptt | int4 | 10 | √ | null | ||
saved_eseal_atn_track_qc | rerun | int4 | 10 | √ | null | ||
saved_eseal_atn_track_qc | ssm_tr | int4 | 10 | √ | null | ||
saved_eseal_atn_track_qc | tkey | int4 | 10 | √ | null | ||
saved_eseal_atn_track_qc | toppid | int4 | 10 | √ | null | ||
saved_eseal_atn_track_qc | vis_filter | int4 | 10 | √ | null | ||
saved_eseal_atn_track_qc | vis_prob | int4 | 10 | √ | null | ||
sd | actualpopupdate | date | 13 | √ | null | ||
sd | comment | text | 2147483647 | √ | null | ||
sd | contact | text | 2147483647 | √ | null | ||
sd | enddate | date | 13 | √ | null | ||
sd | endtime | time | 15,6 | √ | null | ||
sd | est_end_date | date | 13 | √ | null | ||
sd | eventid | int4 | 10 | √ | null | ||
sd | las | text | 2147483647 | √ | null | ||
sd | modelname | text | 2147483647 | √ | null | ||
sd | owner | text | 2147483647 | √ | null | ||
sd | projectname | text | 2147483647 | √ | null | ||
sd | pttnumber | int4 | 10 | √ | null | ||
sd | satdeploymentid | int4 | 10 | √ | null | ||
sd | speciesname | text | 2147483647 | √ | null | ||
sd | startdate | date | 13 | √ | null | ||
sd | starttime | time | 15,6 | √ | null | ||
sd | tagcode | varchar | 50 | √ | null | ||
sd | tagnumber | text | 2147483647 | √ | null | ||
sd | testingnote | text | 2147483647 | √ | null | ||
sd | toppid | text | 2147483647 | √ | null | ||
sd_changes | actualpopupdate | date | 13 | √ | null | ||
sd_changes | comment | text | 2147483647 | √ | null | ||
sd_changes | contact | text | 2147483647 | √ | null | ||
sd_changes | enddate | date | 13 | √ | null | ||
sd_changes | endtime | time | 15,6 | √ | null | ||
sd_changes | est_end_date | date | 13 | √ | null | ||
sd_changes | eventid | int4 | 10 | √ | null | ||
sd_changes | las | text | 2147483647 | √ | null | ||
sd_changes | modelname | text | 2147483647 | √ | null | ||
sd_changes | owner | text | 2147483647 | √ | null | ||
sd_changes | projectname | text | 2147483647 | √ | null | ||
sd_changes | pttnumber | int4 | 10 | √ | null | ||
sd_changes | satdeploymentid | int4 | 10 | √ | null | ||
sd_changes | speciesname | text | 2147483647 | √ | null | ||
sd_changes | startdate | date | 13 | √ | null | ||
sd_changes | starttime | time | 15,6 | √ | null | ||
sd_changes | tagcode | varchar | 50 | √ | null | ||
sd_changes | tagnumber | text | 2147483647 | √ | null | ||
sd_changes | testingnote | text | 2147483647 | √ | null | ||
sd_changes | toppid | text | 2147483647 | √ | null | ||
ssmupdates_bak | active | int4 | 10 | √ | null | ||
ssmupdates_bak | commenthms | text | 2147483647 | √ | null | ||
ssmupdates_bak | commentnoaa | text | 2147483647 | √ | null | ||
ssmupdates_bak | delete | int4 | 10 | √ | null | ||
ssmupdates_bak | eventid | int4 | 10 | √ | null | ||
ssmupdates_bak | moddate | timestamp | 29,6 | √ | null | ||
ssmupdates_bak | public | int4 | 10 | √ | null | ||
starts | id | int4 | 10 | √ | null | ||
starts | t | int4 | 10 | √ | null | ||
tables | column_name | "information_schema"."sql_identifier" | 2147483647 | √ | null | ||
tables | table_name | "information_schema"."sql_identifier" | 2147483647 | √ | null | ||
tables | table_schema | "information_schema"."sql_identifier" | 2147483647 | √ | null | ||
target_ptt | pttnumber | int4 | 10 | √ | null | ||
targets | eventid | int4 | 10 | √ | null | ||
td | a | timestamptz | 35,6 | √ | null | ||
td | row.names | text | 2147483647 | √ | null | ||
test | atn_replaced | int4 | 10 | √ | null | ||
test | comments | text | 2147483647 | √ | null | ||
test | contact | text | 2147483647 | √ | null | ||
test | embargolat | float4 | 8,8 | √ | null | ||
test | embargolon | float4 | 8,8 | √ | null | ||
test | embargountil | date | 13 | √ | null | ||
test | eventid | int4 | 10 | √ | null | ||
test | plot_dashes | int4 | 10 | √ | null | ||
test | plot_points | int4 | 10 | √ | null | ||
test | priority | int4 | 10 | √ | null | ||
test | ptt | int4 | 10 | √ | null | ||
test | rerun | int4 | 10 | √ | null | ||
test | ssm_tr | int4 | 10 | √ | null | ||
test | tkey | int4 | 10 | √ | null | ||
test | toppid | int4 | 10 | √ | null | ||
test | vis_filter | int4 | 10 | √ | null | ||
test | vis_prob | int4 | 10 | √ | null | ||
test_df | last_location.latitude | float8 | 17,17 | √ | null | ||
test_df | last_update_date | timestamptz | 35,6 | √ | null | ||
test_df | row.names | text | 2147483647 | √ | null | ||
testdata | a | timestamptz | 35,6 | √ | null | ||
testdata | b | timestamptz | 35,6 | √ | null | ||
testdata | row.names | text | 2147483647 | √ | null | ||
testdata2 | a | timestamptz | 35,6 | √ | null | ||
testdata2 | b | timestamptz | 35,6 | √ | null | ||
testdata2 | row.names | text | 2147483647 | √ | null | ||
tmp | abbrev | text | 2147483647 | √ | null | ||
tmp | comments | text | 2147483647 | √ | null | ||
tmp | commercial | int4 | 10 | √ | null | ||
tmp | commonname | text | 2147483647 | √ | null | ||
tmp | contact | text | 2147483647 | √ | null | ||
tmp | filter | text | 2147483647 | √ | null | ||
tmp | genus | text | 2147483647 | √ | null | ||
tmp | lsdname | text | 2147483647 | √ | null | ||
tmp | pagename | text | 2147483647 | √ | null | ||
tmp | project | int4 | 10 | √ | null | ||
tmp | species | text | 2147483647 | √ | null | ||
tmp | speciescode | int4 | 10 | √ | null | ||
tmp | taxon | text | 2147483647 | √ | null | ||
tmp | workgroup | text | 2147483647 | √ | null | ||
turtle | abbrev | text | 2147483647 | √ | null | ||
turtle | comments | text | 2147483647 | √ | null | ||
turtle | commercial | int4 | 10 | √ | null | ||
turtle | commonname | text | 2147483647 | √ | null | ||
turtle | contact | text | 2147483647 | √ | null | ||
turtle | filter | text | 2147483647 | √ | null | ||
turtle | genus | text | 2147483647 | √ | null | ||
turtle | lsdname | text | 2147483647 | √ | null | ||
turtle | pagename | text | 2147483647 | √ | null | ||
turtle | project | int4 | 10 | √ | null | ||
turtle | species | text | 2147483647 | √ | null | ||
turtle | speciescode | int4 | 10 | √ | null | ||
turtle | taxon | text | 2147483647 | √ | null | ||
turtle | workgroup | text | 2147483647 | √ | null | ||
ut | deployment_date | timestamp | 29,6 | √ | null | ||
ut | pttnumber | int4 | 10 | √ | null | ||
wc_whitesharks | eventid | int4 | 10 | √ | null | ||
wc_whitesharks | wc_id | text | 2147483647 | √ | null | ||
whaleshark | atn_replaced | int4 | 10 | √ | null | ||
whaleshark | comments | text | 2147483647 | √ | null | ||
whaleshark | contact | text | 2147483647 | √ | null | ||
whaleshark | embargolat | float4 | 8,8 | √ | null | ||
whaleshark | embargolon | float4 | 8,8 | √ | null | ||
whaleshark | embargountil | date | 13 | √ | null | ||
whaleshark | eventid | int4 | 10 | √ | null | ||
whaleshark | plot_dashes | int4 | 10 | √ | null | ||
whaleshark | plot_points | int4 | 10 | √ | null | ||
whaleshark | priority | int4 | 10 | √ | null | ||
whaleshark | ptt | int4 | 10 | √ | null | ||
whaleshark | rerun | int4 | 10 | √ | null | ||
whaleshark | ssm_tr | int4 | 10 | √ | null | ||
whaleshark | toppid | int4 | 10 | √ | null | ||
whaleshark | vis_filter | int4 | 10 | √ | null | ||
whaleshark | vis_prob | int4 | 10 | √ | null | ||
whiteshark | actpopdate | text | 2147483647 | √ | null | ||
whiteshark | angler | text | 2147483647 | √ | null | ||
whiteshark | animal_id | int4 | 10 | √ | null | ||
whiteshark | argosaccno | text | 2147483647 | √ | null | ||
whiteshark | baittype | text | 2147483647 | √ | null | ||
whiteshark | bertarelli_name | text | 2147483647 | √ | null | ||
whiteshark | claspers | text | 2147483647 | √ | null | ||
whiteshark | commonname | text | 2147483647 | √ | null | ||
whiteshark | contag1number | text | 2147483647 | √ | null | ||
whiteshark | contag1position | text | 2147483647 | √ | null | ||
whiteshark | contag1type | text | 2147483647 | √ | null | ||
whiteshark | contag2number | text | 2147483647 | √ | null | ||
whiteshark | contag2position | text | 2147483647 | √ | null | ||
whiteshark | contag2type | text | 2147483647 | √ | null | ||
whiteshark | correctedsst | text | 2147483647 | √ | null | ||
whiteshark | darttype | text | 2147483647 | √ | null | ||
whiteshark | deploycomment | text | 2147483647 | √ | null | ||
whiteshark | dlatdd | float8 | 17,17 | √ | null | ||
whiteshark | dlatdeg | text | 2147483647 | √ | null | ||
whiteshark | dlatmin | text | 2147483647 | √ | null | ||
whiteshark | dlondd | float8 | 17,17 | √ | null | ||
whiteshark | dlondeg | text | 2147483647 | √ | null | ||
whiteshark | dlonmin | text | 2147483647 | √ | null | ||
whiteshark | dnanumber | text | 2147483647 | √ | null | ||
whiteshark | dnasamplelocation | text | 2147483647 | √ | null | ||
whiteshark | ease2boat | text | 2147483647 | √ | null | ||
whiteshark | edna | text | 2147483647 | √ | null | ||
whiteshark | ew | text | 2147483647 | √ | null | ||
whiteshark | famename | text | 2147483647 | √ | null | ||
whiteshark | fighttime | text | 2147483647 | √ | null | ||
whiteshark | fin_id | text | 2147483647 | √ | null | ||
whiteshark | fishingdepth | text | 2147483647 | √ | null | ||
whiteshark | fishmethod | text | 2147483647 | √ | null | ||
whiteshark | gpsused | text | 2147483647 | √ | null | ||
whiteshark | halfgirth | text | 2147483647 | √ | null | ||
whiteshark | handlingcomments | text | 2147483647 | √ | null | ||
whiteshark | handlingtime | text | 2147483647 | √ | null | ||
whiteshark | hooktype | text | 2147483647 | √ | null | ||
whiteshark | injuries | text | 2147483647 | √ | null | ||
whiteshark | irrigation | text | 2147483647 | √ | null | ||
whiteshark | leaderlength | text | 2147483647 | √ | null | ||
whiteshark | leadertest | text | 2147483647 | √ | null | ||
whiteshark | leadertype | text | 2147483647 | √ | null | ||
whiteshark | leadtagger | text | 2147483647 | √ | null | ||
whiteshark | len1 | text | 2147483647 | √ | null | ||
whiteshark | len1type | text | 2147483647 | √ | null | ||
whiteshark | len2 | text | 2147483647 | √ | null | ||
whiteshark | len2type | text | 2147483647 | √ | null | ||
whiteshark | len3 | text | 2147483647 | √ | null | ||
whiteshark | len3type | text | 2147483647 | √ | null | ||
whiteshark | linetest | text | 2147483647 | √ | null | ||
whiteshark | loopnum | text | 2147483647 | √ | null | ||
whiteshark | loopposition | text | 2147483647 | √ | null | ||
whiteshark | loops | text | 2147483647 | √ | null | ||
whiteshark | masskg | text | 2147483647 | √ | null | ||
whiteshark | masstype | text | 2147483647 | √ | null | ||
whiteshark | nickname | text | 2147483647 | √ | null | ||
whiteshark | ns | text | 2147483647 | √ | null | ||
whiteshark | numberhooks | text | 2147483647 | √ | null | ||
whiteshark | paint | text | 2147483647 | √ | null | ||
whiteshark | penetrationdepth | text | 2147483647 | √ | null | ||
whiteshark | popup_comment | text | 2147483647 | √ | null | ||
whiteshark | prboattack | text | 2147483647 | √ | null | ||
whiteshark | probe | text | 2147483647 | √ | null | ||
whiteshark | progdate | text | 2147483647 | √ | null | ||
whiteshark | progpopdate | text | 2147483647 | √ | null | ||
whiteshark | project | text | 2147483647 | √ | null | ||
whiteshark | psatleadernumber | text | 2147483647 | √ | null | ||
whiteshark | ptt | int4 | 10 | √ | null | ||
whiteshark | pulltime | text | 2147483647 | √ | null | ||
whiteshark | releasecomment | text | 2147483647 | √ | null | ||
whiteshark | releasedevice | text | 2147483647 | √ | null | ||
whiteshark | seastate | text | 2147483647 | √ | null | ||
whiteshark | seriesname | text | 2147483647 | √ | null | ||
whiteshark | setnumber | text | 2147483647 | √ | null | ||
whiteshark | setstarttime | text | 2147483647 | √ | null | ||
whiteshark | settime | text | 2147483647 | √ | null | ||
whiteshark | sex | text | 2147483647 | √ | null | ||
whiteshark | sexmaturity | text | 2147483647 | √ | null | ||
whiteshark | sgdepkey | int4 | 10 | √ | null | ||
whiteshark | sharkapp | text | 2147483647 | √ | null | ||
whiteshark | species | text | 2147483647 | √ | null | ||
whiteshark | sst | text | 2147483647 | √ | null | ||
whiteshark | stableiso_num | text | 2147483647 | √ | null | ||
whiteshark | tag1side | text | 2147483647 | √ | null | ||
whiteshark | tag2code | text | 2147483647 | √ | null | ||
whiteshark | tag2progdate | text | 2147483647 | √ | null | ||
whiteshark | tag2ptt | text | 2147483647 | √ | null | ||
whiteshark | tag2side | text | 2147483647 | √ | null | ||
whiteshark | tagapplocation | text | 2147483647 | √ | null | ||
whiteshark | tagcode | text | 2147483647 | √ | null | ||
whiteshark | tageventcomment | text | 2147483647 | √ | null | ||
whiteshark | taggingdate | text | 2147483647 | √ | null | ||
whiteshark | taggingtime | text | 2147483647 | √ | null | ||
whiteshark | taggingvessel | text | 2147483647 | √ | null | ||
whiteshark | tagnumber | text | 2147483647 | √ | null | ||
whiteshark | tagposition | text | 2147483647 | √ | null | ||
whiteshark | tagteam | text | 2147483647 | √ | null | ||
whiteshark | tagtype | text | 2147483647 | √ | null | ||
whiteshark | toppid | int4 | 10 | √ | null | ||
whiteshark | transfercaptain | text | 2147483647 | √ | null | ||
whiteshark | waterdepth | text | 2147483647 | √ | null | ||
whiteshark | wc_id | text | 2147483647 | √ | null | ||
whiteshark | weather | text | 2147483647 | √ | null |