Table webco_3.9.1.public.allocation_freelancer_role 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_oid int8 19
allocation_freelancer.obj_oid fkallocation_freelancer_role_af_oid
role_oid int8 19
role.obj_oid fkcallocation_freelancer_role_oid

Table contained 0 rows at Tue Feb 04 14:58 EST 2014

Column(s) Type Sort Constraint Name
obj_oid Primary key Asc allocation_freelancer_role_pkey
allocation_freelancer_oid Performance Asc allocation_freelancer_role_af_idx
role_oid Performance Asc allocation_freelancer_role_role_idx
allocation_freelancer_oid + role_oid Must be unique Asc/Asc allocation_freelancer_role_unique_index

Close relationships  within of separation: