person

5142 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
person_num serial 10 √ nextval('person_person_num_seq'::regclass)
author_list.person_num author_list_person_num_fkeyR
bridge_person_num_distinctname.person_num Implied ConstraintR
person_orcid.person_num Implied ConstraintR
person_scopus.person_num Implied ConstraintR
person_submission_download_stats2.person_num Implied ConstraintR
person_submissions2.person_num Implied ConstraintR
person_submissions_licenses.person_num Implied ConstraintR
first_name varchar 45 null
middle_initial varchar 20 √ null
last_name varchar 45 null
email varchar 100 √ null
approval int4 10 0
orcid_id varchar 19 √ null
institution varchar 256 √ null
scopus varchar 256 √ null

Indexes

Constraint Name Type Sort Column(s)
person_pkey Primary key Asc person_num
person_person_num_key Must be unique Asc person_num

Relationships

Close relationships within degrees of separation