resource

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
obj_oid int8 19 null
allocation.deliver_to_oid fkcalloc_deliver_to_oidN
circulation_record.resource_oid fkccirc_record_resource_oidC
holding.resource_oid fkholding_resourceC
inventory_item.inventoried_home_location_oid inventory_item_inventoried_home_location_oid_fkeyN
inventory_item.resource_oid inventory_item_resource_oid_fkeyC
inventory_note.resource_oid inventory_note_resource_oid_fkeyN
inventory_selector.home_location_oid inventory_selector_home_location_oid_fkeyN
inventory_selector.resource_oid inventory_selector_resource_oid_fkeyC
invoice_line.resource_oid fkinv_line_resN
location.resource_oid fklocation_rsrc_oidC
maintenance_event.resource_oid kmaintevent_resource_oidR
resource.containing_resource_oid fkres_cont_resN
resource.location_resource_oid fkcres_loc_resN
resource_schedule.proposed_resource_oid fkcresource_schedule_proposed_resource_oidC
resource_schedule.scheduled_resource_oid fkcresource_schedule_scheduled_resource_oidC
task.location_oid task_location_oid_fkeyN
ticket.location_oid fkticket_locationN
ticket.resource_oid fkticket_resN
creation_date timestamptz 35,6 √ null
creating_operator_oid int8 19 √ null
modified timestamptz 35,6 √ null
deleted bool 1 false
origin varchar 2147483647 null
unique_identifier varchar 2147483647 √ null
label_id varchar 2147483647 null
metaclass wcof_tag 2147483647 null
circulating bool 1 √ null
unserialized bool 1 √ null
barcode varchar 2147483647 √ null
circulation_record_oid int8 19 √ null
rtype_oid int8 19 null
resource_type.obj_oid resource_rtype_oid_fkeyR
containing_resource_oid int8 19 √ null
resource.obj_oid fkres_cont_resN
location_resource_oid int8 19 √ null
resource.obj_oid fkcres_loc_resN
checkout_center_oid int8 19 null
checkout_center.obj_oid resource_checkout_center_oid_fkeyC
assigned_person_oid int8 19 √ null
person.obj_oid fkcres_personN
assigned_department_oid int8 19 √ null
department.obj_oid fkcres_departmentN
shelf_location varchar 2147483647 √ null
value money 2147483647 √ null
aggregate_value money 2147483647 √ null
location_note varchar 2147483647 √ null
destination bool 1 √ null
accessories _varchar 2147483647 ARRAY[]::character varying[]
condition_note varchar 2147483647 √ null
description varchar 2147483647 √ null
url varchar 2147483647 √ null
manufacturer varchar 2147483647 √ null
model varchar 2147483647 √ null
serial_number varchar 2147483647 √ null
warranty_labor varchar 2147483647 √ null
warranty_parts varchar 2147483647 √ null
vendor varchar 2147483647 √ null
purchase_date timestamptz 35,6 √ null
room_number varchar 2147483647 √ null
capacity int4 10 √ null
max_quantity int4 10 √ null
roles _varchar 2147483647 ARRAY[]::character varying[]
purchase_order varchar 2147483647 √ null
purchase_note varchar 2147483647 √ null
asset_tag varchar 2147483647 √ null
replacement_date timestamptz 35,6 √ null
last_inventoried_date timestamptz 35,6 √ null
hostname varchar 2147483647 √ null
hardware_version varchar 2147483647 √ null
software_version varchar 2147483647 √ null
ip_address varchar 2147483647 √ null
mac_address varchar 2147483647 √ null
budget_number varchar 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
resource_pkey Primary key Asc obj_oid
resource_barcode_key Must be unique Asc barcode
resource_checkout_center_oid_idx Performance Asc checkout_center_oid
resource_circulation_record_oid_idx Performance Asc circulation_record_oid
resource_label_id_key Must be unique Asc label_id
resource_location_resource_oid_idx Performance Asc location_resource_oid
resource_metaclass_idx Performance Asc metaclass
resource_type_location_idx Performance Asc/Asc checkout_center_oid + rtype_oid
resource_unique_identifier_key Must be unique Asc unique_identifier
resource_unserialized_idx Performance Asc unserialized
rtype_oid_idx Performance Asc rtype_oid

Check Constraints

Constraint Name Constraint
resource_media_equipment_warranty_parts ((NOT ((metaclass <> 'MEDIA'::wcof_tag) AND (metaclass <> 'EQUIPMENT'::wcof_tag) AND (warranty_parts IS NOT NULL))))
resource_media_equipment_purchase_order ((NOT ((metaclass <> 'MEDIA'::wcof_tag) AND (metaclass <> 'EQUIPMENT'::wcof_tag) AND (purchase_order IS NOT NULL))))
resource_media_equipment_manufacturer ((NOT ((metaclass <> 'MEDIA'::wcof_tag) AND (metaclass <> 'EQUIPMENT'::wcof_tag) AND (manufacturer IS NOT NULL))))
resource_media_equipment_warranty_labor ((NOT ((metaclass <> 'MEDIA'::wcof_tag) AND (metaclass <> 'EQUIPMENT'::wcof_tag) AND (warranty_labor IS NOT NULL))))
resource_media_equipment_serial_number ((NOT ((metaclass <> 'MEDIA'::wcof_tag) AND (metaclass <> 'EQUIPMENT'::wcof_tag) AND (serial_number IS NOT NULL))))
resource_media_equipment_purchase_date ((NOT ((metaclass <> 'MEDIA'::wcof_tag) AND (metaclass <> 'EQUIPMENT'::wcof_tag) AND (purchase_date IS NOT NULL))))
resource_not_own_location ((location_resource_oid <> obj_oid))
resource_media_equipment_vendor ((NOT ((metaclass <> 'MEDIA'::wcof_tag) AND (metaclass <> 'EQUIPMENT'::wcof_tag) AND (vendor IS NOT NULL))))
resource_media_equipment_model ((NOT ((metaclass <> 'MEDIA'::wcof_tag) AND (metaclass <> 'EQUIPMENT'::wcof_tag) AND (model IS NOT NULL))))
resource_location_capacity ((NOT ((metaclass <> 'LOCATION'::wcof_tag) AND (capacity IS NOT NULL))))
resource_metaclass_check ((metaclass = ANY (ARRAY['EQUIPMENT'::wcof_tag, 'MEDIA'::wcof_tag, 'LOCATION'::wcof_tag])))

Relationships

Close relationships within degrees of separation