maintenance_type

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
obj_oid int8 19 null
maintenance_schedule.maintenance_type_oid kmaintsched_mtype_oidR
name varchar 2147483647 null
organization_oid int8 19 √ null
organization.obj_oid fkmainttype_org_oidR
summary varchar 2147483647 √ null
description varchar 2147483647 √ null
active bool 1 true
default_frequency cl_frequency 2147483647 √ null
default_duration interval 49,6 √ null
default_start_time_minutes int4 10 √ null
default_person_oid int8 19 √ null
person.obj_oid fkmainttype_person_oidN
default_vendor_oid int8 19 √ null
vendor.obj_oid fkmainttype_vendor_oidN
default_ticket_type_oid int8 19 √ null
ticket_type.obj_oid fkmainttype_ticket_type_oidN
default_priority_oid int8 19 √ null
ticket_priority.obj_oid fkmainttype_priority_oidN
default_severity_oid int8 19 √ null
ticket_severity.obj_oid fkmainttype_severity_oidN
default_problem_type_oid int8 19 √ null
ticket_problem_type.obj_oid fkmainttype_problem_type_oidN
default_remedy_type_oid int8 19 √ null
ticket_remedy_type.obj_oid fkmainttype_remedy_type_oidN

Indexes

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

Relationships

Close relationships within degrees of separation