Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | bigserial | 19 | √ | nextval('gobs.observation_id_seq'::regclass) |
|
|
ID |
|||
| fk_id_series | int4 | 10 | null |
|
|
Series ID |
||||
| fk_id_spatial_object | int8 | 19 | null |
|
|
ID of the object in the spatial object table |
||||
| fk_id_import | int4 | 10 | null |
|
|
Import id |
||||
| ob_value | jsonb | 2147483647 | null |
|
|
Vector containing the measured or computed data values. Ex : 1543, 1637 |
||||
| ob_start_timestamp | timestamp | 29,6 | null |
|
|
Start timestamp of the observation data |
||||
| ob_validation | timestamp | 29,6 | √ | null |
|
|
Date and time when the data has been validated (the corresponding import status has been changed from pending to validated). Can be used to find all observations not yet validated, with NULL values in this field. |
|||
| ob_end_timestamp | timestamp | 29,6 | √ | null |
|
|
End timestamp of the observation data (optional) |
|||
| ob_uid | uuid | 2147483647 | uuid_generate_v4() |
|
|
Observation uid: autogenerated unique identifier |
||||
| created_at | timestamp | 29,6 | now() |
|
|
Creation timestamp |
||||
| updated_at | timestamp | 29,6 | now() |
|
|
Last updated timestamp |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| observation_pkey | Primary key | Asc | id |
| observation_data_unique | Must be unique | Asc/Asc/Asc | fk_id_series + fk_id_spatial_object + ob_start_timestamp |
| observation_fk_id_import_idx | Performance | Asc | fk_id_import |
| observation_fk_id_series_idx | Performance | Asc | fk_id_series |
| observation_fk_id_spatial_object_idx | Performance | Asc | fk_id_spatial_object |
| observation_ob_timestamp_idx | Performance | Asc | ob_start_timestamp |
Relationships
Close relationships within degrees of separation
