SchemaSpy - Table topp.public.tblshark

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column	Type	Size	Nulls	Auto	Default
tkey	serial	10		√	nextval('tblshark_sighting_tkey_seq'::regclass)
animal_id	int4	10	√		null
old_id	text	2147483647	√		null
fin_id	text	2147483647	√		null
nickname	text	2147483647	√		null
date	text	2147483647	√		null
time	text	2147483647	√		null
depth	text	2147483647	√		null
lat	text	2147483647	√		null
long	text	2147483647	√		null
length_ft	text	2147483647	√		null
length_m	text	2147483647	√		null
sex	text	2147483647	√		null
picture	text	2147483647	√		null
video	text	2147483647	√		null
stomach	text	2147483647	√		null
external	text	2147483647	√		null
pat	text	2147483647	√		null
visual	text	2147483647	√		null
biopsy	text	2147483647	√		null
location	text	2147483647	√		null
notes	text	2147483647	√		null

Table contained 1,329 rows at Wed Dec 27 13:25 PST 2017

Indexes:

Column(s)	Type	Sort	Constraint Name
tkey	Primary key	Asc	tblshark_sighting_pkey