allocation

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
obj_oid int8 19 null
allocation.copy_of allocation_copy_of_fkeyN
allocation_accompanying_person.allocation_oid allocation_accompanying_person_allocation_oid_fkeyC
allocation_group.allocation_oid allocation_group_allocation_oid_fkeyC
allocation_group.source_allocation_oid fkcalloc_group_src_alloc_oidC
allocation_item_building_pass.allocation_oid allocation_item_building_pass_allocation_oid_fkeyC
allocation_log.allocation_oid fkcalloc_log_alloc_oidC
allocation_repeat_rule.allocation_oid allocation_repeat_rule_allocation_oid_fkeyC
invoice.allocation_oid fkcinvoice_alloc_oidC
resource_schedule.allocation_oid fkcresource_schedule_alloc_oidC
task.allocation_oid task_allocation_oid_fkeyC
turndown.allocation_oid turndown_allocation_oid_fkeyN
type_allocation_usage_data.allocation_oid type_allocation_usage_data_allocation_oid_fkeyC
checkout_center_oid int8 19 √ null
checkout_center.obj_oid fkcalloc_checkout_center_oidC
agent_oid int8 19 √ 1
person.obj_oid fkcalloc_agent_oid
original_agent_oid int8 19 √ null
person.obj_oid fkallocation_original_agent_oidN
patron_oid int8 19 √ null
person.obj_oid fkcalloc_patron_oidR
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
nonexpiring bool 1 √ null
approved bool 1 √ null
pickup_instructions varchar 2147483647 √ null
id varchar 2147483647 √ null
auto_circulate bool 1 √ null
patron_class_oid int8 19 √ null
patron_class.obj_oid fkcpatron_class_oidR
contact_person int8 19 √ null
person.obj_oid fkcalloc_contact_personN
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_oidN
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
account_oid int8 19 √ null
account.obj_oid fkcaccount_oidR
event_description varchar 2147483647 √ null
allocation_state wcof_tag 2147483647 √ null
copy_of int8 19 √ null
allocation.obj_oid allocation_copy_of_fkeyN

Indexes

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

Relationships

Close relationships within degrees of separation