Table edi_sandbox.ecocom_dp.observation_ancillary
holds other info about a sampling event, eg, conditions, weather, observers, etc

Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
observation_ancillary_id varchar 100
event_id varchar 100  √  null
event.event_id observation_ancillary_event_fk R
variable_name varchar 200  √  null
value varchar 200  √  null
unit varchar 200  √  null

Table contained 0 rows at Wed Oct 25 17:00 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name Anomalies
observation_ancillary_id Primary key Asc observation_ancillary_pk  
event_id + variable_name Must be unique Asc/Asc observation_ancillary_uniq These unique columns are also nullable

Close relationships  within of separation: