management_plan

22000 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
management_plan_id serial 10 √ nextval('"fieldCrop_field_crop_id_seq"'::regclass)
crop_management_plan.management_plan_id crop_management_plan_management_plan_id_foreign R
planting_management_plan.management_plan_id planting_management_plan_management_plan_id_foreign R
shiftTask.management_plan_id shifttask_field_crop_id_foreign C
deleted bool 1 false
created_by_user_id varchar 255 √ '1'::character varying
users.user_id management_plan_created_by_user_id_foreign R
updated_by_user_id varchar 255 √ '1'::character varying
users.user_id management_plan_updated_by_user_id_foreign R
created_at timestamptz 35,6 '1999-12-31 16:00:00-08'::timestamp with time zone
updated_at timestamptz 35,6 '1999-12-31 16:00:00-08'::timestamp with time zone
crop_variety_id uuid 2147483647 √ null
crop_variety.crop_variety_id management_plan_crop_variety_id_foreign R
notes text 2147483647 √ null
name varchar 255 √ null
start_date date 13 √ null
complete_date date 13 √ null
abandon_date date 13 √ null
complete_notes text 2147483647 √ null
rating text 2147483647 √ null
abandon_reason varchar 255 √ null
management_plan_group_id uuid 2147483647 √ null
management_plan_group.management_plan_group_id management_plan_management_plan_group_id_foreign R
repetition_number int2 5 √ null

Indexes

Constraint Name Type Sort Column(s)
management_plan_pkey Primary key Asc management_plan_id

Relationships

Close relationships within degrees of separation