SchemaSpy Analysis of topp.wc - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Wed Dec 27 13:27 PST 2017
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

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