Table webco_3.6.1.public.allocation 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_building_pass.allocation_oid allocation_building_pass_allocation_oid_fkey
allocation_contents.allocation_oid fkcallocation_contents_allocation_oid
allocation_freelancer.allocation_oid fkcallocation_freelancer_allocation_oid
allocation_group.allocation_oid allocation_group_allocation_oid_fkey
allocation_group.source_allocation_oid fkcalloc_group_src_alloc_oid
allocation_item.allocation_oid fkcallocation_item_allocation_oid
allocation_log.allocation_oid fkcalloc_log_alloc_oid
allocation_person.allocation_oid allocation_person_allocation_oid_fkey
allocation_repeat_rule.allocation_oid allocation_repeat_rule_allocation_oid_fkey
allocation_route.allocation_oid allocation_route_allocation_oid_fkey
allocation_route_message.allocation_oid allocation_route_message_allocation_oid_fkey
allocation_staffing.allocation_oid fkallocation_staffing_allocation_oid
allocation_task.allocation_oid allocation_task_allocation_oid_fkey
invoice.allocation_oid fkcinvoice_alloc_oid
mail_event.allocation_oid fkmail_event_alloc_oid
pir_allocation.allocation_oid fkcpir_allocation_alloc_oid
resource_schedule.allocation_oid fkcresource_schedule_alloc_oid
turndown.allocation_oid turndown_allocation_oid_fkey
location_oid int8 19  √  null
location.obj_oid fkcalloc_location_oid
agent_oid int8 19  √  1
person.obj_oid fkcalloc_agent_oid
patron_oid int8 19  √  null
person.obj_oid fkcalloc_patron_oid
creation_time timestamp 29,6  √  null
start_time timestamp 29,6  √  null
end_time timestamp 29,6  √  null
expire_time timestamp 29,6  √  null
note varchar 2147483647  √  null
is_show bool 1  √  null
nonexpiring bool 1  √  null
pickup_instructions varchar 2147483647  √  null
pickup_option varchar 2147483647  √  null
id varchar 2147483647  √  null
return_option varchar 2147483647  √  null
auto_circulate bool 1  √  null
patron_class varchar 2147483647  √  null
contact_person int8 19  √  null
person.obj_oid fkcalloc_contact_person
contact_name_string varchar 2147483647  √  null
contact_phone_string varchar 2147483647  √  null
renewal_count int8 19  √  null
delivery_type varchar 2147483647  √  null
deliver_to_string varchar 2147483647  √  null
deliver_to_oid int8 19  √  null
resource.obj_oid fkcalloc_deliver_to_oid
billing_type varchar 2147483647  √  null
use_charge_duration bool 1  √  null
charge_duration varchar 2147483647  √  null
payment_type varchar 2147483647  √  null
credit_card_type varchar 2147483647  √  null
po_number varchar 2147483647  √  null
payee_oid int8 19  √  null
person.obj_oid fkcalloc_payee_oid
account_code varchar 2147483647  √  null
paying_department_oid int8 19  √  null
department.obj_oid fkcalloc_paying_department_oid
event_description varchar 2147483647  √  null

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_pkey
patron_oid Performance Asc allocation_patron_idx

Close relationships  within of separation: