maintenance_schedule

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
obj_oid int8 19 null
maintenance_event.maintenance_schedule_oid kmaintevent_msched_oidR
name varchar 2147483647 null
rtype_oid int8 19 null
resource_type.obj_oid kmaintsched_rtype_oidR
maintenance_type_oid int8 19 null
maintenance_type.obj_oid kmaintsched_mtype_oidR
description varchar 2147483647 √ null
active bool 1 true
auto_take_offline bool 1 false
frequency cl_frequency 2147483647 √ null
duration interval 49,6 √ null
start_time_minutes int4 10 √ null
person_oid int8 19 √ null
person.obj_oid fkmaintsched_person_oidN
vendor_oid int8 19 √ null
vendor.obj_oid fkmaintsched_vendor_oidN
ticket_type_oid int8 19 √ null
ticket_type.obj_oid fkmaintsched_ticket_type_oidN
priority_oid int8 19 √ null
ticket_priority.obj_oid fkmaintsched_priority_oidN
severity_oid int8 19 √ null
ticket_severity.obj_oid fkmaintsched_severity_oidN
problem_type_oid int8 19 √ null
ticket_problem_type.obj_oid fkmaintsched_problem_type_oidN
remedy_type_oid int8 19 √ null
ticket_remedy_type.obj_oid fkmaintsched_remedy_type_oidN

Indexes

Constraint Name Type Sort Column(s)
maintenance_schedule_pkey Primary key Asc obj_oid

Relationships

Close relationships within degrees of separation