Table studipjlu_23.calendar_events 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
event_id varchar 32
log_events.event_id Implied Constraint R
resources_temporary_events.event_id Implied Constraint R
range_id varchar 32
autor_id varchar 32
editor_id varchar 32
uid varchar 255
start int unsigned 10 0
end int unsigned 10 0
summary varchar 255
description text 65535  √  null
class enum 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 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

Table contained 0 rows at Do Aug 02 15:36 GMT+01:00 2018

Indexes:
Column(s) Type Sort Constraint Name
event_id Primary key Asc PRIMARY
autor_id Performance Asc autor_id
range_id + class Performance Asc/Asc range_id
uid + range_id Must be unique Asc/Asc uid_range

Close relationships: