SchemaSpy - Table ilias4

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column	Type	Size	Nulls	Default
id	int	10		0
rep_obj_id	int	10		0
obj_id	int	10		0
obj_type	varchar	10	√	null
type	int	10		0
author	int	10		0
note_text	longtext	2147483647	√	null
label	int	10		0
creation_date	datetime	19	√	null
update_date	datetime	19	√	null
subject	varchar	200	√	null
no_repository	tinyint	3	√	0

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

Indexes:

Column(s)	Type	Sort	Constraint Name
id	Primary key	Asc	PRIMARY
author	Performance	Asc	i1_idx
rep_obj_id + obj_id + obj_type	Performance	Asc/Asc/Asc	i2_idx