Table zot.dreport 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
dreport_id int 10  √ 
dreport_channel int 10 0
dreport_mid char 255
dreport_site char 255
dreport_recip char 255
dreport_result char 255
dreport_time datetime 19 0000-00-00 00:00:00
dreport_xchan char 255
xchan.xchan_hash Defined in XML R
dreport_queue char 255

Table contained 8 579 rows at fr nov 06 17:11 CET 2015

Indexes:
Column(s) Type Sort Constraint Name
dreport_id Primary key Asc PRIMARY
dreport_channel Performance Asc dreport_channel
dreport_mid Performance Asc dreport_mid
dreport_queue Performance Asc dreport_queue
dreport_site Performance Asc dreport_site
dreport_time Performance Asc dreport_time
dreport_xchan Performance Asc dreport_xchan

Close relationships  within of separation: