interface/forms/bronchitis/table.sql

   1 CREATE TABLE IF NOT EXISTS `form_bronchitis` (
   2 id bigint(20) NOT NULL auto_increment,
   3 date datetime default NULL,
   4 pid bigint(20) default NULL,
   5 user varchar(255) default NULL,
   6 groupname varchar(255) default NULL,
   7 authorized tinyint(4) default NULL,
   8 activity tinyint(4) default NULL,
   9 bronchitis_date_of_illness datetime default NULL,
  10 bronchitis_hpi longtext,
  11 bronchitis_ops_fever varchar(255),
  12 bronchitis_ops_cough varchar(255),
  13 bronchitis_ops_dizziness varchar(255),
  14 bronchitis_ops_chest_pain varchar(255),
  15 bronchitis_ops_dyspnea varchar(255),
  16 bronchitis_ops_sweating varchar(255),
  17 bronchitis_ops_wheezing varchar(255),
  18 bronchitis_ops_malaise varchar(255),
  19 bronchitis_ops_sputum varchar(255),
  20 bronchitis_ops_appearance longtext,
  21 bronchitis_ops_all_reviewed varchar(255),
  22 bronchitis_review_of_pmh varchar(255),
  23 bronchitis_review_of_medications varchar(255),
  24 bronchitis_review_of_allergies varchar(255),
  25 bronchitis_review_of_sh varchar(255),
  26 bronchitis_review_of_fh varchar(255),
  27 bronchitis_tms_normal_right varchar(255),
  28 bronchitis_tms_normal_left varchar(255),
  29 bronchitis_nares_normal_right varchar(255),
  30 bronchitis_nares_normal_left varchar(255),
  31 bronchitis_tms_thickened_right varchar(255),
  32 bronchitis_tms_thickened_left varchar(255),
  33 bronchitis_tms_af_level_right varchar(255),
  34 bronchitis_tms_af_level_left varchar(255),
  35 bronchitis_nares_swelling_right varchar(255),
  36 bronchitis_nares_swelling_left varchar(255),
  37 bronchitis_tms_retracted_right varchar(255),
  38 bronchitis_tms_retracted_left varchar(255),
  39 bronchitis_nares_discharge_right varchar(255),
  40 bronchitis_nares_discharge_left varchar(255),
  41 bronchitis_tms_bulging_right varchar(255),
  42 bronchitis_tms_bulging_left varchar(255),
  43 bronchitis_tms_perforated_right varchar(255),
  44 bronchitis_tms_perforated_left varchar(255),
  45 bronchitis_tms_nares_not_examined varchar(255),
  46 bronchitis_no_sinus_tenderness varchar(255),
  47 bronchitis_oropharynx_normal varchar(255),
  48 bronchitis_sinus_tenderness_frontal_right varchar(255),
  49 bronchitis_sinus_tenderness_frontal_left varchar(255),
  50 bronchitis_oropharynx_erythema varchar(255),
  51 bronchitis_oropharynx_exudate varchar(255),
  52 bronchitis_oropharynx_abcess varchar(255),
  53 bronchitis_oropharynx_ulcers varchar(255),
  54 bronchitis_sinus_tenderness_maxillary_right varchar(255),
  55 bronchitis_sinus_tenderness_maxillary_left varchar(255),
  56 bronchitis_oropharynx_appearance longtext,
  57 bronchitis_sinus_tenderness_not_examined varchar(255),
  58 bronchitis_oropharynx_not_examined varchar(255),
  59 bronchitis_heart_pmi varchar(255),
  60 bronchitis_heart_s3 varchar(255),
  61 bronchitis_heart_s4 varchar(255),
  62 bronchitis_heart_click varchar(255),
  63 bronchitis_heart_rub varchar(255),
  64 bronchitis_heart_murmur longtext,
  65 bronchitis_heart_grade longtext,
  66 bronchitis_heart_location longtext,
  67 bronchitis_heart_normal varchar(255),
  68 bronchitis_heart_not_examined varchar(255),
  69 bronchitis_lungs_bs_normal varchar(255),
  70 bronchitis_lungs_bs_reduced varchar(255),
  71 bronchitis_lungs_bs_increased varchar(255),
  72 bronchitis_lungs_crackles_lll varchar(255),
  73 bronchitis_lungs_crackles_rll varchar(255),
  74 bronchitis_lungs_crackles_bll varchar(255),
  75 bronchitis_lungs_rubs_lll varchar(255),
  76 bronchitis_lungs_rubs_rll varchar(255),
  77 bronchitis_lungs_rubs_bll varchar(255),
  78 bronchitis_lungs_wheezes_lll varchar(255),
  79 bronchitis_lungs_wheezes_rll varchar(255),
  80 bronchitis_lungs_wheezes_bll varchar(255),
  81 bronchitis_lungs_wheezes_dll varchar(255),
  82 bronchitis_lungs_normal_exam varchar(255),
  83 bronchitis_lungs_not_examined varchar(255),
  84 bronchitis_diagnostic_tests longtext,
  85 diagnosis1_bronchitis_form varchar(255),
  86 diagnosis2_bronchitis_form varchar(255),
  87 diagnosis3_bronchitis_form varchar(255),
  88 diagnosis4_bronchitis_form varchar(255),
  89 bronchitis_additional_diagnosis longtext,
  90 bronchitis_treatment longtext,
  91 PRIMARY KEY (id)
  92 ) ENGINE=MyISAM;