SchemaSpy - Table iliasRelease_4_4_x_branch.il_news

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
priority	int	10	√	1
title	varchar	200	√	null
content	longtext	2147483647	√	null
context_obj_id	int	10	√	null
context_obj_type	varchar	10	√	null
context_sub_obj_id	int	10	√	null
context_sub_obj_type	varchar	10	√	null
content_type	char	5	√	text
creation_date	datetime	19	√	null
update_date	datetime	19	√	null
user_id	int	10	√	null
visibility	char	6	√	users
content_long	longtext	2147483647	√	null
content_is_lang_var	tinyint	3	√	0
mob_id	int	10	√	null
playtime	varchar	8	√	null
start_date	datetime	19	√	null
end_date	datetime	19	√	null
content_text_is_lang_var	tinyint	3		0
mob_cnt_download	int	10		0
mob_cnt_play	int	10		0

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

Indexes:

Column(s)	Type	Sort	Constraint Name
id	Primary key	Asc	PRIMARY
context_obj_id	Performance	Asc	i1_idx
creation_date	Performance	Asc	i2_idx
mob_id	Performance	Asc	mo_idx