Table webco_4.1.0.public.allocation_freelancer Generated by
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
allocation_freelancer_assigned.allocation_freelancer_oid fkallocation_freelancer_assigned_af_oid
allocation_freelancer_role.allocation_freelancer_oid fkallocation_freelancer_role_af_oid
hash varchar 2147483647
allocation_oid int8 19
allocation.obj_oid fkcallocation_freelancer_allocation_oid
person_oid int8 19
person.obj_oid fkcallocation_freelancer_person_oid
last_sent_mail wcof_tag 2147483647  √  null
availability wcof_tag 2147483647

Table contained 0 rows at Wed Nov 05 15:04 EST 2014

Column(s) Type Sort Constraint Name
obj_oid Primary key Asc allocation_freelancer_pkey
allocation_oid Performance Asc allocation_freelancer_allocation_idx
hash Must be unique Asc allocation_freelancer_hash_key
hash Must be unique Asc allocation_freelancer_hash_unique_index
person_oid Performance Asc allocation_freelancer_person_idx
allocation_oid + person_oid Must be unique Asc/Asc allocation_freelancer_unique_index

Close relationships  within of separation: