shiftTask

2585 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
task_id int4 10 √ null
task_type.task_type_id shifttask_task_id_foreign R
shift_id uuid 2147483647 √ null
shift.shift_id shifttask_shift_id_foreign R
management_plan_id int4 10 √ null
management_plan.management_plan_id shifttask_field_crop_id_foreign C
is_location bool 1 √ false
location_id uuid 2147483647 √ null
location.location_id shifttask_field_id_foreign R
duration float4 8,8 √ null
deleted bool 1 √ false
created_by_user_id varchar 255 √ '1'::character varying
users.user_id shifttask_created_by_user_id_foreign R
updated_by_user_id varchar 255 √ '1'::character varying
users.user_id shifttask_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

Relationships

Close relationships within degrees of separation