person

5359 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
person_num serial 10 √ nextval('person_person_num_seq'::regclass)
affiliation.person_num fk_affiliation_personR
author_list.person_num fk_author_list_personR
d_affiliation.person_num Implied ConstraintR
d_author_list.person_num Implied ConstraintR
d_person.person_num Implied ConstraintR
person_external_identifier.person_num fk_person_external_identifier_personR
seddb_affiliation.person_num Implied ConstraintR
first_name varchar 256 null
middle_name varchar 256 √ null
last_name varchar 64 null
pnum int4 10 1
status int4 10 √ 1

Indexes

Constraint Name Type Sort Column(s)
person_pkey Primary key Asc person_num
uc_person Must be unique Asc/Asc/Asc first_name + last_name + pnum

Relationships

Close relationships within degrees of separation