|
id
|
bigint(20) unsigned
|
|
|
|
|
user_id
|
bigint(20) unsigned
|
|
|
|
|
patient_ref_id
|
varchar(255)
|
|
|
|
|
respondent_name
|
varchar(255)
|
|
|
|
|
respondent_email
|
varchar(255)
|
|
|
|
|
respondent_age
|
int(11)
|
|
|
|
|
respondent_gender
|
varchar(255)
|
|
|
|
|
education
|
varchar(255)
|
|
|
|
|
diagnosis
|
varchar(255)
|
|
|
|
|
disease_name
|
varchar(255)
|
|
|
|
|
consent
|
tinyint(1)
|
|
|
0
|
|
institute
|
varchar(255)
|
|
|
|
|
answers
|
longtext
|
|
|
|
|
cat1_raw
|
int(11)
|
|
|
0
|
|
cat2_raw
|
int(11)
|
|
|
0
|
|
cat3_raw
|
int(11)
|
|
|
0
|
|
cat4_raw
|
int(11)
|
|
|
0
|
|
cat1_pct
|
decimal(5,2)
|
|
|
0.00
|
|
cat2_pct
|
decimal(5,2)
|
|
|
0.00
|
|
cat3_pct
|
decimal(5,2)
|
|
|
0.00
|
|
cat4_pct
|
decimal(5,2)
|
|
|
0.00
|
|
total_raw
|
int(11)
|
|
|
0
|
|
total_pct
|
decimal(5,2)
|
|
|
0.00
|
|
created_at
|
timestamp
|
|
|
|
|
updated_at
|
timestamp
|
|
|
|