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

Close relationships within degrees of separation