Table webco_5.0.public.resource_type Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
obj_oid int8 19
inventory_selector.resource_type_oid inventory_selector_resource_type_oid_fkey
resource.rtype_oid resource_rtype_oid_fkey
resource_type_certification.resource_type_oid resource_type_certification_resource_type_oid_fkey
resource_type_fallback.fallback_oid resource_type_fallback_fallback_oid_fkey
resource_type_fallback.type_oid resource_type_fallback_type_oid_fkey
unique_identifier varchar 2147483647
parent_oid int8 19  √  null
modified timestamptz 35,6  √  null
deleted bool 1  √  null
origin varchar 2147483647
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 odcl_money 2147483647  √  null
org_oid int8 19  √  null
organization.obj_oid fkcresource_type_org_oid

Table contained 0 rows at Thu Feb 14 09:10 CST 2019

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

Close relationships  within of separation: