Lithium electric cab service provider : Transforming India's urban transportation landscape through sustainable electric mobility solutions Driving positive change by promoting clean, efficient, and eco-friendly transportation options across the country. Create a greener and more sustainable future for India by revolutionizing the way people move With a mission to lead the transition towards sustainable electric mobility in India by offering a comprehensive range of electric vehicles and supporting infrastructure. We aim to provide reliable, accessible, and cost-effective transportation solutions that align with environmental conservation goals and contribute to a healthier planet. We strive to reduce the environmental impact of transportation by reducing carbon emissions – improving air quality and enhancing the overall quality of life for communities through our electric mobility solutions. Fuelling sustainable mobility – powering the way toward a greener future We are an ISO 26000 certified company recognized for implementing Guidance on Social Responsibility in Bengaluru, Delhi, Mumbai, Hyderabad and Pune below is a database tablea of litium electric cab service provider: this is the etms_trips table's schema : CREATE TABLE etms_trips ( id integer, driver_lithium_id character varying, b2b_trip_id character varying, actual_end_time timestamp without time zone, actual_pax integer, actual_start_time timestamp without time zone, billing_model character varying, branch_office_reporting_time timestamp without time zone, city_code character varying, client character varying, client_office character varying, client_trip_allocation_time timestamp without time zone, client_trip_id character varying, data_source character varying, delay_reason character varying, driver_contact_no character varying, driver_name character varying, employee_location json, first_emp_actual_pick_time timestamp without time zone, first_emp_planned_pick_time timestamp without time zone, first_pickup_delay integer, first_pickup_driver_reportin_time timestamp without time zone, has_sent_to_sf boolean, has_summary_generated boolean, isb2b boolean, is_escort boolean, is_reconciled boolean, last_emp_actual_drop_time timestamp without time zone, last_emp_planned_drop_time timestamp without time zone, lithium_cab_allocation_time timestamp without time zone, lithium_trip_id character varying, ota_otd_status character varying, ow_actual_distance double precision, ow_planned_distance double precision, planned_end_time timestamp without time zone, planned_pax integer, planned_start_time timestamp without time zone, remarks character varying, seat_utilization double precision, shift_time character varying, slab character varying, travel_time_in_mins integer, trip_date date, trip_status character varying, trip_time bigint, trip_type character varying, two_way_actual_distance double precision, vehicle_reg_no character varying, valid_trip boolean, has_cross_checked boolean, reconciled_copy_status character varying, kwh_consumed double precision, vehicle_parent_site character varying, created_at timestamp without time zone, updated_at timestamp without time zone, model character varying, created_by integer, updated_by integer, uploaded_type character varying ) definitions and relation of the columns values in the etms_trips table driver_lithium_id = This is the employee ID of the driver who has done this trip. Drivers are also referred to as service provider. actual_end_time = This is the actual end time of the trip. It is also referred to as actual trip end time. actual_pax = This is the actual passenger count in the trip excluding driver. Passengers are also referred to as employees. actual_start_time = This is the actual start time of the trip. It is also referred to as actual trip start time. billing_model = This is the billing model of the trip. The billing model defines the category in which this trip was done as per the billing models opted by the client. city_code = The is the city code for the trip. It tells in which city the trip was done. client = This is the client name for which the trip was done. client_office = This is client office name. This is location from where the employees are picked for the drop type trip or where the employee are dropped for pickup type trip. client_trip_allocation_time = This is the client trip allocation time. This will tell the time at which the trip was allocated to lithium. client_trip_id = This is the client trip ID. This is generated from the ETMS tool being used by the client. data_source = This is the data source. It will tell us from where we got the data for this trip. delay_reason = This is the reason for the trip delay. If the trip has been completed late. The reason for the same will be mentioned here. driver_contact_no = This is the contact number of the driver. It is also referred to as mobile number. driver_name = This is the name of the driver who has done this trip. Drivers are also referred to as service provider. employee_location = This is addresses for all the employees in that trip. first_emp_actual_pick_time = This is the actual pick-up time for the first employee. first_emp_planned_pick_time = This is the planned pick-up time for the first employee. first_pickup_delay = This is delay in mins for the first pick-up. If the actual pick-up time is more than the planned pick-up time. is_escort = This is escort related information. It means that if any security guard is also travelling with the employees in car for there safety. last_emp_actual_drop_time = This is the actual drop time for the last employee. last_emp_planned_drop_time = This is the planned drop time for the last employee. lithium_cab_allocation_time = This is the lithium cab allocation time. It tells when the vehicle was allocated for this trip lithium_trip_id = This is the lithium trip ID. This is the unique identifier for this record from lithium's side. It is also known trip ID. ow_actual_distance = This is the one way actual distance of the trip. ow_planned_distance = This is the one way planned distance of the trip. planned_end_time = This is the planned end time of the trip planned_pax = This is the planned passenger count in the trip excluding driver. Passengers are also referred to as employees. planned_start_time = This is the planned start time of the trip seat_utilization = This is the seat utilization for the trip. This is calculated based on the passenger count. shift_time = This is the shift time for the trip. The trips are planned as per the shift timings, to make they start and end on time. slab = This is the classification of trips as per the kilometres that need to be travelled for the trip. travel_time_in_mins = This is the actual time spent on trip in minutes. trip_status = This is the status of the trip. trip_type = This is trip type. If its pickup, that means the employee needs to be picked from their home and dropped to office. If its drop, that means the employee needs to be picked from office and dropped to their homes. two_way_actual_distance = This is the two way actual distance of the trip. vehicle_reg_no = This is the registration number of the vehicle which was used for the trip. The vehicles are also referred to as cab & car. vehicle_parent_site = This is the vehicle parent site. It tells about the parent site site of the vehicle who has done this trip. Model = This is vehicle model. It tells the model of the car which has been used to do this trip.