contrib/forms/patient_intake_history/table.sql

   1 CREATE TABLE IF NOT EXISTS `form_patient_intake_history` (
   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 pih_patient tinyint(1),
  11 pih_consultation tinyint(1),
  12 pih_report_sent tinyint(1),
  13 pih_report_sent_date varchar(255),
  14 pname varchar(255),
  15 pbdate varchar(255),
  16 pih_pid varchar(255),
  17 pih_date varchar(255),
  18 address varchar(255),
  19 city varchar(255),
  20 state varchar(255),
  21 home_phone varchar(255),
  22 work_phone varchar(255),
  23 employer varchar(255),
  24 insurance varchar(255),
  25 policy_no varchar(255),
  26 name_to_use varchar(255),
  27 primary_language varchar(255),
  28 partner_emergency_contact varchar(255),
  29 partner_name longtext,
  30 relationship varchar(255),
  31 partner_home_phone varchar(255),
  32 partner_work_phone varchar(255),
  33 referred_by varchar(255),
  34 why_come_to_office varchar(255),
  35 primary_care_visit tinyint(1),
  36 new_problem tinyint(1),
  37 problem_description longtext,
  38 last_period_date varchar(255),
  39 gh_notes_1 varchar(255),
  40 periods_began varchar(255),
  41 gh_notes_2 varchar(255),
  42 period_lenght varchar(255),
  43 gh_notes_3 varchar(255),
  44 period_days_between varchar(255),
  45 gh_notes_4 varchar(255),
  46 period_changes tinyint(1),
  47 pih_gh_recent_changes_periods tinyint(1),
  48 gh_notes_5 varchar(255),
  49 sexually_active tinyint(1),
  50 gh_notes_6 varchar(255),
  51 ever_had_sex tinyint(1),
  52 gh_notes_7 varchar(255),
  53 number_of_partners varchar(255),
  54 gh_notes_8 varchar(255),
  55 partners varchar(16),
  56 gh_notes_9 varchar(255),
  57 present_birth_control varchar(255),
  58 gh_notes_10 varchar(255),
  59 pills_iud tinyint(1),
  60 gh_notes_11 varchar(255),
  61 pills_how_long varchar(255),
  62 gh_notes_12 varchar(255),
  63 pap_test varchar(255),
  64 gh_notes_13 varchar(255),
  65 breast_self_exam tinyint(1),
  66 gh_notes_14 varchar(255),
  67 des tinyint(1),
  68 gh_notes_15 varchar(255),
  69 oh_pregnancies varchar(255),
  70 oh_abortions varchar(255),
  71 oh_miscarriages varchar(255),
  72 oh_premature_births varchar(255),
  73 oh_live_births varchar(255),
  74 oh_living_children varchar(255),
  75 oh_complications varchar(255),
  76 oh_ch_rec_0 longtext,
  77 oh_ch_rec_1 longtext,
  78 oh_ch_rec_2 longtext,
  79 oh_ch_rec_3 longtext,
  80 oh_ch_rec_4 longtext,
  81 oh_ch_rec_5 longtext,
  82 oh_diabetes tinyint(1),
  83 oh_hipertension tinyint(1),
  84 oh_preemclampsia tinyint(1),
  85 oh_complic_other tinyint(1),
  86 oh_depression tinyint(1),
  87 oh_depression_treated varchar(255),
  88 pres_drug_rec_0 longtext,
  89 pres_drug_rec_1 longtext,
  90 pres_drug_rec_2 longtext,
  91 pres_drug_rec_3 longtext,
  92 pres_drug_rec_4 longtext,
  93 pres_drug_rec_5 longtext,
  94 pres_drug_rec_6 longtext,
  95 pres_drug_rec_7 longtext,
  96 pres_drug_rec_8 longtext,
  97 pres_drug_rec_9 longtext,
  98 fh_mother tinyint(1),
  99 fh_mother_dec_cause varchar(255),
 100 fh_mother_dec_age varchar(255),
 101 fh_father tinyint(1),
 102 fh_father_dec_cause varchar(255),
 103 fh_father_dec_age varchar(255),
 104 fh_sibl_living varchar(255),
 105 fh_sib_deceased varchar(255),
 106 fh_sib_dec_cause varchar(255),
 107 fh_children_living varchar(255),
 108 fh_children_deceased varchar(255),
 109 fh_children_dec_cause varchar(255),
 110 fh_diabetes tinyint(1),
 111 fh_diabetes_info varchar(255),
 112 fh_notes_1 varchar(255),
 113 fh_stroke tinyint(1),
 114 fh_stroke_info varchar(255),
 115 fh_notes_2 varchar(255),
 116 fh_heart_disease tinyint(1),
 117 fh_heart_disease_info varchar(255),
 118 fh_notes_3 varchar(255),
 119 fhbllod_clots tinyint(1),
 120 fhbllod_clots_info varchar(255),
 121 fh_notes_4 varchar(255),
 122 fh_high_pressure tinyint(1),
 123 fh_high_pressure_info varchar(255),
 124 fh_notes_5 varchar(255),
 125 fh_high_cholesterol tinyint(1),
 126 fh_high_cholesterol_info varchar(255),
 127 fh_notes_6 varchar(255),
 128 fh_osteoporosis tinyint(1),
 129 fh_osteoporosis_info varchar(255),
 130 fh_notes_7 varchar(255),
 131 fh_hepatitis tinyint(1),
 132 fh_hepatitis_info varchar(255),
 133 fh_notes_8 varchar(255),
 134 fh_hiv tinyint(1),
 135 fh_hiv_info varchar(255),
 136 fh_notes_9 varchar(255),
 137 fh_tuberculosis tinyint(1),
 138 fh_tuberculosis_info varchar(255),
 139 fh_notes_10 varchar(255),
 140 dh_birth_defects tinyint(1),
 141 dh_birth_defects_info varchar(255),
 142 fh_notes_11 varchar(255),
 143 fh_alcohol_drugs tinyint(1),
 144 fh_alcohol_drugs_info varchar(255),
 145 fh_notes_12 varchar(255),
 146 fh_breast_cancer tinyint(1),
 147 fh_breast_cancer_info varchar(255),
 148 fh_notes_13 varchar(255),
 149 fh_colon_cancer tinyint(1),
 150 fh_colon_cancer_info varchar(255),
 151 fh_notes_14 varchar(255),
 152 fh_ovarian_cancer varchar(255),
 153 fh_notes_15 varchar(255),
 154 fh_uterine_cancer tinyint(1),
 155 fh_uterine_cancer_info varchar(255),
 156 fh_notes_16 varchar(255),
 157 fh_mental_illness tinyint(1),
 158 fh_mental_illness_info varchar(255),
 159 fh_notes_17 varchar(255),
 160 fh_alzheimer tinyint(1),
 161 fh_alzheimer_info varchar(255),
 162 fh_notes_18 varchar(255),
 163 fh_other_illness tinyint(1),
 164 fh_other_illness_info varchar(255),
 165 fh_notes_19 varchar(255),
 166 sh_smoked_packs varchar(255),
 167 sh_smoked_years varchar(255),
 168 pih_smoked tinyint(1),
 169 sh_notes_1 varchar(255),
 170 sh_alcohol_drinks_day varchar(255),
 171 sh_alcohol_drinks_week varchar(255),
 172 sh_alcohol_drinks_type varchar(255),
 173 pih_alcohol tinyint(1),
 174 sh_notes_2 varchar(255),
 175 pih_drug tinyint(1),
 176 sh_notes_3 varchar(255),
 177 pih_seat_belt tinyint(1),
 178 sh_notes_4 varchar(255),
 179 sh_exercise_info varchar(255),
 180 pih_exercise tinyint(1),
 181 sh_notes_5 varchar(255),
 182 sh_dairy_daily varchar(255),
 183 pih_dairy tinyint(1),
 184 sh_notes_6 varchar(255),
 185 pih_hazards tinyint(1),
 186 sh_notes_7 varchar(255),
 187 pih_abuse tinyint(1),
 188 sh_notes_8 varchar(255),
 189 pih_living_will tinyint(1),
 190 sh_notes_9 varchar(255),
 191 pih_donor tinyint(1),
 192 sh_notes_10 varchar(255),
 193 pih_pp_orientation varchar(16),
 194 pih_pp_status varchar(16),
 195 pp_living_children varchar(255),
 196 pp_number_household varchar(255),
 197 pih_pp_education varchar(32),
 198 pp_current_job varchar(255),
 199 pp_travel_outside_us tinyint(1),
 200 pp_travel_outside_locations varchar(255),
 201 pih_ih_asthma tinyint(1),
 202 pih_ih_asthma_date varchar(255),
 203 ih_notes_1 varchar(255),
 204 pih_ih_pneumonia tinyint(1),
 205 pih_ih_pneumonia_date varchar(255),
 206 ih_notes_2 varchar(255),
 207 pih_ih_kidney tinyint(1),
 208 pih_ih_kidney_date varchar(255),
 209 ih_notes_3 varchar(255),
 210 pih_ih_tuber tinyint(1),
 211 pih_ih_tuber_date varchar(255),
 212 ih_notes_4 varchar(255),
 213 pih_ih_fibroids tinyint(1),
 214 pih_ih_fibroids_date varchar(255),
 215 ih_notes_5 varchar(255),
 216 pih_ih_sexually tinyint(1),
 217 pih_ih_sexually_date varchar(255),
 218 ih_notes_6 varchar(255),
 219 pih_ih_infertil tinyint(1),
 220 pih_ih_infertil_date varchar(255),
 221 ih_notes_7 varchar(255),
 222 pih_ih_hiv tinyint(1),
 223 pih_ih_hiv_date varchar(255),
 224 ih_notes_8 varchar(255),
 225 pih_ih_heart tinyint(1),
 226 pih_ih_heart_date varchar(255),
 227 ih_notes_9 varchar(255),
 228 pih_ih_diabetes tinyint(1),
 229 pih_ih_diabetes_date varchar(255),
 230 ih_notes_10 varchar(255),
 231 pih_ih_high_pressure tinyint(1),
 232 pih_ih_high_pressure_date varchar(255),
 233 ih_notes_11 varchar(255),
 234 pih_ih_stroke tinyint(1),
 235 pih_ih_stroke_date varchar(255),
 236 ih_notes_12 varchar(255),
 237 pih_ih_rheumatic tinyint(1),
 238 pih_ih_rheumatic_date varchar(255),
 239 ih_notes_13 varchar(255),
 240 pih_ih_blood_clots tinyint(1),
 241 pih_ih_blood_clots_date varchar(255),
 242 ih_notes_14 varchar(255),
 243 pih_ih_eating_disorder tinyint(1),
 244 pih_ih_eating_disorder_date varchar(255),
 245 ih_notes_15 varchar(255),
 246 pih_ih_autoimmune tinyint(1),
 247 pih_ih_autoimmune_date varchar(255),
 248 ih_notes_16 varchar(255),
 249 pih_ih_chickenpox tinyint(1),
 250 pih_ih_chickenpox_date varchar(255),
 251 ih_notes_17 varchar(255),
 252 pih_ih_cancer tinyint(1),
 253 pih_ih_cancer_date varchar(255),
 254 ih_notes_18 varchar(255),
 255 pih_ih_reflux tinyint(1),
 256 pih_ih_reflux_date varchar(255),
 257 ih_notes_19 varchar(255),
 258 pih_ih_depression tinyint(1),
 259 pih_ih_depression_date varchar(255),
 260 ih_notes_20 varchar(255),
 261 pih_ih_anemia tinyint(1),
 262 pih_ih_anemia_date varchar(255),
 263 ih_notes_21 varchar(255),
 264 pih_ih_blood_transf tinyint(1),
 265 pih_ih_blood_transf_date varchar(255),
 266 ih_notes_22 varchar(255),
 267 pih_ih_seizures tinyint(1),
 268 pih_ih_seizures_date varchar(255),
 269 ih_notes_23 varchar(255),
 270 pih_ih_bowel_problems tinyint(1),
 271 pih_ih_bowel_problems_date varchar(255),
 272 ih_notes_24 varchar(255),
 273 pih_ih_glaucoma tinyint(1),
 274 pih_ih_glaucoma_date varchar(255),
 275 ih_notes_25 varchar(255),
 276 pih_ih_cataracts tinyint(1),
 277 pih_ih_cataracts_date varchar(255),
 278 ih_notes_26 varchar(255),
 279 pih_ih_joint_pain tinyint(1),
 280 pih_ih_joint_pain_date varchar(255),
 281 ih_notes_27 varchar(255),
 282 pih_ih_broken_bones tinyint(1),
 283 pih_ih_broken_bones_date varchar(255),
 284 ih_notes_28 varchar(255),
 285 pih_ih_hepatitis tinyint(1),
 286 pih_ih_hepatitis_date varchar(255),
 287 ih_notes_29 varchar(255),
 288 pih_ih_thyroid tinyint(1),
 289 pih_ih_thyroid_date varchar(255),
 290 ih_notes_30 varchar(255),
 291 pih_ih_galibladder tinyint(1),
 292 pih_ih_galibladder_date varchar(255),
 293 ih_notes_31 varchar(255),
 294 pih_ih_headaches tinyint(1),
 295 pih_ih_headaches_date varchar(255),
 296 ih_notes_32 varchar(255),
 297 pih_ih_des tinyint(1),
 298 pih_ih_des_date varchar(255),
 299 ih_notes_33 varchar(255),
 300 pih_ih_bleeding_disorders tinyint(1),
 301 pih_ih_bleeding_disorders_date varchar(255),
 302 ih_notes_34 varchar(255),
 303 pih_ih_other tinyint(1),
 304 pih_ih_other_date varchar(255),
 305 ih_notes_35 varchar(255),
 306 pih_ih_extended_info longtext,
 307 op_rec_0 longtext,
 308 op_rec_1 longtext,
 309 op_rec_2 longtext,
 310 op_rec_3 longtext,
 311 op_rec_4 longtext,
 312 op_rec_5 longtext,
 313 ii_rec_0 varchar(255),
 314 ii_rec_1 varchar(255),
 315 ii_rec_2 varchar(255),
 316 ii_rec_3 varchar(255),
 317 ii_rec_4 varchar(255),
 318 ii_rec_5 varchar(255),
 319 ii_rec_6 varchar(255),
 320 ii_rec_7 varchar(255),
 321 ii_rec_8 varchar(255),
 322 ii_rec_9 varchar(255),
 323 ii_rec_10 varchar(255),
 324 ii_rec_11 varchar(255),
 325 imm_influenza varchar(255),
 326 imm_hepatitis_a varchar(255),
 327 imm_hepatitis_b varchar(255),
 328 imm_varicella varchar(255),
 329 imm_pneumococcal varchar(255),
 330 imm_mmr varchar(255),
 331 imm_tetanus varchar(255),
 332 imm_tuberculosis_skin varchar(255),
 333 imm_tuberculosis_result varchar(255),
 334 imm_tuberculosis varchar(255),
 335 imm_extended_info longtext,
 336
 337 pih_completed_by varchar(32),
 338 pih_completed_by_other varchar(255),
 339 pih_date_reviewed_1 varchar(255),
 340 pih_date_reviewed_2 varchar(255),
 341 pih_date_reviewed_3 varchar(255),
 342 pih_date_reviewed_4 varchar(255),
 343 pih_date_reviewed_5 varchar(255),
 344 pih_date_reviewed_6 varchar(255),
 345
 346 linked_ros_id bigint(20) NOT NULL,
 347
 348 PRIMARY KEY (id)
 349 ) ENGINE=MyISAM;
 350
 351
 352 CREATE TABLE IF NOT EXISTS `form_patient_intake_history_ros` (
 353 id bigint(20) NOT NULL auto_increment,
 354 date datetime default NULL,
 355 pid bigint(20) default NULL,
 356 user varchar(255) default NULL,
 357 groupname varchar(255) default NULL,
 358 authorized tinyint(4) default NULL,
 359 activity tinyint(4) default NULL,
 360
 361 ros_weight_loss_now tinyint(1),
 362 ros_weight_loss_past tinyint(1),
 363 ros_weight_loss_notsure tinyint(1),
 364 ros_notes_1 varchar(255),
 365 ros_weight_gain_now tinyint(1),
 366 ros_weight_gain_past tinyint(1),
 367 ros_weight_gain_notsure tinyint(1),
 368 ros_notes_2 varchar(255),
 369 ros_fever_now tinyint(1),
 370 ros_fever_past tinyint(1),
 371 ros_fever_notsure tinyint(1),
 372 ros_notes_3 varchar(255),
 373 ros_fatigue_now tinyint(1),
 374 ros_fatigue_past tinyint(1),
 375 ros_fatigue_notsure tinyint(1),
 376 ros_notes_4 varchar(255),
 377 ros_height_change_now tinyint(1),
 378 ros_height_change_past tinyint(1),
 379 ros_height_change_notsure tinyint(1),
 380 ros_notes_5 varchar(255),
 381 ros_dvision_now tinyint(1),
 382 ros_dvision_past tinyint(1),
 383 ros_dvision_notsure tinyint(1),
 384 ros_notes_6 varchar(255),
 385 ros_spots_eyes_now tinyint(1),
 386 ros_spots_eyes_past tinyint(1),
 387 ros_spots_eyes_notsure tinyint(1),
 388 ros_notes_7 varchar(255),
 389 ros_vis_changes_now tinyint(1),
 390 ros_vis_changes_past tinyint(1),
 391 ros_vis_changes_notsure tinyint(1),
 392 ros_notes_8 varchar(255),
 393 ros_glasses_now tinyint(1),
 394 ros_glasses_past tinyint(1),
 395 ros_glasses_notsure tinyint(1),
 396 ros_notes_9 varchar(255),
 397 ros_earaches_now tinyint(1),
 398 ros_earaches_past tinyint(1),
 399 ros_earaches_notsure tinyint(1),
 400 ros_notes_10 varchar(255),
 401 ros_ringing_now tinyint(1),
 402 ros_ringing_past tinyint(1),
 403 ros_ringing_notsure tinyint(1),
 404 ros_notes_11 varchar(255),
 405 ros_hearing_problems_now tinyint(1),
 406 ros_hearing_problems_past tinyint(1),
 407 ros_hearing_problems_notsure tinyint(1),
 408 ros_notes_12 varchar(255),
 409 ros_sinus_problems_now tinyint(1),
 410 ros_sinus_problems_past tinyint(1),
 411 ros_sinus_problems_notsure tinyint(1),
 412 ros_notes_13 varchar(255),
 413 ros_sore_throat_now tinyint(1),
 414 ros_sore_throat_past tinyint(1),
 415 ros_sore_throat_notsure tinyint(1),
 416 ros_notes_14 varchar(255),
 417 ros_mouth_sores_now tinyint(1),
 418 ros_mouth_sores_past tinyint(1),
 419 ros_mouth_sores_notsure tinyint(1),
 420 ros_notes_15 varchar(255),
 421 ros_dental_problems_now tinyint(1),
 422 ros_dental_problems_past tinyint(1),
 423 ros_dental_problems_notsure tinyint(1),
 424 ros_notes_16 varchar(255),
 425 ros_chest_pain_now tinyint(1),
 426 ros_chest_pain_past tinyint(1),
 427 ros_chest_pain_notsure tinyint(1),
 428 ros_notes_17 varchar(255),
 429 ros_difficulty_breathing_now tinyint(1),
 430 ros_difficulty_breathing_past tinyint(1),
 431 ros_difficulty_breathing_notsure tinyint(1),
 432 ros_notes_18 varchar(255),
 433 ros_swelling_legs_now tinyint(1),
 434 ros_swelling_legs_past tinyint(1),
 435 ros_swelling_legs_notsure tinyint(1),
 436 ros_notes_19 varchar(255),
 437 ros_rapid_heartbeat_now tinyint(1),
 438 ros_rapid_heartbeat_past tinyint(1),
 439 ros_rapid_heartbeat_notsure tinyint(1),
 440 ros_notes_20 varchar(255),
 441 ros_painful_breathing_now tinyint(1),
 442 ros_painful_breathing_past tinyint(1),
 443 ros_painful_breathing_notsure tinyint(1),
 444 ros_notes_21 varchar(255),
 445 ros_wheezing_now tinyint(1),
 446 ros_wheezing_past tinyint(1),
 447 ros_wheezing_notsure tinyint(1),
 448 ros_notes_22 varchar(255),
 449 ros_spitting_blood_now tinyint(1),
 450 ros_spitting_blood_past tinyint(1),
 451 ros_spitting_blood_notsure tinyint(1),
 452 ros_notes_23 varchar(255),
 453 ros_breath_shortness_now tinyint(1),
 454 ros_breath_shortness_past tinyint(1),
 455 ros_breath_shortness_notsure tinyint(1),
 456 ros_notes_24 varchar(255),
 457 ros_chronic_cough_now tinyint(1),
 458 ros_chronic_cough_past tinyint(1),
 459 ros_chronic_cough_notsure tinyint(1),
 460 ros_notes_25 varchar(255),
 461 ros_diarrhea_now tinyint(1),
 462 ros_diarrhea_past tinyint(1),
 463 ros_diarrhea_notsure tinyint(1),
 464 ros_notes_26 varchar(255),
 465 ros_bloody_stool_now tinyint(1),
 466 ros_bloody_stool_past tinyint(1),
 467 ros_bloody_stool_notsure tinyint(1),
 468 ros_notes_27 varchar(255),
 469 ros_nausea_now tinyint(1),
 470 ros_nausea_past tinyint(1),
 471 ros_nausea_notsure tinyint(1),
 472 ros_notes_28 varchar(255),
 473 ros_constipation_now tinyint(1),
 474 ros_constipation_past tinyint(1),
 475 ros_constipation_notsure tinyint(1),
 476 ros_notes_29 varchar(255),
 477 ros_gas_loss_now tinyint(1),
 478 ros_gas_loss_past tinyint(1),
 479 ros_gas_loss_notsure tinyint(1),
 480 ros_notes_30 varchar(255),
 481 ros_blood_urine_now tinyint(1),
 482 ros_blood_urine_past tinyint(1),
 483 ros_blood_urine_notsure tinyint(1),
 484 ros_notes_31 varchar(255),
 485 ros_pain_urination_now tinyint(1),
 486 ros_pain_urination_past tinyint(1),
 487 ros_pain_urination_notsure tinyint(1),
 488 ros_notes_32 varchar(255),
 489 ros_urgency_urinate_now tinyint(1),
 490 ros_urgency_urinate_past tinyint(1),
 491 ros_urgency_urinate_notsure tinyint(1),
 492 ros_notes_33 varchar(255),
 493 ros_frequent_urination_now tinyint(1),
 494 ros_frequent_urination_past tinyint(1),
 495 ros_frequent_urination_notsure tinyint(1),
 496 ros_notes_34 varchar(255),
 497 ros_incomplete_emptying_now tinyint(1),
 498 ros_incomplete_emptying_past tinyint(1),
 499 ros_incomplete_emptying_notsure tinyint(1),
 500 ros_notes_35 varchar(255),
 501 ros_unint_urine_loss_now tinyint(1),
 502 ros_unint_urine_loss_past tinyint(1),
 503 ros_unint_urine_loss_notsure tinyint(1),
 504 ros_notes_36 varchar(255),
 505 ros_lifting_urine_loss_now tinyint(1),
 506 ros_lifting_urine_loss_past tinyint(1),
 507 ros_lifting_urine_loss_notsure tinyint(1),
 508 ros_notes_37 varchar(255),
 509 ros_abnormal_bleeding_now tinyint(1),
 510 ros_abnormal_bleeding_past tinyint(1),
 511 ros_abnormal_bleeding_notsure tinyint(1),
 512 ros_notes_38 varchar(255),
 513 ros_painful_periods_now tinyint(1),
 514 ros_painful_periods_past tinyint(1),
 515 ros_painful_periods_notsure tinyint(1),
 516 ros_notes_39 varchar(255),
 517 ros_pms_now tinyint(1),
 518 ros_pms_past tinyint(1),
 519 ros_pms_notsure tinyint(1),
 520 ros_notes_40 varchar(255),
 521 ros_painful_intercourse_now tinyint(1),
 522 ros_painful_intercourse_past tinyint(1),
 523 ros_painful_intercourse_notsure tinyint(1),
 524 ros_notes_41 varchar(255),
 525 ros_vaginal_discharge_now tinyint(1),
 526 ros_vaginal_discharge_past tinyint(1),
 527 ros_vaginal_discharge_notsure tinyint(1),
 528 ros_notes_42 varchar(255),
 529 ros_muscle_weakness_now tinyint(1),
 530 ros_muscle_weakness_past tinyint(1),
 531 ros_muscle_weakness_notsure tinyint(1),
 532 ros_notes_43 varchar(255),
 533 ros_muscle_pain_now tinyint(1),
 534 ros_muscle_pain_past tinyint(1),
 535 ros_muscle_pain_notsure tinyint(1),
 536 ros_notes_44 varchar(255),
 537 ros_rash_now tinyint(1),
 538 ros_rash_past tinyint(1),
 539 ros_rash_notsure tinyint(1),
 540 ros_notes_45 varchar(255),
 541 ros_sores_now tinyint(1),
 542 ros_sores_past tinyint(1),
 543 ros_sores_notsure tinyint(1),
 544 ros_notes_46 varchar(255),
 545 ros_dry_skin_now tinyint(1),
 546 ros_dry_skin_past tinyint(1),
 547 ros_dry_skin_notsure tinyint(1),
 548 ros_notes_47 varchar(255),
 549 ros_moles_now tinyint(1),
 550 ros_moles_past tinyint(1),
 551 ros_moles_notsure tinyint(1),
 552 ros_notes_48 varchar(255),
 553 ros_pain_breast_now tinyint(1),
 554 ros_pain_breast_past tinyint(1),
 555 ros_pain_breast_notsure tinyint(1),
 556 ros_notes_49 varchar(255),
 557 ros_nipple_discharge_now tinyint(1),
 558 ros_nipple_discharge_past tinyint(1),
 559 ros_nipple_discharge_notsure tinyint(1),
 560 ros_notes_50 varchar(255),
 561 ros_lumps_now tinyint(1),
 562 ros_lumps_past tinyint(1),
 563 ros_lumps_notsure tinyint(1),
 564 ros_notes_51 varchar(255),
 565 ros_dizziness_now tinyint(1),
 566 ros_dizziness_past tinyint(1),
 567 ros_dizziness_notsure tinyint(1),
 568 ros_notes_52 varchar(255),
 569 ros_seizures_now tinyint(1),
 570 ros_seizures_past tinyint(1),
 571 ros_seizures_notsure tinyint(1),
 572 ros_notes_53 varchar(255),
 573 ros_numbness_now tinyint(1),
 574 ros_numbness_past tinyint(1),
 575 ros_numbness_notsure tinyint(1),
 576 ros_notes_54 varchar(255),
 577 ros_trouble_walking_now tinyint(1),
 578 ros_trouble_walking_past tinyint(1),
 579 ros_trouble_walking_notsure tinyint(1),
 580 ros_notes_55 varchar(255),
 581 ros_memory_problems_now tinyint(1),
 582 ros_memory_problems_past tinyint(1),
 583 ros_memory_problems_notsure tinyint(1),
 584 ros_notes_56 varchar(255),
 585 ros_freq_headaches_now tinyint(1),
 586 ros_freq_headaches_past tinyint(1),
 587 ros_freq_headaches_notsure tinyint(1),
 588 ros_notes_57 varchar(255),
 589 ros_depression_now tinyint(1),
 590 ros_depression_past tinyint(1),
 591 ros_depression_notsure tinyint(1),
 592 ros_notes_58 varchar(255),
 593 ros_anxiety_now tinyint(1),
 594 ros_anxiety_past tinyint(1),
 595 ros_anxiety_notsure tinyint(1),
 596 ros_notes_59 varchar(255),
 597 ros_hair_loss_now tinyint(1),
 598 ros_hair_loss_past tinyint(1),
 599 ros_hair_loss_notsure tinyint(1),
 600 ros_notes_60 varchar(255),
 601 ros_heat_cold_intolerance_now tinyint(1),
 602 ros_heat_cold_intolerance_past tinyint(1),
 603 ros_heat_cold_intolerance_notsure tinyint(1),
 604 ros_notes_61 varchar(255),
 605 ros_abnormal_thirst_now tinyint(1),
 606 ros_abnormal_thirst_past tinyint(1),
 607 ros_abnormal_thirst_notsure tinyint(1),
 608 ros_notes_62 varchar(255),
 609 ros_hot_flashes_now tinyint(1),
 610 ros_hot_flashes_past tinyint(1),
 611 ros_hot_flashes_notsure tinyint(1),
 612 ros_notes_63 varchar(255),
 613 ros_frequent_bruises_now tinyint(1),
 614 ros_frequent_bruises_past tinyint(1),
 615 ros_frequent_bruises_notsure tinyint(1),
 616 ros_notes_64 varchar(255),
 617 ros_cuts_bleeding_now tinyint(1),
 618 ros_cuts_bleeding_past tinyint(1),
 619 ros_cuts_bleeding_notsure tinyint(1),
 620 ros_notes_65 varchar(255),
 621 ros_enlarged_nodes_now tinyint(1),
 622 ros_enlarged_nodes_past tinyint(1),
 623 ros_enlarged_nodes_notsure tinyint(1),
 624 ros_notes_66 varchar(255),
 625 ros_med_allergy_now tinyint(1),
 626 ros_med_allergy_past tinyint(1),
 627 ros_med_allergy_notsure tinyint(1),
 628 ros_notes_68 varchar(255),
 629 ros_med_allergy_reaction varchar(255),
 630 ros_latex_allergy_now tinyint(1),
 631 ros_latex_allergy_past tinyint(1),
 632 ros_latex_allergy_notsure tinyint(1),
 633 ros_notes_69 varchar(255),
 634 ros_other_allergy_now tinyint(1),
 635 ros_other_allergy_past tinyint(1),
 636 ros_other_allergy_notsure tinyint(1),
 637 ros_notes_70 varchar(255),
 638 ros_other_allergy_reaction_ varchar(255),
 639
 640 PRIMARY KEY (id)
 641 ) ENGINE=MyISAM;