Table webco_5.0.public.section_member 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
origin varchar 2147483647  √  null
section_oid int8 19  √  null
section.obj_oid fkc_section_member_section_oid
member_oid int8 19  √  null
person.obj_oid fkc_section_member_member_oid
start_date timestamptz 35,6  √  null
end_date timestamptz 35,6  √  null
created_date timestamptz 35,6  √  null
status wcof_tag 2147483647

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 section_member_pkey  
member_oid Performance Asc section_member_member_oid_idx  
section_oid Performance Asc section_member_section_oid_idx  
section_oid + member_oid Must be unique Asc/Asc unique_section_member These unique columns are also nullable

Close relationships  within of separation: