Table webco_4.1.0.public.allocation_freelancer_role 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
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 Wed Nov 05 15:04 EST 2014

Indexes:
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: