Table webco_3.6.1.public.allocation_freelancer 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_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 varchar 2147483647  √  null
availability varchar 2147483647

Table contained 0 rows at Wed May 11 15:14 EDT 2011

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