Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int8 | 19 | null |
|
|
|||||||||||||
| planting_zone_id | int8 | 19 | null |
|
|
Which planting zone this subzone is part of. |
||||||||||||
| name | text | 2147483647 | null |
|
|
Short name of this planting subzone. This is often just a single letter and number. Must be unique within a planting zone. |
||||||||||||
| full_name | text | 2147483647 | null |
|
|
|||||||||||||
| boundary | geometry | 2147483647 | null |
|
|
Boundary of the subzone. Coordinates always use SRID 4326 (WGS 84 latitude/longitude). |
||||||||||||
| created_by | int8 | 19 | null |
|
|
Which user created the subzone. |
||||||||||||
| created_time | timestamptz | 35,6 | null |
|
|
When the subzone was originally created. |
||||||||||||
| modified_by | int8 | 19 | null |
|
|
Which user most recently modified the subzone. |
||||||||||||
| modified_time | timestamptz | 35,6 | null |
|
|
When the subzone was most recently modified. |
||||||||||||
| planting_site_id | int8 | 19 | null |
|
|
Which planting site this subzone is part of. This is the same as the planting site ID of this subzone’s planting zone, but is duplicated here so it can be used as the target of a foreign key constraint. |
||||||||||||
| area_ha | numeric | 131089 | null |
|
|
|||||||||||||
| planting_completed_time | timestamptz | 35,6 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| plots_pkey | Primary key | Asc | id |
| plots_planting_site_id_id_key | Must be unique | Asc/Asc | planting_site_id + id |
| plots_planting_zone_id_name_key | Must be unique | Asc/Asc | planting_zone_id + name |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| area_positive | ((area_ha > (0)::numeric)) |