Table topp.atn.deployment 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
deployment_id serial 10  √  nextval('atn.deployment_deployment_id_seq'::regclass)
deployment_bak.deployment_id Implied Constraint R
event.deployment_id event_deployment_id R
species_code int4 10  √  null
species_year_serial int4 10  √  null
animal_name text 2147483647  √  null
deployment_date timestamptz 35,6  √  null
local_deployment_name text 2147483647  √  null
genus text 2147483647  √  null
species text 2147483647  √  null
principal_investigator_email text 2147483647  √  null
data_wrangler_email text 2147483647  √  null
deployment_longitude numeric 131089  √  null
deployment_latitude numeric 131089  √  null
userid int4 10  √  null
toppid int4 10  √  null

Table contained 78 rows at Wed Dec 27 13:21 PST 2017

Indexes:
Column(s) Type Sort Constraint Name Anomalies
deployment_id Primary key Asc deployment_pkey  
local_deployment_name + userid Must be unique Asc/Asc constraint_unique These unique columns are also nullable

Close relationships: