collecting_event

15389 rows


Description

Details of sample collection from a particular site, in particular the date of collection. A site can be revisted 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_fkR
sample.coll_event_id collecting_event_sample_fkR

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

FK. ID for a site. Links to the site table
start_date varchar 22 √ null

Start of the collection event.
end_date varchar 22 √ null

End of the collection event
coll_event_notes varchar 4000 √ null

Notes about the event.
timestamp_created timestamptz 35,6 now()
timestamp_modified timestamptz 35,6 √ now()
verbatim_date varchar 255 √ null

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