Table topp.public.acoustic_vr4pos
Simple table containing positions from "sbd_pos.csv" files for VR4G receivers.

 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
tkey serial 10  √  nextval('acoustic_vr4pos_tkey_seq'::regclass)
receiver int4 10  √  null
datetime timestamp 29,6  √  null
longitude float8 17,17  √  null
latitude float8 17,17  √  null
err_rad_km float8 17,17  √  null

Table contained 16,528 rows at Wed Dec 27 13:25 PST 2017

Indexes:
Column(s) Type Sort Constraint Name Anomalies
tkey Primary key Asc acoustic_vr4pos_pkey  
receiver + datetime Must be unique Asc/Asc acoustic_vr4pos_receiver_datetime_key These unique columns are also nullable