Table zot.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
id int 10  √ 
notify.id Implied Constraint R
aid int unsigned 10 0
uid int 10 0
event_xchan char 255
xchan.xchan_hash Defined in XML R
event_hash char 255
hubloc.hubloc_hash Defined in XML R
channel.channel_hash Defined in XML R
xchan.xchan_hash Defined in XML R
created datetime 19 0000-00-00 00:00:00
edited datetime 19 0000-00-00 00:00:00
start datetime 19 0000-00-00 00:00:00
finish datetime 19 0000-00-00 00:00:00
summary text 65535
description text 65535
location text 65535
type char 255
nofinish bit 0 0
adjust bit 0 1
ignore bit 0 0
allow_cid mediumtext 16777215
allow_gid mediumtext 16777215
deny_cid mediumtext 16777215
deny_gid mediumtext 16777215
event_status char 255
event_status_date datetime 19 0000-00-00 00:00:00
event_percent smallint 5 0
event_repeat text 65535
event_sequence smallint 5 0
event_priority smallint 5 0
event_vdata text 65535

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
adjust Performance Asc adjust
aid Performance Asc aid
event_hash Performance Asc event_hash
event_priority Performance Asc event_priority
event_sequence Performance Asc event_sequence
event_status Performance Asc event_status
event_xchan Performance Asc event_xchan
finish Performance Asc finish
ignore Performance Asc ignore
nofinish Performance Asc nofinish
start Performance Asc start
type Performance Asc type
uid Performance Asc uid

Close relationships  within of separation: