resource_schedule

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
obj_oid int8 19 null
maintenance_event.offline_node_oid kmaintevent_offline_oidR
autocirculate bool 1 √ false
allocation_oid int8 19 √ null
allocation.obj_oid fkcresource_schedule_alloc_oidC
type wcof_tag 2147483647 null
scheduled_by wcof_tag 2147483647 null
requested_rtype_oid int8 19 null
scheduled_resource_oid int8 19 √ null
resource.obj_oid fkcresource_schedule_scheduled_resource_oidC
proposed_resource_oid int8 19 √ null
resource.obj_oid fkcresource_schedule_proposed_resource_oidC
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
return_agent_oid int8 19 √ 1
person.obj_oid fkcresource_schedule_return_agent_oid
uuid uuid 2147483647 null
event_group uuid 2147483647 null
checkout_center_oid int8 19 √ null
checkout_center.obj_oid fkcresource_schedule_checkout_centerC

Indexes

Constraint Name Type Sort Column(s)
resource_schedule_pkey Primary key Asc obj_oid
allocation_resource_schedule_idx Performance Asc allocation_oid
resource_schedule_end_time_idx Performance Asc end_time
resource_schedule_event_group_idx Performance Asc event_group
resource_schedule_real_end_time_idx Performance Asc real_end_time
resource_schedule_real_start_time_idx Performance Asc real_start_time
resource_schedule_requested_resource_oid Performance Asc requested_rtype_oid
resource_schedule_start_time_idx Performance Asc start_time
resource_schedule_type_idx Performance Asc type
resource_schedule_uuid_idx Must be unique Asc uuid
rs_sched_res_schedule_type_idx Performance Asc/Asc type + scheduled_resource_oid
scheduled_resource_resource_schedule_idx Performance Asc scheduled_resource_oid

Check Constraints

Constraint Name Constraint
ck_proposed_or_resource_null (((proposed_resource_oid IS NULL) OR (scheduled_resource_oid IS NULL)))

Relationships

Close relationships within degrees of separation