planting_management_plan

25111 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
planting_management_plan_id uuid 2147483647 uuid_generate_v4()
bed_method.planting_management_plan_id bed_method_planting_management_plan_id_foreign R
broadcast_method.planting_management_plan_id broadcast_method_planting_management_plan_id_foreign R
container_method.planting_management_plan_id container_method_planting_management_plan_id_foreign R
management_tasks.planting_management_plan_id management_tasks_planting_management_plan_id_foreign R
plant_task.planting_management_plan_id plant_task_planting_management_plan_id_foreign R
row_method.planting_management_plan_id row_method_planting_management_plan_id_foreign R
transplant_task.planting_management_plan_id transplant_task_planting_management_plan_id_foreign R
transplant_task.prev_planting_management_plan_id transplant_task_prev_planting_management_plan_id_foreign R
management_plan_id int4 10 null
management_plan.management_plan_id planting_management_plan_management_plan_id_foreign R
is_final_planting_management_plan bool 1 √ null
planting_method text 2147483647 √ null
is_planting_method_known bool 1 √ null
estimated_seeds numeric 36,12 √ null
estimated_seeds_unit text 2147483647 √ 'kg'::text
location_id uuid 2147483647 √ null
location.location_id planting_management_plan_location_id_foreign R
pin_coordinate jsonb 2147483647 √ null
notes text 2147483647 √ null
planting_task_type text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
planting_management_plan_pkey Primary key Asc planting_management_plan_id

Relationships

Close relationships within degrees of separation