URL -35.200.164.
184
port -3306
user-test_read
password-test_read
SELECT * FROM cardiotrack_test.patient order by created_on desc;
SELECT count(*) FROM cardiotrack_test.patient where cardiotrack_version =
'C8FD195691F1'order by created_on desc;
SELECT * FROM cardiotrack_test.cardiotrack_device_tbl where
cardiotrack_device_id='ME18ABB005';
select
id,name,age,gender,waist,abdomen,chest,hip,height,bmi,body_fat,bone_mass,muscle_mas
s,body_water,waist_hip_ratio,waist_height_ratio FROM cardiotrack_test.patient
where id = 'CLI015@143@19420193242849252';
select
id,name,age,gender,waist,abdomen,chest,hip,height,bmi,body_fat,bone_mass,muscle_mas
s,body_water,waist_hip_ratio,waist_height_ratio FROM cardiotrack_test.patient
where id = 'CLI015@143@184201919283668527';
select
id,name,age,gender,waist,abdomen,chest,hip,height,bmi,body_fat,bone_mass,muscle_mas
s,body_water,waist_hip_ratio,waist_height_ratio FROM cardiotrack_test.patient
where id = 'CLI015@143@184201910493468887';
cans in latest version - 1.26
select * FROM cardiotrack_test.patient where id ='CLI015@143@23420191441581664';
select count(*) FROM cardiotrack_test.file_content where file_name like
'CLI01808@1@9520191415617742%';
get file count of files uploaded.
SELECT count(*) FROM cardiotrack_test.specialist_patient_table where pat_uid like
'CLI01808@1@9520191415617742%';
describe cardiotrack_test.patient;
select
id,name,age,gender,waist,abdomen,chest,hip,height,bmi,body_fat,bone_mass,muscle_mas
s,body_water,waist_hip_ratio,waist_height_ratio FROM cardiotrack_test.patient
where id = 'CLI015@143@234201914515734094';
ver -1.27
select * FROM cardiotrack_test.patient where id ='CLI01808@1@2642019182676252';
select * FROM cardiotrack_test.patient where id like
'CLI01808@1@205201915134443284%';
select * FROM cardiotrack_test.patient where id like
'CLI015@143@23420191441581664%';
select count(*) FROM cardiotrack_test.file_content where file_name like
'CLI01808@1@115201915372410009%';
SELECT count(*) FROM cardiotrack_test.specialist_patient_table where pat_uid like
'CLI01808@1@9520191415617742%';
select * FROM cardiotrack_test.patient where id like
'CLI01791@1@105201915165226196%';
select count(*) FROM cardiotrack_test.file_content where file_name like
'CLI01791@1@105201915165226196%';
select * FROM cardiotrack_test.file_content where file_name like
'CLI01791@1@105201915165226196%';
SELECT count(*) FROM cardiotrack_test.specialist_patient_table where pat_uid like
'CLI01791@1@105201915165226196%';
SELECT * FROM cardiotrack_test.specialist_patient_table where pat_uid like
'pat031@2019051302560039614491%';
SELECT * FROM cardiotrack_test.ct_patient where patientId like
'pat031@2019051302524924426238%';
select count(*) FROM cardiotrack_test.file_content where file_name like
'pat031@2019051302524924426238%';
select * FROM cardiotrack_test.file_content where file_name like
'pat031@2019051302524924426238%';
SELECT count(*) FROM cardiotrack_test.specialist_patient_table where pat_uid like
'pat031@2019051302524924426238%';
SELECT * FROM cardiotrack_test.specialist_patient_table where pat_uid like
'pat031@2019051302524924426238%';
select * FROM cardiotrack_test.patient where id like
'CLI01791@1@165201917151552013%';
select count(*) FROM cardiotrack_test.file_content where file_name like
'CLI01791@1@165201917151552013%';
select * FROM cardiotrack_test.file_content where file_name like
'CLI01791@1@165201917151552013%';
SELECT * FROM cardiotrack_test.specialist_patient_table where pat_uid like
'CLI01791@1@165201917151552013%';
select * FROM cardiotrack_test.patient where id like
'CLI01793@7@76201915283559013%';
select count(*) FROM cardiotrack_test.file_content where file_name like
'CLI01793@7@76201915283559013%';
select * FROM cardiotrack_test.file_content where file_name like
'CLI01793@7@76201915283559013%';
SELECT * FROM cardiotrack_test.specialist_patient_table where pat_uid like
'CLI01793@7@76201915283559013%';
select * FROM cardiotrack_test.patient where id like
'CLI01793@7@76201915133919240%';
select count(*) FROM cardiotrack_test.file_content where file_name like
'CLI01793@7@76201915133919240%';
select * FROM cardiotrack_test.file_content where file_name like
'CLI01793@7@76201915133919240%';
SELECT * FROM cardiotrack_test.specialist_patient_table where pat_uid like
'CLI01793@7@76201915133919240%';
fetching data for ME90 capturing the device id
select * FROM cardiotrack_test.patient where id like
'CLI01807@3@126201910344834581%';
'CLI01807@3@126201910344834581', 'Test Samsung 9 Ver 28 Jio Fix', '55', 'Female',
'2019-06-12 10:34:51', 'Active', '', '', '', '2', '100', '180', '55', '49', '65',
'Positive', 'Positive', '16', '', 'T_1.34', 'D43639DAC83D', '356650102221506',
'5575866866', '1905160179314550', 'DegC', 'Random Blood Glucose', '144',
'Positive', 'Hypertensive Crisis', 'Positive', 'Positive', 'N', NULL, '159', '',
'2019-06-12 05:05:51', '1', 'N', 'Y', 'U', '65', '45', '130', '45', '195', '17.09',
'27.76', '18.74', '72.24', '53.5', '1.44', '0.33'
select count(*) FROM cardiotrack_test.file_content where file_name like
'CLI01807@3@126201910344834581%';
select * FROM cardiotrack_test.file_content where file_name like
'CLI01807@3@126201910344834581%';
# id, file_name, createdon, heart_rate, P_Wave, PR_Segment, PR_Interval,
QRS_Complex, ST_Segment, T_Wave, QT_Interval, QTc_Interval, RR_Interval,
heart_rate_msg, hr_msg_time, QRS_Axis
'435278', 'CLI01807@3@126201910344834581_001.dat', '2019-06-12 10:35:44', '77',
'0', '0', '0', '0', '0', '0', '0', '0', '0', 'ME90', '2019-06-12 10:35:44', ''
SELECT * FROM cardiotrack_test.specialist_patient_table where pat_uid like
'CLI01807@3@126201910344834581%';
# register_id, fname, lname, age, gender, mob_no, email_id, pat_uid, file_name,
push_token, zoom_id, zoom_token, status, concerned_doc, severity, refered_doc_id,
reffered_doc_name, timestamp, request_type, opinion_given_by, upd_time
'4738', 'Test Samsung 9 Ver 28 Jio Fix', 'NA', '55', 'Female', '5575866866', NULL,
'CLI01807@3@126201910344834581', NULL, NULL, NULL, NULL, '~Otherwise normal ECG',
'DOC001', 'Severe', 'CLI01807', 'Bhaskar l', '2019-06-12 05:06:04', 'M', 'DOC001',
'2019-06-12 05:10:06'
scan id -126201910502414626
select * FROM cardiotrack_test.patient where id like
'CLI01807@3@126201910502414626%';
# id, name, age, gender, created_on, status, pdesc, p_email, p_image, lead_type,
p_spo2, p_bp_systalic, p_bp_diastalic, p_teperature, p_body_weight,
p_malaria_test_result, p_hiv_test_result, p_haemoglobin_measurement, p_symptoms,
app_version, cardiotrack_version, android_id, patient_mobile, patient_citzen_id,
temprature_type, blood_sugar_type, blood_sugar, diabetes_test, hypertension_result,
obesity, smoker, cardiologs_status, location, cholesterol, doctor_name,
system_timestamp, total_number_of_file, cardioAI_status, ecg_closed_properly,
zipstatus, waist, abdomen, chest, hip, height, bmi, body_fat, bone_mass,
muscle_mass, body_water, waist_hip_ratio, waist_height_ratio
'CLI01807@3@126201910502414626', 'Test Me90 Android 9 Ver 34', '58', 'Male',
'2019-06-12 10:51:55', 'Active', '', '', '', '2', '99', '180', '80', '49', '85',
'Negative', 'Negative', '14', '1 Fatigue or confusion. 2 Blood in the urine. 3
Pain, numbness, weakness or coldness in the legs or arms', 'T_1.34',
'D43639DAC83D', '356650102221506', '5856958669', '1906120180710502', 'DegC',
'Fasting Blood Glucose', 'low', 'Negative', 'Hypertension Stage 1', 'Negative',
'Negative', 'N', NULL, 'low', '', '2019-06-12 05:23:00', '1', 'N', 'Y', 'U', '52',
'52', '150', '52', '165', '31.22', '34.61', '14.29', '65.39', '51.1', '1', '0.32'
select count(*) FROM cardiotrack_test.file_content where file_name like
'CLI01807@3@126201910502414626%';
select * FROM cardiotrack_test.file_content where file_name like
'CLI01807@3@126201910502414626%';
# id, file_name, createdon, heart_rate, P_Wave, PR_Segment, PR_Interval,
QRS_Complex, ST_Segment, T_Wave, QT_Interval, QTc_Interval, RR_Interval,
heart_rate_msg, hr_msg_time, QRS_Axis
'435279', 'CLI01807@3@126201910502414626_001.dat', '2019-06-12 10:52:55', '73',
'0', '0', '0', '0', '0', '0', '0', '0', '0', 'ME90', '2019-06-12 10:52:55', ''
SELECT * FROM cardiotrack_test.specialist_patient_table where pat_uid like
'CLI01807@3@126201910502414626%';
# register_id, fname, lname, age, gender, mob_no, email_id, pat_uid, file_name,
push_token, zoom_id, zoom_token, status, concerned_doc, severity, refered_doc_id,
reffered_doc_name, timestamp, request_type, opinion_given_by, upd_time
'4739', 'Test Me90 Android 9 Ver 34', 'NA', '58', 'Male', '5856958669', NULL,
'CLI01807@3@126201910502414626', NULL, NULL, NULL, NULL, 'Under Processing',
'DOC024', 'Pending', 'CLI01807', 'Bhaskar l', '2019-06-12 05:35:36', 'M', NULL,
'2019-06-12 05:35:37'
126201910502414626
126201910564856993
126201910582051316
126201910593316377
12620191104717794
