task_type

4 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
obj_oid int8 19 null
task.task_type_oid task_task_type_oid_fkeyC
task_profile_task_type.task_type_oid task_profile_task_type_task_type_oid_fkeyC
name varchar 2147483647 √ null
organization_oid int8 19 √ null
organization.obj_oid task_type_organization_oid_fkeyC
is_allocation_task bool 1 √ null
default_relative_task_time wcof_relative_task_time 2147483647 √ null
default_notes varchar 2147483647 √ null
active bool 1 √ null
affiliated_allocation_task wcof_tag 2147483647 √ null
default_required_assignments int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
task_type_pkey Primary key Asc obj_oid
task_type_affiliated_allocation_task_key Must be unique Asc affiliated_allocation_task

Relationships

Close relationships within degrees of separation