resource_type

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
obj_oid int8 19 null
inventory_selector.resource_type_oid inventory_selector_resource_type_oid_fkeyN
maintenance_schedule.rtype_oid kmaintsched_rtype_oidR
resource.rtype_oid resource_rtype_oid_fkeyR
resource_type_certification.resource_type_oid resource_type_certification_resource_type_oid_fkeyC
resource_type_fallback.fallback_oid resource_type_fallback_fallback_oid_fkeyC
resource_type_fallback.type_oid resource_type_fallback_type_oid_fkeyC
ticket_assignment_rule.resource_type_oid tar_rtype_oidC
type_allocation_usage_data.resource_type_oid type_allocation_usage_data_resource_type_oid_fkeyC
unique_identifier varchar 2147483647 null
parent_oid int8 19 √ null
modified timestamptz 35,6 √ null
deleted bool 1 √ null
origin varchar 2147483647 null
name varchar 2147483647 √ null
path varchar 2147483647 √ null
description varchar 2147483647 √ null
requires_certification bool 1 false
caption varchar 2147483647 √ null
authorized bool 1 √ null
pir_p bool 1 √ true
image_url varchar 2147483647 √ null
description_url varchar 2147483647 √ null
link_text varchar 2147483647 √ null
value money 2147483647 √ null
org_oid int8 19 √ null
organization.obj_oid fkcresource_type_org_oidC

Indexes

Constraint Name Type Sort Column(s)
resource_type_pkey Primary key Asc obj_oid
resource_type_unique_identifier_idx Must be unique Asc unique_identifier

Relationships

Close relationships within degrees of separation