il_news_item

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
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
orgu_obj_type_settings.obj_type Implied ConstraintR
context_sub_obj_id INT 10 null
context_sub_obj_type VARCHAR 10 null
orgu_obj_type_settings.obj_type Implied ConstraintR
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
content_html TINYINT 3 0
update_user_id INT 10 0

Indexes

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

Relationships