Table topp.wc2.deployment Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
wc_id text 2147483647  √  null
owner text 2147483647  √  null
status text 2147483647  √  null
last_update_date text 2147483647  √  null
last_location_latitude float8 17,17  √  null
last_location_longitude float8 17,17  √  null
last_location_location_date text 2147483647  √  null
tag_type text 2147483647  √  null
serial_number text 2147483647  √  null
program_number int4 10  √  null
ptt_decimal int4 10  √  null
first_uplink_date text 2147483647  √  null
last_uplink_date text 2147483647  √  null
source text 2147483647  √  null
deploy_id text 2147483647  √  null
species text 2147483647  √  null
tagtype text 2147483647  √  null
locality text 2147483647  √  null
fastloc int4 10  √  null
local_tag.id text 2147483647  √  null
cl_nn text 2147483647  √  null
default_location_process bool 1  √  null

Table contained 40 rows at Wed Dec 27 13:28 PST 2017