Table zfindb.informix.author 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
author_pk_id serial8 19  √ 
author_publication.authorpub_author_id authorpub_author_id_fk R
person_author.persauth_author_id persauth_author_id_fk R
author_first_name varchar 100  √  null
author_last_name varchar 100  √  null
author_institution lvarchar 255  √  null

Table contained 0 rows at Tue Nov 10 13:18 PST 2015

Indexes:
Column(s) Type Sort Constraint Name Anomalies
author_institution + author_first_name + author_last_name + author_institution Must be unique Asc/Asc/Asc/Asc author_ak_index These unique columns are also nullable
author_institution + author_pk_id Must be unique Asc/Asc author_pk_id_index  

Close relationships  within of separation: