Table zfindb.public.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 bigserial 19  √  nextval('author_author_pk_id_seq'::regclass)
author_publication.authorpub_author_id authorpub_author_id_fk R
person_author.persauth_author_id persauth_author_id_fk R
author_first_name text 2147483647  √  null
author_last_name text 2147483647  √  null
author_institution text 2147483647  √  null

Table contained 0 rows at Mon Sep 03 04:09 PDT 2018

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

Close relationships  within of separation: