SchemaSpy - View topp.public.aec

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column	Type	Size	Nulls	Default
encounterid	int4	10	√	null
toppid	varchar	20	√	null
speciescode	varchar	2	√	null
animalid	varchar	40	√	null
gender	varchar	20	√	null
identifyingfeatures	varchar	255	√	null
nickname	varchar	40	√	null
red	int4	10	√	null
green	int4	10	√	null
blue	int4	10	√	null
speciesname	varchar	80	√	null
genus	varchar	80	√	null
species	varchar	80	√	null
taxongroup	varchar	80	√	null
workinggroup	varchar	80	√	null
abreviation	varchar	20	√	null
concatname	text	2147483647	√	null
projectid	int4	10	√	null
name	varchar	80	√	null
casecomment	text	2147483647	√	null
ownerid	int4	10	√	null
contactid	int4	10	√	null
provisional	bool	1	√	null
tripid	int4	10	√	null
conditionsid	int4	10	√	null
locationid	int4	10	√	null
encountertypeid	int4	10	√	null
agentid	int4	10	√	null
datetime	timestamptz	35,6	√	null
encountercomment	text	2147483647	√	null
handlingtime	time	15,6	√	null
masskg	float4	8,8	√	null
masstypeid	int4	10	√	null
lengthcm	float4	8,8	√	null
lengthtypeid	int4	10	√	null
annimalcondition	text	2147483647	√	null
injuries	varchar	255	√	null
distinguishingfeaturess	varchar	255	√	null
dnasampled	bool	1	√	null

Analyzed at Wed Dec 27 13:25 PST 2017