| id |
int(100)
|
|
|
|
| img_url |
varchar(100)
|
utf8_general_ci
|
|
|
| name |
varchar(100)
|
utf8_general_ci
|
|
|
| email |
varchar(1000)
|
utf8_general_ci
|
|
|
| doctor |
varchar(100)
|
utf8_general_ci
|
|
|
| address |
varchar(100)
|
utf8_general_ci
|
|
|
| phone |
varchar(100)
|
utf8_general_ci
|
|
|
| sex |
varchar(100)
|
utf8_general_ci
|
|
|
| birthdate |
varchar(100)
|
utf8_general_ci
|
|
|
| age |
varchar(100)
|
utf8_general_ci
|
|
|
| bloodgroup |
varchar(100)
|
utf8_general_ci
|
|
|
| ion_user_id |
varchar(100)
|
utf8_general_ci
|
|
|
| patient_id |
varchar(100)
|
utf8_general_ci
|
|
|
| add_date |
varchar(100)
|
utf8_general_ci
|
|
|
| registration_time |
varchar(100)
|
utf8_general_ci
|
|
|
| how_added |
varchar(100)
|
utf8_general_ci
|
|
|
| hospital_id |
varchar(100)
|
utf8_general_ci
|
|
|
| appointment_confirmation |
varchar(1000)
|
utf8_general_ci
|
|
|
| appointment_creation |
varchar(1000)
|
utf8_general_ci
|
|
|
| payment_confirmation |
varchar(100)
|
utf8_general_ci
|
|
|
| meeting_schedule |
varchar(1000)
|
utf8_general_ci
|
|
|
| language |
varchar(100)
|
utf8_general_ci
|
|
|
| national_id |
varchar(100)
|
utf8_general_ci
|
|
|
| height |
varchar(100)
|
utf8_general_ci
|
|
|
| weight |
varchar(100)
|
utf8_general_ci
|
|
|
| known_allergies |
varchar(200)
|
utf8_general_ci
|
|
|
| medical_history |
varchar(200)
|
utf8_general_ci
|
|
|
| emergency_contact_name |
varchar(255)
|
utf8_general_ci
|
|
|
| emergency_contact_number |
varchar(255)
|
utf8_general_ci
|
|
|
| disease |
varchar(100)
|
utf8_general_ci
|
|
|
| body_mass_index |
varchar(300)
|
utf8_general_ci
|
|
|
| habits |
varchar(300)
|
utf8_general_ci
|
|
|
| do_you_use_tobacco |
varchar(100)
|
utf8_general_ci
|
|
|
| do_you_use_alcohol |
varchar(100)
|
utf8_general_ci
|
|
|
| do_you_use_drugs |
varchar(100)
|
utf8_general_ci
|
|
|
| physical_activity |
varchar(300)
|
utf8_general_ci
|
|
|
| allergies |
varchar(300)
|
utf8_general_ci
|
|
|
| cardiovascular_risk_factors |
varchar(100)
|
utf8_general_ci
|
|
|
| previous_illnesses |
varchar(300)
|
utf8_general_ci
|
|
|
| are_you_on_medication |
varchar(300)
|
utf8_general_ci
|
|
|
| surgical_interventions |
varchar(300)
|
utf8_general_ci
|
|
|
| vaccination_status |
varchar(100)
|
utf8_general_ci
|
|
|
| family_history |
varchar(300)
|
utf8_general_ci
|
|
|
| marital_status |
varchar(100)
|
utf8_general_ci
|
|
|
| children |
varchar(100)
|
utf8_general_ci
|
|
|
| morbid_history |
varchar(300)
|
utf8_general_ci
|
|
|
| diseases |
varchar(300)
|
utf8_general_ci
|
|
|
| nutrition |
varchar(300)
|
utf8_general_ci
|
|
|
| emotional_status |
varchar(300)
|
utf8_general_ci
|
|
|
| reproductive_status |
varchar(100)
|
utf8_general_ci
|
|
|
| date_of_last_menstrual_period |
varchar(100)
|
utf8_general_ci
|
|
|
| date_of_last_gynecological_examination |
varchar(100)
|
utf8_general_ci
|
|
|
| pregnancies |
varchar(100)
|
utf8_general_ci
|
|
|
| contraceptive_method |
varchar(300)
|
utf8_general_ci
|
|
|
| previous_jobs |
varchar(300)
|
utf8_general_ci
|
|
|
| length_of_last_employment |
varchar(300)
|
utf8_general_ci
|
|
|
| risk_factors_for_last_employment |
varchar(300)
|
utf8_general_ci
|
|
|
| hours_covered_for_last_employment |
varchar(300)
|
utf8_general_ci
|
|
|
| current_position |
varchar(300)
|
utf8_general_ci
|
|
|
| seniority_of_current_position |
varchar(300)
|
utf8_general_ci
|
|
|
| current_risk_factors |
varchar(300)
|
utf8_general_ci
|
|
|
| schedule_of_current_position |
varchar(300)
|
utf8_general_ci
|
|
|
| days_off_from_current_position |
varchar(300)
|
utf8_general_ci
|
|
|
| custom_fields |
varchar(1000)
|
utf8_general_ci
|
|
|
