collecting_event

20581 rows


Description

Details of sample collection from a particular site, in particular the dates of collection. A site can be revisited multiple times.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
coll_event_id serial 10 √ nextval('collecting_event_coll_event_id_seq'::regclass)
collector.coll_event_id collecting_event_collector_fk R
sample.coll_event_id collecting_event_sample_fk R

PK. Unique ID for a collecting event. Generated by the database
site_id int4 10 null
site.site_id site_collecting_event_fk R

FK. ID for a site. Links to the site table
start_date_verbatim varchar 250 √ null

Verbatim date for the start of the collection event.
end_date_verbatim varchar 250 √ null

Verbatim date for the end of the collection event
coll_event_notes varchar 4000 √ null

Reason for collection, notes about the event.
timestamp_created timestamptz 35,6 now()
timestamp_modified timestamptz 35,6 √ now()
start_date date 13 √ null

Start date for collecting event YYYY-MM-DD. Over-precise translation of the verbatim dates. First January used where only year provided.
end_date date 13 √ null

Start date for collecting event YYYY-MM-DD. Over-precise translation of the verbatim dates. 31st December used where only year provided.

Indexes

Constraint Name Type Sort Column(s)
coll_event_id Primary key Asc coll_event_id
collecting_event_site_id_idx Performance Asc site_id

Relationships

Close relationships within degrees of separation