Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | int8 | 19 | null |
|
|
|||||
| monitoring_plot_id | int8 | 19 | null |
|
|
|||||
| planting_subzone_id | int8 | 19 | √ | null |
|
|
||||
| planting_site_id | int8 | 19 | null |
|
|
|||||
| planting_subzone_history_id | int8 | 19 | √ | null |
|
|
||||
| planting_site_history_id | int8 | 19 | null |
|
|
|||||
| created_by | int8 | 19 | null |
|
|
Which user created or edited the monitoring plot or its planting site. |
||||
| created_time | timestamptz | 35,6 | null |
|
|
When the monitoring plot was created, edited, or associated with a new planting site history record. May differ from the time when the subzone or planting site was created or edited since plots can be created when observations start. |
||||
| name | text | 2147483647 | null |
|
|
|||||
| full_name | text | 2147483647 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| monitoring_plot_histories_pkey | Primary key | Asc | id |
| monitoring_plot_histories_created_by_idx | Performance | Asc | created_by |
| monitoring_plot_histories_monitoring_plot_id_idx | Performance | Asc | monitoring_plot_id |
| monitoring_plot_histories_planting_site_history_id_idx | Performance | Asc | planting_site_history_id |
| monitoring_plot_histories_planting_site_id_idx | Performance | Asc | planting_site_id |
| monitoring_plot_histories_planting_subzone_history_id_idx | Performance | Asc | planting_subzone_history_id |
| monitoring_plot_histories_planting_subzone_id_idx | Performance | Asc | planting_subzone_id |