geol_context_provided_by

4443 rows


Description

Linking table between geological context and person - more than one person can contribute to the geological context

Columns

Column Type Size Nulls Auto Default Children Parents Comments
geol_context_id int4 10 null
geol_context.geol_context_id geol_context_geol_context_provided_by_fkR

PK/FK. ID for the geological context. Links to the geol_context table. Part of composite primary key.
person_id int4 10 null
person.person_id person_geol_context_provided_by_fkR

PK/FK. ID for person who provided the details of the geological context. Links to the person 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)
geol_context_provided_by_id Primary key Asc/Asc geol_context_id + person_id

Relationships

Close relationships within degrees of separation