Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int8 | 19 | null |
|
|
|||||||||||||||||||||||
| organization_id | int8 | 19 | null |
|
|
Which organization owns this planting site. |
||||||||||||||||||||||
| name | text | 2147483647 | null |
|
|
Short name of this planting site. Must be unique within the organization. |
||||||||||||||||||||||
| description | text | 2147483647 | √ | null |
|
|
Optional user-supplied description of the planting site. |
|||||||||||||||||||||
| boundary | geometry | 2147483647 | √ | null |
|
|
Boundary of the entire planting site. Planting zones will generally fall inside this boundary. This will typically be a single polygon but may be multiple polygons if a planting site has several disjoint areas. Coordinates always use SRID 4326 (WGS 84 latitude/longitude). |
|||||||||||||||||||||
| created_by | int8 | 19 | null |
|
|
Which user created the planting site. |
||||||||||||||||||||||
| created_time | timestamptz | 35,6 | null |
|
|
When the planting site was originally created. |
||||||||||||||||||||||
| modified_by | int8 | 19 | null |
|
|
Which user most recently modified the planting site. |
||||||||||||||||||||||
| modified_time | timestamptz | 35,6 | null |
|
|
When the planting site was most recently modified. |
||||||||||||||||||||||
| time_zone | text | 2147483647 | √ | null |
|
|
||||||||||||||||||||||
| area_ha | numeric | 131089 | √ | null |
|
|
||||||||||||||||||||||
| project_id | int8 | 19 | √ | null |
|
|
||||||||||||||||||||||
| exclusion | geometry | 2147483647 | √ | null |
|
|
Optional area to exclude from a site. No monitoring plots will be located in this area. |
|||||||||||||||||||||
| grid_origin | geometry | 2147483647 | √ | null |
|
|
Coordinates of the origin point of the grid of monitoring plots. Monitoring plot corners have X and Y coordinates that are multiples of 25 meters from the origin point. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| planting_sites_pkey | Primary key | Asc | id |
| planting_sites_organization_id_name_key | Must be unique | Asc/Asc | organization_id + name |
| planting_sites_project_id_idx | Performance | Asc | project_id |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| planting_sites_description_check | ((description !~ similar_to_escape(' *'::text))) |
| area_positive | ((area_ha > (0)::numeric)) |