field_work_task

5069 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
task_id int4 10 null
task.task_id fieldworklog_activity_id_foreign C
field_work_type_id int4 10 √ null
field_work_type.field_work_type_id field_work_task_field_work_type_id_foreign R
created_by_user_id varchar 255 √ '1'::character varying
users.user_id field_work_task_created_by_user_id_foreign R
updated_by_user_id varchar 255 √ '1'::character varying
users.user_id field_work_task_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

Indexes

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

Relationships

Close relationships within degrees of separation