person

1057 rows


Description

A list of people - can be contributors, authors, collectors etc.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
person_id serial 10 √ nextval('person_person_id_seq'::regclass)
affiliation.person_id person_affiliation_fkR
analysis.provided_by person_analysis_fk_1R
analysis.run_by person_analysis_fkR
author.person_id person_author_fkR
collector.person_id person_collector_fkR
geol_context_provided_by.person_id person_geol_context_provided_by_fkR
interpreted_age_provided_by.person_id person_interpreted_age_provided_by_fkR
sample_provided_by.person_id person_sample_provided_by_fkR
storage.contact_person person_contact_personR

PK. Unique identifier for a person. Generated by database.
first_name varchar 50 √ null

First name.
middle_initial varchar 50 √ null

Middle initial (with period).
last_name varchar 50 null

Last name.
timestamp_created timestamptz 35,6 now()
timestamp_modified timestamptz 35,6 √ now()
orcid_id varchar 255 √ null

ORCID - See https://orcid.org/
is_contributor bool 1 √ false
contributor_notes varchar 1000 √ null

Indexes

Constraint Name Type Sort Column(s)
person_id Primary key Asc person_id
person_lower_idx Performance

Relationships

Close relationships within degrees of separation