Table iliasRelease_4_4_x_branch.cal_entries 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
cal_id int 10 0
last_update datetime 19  √  null
title char 128  √  null
subtitle char 64  √  null
description varchar 4000  √  null
location varchar 4000  √  null
fullday tinyint 3 0
starta datetime 19  √  null
enda datetime 19  √  null
informations varchar 4000  √  null
auto_generated tinyint 3 0
context_id int 10 0
translation_type tinyint 3 0
is_milestone tinyint 3 0
completion int 10 0
notification tinyint 3 0

Table contained 0 rows at Wed Apr 27 21:48 CEST 2016

Indexes:
Column(s) Type Sort Constraint Name
cal_id Primary key Asc PRIMARY
last_update Performance Asc i1_idx
context_id Performance Asc i2_idx