Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
observation_id | int8 | 19 | null |
|
|
|||||||||||||||||||||
monitoring_plot_id | int8 | 19 | null |
|
|
|||||||||||||||||||||
claimed_by | int8 | 19 | √ | null |
|
|
||||||||||||||||||||
claimed_time | timestamptz | 35,6 | √ | null |
|
|
||||||||||||||||||||
completed_by | int8 | 19 | √ | null |
|
|
||||||||||||||||||||
completed_time | timestamptz | 35,6 | √ | null |
|
|
Server-generated completion date and time. This is the time the observation was submitted to the server, not the time it was performed in the field. |
|||||||||||||||||||
created_by | int8 | 19 | null |
|
|
|||||||||||||||||||||
created_time | timestamptz | 35,6 | null |
|
|
|||||||||||||||||||||
is_permanent | bool | 1 | null |
|
|
If true, this plot was selected for observation as a permanent monitoring plot. If false, this plot was selected as a temporary monitoring plot. |
||||||||||||||||||||
modified_by | int8 | 19 | null |
|
|
|||||||||||||||||||||
modified_time | timestamptz | 35,6 | √ | null |
|
|
||||||||||||||||||||
observed_time | timestamptz | 35,6 | √ | null |
|
|
Client-supplied observation date and time. This is the time the observation was performed in the field, not the time it was submitted to the server. |
|||||||||||||||||||
notes | text | 2147483647 | √ | null |
|
|
||||||||||||||||||||
status_id | int4 | 10 | null |
|
|
|||||||||||||||||||||
monitoring_plot_history_id | int8 | 19 | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
observation_plots_pkey | Primary key | Asc/Asc | observation_id + monitoring_plot_id |
observation_plots_monitoring_plot_history_id_idx | Performance | Asc | monitoring_plot_history_id |
observation_plots_monitoring_plot_id_idx | Performance | Asc | monitoring_plot_id |
Check Constraints
Constraint Name | Constraint |
---|---|
cannot_unclaim_completed_plot | ((completed_by IS NULL) OR ((completed_by IS NOT NULL) AND (claimed_by IS NOT NULL))) |