Table ilias4_3.cal_categories 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
cat_id int 10 0
obj_id int 10 0
title char 128  √  null
color char 8  √  null
type tinyint 3 0
loc_type tinyint 3 1
remote_url varchar 500  √  null
remote_user varchar 50  √  null
remote_pass varchar 50  √  null
remote_sync datetime 19  √  null

Table contained 0 rows at Sun May 01 00:15 CEST 2016

Indexes:
Column(s) Type Sort Constraint Name
cat_id Primary key Asc PRIMARY
obj_id Performance Asc i2_idx
type Performance Asc i3_idx