Table edi_sandbox.ecocom_dp.sampling_location
self-referencing; parent of a loc can be another loc

 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
sampling_location_id varchar 100
observation.sampling_location_id observation_sampling_location_fk R
sampling_location.parent_sampling_location_id parent_sampling_location_fk R
sampling_location_ancillary.sampling_location_id sampling_location_ancillary_fk R
sampling_location_name varchar 500  √  null
latitude float8 17,17  √  null
longitude float8 17,17  √  null
elevation float8 17,17  √  null
parent_sampling_location_id varchar 100  √  null
sampling_location.sampling_location_id parent_sampling_location_fk R

Table contained 0 rows at Wed Aug 16 14:05 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name
sampling_location_id Primary key Asc sampling_location_pk

Close relationships  within of separation: