SchemaSpy - Table topp.deprecated.tbltgsmrusummary

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column	Type	Size	Nulls	Auto	Default
skey	serial	10		√	nextval('deprecated.tbltgsmrusummary_skey_seq'::regclass)
tgsumkey	text	2147483647	√		null
reff	text	2147483647	√		null
ptt	text	2147483647	√		null
cnt	text	2147483647	√		null
checksum	text	2147483647	√		null
tx_date	text	2147483647	√		null
s_date	text	2147483647	√		null
m_date	text	2147483647	√		null
e_date	text	2147483647	√		null
surf_dist	text	2147483647	√		null
div_dist	text	2147483647	√		null
dive_tm	text	2147483647	√		null
surf_tm	text	2147483647	√		null
haul_tm	text	2147483647	√		null
max_vel	text	2147483647	√		null
n_hauls	text	2147483647	√		null
n_cycles	text	2147483647	√		null
av_depth	text	2147483647	√		null
max_depth	text	2147483647	√		null
surf_dry	text	2147483647	√		null
ovf	text	2147483647	√		null
cruise_tm	text	2147483647	√		null
avg_sst	text	2147483647	√		null
avg_speed	text	2147483647	√		null
sd_depth	text	2147483647	√		null
av_dur	text	2147483647	√		null
sd_dur	text	2147483647	√		null
max_dur	text	2147483647	√		null
dp_n_cycles	text	2147483647	√		null
dp_av_depth	text	2147483647	√		null
dp_max_depth	text	2147483647	√		null
dp_avg_speed	text	2147483647	√		null
dp_sd_depth	text	2147483647	√		null
dp_av_dur	text	2147483647	√		null
dp_sd_dur	text	2147483647	√		null
dp_max_dur	text	2147483647	√		null
dp_dive_tm	text	2147483647	√		null

Table contained 17,388 rows at Wed Dec 27 13:21 PST 2017

Indexes:

Column(s)	Type	Sort	Constraint Name
skey	Primary key	Asc	tbltgsmrusummary_pkey