event_data

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
event_id VARCHAR 32 null
author_id VARCHAR 32 null
editor_id VARCHAR 32 √ null
uid VARCHAR 255 null
start INT UNSIGNED 10 0
end INT UNSIGNED 10 0
summary VARCHAR 255
description TEXT 65535 √ null
class enum('PUBLIC', 'PRIVATE', 'CONFIDENTIAL') 12 PRIVATE
categories TINYTEXT 255 √ null
category_intern TINYINT UNSIGNED 3 0
priority TINYINT UNSIGNED 3 0
location TINYTEXT 255 √ null
ts INT UNSIGNED 10 0
linterval SMALLINT UNSIGNED 5 √ null
sinterval SMALLINT UNSIGNED 5 √ null
wdays VARCHAR 7 √ null
month TINYINT UNSIGNED 3 √ null
day TINYINT UNSIGNED 3 √ null
rtype enum('SINGLE', 'DAILY', 'WEEKLY', 'MONTHLY', 'YEARLY') 7 SINGLE
duration SMALLINT UNSIGNED 5 0
count SMALLINT 5 √ 0
expire INT UNSIGNED 10 0
exceptions TEXT 65535 √ null
mkdate INT UNSIGNED 10 0
chdate INT UNSIGNED 10 0
importdate INT 10 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc event_id
autor_id Performance Asc author_id
uid Must be unique Asc uid

Diagram producer might be missing

No diagrams were produced please see application output for any errors