|
attachment_id
|
bigint(20) unsigned
|
|
|
|
|
school_code
|
varchar(30)
|
|
|
|
|
notification_id
|
bigint(20) unsigned
|
|
|
0
|
|
attachment_type
|
enum
|
-- |
|
image
|
|
attachment_name
|
varchar(255)
|
|
|
|
|
attachment_path
|
varchar(255)
|
|
|
|
|
attachment_caption
|
varchar(255)
|
|
|
|
|
thumbnail_path
|
varchar(255)
|
|
|
|
|
file_size
|
bigint(20) unsigned
|
|
|
0
|
|
file_extension
|
varchar(20)
|
|
|
|
|
mime_type
|
varchar(150)
|
|
|
|
|
sort_order
|
int(11)
|
|
|
0
|
|
is_active
|
tinyint(1)
|
|
|
1
|
|
delete_status
|
tinyint(1)
|
|
|
0
|
|
created_at
|
datetime
|
|
|
current_timestamp()
|