Table webco_4.7.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
name varchar 2147483647  √  null
title varchar 2147483647  √  null
external_id 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:20 CST 2019

Indexes:
Column(s) Type Sort Constraint Name Anomalies
obj_oid Primary key Asc resource_type_certification_pkey  
effective_date Performance Asc resource_type_certification_effective_date_idx  
expiration_date Performance Asc resource_type_certification_expiration_date_idx  
external_id Must be unique Asc resource_type_certification_external_id_key This unique column is also nullable
name Must be unique Asc resource_type_certification_name_key This unique column is also nullable
person_oid Performance Asc resource_type_certification_person_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: