Table webco_5.0.public.task Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
obj_oid int8 19
task_person.task_oid task_person_task_oid_fkey
task_type_oid int8 19
task_type.obj_oid task_task_type_oid_fkey
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
organization.obj_oid task_organization_oid_fkey
allocation_oid int8 19  √  null
allocation.obj_oid task_allocation_oid_fkey
required_assignments int4 10  √  null

Table contained 0 rows at Thu Feb 14 09:10 CST 2019

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

Close relationships  within of separation: