Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
Surrogate id of the record used as the primary incrementing key |
||||
| date | DATETIME | 19 | √ | null |
|
|
Date when the record was created |
||||
| pid | BIGINT | 19 | √ | null |
|
|
The internal patient identifier |
||||
| user | VARCHAR | 50 | √ | null |
|
|
User responsible for creating the record. |
||||
| groupname | VARCHAR | 50 | √ | null |
|
|
The groupname that created this record. |
||||
| TINYINT | 3 | √ | null |
|
|
Authorization flag |
|||||
| activity | TINYINT | 3 | √ | null |
|
|
Activity status, 1=form is active, 0=inactive |
||||
| bronchitis_date_of_illness | DATETIME | 19 | √ | null |
|
|
Date of illness for bronchitis |
||||
| bronchitis_hpi | LONGTEXT | 2147483647 | √ | null |
|
|
History of Present Illness for bronchitis |
||||
| bronchitis_ops_fever | TEXT | 65535 | √ | null |
|
|
Operations related to fever |
||||
| bronchitis_ops_cough | TEXT | 65535 | √ | null |
|
|
Operations related to cough |
||||
| bronchitis_ops_dizziness | TEXT | 65535 | √ | null |
|
|
Operations related to dizziness |
||||
| bronchitis_ops_chest_pain | TEXT | 65535 | √ | null |
|
|
Operations related to chest pain |
||||
| bronchitis_ops_dyspnea | TEXT | 65535 | √ | null |
|
|
Operations related to dyspnea |
||||
| bronchitis_ops_sweating | TEXT | 65535 | √ | null |
|
|
Operations related to sweating |
||||
| bronchitis_ops_wheezing | TEXT | 65535 | √ | null |
|
|
Operations related to wheezing |
||||
| bronchitis_ops_malaise | TEXT | 65535 | √ | null |
|
|
Operations related to malaise |
||||
| bronchitis_ops_sputum | TEXT | 65535 | √ | null |
|
|
Operations related to sputum |
||||
| bronchitis_ops_appearance | LONGTEXT | 2147483647 | √ | null |
|
|
Operations related to appearance |
||||
| bronchitis_ops_all_reviewed | TEXT | 65535 | √ | null |
|
|
Operations related to all reviewed |
||||
| bronchitis_review_of_pmh | TEXT | 65535 | √ | null |
|
|
Review of Past Medical History for bronchitis |
||||
| bronchitis_review_of_medications | TEXT | 65535 | √ | null |
|
|
Review of medications for bronchitis |
||||
| bronchitis_review_of_allergies | TEXT | 65535 | √ | null |
|
|
Review of allergies for bronchitis |
||||
| bronchitis_review_of_sh | TEXT | 65535 | √ | null |
|
|
Review of social history for bronchitis |
||||
| bronchitis_review_of_fh | TEXT | 65535 | √ | null |
|
|
Review of family history for bronchitis |
||||
| bronchitis_tms_normal_right | TEXT | 65535 | √ | null |
|
|
Tympanic Membrane and Sinus - Normal Right |
||||
| bronchitis_tms_normal_left | TEXT | 65535 | √ | null |
|
|
Tympanic Membrane and Sinus - Normal Left |
||||
| bronchitis_nares_normal_right | TEXT | 65535 | √ | null |
|
|
Nares - Normal Right |
||||
| bronchitis_nares_normal_left | TEXT | 65535 | √ | null |
|
|
Nares - Normal Left |
||||
| bronchitis_tms_thickened_right | TEXT | 65535 | √ | null |
|
|
Tympanic Membrane and Sinus - Thickened Right |
||||
| bronchitis_tms_thickened_left | TEXT | 65535 | √ | null |
|
|
Tympanic Membrane and Sinus - Thickened Left |
||||
| bronchitis_tms_af_level_right | TEXT | 65535 | √ | null |
|
|
Tympanic Membrane and Sinus - AF Level Right |
||||
| bronchitis_tms_af_level_left | TEXT | 65535 | √ | null |
|
|
Tympanic Membrane and Sinus - AF Level Left |
||||
| bronchitis_nares_swelling_right | TEXT | 65535 | √ | null |
|
|
Nares - Swelling Right |
||||
| bronchitis_nares_swelling_left | TEXT | 65535 | √ | null |
|
|
Nares - Swelling Left |
||||
| bronchitis_tms_retracted_right | TEXT | 65535 | √ | null |
|
|
Tympanic Membrane and Sinus - Retracted Right |
||||
| bronchitis_tms_retracted_left | TEXT | 65535 | √ | null |
|
|
Tympanic Membrane and Sinus - Retracted Left |
||||
| bronchitis_nares_discharge_right | TEXT | 65535 | √ | null |
|
|
Nares - Discharge Right |
||||
| bronchitis_nares_discharge_left | TEXT | 65535 | √ | null |
|
|
Nares - Discharge Left |
||||
| bronchitis_tms_bulging_right | TEXT | 65535 | √ | null |
|
|
Tympanic Membrane and Sinus - Bulging Right |
||||
| bronchitis_tms_bulging_left | TEXT | 65535 | √ | null |
|
|
Tympanic Membrane and Sinus - Bulging Left |
||||
| bronchitis_tms_perforated_right | TEXT | 65535 | √ | null |
|
|
Tympanic Membrane and Sinus - Perforated Right |
||||
| bronchitis_tms_perforated_left | TEXT | 65535 | √ | null |
|
|
Tympanic Membrane and Sinus - Perforated Left |
||||
| bronchitis_tms_nares_not_examined | TEXT | 65535 | √ | null |
|
|
Tympanic Membrane and Sinus - Nares Not Examined |
||||
| bronchitis_no_sinus_tenderness | TEXT | 65535 | √ | null |
|
|
No sinus tenderness |
||||
| bronchitis_oropharynx_normal | TEXT | 65535 | √ | null |
|
|
Oropharynx - Normal |
||||
| bronchitis_sinus_tenderness_frontal_right | TEXT | 65535 | √ | null |
|
|
Sinus Tenderness - Frontal Right |
||||
| bronchitis_sinus_tenderness_frontal_left | TEXT | 65535 | √ | null |
|
|
Sinus Tenderness - Frontal Left |
||||
| bronchitis_oropharynx_erythema | TEXT | 65535 | √ | null |
|
|
Oropharynx - Erythema |
||||
| bronchitis_oropharynx_exudate | TEXT | 65535 | √ | null |
|
|
Oropharynx - Exudate |
||||
| bronchitis_oropharynx_abcess | TEXT | 65535 | √ | null |
|
|
Oropharynx - Abscess |
||||
| bronchitis_oropharynx_ulcers | TEXT | 65535 | √ | null |
|
|
Oropharynx - Ulcers |
||||
| bronchitis_sinus_tenderness_maxillary_right | TEXT | 65535 | √ | null |
|
|
Sinus Tenderness - Maxillary Right |
||||
| bronchitis_sinus_tenderness_maxillary_left | TEXT | 65535 | √ | null |
|
|
Sinus Tenderness - Maxillary Left |
||||
| bronchitis_oropharynx_appearance | LONGTEXT | 2147483647 | √ | null |
|
|
Oropharynx - Appearance |
||||
| bronchitis_sinus_tenderness_not_examined | TEXT | 65535 | √ | null |
|
|
Sinus Tenderness - Not Examined |
||||
| bronchitis_oropharynx_not_examined | TEXT | 65535 | √ | null |
|
|
Oropharynx - Not Examined |
||||
| bronchitis_heart_pmi | TEXT | 65535 | √ | null |
|
|
Heart - PMI (Point of Maximal Impulse) |
||||
| bronchitis_heart_s3 | TEXT | 65535 | √ | null |
|
|
Heart - S3 Sound |
||||
| bronchitis_heart_s4 | TEXT | 65535 | √ | null |
|
|
Heart - S4 Sound |
||||
| bronchitis_heart_click | TEXT | 65535 | √ | null |
|
|
Heart - Click Sound |
||||
| bronchitis_heart_rub | TEXT | 65535 | √ | null |
|
|
Heart - Rub Sound |
||||
| bronchitis_heart_murmur | LONGTEXT | 2147483647 | √ | null |
|
|
Heart - Murmur |
||||
| bronchitis_heart_grade | LONGTEXT | 2147483647 | √ | null |
|
|
Heart - Grade |
||||
| bronchitis_heart_location | LONGTEXT | 2147483647 | √ | null |
|
|
Heart - Location |
||||
| bronchitis_heart_normal | TEXT | 65535 | √ | null |
|
|
Heart - Normal Exam |
||||
| bronchitis_heart_not_examined | TEXT | 65535 | √ | null |
|
|
Heart - Not Examined |
||||
| bronchitis_lungs_bs_normal | TEXT | 65535 | √ | null |
|
|
Lungs - Breath Sounds Normal |
||||
| bronchitis_lungs_bs_reduced | TEXT | 65535 | √ | null |
|
|
Lungs - Breath Sounds Reduced |
||||
| bronchitis_lungs_bs_increased | TEXT | 65535 | √ | null |
|
|
Lungs - Breath Sounds Increased |
||||
| bronchitis_lungs_crackles_lll | TEXT | 65535 | √ | null |
|
|
Lungs - Crackles - Left Lower Lobe |
||||
| bronchitis_lungs_crackles_rll | TEXT | 65535 | √ | null |
|
|
Lungs - Crackles - Right Lower Lobe |
||||
| bronchitis_lungs_crackles_bll | TEXT | 65535 | √ | null |
|
|
Lungs - Crackles - Both Lower Lobes |
||||
| bronchitis_lungs_rubs_lll | TEXT | 65535 | √ | null |
|
|
Lungs - Rubs - Left Lower Lobe |
||||
| bronchitis_lungs_rubs_rll | TEXT | 65535 | √ | null |
|
|
Lungs - Rubs - Right Lower Lobe |
||||
| bronchitis_lungs_rubs_bll | TEXT | 65535 | √ | null |
|
|
Lungs - Rubs - Both Lower Lobes |
||||
| bronchitis_lungs_wheezes_lll | TEXT | 65535 | √ | null |
|
|
Lungs - Wheezes - Left Lower Lobe |
||||
| bronchitis_lungs_wheezes_rll | TEXT | 65535 | √ | null |
|
|
Lungs - Wheezes - Right Lower Lobe |
||||
| bronchitis_lungs_wheezes_bll | TEXT | 65535 | √ | null |
|
|
Lungs - Wheezes - Both Lower Lobes |
||||
| bronchitis_lungs_wheezes_dll | TEXT | 65535 | √ | null |
|
|
Lungs - Wheezes - Diffuse |
||||
| bronchitis_lungs_normal_exam | TEXT | 65535 | √ | null |
|
|
Lungs - Normal Exam |
||||
| bronchitis_lungs_not_examined | TEXT | 65535 | √ | null |
|
|
Lungs - Not Examined |
||||
| bronchitis_diagnostic_tests | LONGTEXT | 2147483647 | √ | null |
|
|
Diagnostic tests for bronchitis |
||||
| diagnosis1_bronchitis_form | TEXT | 65535 | √ | null |
|
|
Diagnosis 1 for bronchitis form |
||||
| diagnosis2_bronchitis_form | TEXT | 65535 | √ | null |
|
|
Diagnosis 2 for bronchitis form |
||||
| diagnosis3_bronchitis_form | TEXT | 65535 | √ | null |
|
|
Diagnosis 3 for bronchitis form |
||||
| diagnosis4_bronchitis_form | TEXT | 65535 | √ | null |
|
|
Diagnosis 4 for bronchitis form |
||||
| bronchitis_additional_diagnosis | LONGTEXT | 2147483647 | √ | null |
|
|
Additional diagnoses for bronchitis |
||||
| bronchitis_treatment | LONGTEXT | 2147483647 | √ | null |
|
|
Treatment information for bronchitis |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |