sample_provided_by

78786 rows


Description

Linking table between sample and person - more than one person can contribute to the description of the sample

Columns

Column Type Size Nulls Auto Default Children Parents Comments
sample_id int4 10 null
sample.sample_id sample_sample_provided_by_fkR

PK/FK. ID for the sample. Links to the sample table. Part of composite primary key.
person_id int4 10 null
person.person_id person_sample_provided_by_fkR

PK/FK. ID for the person who provided the details of the sample (e.g. lithology, color). Links to the sample table. Part of composite primary key.
timestamp_created timestamptz 35,6 now()
timestamp_modified timestamptz 35,6 √ now()

Indexes

Constraint Name Type Sort Column(s)
sample_provided_by_id Primary key Asc/Asc sample_id + person_id

Relationships

Close relationships within degrees of separation