task

49179 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
task_id serial 10 √ nextval('"activityLog_activity_id_seq"'::regclass)
animal_movement_task.task_id animal_movement_task_task_id_foreign R
animal_movement_task_purpose_relationship.task_id animal_movement_task_purpose_relationship_task_id_foreign R
cleaning_task.task_id cleaning_task_task_id_foreign R
field_work_task.task_id fieldworklog_activity_id_foreign C
harvest_task.task_id harvestlog_activity_id_foreign C
irrigation_task.task_id irrigationlog_activity_id_foreign C
location_tasks.task_id activityfields_activity_id_foreign C
maintenance_task.task_id maintenance_task_task_id_foreign R
management_tasks.task_id activitycrops_activity_id_foreign C
pest_control_task.task_id pestcontrollog_activity_id_foreign C
plant_task.task_id seedlog_activity_id_foreign C
sale_task.task_id sale_task_task_id_foreign R
scouting_task.task_id scoutinglog_activity_id_foreign C
social_task.task_id social_task_task_id_foreign R
soil_amendment_task.task_id fertilizerlog_activity_id_foreign C
soil_amendment_task_products.task_id soil_amendment_task_products_task_id_foreign R
soil_sample_task.task_id soil_sample_task_task_id_foreign R
soil_task.task_id soildatalog_activity_id_foreign C
task_animal_batch_relationship.task_id task_animal_batch_relationship_task_id_foreign R
task_animal_relationship.task_id task_animal_relationship_task_id_foreign R
task_document.task_id task_document_task_id_foreign R
transplant_task.task_id transplant_task_task_id_foreign R
transport_task.task_id transport_task_task_id_foreign R
wash_and_pack_task.task_id wash_and_pack_task_task_id_foreign R
due_date date 13 null
owner_user_id varchar 255 null
users.user_id user_id R
notes text 2147483647 √ null
action_needed bool 1 √ false
photo varchar 255 √ null
deleted bool 1 false
created_by_user_id varchar 255 √ '1'::character varying
users.user_id activitylog_created_by_user_id_foreign R
updated_by_user_id varchar 255 √ '1'::character varying
users.user_id activitylog_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
task_type_id int4 10 √ null
task_type.task_type_id task_type_foreign R
assignee_user_id varchar 255 √ null
users.user_id task_assignee_foreign R
coordinates jsonb 2147483647 √ null
duration float4 8,8 √ null
wage_at_moment float4 8,8 √ null
happiness int4 10 √ null
completion_notes text 2147483647 √ null
complete_date date 13 √ null
late_time timestamptz 35,6 √ null
for_review_time timestamptz 35,6 √ null
abandon_date date 13 √ null
abandonment_reason varchar 255 √ null
other_abandonment_reason varchar 255 √ null
abandonment_notes text 2147483647 √ null
override_hourly_wage bool 1 √ false

Indexes

Constraint Name Type Sort Column(s)
activityLog_pkey Primary key Asc task_id

Relationships

Close relationships within degrees of separation