Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int8 | 19 | √ | null |
|
|
||||||||
| organization_id | int8 | 19 | null |
|
|
|||||||||
| project_id | int8 | 19 | √ | null |
|
|
||||||||
| name | text | 2147483647 | null |
|
|
|||||||||
| description | text | 2147483647 | √ | null |
|
|
||||||||
| time_zone | text | 2147483647 | √ | null |
|
|
||||||||
| created_by | int8 | 19 | null |
|
|
|||||||||
| created_time | timestamptz | 35,6 | null |
|
|
|||||||||
| modified_by | int8 | 19 | null |
|
|
|||||||||
| modified_time | timestamptz | 35,6 | null |
|
|
|||||||||
| site_type_id | int4 | 10 | null |
|
|
|||||||||
| site_edit_step | text | 2147483647 | √ | null |
|
|
Client-defined identifier of the step of the site creation process the user is on. Opaque to the server. |
|||||||
| boundary_source | text | 2147483647 | √ | null |
|
|
Client-defined indicator of how the boundary was created, e.g., drawn or uploaded. Opaque to the server. |
|||||||
| boundary | geometry | 2147483647 | √ | null |
|
|
Boundary of the planting site as defined so far. Null if the user has not drawn or uploaded a boundary yet. |
|||||||
| exclusion | geometry | 2147483647 | √ | null |
|
|
Areas inside the boundary that are excluded from the planting site. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| draft_planting_sites_pkey | Primary key | Asc | id |
| draft_planting_sites_organization_id_idx | Performance | Asc | organization_id |
| draft_planting_sites_project_id_idx | Performance | Asc | project_id |