series

0 rows


Description

Series of data

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('gobs.series_id_seq'::regclass)
import.fk_id_series import_fk_id_series_fkey R
observation.fk_id_series observation_fk_id_series_fkey R

Id
fk_id_protocol int4 10 null
protocol.id series_fk_id_protocol_fkey R

Protocol
fk_id_actor int4 10 null
actor.id series_fk_id_actor_fkey R

Actor, source of the observation data.
fk_id_indicator int4 10 null
indicator.id series_fk_id_indicator_fkey R

Indicator. The series is named after the indicator.
fk_id_spatial_layer int4 10 null
spatial_layer.id series_fk_id_spatial_layer_fkey R

Spatial layer, mandatory. If needed, use a global spatial layer with only 1 object representing the global area.

Indexes

Constraint Name Type Sort Column(s)
series_pkey Primary key Asc id
series_fk_id_actor_idx Performance Asc fk_id_actor
series_fk_id_indicator_idx Performance Asc fk_id_indicator
series_fk_id_protocol_idx Performance Asc fk_id_protocol
series_fk_id_spatial_layer_idx Performance Asc fk_id_spatial_layer

Relationships

Close relationships within degrees of separation