Table webco_3.9.3.public.mail_event 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
mail_type varchar 2147483647  √  null
allocation_reminder_interval_oid int8 19  √  null
allocation_reminder_interval.obj_oid fkmail_event_alloc_reminder_interval_oid
allocation_oid int8 19  √  null
allocation.obj_oid fkmail_event_alloc_oid
send_time timestamp 29,6  √  null

Table contained 0 rows at Wed May 07 11:05 EDT 2014

Indexes:
Column(s) Type Sort Constraint Name
allocation_oid Performance Asc mail_event_allocation_idx
allocation_reminder_interval_oid Performance Asc mail_event_allocation_reminder_interavl_idx
obj_oid Must be unique Asc mail_event_obj_oid_key

Close relationships  within of separation: