Table webco_4.7.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_group.allocation_oid allocation_group_allocation_oid_fkey
allocation_group.source_allocation_oid fkcalloc_group_src_alloc_oid
allocation_item_building_pass.allocation_oid allocation_item_building_pass_allocation_oid_fkey
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_task.allocation_oid allocation_task_allocation_oid_fkey
invoice.allocation_oid fkcinvoice_alloc_oid
resource_schedule.allocation_oid fkcresource_schedule_alloc_oid
turndown.allocation_oid turndown_allocation_oid_fkey
checkout_center_oid int8 19  √  null
checkout_center.obj_oid fkcalloc_checkout_center_oid
agent_oid int8 19  √  1
person.obj_oid fkcalloc_agent_oid
original_agent_oid int8 19  √  null
person.obj_oid fkallocation_original_agent_oid
patron_oid int8 19  √  null
person.obj_oid fkcalloc_patron_oid
creation_time timestamptz 35,6  √  null
creation_note varchar 2147483647  √  null
start_time timestamptz 35,6  √  null
real_start_time timestamptz 35,6  √  null
end_time timestamptz 35,6  √  null
real_end_time timestamptz 35,6  √  null
effective_end_time timestamptz 35,6  √  null
expire_time timestamptz 35,6  √  null
note varchar 2147483647  √  null
is_show bool 1  √  null
nonexpiring bool 1  √  null
approved bool 1  √  null
pickup_instructions varchar 2147483647  √  null
pickup_option wcof_tag 2147483647  √  null
id varchar 2147483647  √  null
return_option wcof_tag 2147483647  √  null
auto_circulate bool 1  √  null
patron_class_oid int8 19  √  null
patron_class.obj_oid fkcpatron_class_oid
contact_person int8 19  √  null
person.obj_oid fkcalloc_contact_person
contact_name_string varchar 2147483647  √  null
contact_phone_string varchar 2147483647  √  null
last_renewal timestamptz 35,6  √  null
renewal_count int8 19  √  null
delivery_type wcof_tag 2147483647  √  null
deliver_to_string varchar 2147483647  √  null
deliver_to_oid int8 19  √  null
resource.obj_oid fkcalloc_deliver_to_oid
billing_type wcof_tag 2147483647  √  null
use_charge_duration bool 1  √  null
charge_duration interval 49,6  √  null
payment_type wcof_tag 2147483647  √  null
credit_card_type varchar 2147483647  √  null
po_number varchar 2147483647  √  null
reference_id varchar 2147483647  √  null
project_code 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
allocation_state wcof_tag 2147483647  √  null

Table contained 0 rows at Thu Feb 14 09:20 CST 2019

Indexes:
Column(s) Type Sort Constraint Name
obj_oid Primary key Asc allocation_pkey
approved Performance Asc allocation_approved_idx
checkout_center_oid Performance Asc allocation_location_idx
patron_oid Performance Asc allocation_patron_idx
allocation_state Performance Asc allocation_state_idx

Close relationships  within of separation: