task

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
obj_oid int8 19 null
task_person.task_oid task_person_task_oid_fkeyC
task_type_oid int8 19 null
task_type.obj_oid task_task_type_oid_fkeyC
fixed_time timestamptz 35,6 √ null
relative_time wcof_relative_task_time 2147483647 √ null
task_time timestamptz 35,6 √ null
notes varchar 2147483647 √ null
organization_oid int8 19 null
organization.obj_oid task_organization_oid_fkeyC
allocation_oid int8 19 √ null
allocation.obj_oid task_allocation_oid_fkeyC
location_oid int8 19 √ null
resource.obj_oid task_location_oid_fkeyN
location_note varchar 2147483647 √ null
required_assignments int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
task_pkey Primary key Asc obj_oid

Relationships

Close relationships within degrees of separation