Table webco_4.4.1.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
group_authorization.rtype_oid group_authorization_rtype_oid_fkey
group_resource_type.rtype_oid group_resource_type_rtype_oid_fkey
resource.rtype_oid resource_rtype_oid_fkey
resource_type_fallback.fallback_oid resource_type_fallback_fallback_oid_fkey
resource_type_fallback.type_oid resource_type_fallback_type_oid_fkey
rtid 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
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
open_group_oid int8 19  √  null
wco_group.obj_oid fkcresource_type_open_group_oid
org_oid int8 19  √  null
organization.obj_oid fkcresource_type_org_oid

Table contained 0 rows at Fri Mar 24 10:48 CDT 2017

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

Close relationships  within of separation: