|
message_id
|
bigint(20) unsigned
|
|
|
|
|
school_code
|
varchar(30)
|
|
|
|
|
homework_id
|
bigint(20) unsigned
|
|
|
|
|
student_id
|
bigint(20) unsigned
|
|
|
|
|
sender_type
|
enum
|
-- |
|
parent
|
|
sender_id
|
bigint(20) unsigned
|
|
|
0
|
|
sender_name
|
varchar(150)
|
|
|
|
|
message_text
|
text
|
|
|
|
|
attachment_path
|
text
|
|
|
|
|
attachment_type
|
varchar(50)
|
|
|
|
|
attachment_name
|
varchar(255)
|
|
|
|
|
is_read_by_parent
|
tinyint(1)
|
|
|
1
|
|
is_read_by_teacher
|
tinyint(1)
|
|
|
0
|
|
is_active
|
tinyint(1)
|
|
|
1
|
|
delete_status
|
tinyint(1)
|
|
|
0
|
|
created_at
|
datetime
|
|
|
current_timestamp()
|
|
updated_at
|
datetime
|
|
|
|