|
student_trip_status_id
|
int(11)
|
|
|
|
|
company_id
|
int(11)
|
|
|
1
|
|
branch_id
|
int(11)
|
|
|
1
|
|
trip_id
|
int(11)
|
|
|
0
|
|
route_id
|
int(11)
|
|
|
0
|
|
stop_id
|
int(11)
|
|
|
0
|
|
student_id
|
int(11)
|
|
|
0
|
|
student_name
|
varchar(150)
|
|
|
|
|
class_name
|
varchar(80)
|
|
|
|
|
section_name
|
varchar(80)
|
|
|
|
|
trip_type
|
varchar(30)
|
|
|
pickup
|
|
status
|
varchar(30)
|
|
|
pending
|
|
status_time
|
datetime
|
|
|
|
|
remarks
|
text
|
|
|
|
|
updated_by
|
int(11)
|
|
|
0
|
|
created_at
|
datetime
|
|
|
current_timestamp()
|
|
updated_at
|
datetime
|
|
|
current_timestamp()
|