Table webco_5.0.public.resource_type_certification 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
certification_id varchar 2147483647  √  null
title varchar 2147483647  √  null
description varchar 2147483647  √  null
resource_type_oid int8 19  √  null
resource_type.obj_oid resource_type_certification_resource_type_oid_fkey
person_oid int8 19  √  null
person.obj_oid resource_type_certification_person_oid_fkey
effective_date timestamptz 35,6
expiration_date timestamptz 35,6  √  null
revocation_date timestamptz 35,6  √  null
revocation_note varchar 2147483647  √  null
origin varchar 2147483647
status wcof_tag 2147483647 'PENDING'::wcof_tag

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

Indexes:
Column(s) Type Sort Constraint Name Anomalies
obj_oid Primary key Asc resource_type_certification_pkey  
certification_id Must be unique Asc resource_type_certification_certification_id_key This unique column is also nullable
effective_date Performance Asc resource_type_certification_effective_date_idx  
expiration_date Performance Asc resource_type_certification_expiration_date_idx  
person_oid Performance Asc resource_type_certification_person_idx  
person_oid + resource_type_oid Performance Asc/Asc resource_type_certification_person_rtype_idx  
resource_type_oid Performance Asc resource_type_certification_resource_type_idx  
status Performance Asc resource_type_certification_status_idx  

Close relationships  within of separation: