|
smsid
|
int(11)
|
|
|
|
|
sms_gateway
|
int(11)
|
|
|
0
|
|
message_id
|
varchar(20)
|
|
|
0
|
|
campaign
|
varchar(100)
|
|
|
0
|
|
section_id
|
text
|
|
|
|
|
department_id
|
varchar(20)
|
|
|
0
|
|
student_id
|
int(11)
|
|
|
0
|
|
mobile_number
|
varchar(50)
|
|
|
0
|
|
schedule
|
int(11)
|
|
|
0
|
|
mode_of_transport
|
int(11)
|
|
|
0
|
|
schedule_date
|
datetime
|
|
|
|
|
schedule_status
|
tinyint(4)
|
|
|
0
|
|
message
|
text
|
|
|
|
|
yr_id
|
int(11)
|
|
|
|
|
sent_by
|
int(11)
|
|
|
|
|
sent_date
|
timestamp
|
|
|
current_timestamp()
|
|
modify_by
|
int(11)
|
|
|
0
|
|
modified_at
|
datetime
|
|
|
|