Table webco_4.7.public.subscription 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
subscription_contact.subscription_oid fksubscription_notification_subscription
subscription_notification.subscription_oid fksubscription_notification_subscription
person_oid int8 19
person.obj_oid fksubscription_person_oid
entity_type varchar 2147483647  √  null
entity_oid int8 19  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
obj_oid Primary key Asc subscription_pkey
entity_oid Performance Asc subscription_entity_oid_idx
entity_type Performance Asc subscription_entity_type_idx
person_oid Performance Asc subscription_person_oid_idx

Close relationships  within of separation: