|
id
|
int(11)
|
|
|
|
|
kind
|
varchar(30)
|
|
|
announcement
|
|
title
|
varchar(190)
|
|
|
|
|
body
|
text
|
|
|
|
|
link
|
varchar(255)
|
|
|
|
|
target_type
|
varchar(30)
|
|
|
all
|
|
target_user_id
|
int(11)
|
|
|
|
|
display_mode
|
varchar(40)
|
|
|
top_bar
|
|
display_position
|
varchar(40)
|
|
|
center
|
|
layout_style
|
varchar(40)
|
|
|
inline
|
|
media_position
|
varchar(40)
|
|
|
right
|
|
media_size
|
int(11)
|
|
|
46
|
|
popup_width
|
int(11)
|
|
|
560
|
|
bar_height
|
int(11)
|
|
|
0
|
|
animation_style
|
varchar(40)
|
|
|
none
|
|
bg_color
|
varchar(20)
|
|
|
#8a5a44
|
|
text_color
|
varchar(20)
|
|
|
#ffffff
|
|
accent_color
|
varchar(20)
|
|
|
#c98f6a
|
|
title_color
|
varchar(20)
|
|
|
#ffffff
|
|
body_color
|
varchar(20)
|
|
|
#ffffff
|
|
font_family
|
varchar(80)
|
|
|
|
|
font_size
|
int(11)
|
|
|
15
|
|
title_size
|
int(11)
|
|
|
17
|
|
body_size
|
int(11)
|
|
|
14
|
|
title_weight
|
int(11)
|
|
|
900
|
|
body_weight
|
int(11)
|
|
|
500
|
|
title_font_size
|
smallint(5) unsigned
|
|
|
|
|
body_font_size
|
smallint(5) unsigned
|
|
|
|
|
font_weight
|
smallint(5) unsigned
|
|
|
|
|
text_align
|
varchar(20)
|
|
|
|
|
frame_style
|
varchar(40)
|
|
|
soft
|
|
border_color
|
varchar(20)
|
|
|
#ffffff
|
|
border_width
|
int(11)
|
|
|
0
|
|
radius
|
int(11)
|
|
|
22
|
|
shadow_style
|
varchar(30)
|
|
|
soft
|
|
icon_preset
|
varchar(30)
|
|
|
|
|
box_width
|
int(11)
|
|
|
1180
|
|
box_height
|
int(11)
|
|
|
0
|
|
border_radius
|
int(11)
|
|
|
18
|
|
popup_offset
|
int(11)
|
|
|
18
|
|
z_index
|
int(11)
|
|
|
99999
|
|
media_type
|
varchar(20)
|
|
|
none
|
|
media_path
|
varchar(255)
|
|
|
|
|
media_alt
|
varchar(190)
|
|
|
|
|
icon_text
|
varchar(20)
|
|
|
|
|
icon_path
|
varchar(255)
|
|
|
|
|
button_text
|
varchar(80)
|
|
|
|
|
button_link
|
varchar(255)
|
|
|
|
|
is_active
|
tinyint(1)
|
|
|
1
|
|
allow_close
|
tinyint(1)
|
|
|
1
|
|
send_to_notifications
|
tinyint(1)
|
|
|
0
|
|
created_by_admin_id
|
int(11)
|
|
|
|
|
starts_at
|
datetime
|
|
|
|
|
ends_at
|
datetime
|
|
|
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|
|
updated_at
|
timestamp
|
|
|
|