Table webco_4.3.3.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 Fri Sep 23 14:49 CDT 2016

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: