person

2658 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_fk R
analysis.provided_by person_analysis_fk_1 R
analysis.run_by person_analysis_fk R
author.person_id person_author_fk R
collector.person_id person_collector_fk R
geol_context_provided_by.person_id person_geol_context_provided_by_fk R
interpreted_age_provided_by.person_id person_interpreted_age_provided_by_fk R
sample_provided_by.person_id person_sample_provided_by_fk R
storage.contact_person person_contact_person R

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 varchar 255 √ null

ORCID - See https://orcid.org/
is_contributor bool 1 √ false

Is a contributor to SGP e.g. provided data, context information etc.
contributor_notes varchar 1000 √ null

Notes about the contributor/contributions - especially used if non-traditional contribution such that the person does not appear in sample_provided_by, geol_context_provided_by, interpreted_age_provided_by, run_by or provided_by
phase1_optin bool 1 √ null

Whether or not the person opted to be included in the Phase 1 publication describing the database.

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