Table erigrid.public.organization 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
org_id serial 10  √  nextval('organization_org_id_seq'::regclass)
research_infrastructure.org_id research_infrastructure_org_id_fkey R
orgname varchar 2147483647  √  null

Analyzed at Thu Apr 27 16:49 EEST 2017

Indexes:
Column(s) Type Sort Constraint Name Anomalies
org_id Primary key Asc organization_pkey  
orgname Must be unique Asc organization_orgname_key This unique column is also nullable

Close relationships  within of separation: