contrib/forms/medical_decision/table.sql

   1 CREATE TABLE IF NOT EXISTS `form_medical_decision` (
   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
  10 pname varchar(255),
  11 pbdate varchar(255),
  12 md_pid varchar(255),
  13 md_date varchar(64),
  14 test_lab tinyint(1),
  15 test_lab_cervical tinyint(1),
  16 test_lab_hpv tinyint(1),
  17 test_lab_wet_mount tinyint(1),
  18 test_lab_chlamydia tinyint(1),
  19 test_lab_gonorrhea tinyint(1),
  20 test_lab_other tinyint(1),
  21 test_lab_other_data varchar(255),
  22 test_rad tinyint(1),
  23 test_rad_mammogram tinyint(1),
  24 test_rad_other tinyint(1),
  25 test_rad_other_data varchar(255),
  26 previous_test_results tinyint(1),
  27 previous_test_results_data varchar(255),
  28 test_results_discussion tinyint(1),
  29 test_results_discussion_data varchar(255),
  30 old_records_reviewed tinyint(1),
  31 old_records_reviewed_data varchar(255),
  32 history_other_source tinyint(1),
  33 history_other_source_data varchar(255),
  34 independent_review tinyint(1),
  35 independent_review_data varchar(255),
  36 established_problem tinyint(1),
  37 assessment_and_plan longtext,
  38 md_risk varchar(16),
  39 pc_smoking tinyint(1),
  40 pc_contraception tinyint(1),
  41 pc_weight tinyint(1),
  42 pc_safe_sex tinyint(1),
  43 pc_exercise tinyint(1),
  44 pc_other tinyint(1),
  45 patient_education tinyint(1),
  46 minutes_counseled varchar(255),
  47 total_encounter_time varchar(255),
  48
  49 PRIMARY KEY (id)
  50 ) TYPE=MyISAM;