| id |
bigint(20)
|
|
|
|
| user_id |
bigint(20)
|
|
|
|
| patient_ref_id |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| respondent_name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| respondent_email |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| respondent_age |
int(11)
|
|
|
|
| respondent_gender |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| education |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| diagnosis |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| disease_name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| consent |
tinyint(1)
|
|
|
|
| institute |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| option_answers |
longtext
|
utf8mb4_bin
|
|
|
| table_answers |
longtext
|
utf8mb4_bin
|
|
|
| option_raw |
int(11)
|
|
|
|
| table_raw |
int(11)
|
|
|
|
| total_raw |
int(11)
|
|
|
|
| total_pct |
decimal(5,2)
|
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|