Table topp.public.new_deployment_row 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
id text 2147483647  √  null
owner text 2147483647  √  null
status text 2147483647  √  null
last_update_date int4 10  √  null
tag.tag_type text 2147483647  √  null
tag.serial_number text 2147483647  √  null
argos.program_number int4 10  √  null
argos.ptt_decimal int4 10  √  null
argos.first_uplink_date int4 10  √  null
argos.last_uplink_date int4 10  √  null
last_location.latitude float8 17,17  √  null
last_location.longitude float8 17,17  √  null
last_location.location_date int4 10  √  null
sources.source text 2147483647  √  null
wc_id text 2147483647  √  null
two_digit_year text 2147483647  √  null
taggingdate text 2147483647  √  null
actpopdate text 2147483647  √  null
contact text 2147483647  √  null
speciescode int4 10  √  null
personname text 2147483647  √  null
SSYY float8 17,17  √  null
group_serial int4 10  √  null
group_max_toppid int4 10  √  null
seriesname text 2147483647  √  null
ptt int4 10  √  null
group_base_toppid float8 17,17  √  null
group_offset_toppid float8 17,17  √  null
toppid int4 10  √  null
sgdepkey int4 10  √  null
eventid float8 17,17  √  null

Table contained 4 rows at Wed Dec 27 13:25 PST 2017