draft_planting_sites

-1 rows


Description

Details of planting sites that are in the process of being defined.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
draft_strata.draft_planting_site_id draft_strata_draft_planting_site_id_fkey C
organization_id int8 19 null
organizations.id draft_planting_sites_organization_id_fkey C
projects.organization_id draft_planting_sites_organization_id_project_id_fkey R
project_id int8 19 √ null
projects.id draft_planting_sites_project_id_fkey N
name text 2147483647 null
description text 2147483647 √ null
time_zone text 2147483647 √ null
time_zones.time_zone draft_planting_sites_time_zone_fkey R
created_by int8 19 null
users.id draft_planting_sites_created_by_fkey R
created_time timestamptz 35,6 null
modified_by int8 19 null
users.id draft_planting_sites_modified_by_fkey R
modified_time timestamptz 35,6 null
site_type_id int4 10 null
draft_planting_site_types.id draft_planting_sites_site_type_id_fkey R
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

Relationships