Table topp.deprecated.tbltgsmrudive 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
ckey serial 10  √  nextval('deprecated.tbltgsmrudive_ckey_seq'::regclass)
tbltgsmrucruise.ckey Implied Constraint R
tgdivekey text 2147483647  √  null
reff text 2147483647  √  null
ptt text 2147483647  √  null
ovf text 2147483647  √  null
cnt text 2147483647  √  null
tx_date text 2147483647  √  null
de_date text 2147483647  √  null
surf_dur text 2147483647  √  null
dive_dur text 2147483647  √  null
n_surf_dur text 2147483647  √  null
dep_off text 2147483647  √  null
max_dep text 2147483647  √  null
d1 text 2147483647  √  null
d2 text 2147483647  √  null
d3 text 2147483647  √  null
d4 text 2147483647  √  null
d5 text 2147483647  √  null
v1 text 2147483647  √  null
v2 text 2147483647  √  null
v3 text 2147483647  √  null
v4 text 2147483647  √  null
v5 text 2147483647  √  null
d_dist text 2147483647  √  null
lat text 2147483647  √  null
lon text 2147483647  √  null
travel_r text 2147483647  √  null
homedist text 2147483647  √  null
start_lat text 2147483647  √  null
start_lon text 2147483647  √  null
bottom text 2147483647  √  null
t1 text 2147483647  √  null
t2 text 2147483647  √  null
t3 text 2147483647  √  null
t4 text 2147483647  √  null
t5 text 2147483647  √  null
d_speed text 2147483647  √  null
n_depths text 2147483647  √  null
n_speeds text 2147483647  √  null
depth_str text 2147483647  √  null
speed_str text 2147483647  √  null
propn_str text 2147483647  √  null
percent_area text 2147483647  √  null
sunalt text 2147483647  √  null
sunrise text 2147483647  √  null
sunset text 2147483647  √  null
residual text 2147483647  √  null
grp_number text 2147483647  √  null
uplink_number text 2147483647  √  null

Table contained 117,912 rows at Wed Dec 27 13:21 PST 2017

Indexes:
Column(s) Type Sort Constraint Name
ckey Primary key Asc tbltgsmrudive_pkey

Close relationships: