| blob | 99ac7c1183c6764405d0c4ca39e6f300a715eb2b |
1 CREATE TABLE IF NOT EXISTS `form_ros2` (
2 `id` bigint(20) NOT NULL auto_increment,
3 `date` datetime DEFAULT NULL,
4 `pid` bigint(20) NOT NULL DEFAULT 0,
5 `user` TEXT DEFAULT NULL,
6 `groupname` TEXT DEFAULT NULL,
7 `authorized` tinyint(4) NOT NULL DEFAULT 0,
8 `activity` tinyint(4) NOT NULL DEFAULT 0,
9 `general_headache` varchar(3) NOT NULL default 'N/A',
10 `general_headache_text` TEXT NOT NULL default '',
11 `general_fever` varchar(3) NOT NULL default 'N/A',
12 `general_fever_text` TEXT NOT NULL default '',
13 `general_chills` varchar(3) NOT NULL default 'N/A',
14 `general_chills_text` TEXT NOT NULL default '',
15 `general_body_aches` varchar(3) NOT NULL default 'N/A',
16 `general_body_aches_text` TEXT NOT NULL default '',
17 `general_fatigue` varchar(3) NOT NULL default 'N/A',
18 `general_fatigue_text` TEXT NOT NULL default '',
19 `general_loss_of_appetite` varchar(3) NOT NULL default 'N/A',
20 `general_loss_of_appetite_text` TEXT NOT NULL default '',
21 `general_weight_loss` varchar(3) NOT NULL default 'N/A',
22 `general_weight_loss_text` TEXT NOT NULL default '',
23 `general_daytime_drowsiness` varchar(3) NOT NULL default 'N/A',
24 `general_daytime_drowsiness_text` TEXT NOT NULL default '',
25 `general_excessive_snoring` varchar(3) NOT NULL default 'N/A',
26 `general_excessive_snoring_text` TEXT NOT NULL default '',
27 `neuro_disorientation` varchar(3) NOT NULL default 'N/A',
28 `neuro_disorientation_text` TEXT NOT NULL default '',
29 `neuro_loss_of_consciousness` varchar(3) NOT NULL default 'N/A',
30 `neuro_loss_of_consciousness_text` TEXT NOT NULL default '',
31 `neuro_numbness` varchar(3) NOT NULL default 'N/A',
32 `neuro_numbness_text` TEXT NOT NULL default '',
33 `neuro_tingling` varchar(3) NOT NULL default 'N/A',
34 `neuro_tingling_text` TEXT NOT NULL default '',
35 `neuro_restlessness` varchar(3) NOT NULL default 'N/A',
36 `neuro_restlessness_text` TEXT NOT NULL default '',
37 `neuro_dizziness` varchar(3) NOT NULL default 'N/A',
38 `neuro_dizziness_text` TEXT NOT NULL default '',
39 `neuro_vertigo` varchar(3) NOT NULL default 'N/A',
40 `neuro_vertigo_text` TEXT NOT NULL default '',
41 `neuro_amaurosis_fugax` varchar(3) NOT NULL default 'N/A',
42 `neuro_amaurosis_fugax_text` TEXT NOT NULL default '',
43 `neuro_stroke` varchar(3) NOT NULL default 'N/A',
44 `neuro_stroke_text` TEXT NOT NULL default '',
45 `neuro_gait_abnormality` varchar(3) NOT NULL default 'N/A',
46 `neuro_gait_abnormality_text` TEXT NOT NULL default '',
47 `neuro_frequent_headaches` varchar(3) NOT NULL default 'N/A',
48 `neuro_frequent_headaches_text` TEXT NOT NULL default '',
49 `neuro_parathesias` varchar(3) NOT NULL default 'N/A',
50 `neuro_parathesias_text` TEXT NOT NULL default '',
51 `neuro_seizures` varchar(3) NOT NULL default 'N/A',
52 `neuro_seizures_text` TEXT NOT NULL default '',
53 `neuro_trans_ischemic_attacks` varchar(3) NOT NULL default 'N/A',
54 `neuro_trans_ischemic_attacks_text` TEXT NOT NULL default '',
55 `neuro_significant_tremors` varchar(3) NOT NULL default 'N/A',
56 `neuro_significant_tremors_text` TEXT NOT NULL default '',
57 `neck_neck_stiffness` varchar(3) NOT NULL default 'N/A',
58 `neck_neck_stiffness_text` TEXT NOT NULL default '',
59 `neck_neck_pain` varchar(3) NOT NULL default 'N/A',
60 `neck_neck_pain_text` TEXT NOT NULL default '',
61 `neck_neck_masses` varchar(3) NOT NULL default 'N/A',
62 `neck_neck_masses_text` TEXT NOT NULL default '',
63 `neck_neck_tenderness` varchar(3) NOT NULL default 'N/A',
64 `neck_neck_tenderness_text` TEXT NOT NULL default '',
65 `heent_oral_ulcers` varchar(3) NOT NULL default 'N/A',
66 `heent_oral_ulcers_text` TEXT NOT NULL default '',
67 `heent_excessive_cavities` varchar(3) NOT NULL default 'N/A',
68 `heent_excessive_cavities_text` TEXT NOT NULL default '',
69 `heent_gingival_disease` varchar(3) NOT NULL default 'N/A',
70 `heent_gingival_disease_text` TEXT NOT NULL default '',
71 `heent_persistent_hoarseness` varchar(3) NOT NULL default 'N/A',
72 `heent_persistent_hoarseness_text` TEXT NOT NULL default '',
73 `heent_mouth_lesions` varchar(3) NOT NULL default 'N/A',
74 `heent_mouth_lesions_text` TEXT NOT NULL default '',
75 `heent_dysphagia` varchar(3) NOT NULL default 'N/A',
76 `heent_dysphagia_text` TEXT NOT NULL default '',
77 `heent_odynophagia` varchar(3) NOT NULL default 'N/A',
78 `heent_odynophagia_text` TEXT NOT NULL default '',
79 `heent_dental_pain` varchar(3) NOT NULL default 'N/A',
80 `heent_dental_pain_text` TEXT NOT NULL default '',
81 `heent_sore_throat` varchar(3) NOT NULL default 'N/A',
82 `heent_sore_throat_text` TEXT NOT NULL default '',
83 `heent_ear_pain` varchar(3) NOT NULL default 'N/A',
84 `heent_ear_pain_text` TEXT NOT NULL default '',
85 `heent_ear_discharge` varchar(3) NOT NULL default 'N/A',
86 `heent_ear_discharge_text` TEXT NOT NULL default '',
87 `heent_tinnitus` varchar(3) NOT NULL default 'N/A',
88 `heent_tinnitus_text` TEXT NOT NULL default '',
89 `heent_hearing_loss` varchar(3) NOT NULL default 'N/A',
90 `heent_hearing_loss_text` TEXT NOT NULL default '',
91 `heent_allergic_rhinitis` varchar(3) NOT NULL default 'N/A',
92 `heent_allergic_rhinitis_text` TEXT NOT NULL default '',
93 `heent_nasal_congestion` varchar(3) NOT NULL default 'N/A',
94 `heent_nasal_congestion_text` TEXT NOT NULL default '',
95 `heent_nasal_discharge` varchar(3) NOT NULL default 'N/A',
96 `heent_nasal_discharge_text` TEXT NOT NULL default '',
97 `heent_nasal_injury` varchar(3) NOT NULL default 'N/A',
98 `heent_nasal_injury_text` TEXT NOT NULL default '',
99 `heent_nasal_surgery` varchar(3) NOT NULL default 'N/A',
100 `heent_nasal_surgery_text` TEXT NOT NULL default '',
101 `heent_nose_bleeds` varchar(3) NOT NULL default 'N/A',
102 `heent_nose_bleeds_text` TEXT NOT NULL default '',
103 `heent_post_nasal_drip` varchar(3) NOT NULL default 'N/A',
104 `heent_post_nasal_drip_text` TEXT NOT NULL default '',
105 `heent_sinus_pressure` varchar(3) NOT NULL default 'N/A',
106 `heent_sinus_pressure_text` TEXT NOT NULL default '',
107 `heent_sinus_pain` varchar(3) NOT NULL default 'N/A',
108 `heent_sinus_pain_text` TEXT NOT NULL default '',
109 `heent_headache` varchar(3) NOT NULL default 'N/A',
110 `heent_headache_text` TEXT NOT NULL default '',
111 `heent_eye_pain` varchar(3) NOT NULL default 'N/A',
112 `heent_eye_pain_text` TEXT NOT NULL default '',
113 `heent_eye_redness` varchar(3) NOT NULL default 'N/A',
114 `heent_eye_redness_text` TEXT NOT NULL default '',
115 `heent_visual_changes` varchar(3) NOT NULL default 'N/A',
116 `heent_visual_changes_text` TEXT NOT NULL default '',
117 `heent_blurry_vision` varchar(3) NOT NULL default 'N/A',
118 `heent_blurry_vision_text` TEXT NOT NULL default '',
119 `heent_eye_discharge` varchar(3) NOT NULL default 'N/A',
120 `heent_eye_discharge_text` TEXT NOT NULL default '',
121 `heent_eye_glasses_contacts` varchar(3) NOT NULL default 'N/A',
122 `heent_eye_glasses_contacts_text` TEXT NOT NULL default '',
123 `heent_excess_tearing` varchar(3) NOT NULL default 'N/A',
124 `heent_excess_tearing_text` TEXT NOT NULL default '',
125 `heent_photophobia` varchar(3) NOT NULL default 'N/A',
126 `heent_photophobia_text` TEXT NOT NULL default '',
127 `heent_scotomata` varchar(3) NOT NULL default 'N/A',
128 `heent_scotomata_text` TEXT NOT NULL default '',
129 `heent_tunnel_vision` varchar(3) NOT NULL default 'N/A',
130 `heent_tunnel_vision_text` TEXT NOT NULL default '',
131 `heent_glaucoma` varchar(3) NOT NULL default 'N/A',
132 `heent_glaucoma_text` TEXT NOT NULL default '',
133 `cardiovascular_sub_sternal_or_left_chest_pain` varchar(3) NOT NULL default 'N/A',
134 `cardiovascular_sub_sternal_or_left_chest_pain_text` TEXT NOT NULL default '',
135 `cardiovascular_other_chest_pain` varchar(3) NOT NULL default 'N/A',
136 `cardiovascular_other_chest_pain_text` TEXT NOT NULL default '',
137 `cardiovascular_palpitations` varchar(3) NOT NULL default 'N/A',
138 `cardiovascular_palpitations_text` TEXT NOT NULL default '',
139 `cardiovascular_irregular_rhythm` varchar(3) NOT NULL default 'N/A',
140 `cardiovascular_irregular_rhythm_text` TEXT NOT NULL default '',
141 `cardiovascular_jugular_vein_distention` varchar(3) NOT NULL default 'N/A',
142 `cardiovascular_jugular_vein_distention_text` TEXT NOT NULL default '',
143 `cardiovascular_claudication` varchar(3) NOT NULL default 'N/A',
144 `cardiovascular_claudication_text` TEXT NOT NULL default '',
145 `cardiovascular_dizziness` varchar(3) NOT NULL default 'N/A',
146 `cardiovascular_dizziness_text` TEXT NOT NULL default '',
147 `cardiovascular_dyspnea_on_exertion` varchar(3) NOT NULL default 'N/A',
148 `cardiovascular_dyspnea_on_exertion_text` TEXT NOT NULL default '',
149 `cardiovascular_orthopnea` varchar(3) NOT NULL default 'N/A',
150 `cardiovascular_orthopnea_text` TEXT NOT NULL default '',
151 `cardiovascular_noctural_dyspnea` varchar(3) NOT NULL default 'N/A',
152 `cardiovascular_noctural_dyspnea_text` TEXT NOT NULL default '',
153 `cardiovascular_edema` varchar(3) NOT NULL default 'N/A',
154 `cardiovascular_edema_text` TEXT NOT NULL default '',
155 `cardiovascular_presyncope` varchar(3) NOT NULL default 'N/A',
156 `cardiovascular_presyncope_text` TEXT NOT NULL default '',
157 `cardiovascular_syncope` varchar(3) NOT NULL default 'N/A',
158 `cardiovascular_syncope_text` TEXT NOT NULL default '',
159 `cardiovascular_heart_murmur` varchar(3) NOT NULL default 'N/A',
160 `cardiovascular_heart_murmur_text` TEXT NOT NULL default '',
161 `cardiovascular_raynauds` varchar(3) NOT NULL default 'N/A',
162 `cardiovascular_raynauds_text` TEXT NOT NULL default '',
163 `cardiovascular_severe_varicose_veins` varchar(3) NOT NULL default 'N/A',
164 `cardiovascular_severe_varicose_veins_text` TEXT NOT NULL default '',
165 `cardiovascular_deep_vein_thrombosis` varchar(3) NOT NULL default 'N/A',
166 `cardiovascular_deep_vein_thrombosis_text` TEXT NOT NULL default '',
167 `cardiovascular_thrombophlebitis` varchar(3) NOT NULL default 'N/A',
168 `cardiovascular_thrombophlebitis_text` TEXT NOT NULL default '',
169 `respirations_cough` varchar(3) NOT NULL default 'N/A',
170 `respirations_cough_text` TEXT NOT NULL default '',
171 `respirations_sputum` varchar(3) NOT NULL default 'N/A',
172 `respirations_sputum_text` TEXT NOT NULL default '',
173 `respirations_dyspnea` varchar(3) NOT NULL default 'N/A',
174 `respirations_dyspnea_text` TEXT NOT NULL default '',
175 `respirations_wheezes` varchar(3) NOT NULL default 'N/A',
176 `respirations_wheezes_text` TEXT NOT NULL default '',
177 `respirations_rales` varchar(3) NOT NULL default 'N/A',
178 `respirations_rales_text` TEXT NOT NULL default '',
179 `respirations_labored_breathing` varchar(3) NOT NULL default 'N/A',
180 `respirations_labored_breathing_text` TEXT NOT NULL default '',
181 `respirations_hemoptysis` varchar(3) NOT NULL default 'N/A',
182 `respirations_hemoptysis_text` TEXT NOT NULL default '',
183 `gu_frequent_urination` varchar(3) NOT NULL default 'N/A',
184 `gu_frequent_urination_text` TEXT NOT NULL default '',
185 `gu_dysuria` varchar(3) NOT NULL default 'N/A',
186 `gu_dysuria_text` TEXT NOT NULL default '',
187 `gu_dyspareunia` varchar(3) NOT NULL default 'N/A',
188 `gu_dyspareunia_text` TEXT NOT NULL default '',
189 `gu_discharge` varchar(3) NOT NULL default 'N/A',
190 `gu_discharge_text` TEXT NOT NULL default '',
191 `gu_odor` varchar(3) NOT NULL default 'N/A',
192 `gu_odor_text` TEXT NOT NULL default '',
193 `gu_fertility_problems` varchar(3) NOT NULL default 'N/A',
194 `gu_fertility_problems_text` TEXT NOT NULL default '',
195 `gu_flank_pain_kidney_stone` varchar(3) NOT NULL default 'N/A',
196 `gu_flank_pain_kidney_stone_text` TEXT NOT NULL default '',
197 `gu_polyuria` varchar(3) NOT NULL default 'N/A',
198 `gu_polyuria_text` TEXT NOT NULL default '',
199 `gu_hematuria` varchar(3) NOT NULL default 'N/A',
200 `gu_hematuria_text` TEXT NOT NULL default '',
201 `gu_pyuria` varchar(3) NOT NULL default 'N/A',
202 `gu_pyuria_text` TEXT NOT NULL default '',
203 `gu_umbilical_hernia` varchar(3) NOT NULL default 'N/A',
204 `gu_umbilical_hernia_text` TEXT NOT NULL default '',
205 `gu_incontinence` varchar(3) NOT NULL default 'N/A',
206 `gu_incontinence_text` TEXT NOT NULL default '',
207 `gu_nocturia` varchar(3) NOT NULL default 'N/A',
208 `gu_nocturia_text` TEXT NOT NULL default '',
209 `gu_urinary_urgency` varchar(3) NOT NULL default 'N/A',
210 `gu_urinary_urgency_text` TEXT NOT NULL default '',
211 `gu_recurrent_utis` varchar(3) NOT NULL default 'N/A',
212 `gu_recurrent_utis_text` TEXT NOT NULL default '',
213 `gu_venereal_disease` varchar(3) NOT NULL default 'N/A',
214 `gu_venereal_disease_text` TEXT NOT NULL default '',
215 `male_gu_erectile_dysfunction` varchar(3) NOT NULL default 'N/A',
216 `male_gu_erectile_dysfunction_text` TEXT NOT NULL default '',
217 `male_gu_inguinal_hernia` varchar(3) NOT NULL default 'N/A',
218 `male_gu_inguinal_hernia_text` TEXT NOT NULL default '',
219 `male_gu_penile_lesions` varchar(3) NOT NULL default 'N/A',
220 `male_gu_penile_lesions_text` TEXT NOT NULL default '',
221 `male_gu_scrotal_mass` varchar(3) NOT NULL default 'N/A',
222 `male_gu_scrotal_mass_text` TEXT NOT NULL default '',
223 `male_gu_testicular_pain` varchar(3) NOT NULL default 'N/A',
224 `male_gu_testicular_pain_text` TEXT NOT NULL default '',
225 `male_gu_urethral_discharge` varchar(3) NOT NULL default 'N/A',
226 `male_gu_urethral_discharge_text` TEXT NOT NULL default '',
227 `male_gu_weak_urinary_stream` varchar(3) NOT NULL default 'N/A',
228 `male_gu_weak_urinary_stream_text` TEXT NOT NULL default '',
229 `female_gu_abnormal_menses` varchar(3) NOT NULL default 'N/A',
230 `female_gu_abnormal_menses_text` TEXT NOT NULL default '',
231 `female_gu_abnormal_vaginal_bleeding` varchar(3) NOT NULL default 'N/A',
232 `female_gu_abnormal_vaginal_bleeding_text` TEXT NOT NULL default '',
233 `female_gu_vaginal_discharge` varchar(3) NOT NULL default 'N/A',
234 `female_gu_vaginal_discharge_text` TEXT NOT NULL default '',
235 `gi_abdominal_pain` varchar(3) NOT NULL default 'N/A',
236 `gi_abdominal_pain_text` TEXT NOT NULL default '',
237 `gi_cramps` varchar(3) NOT NULL default 'N/A',
238 `gi_cramps_text` TEXT NOT NULL default '',
239 `gi_tenderness` varchar(3) NOT NULL default 'N/A',
240 `gi_tenderness_text` TEXT NOT NULL default '',
241 `gi_vomiting` varchar(3) NOT NULL default 'N/A',
242 `gi_vomiting_text` TEXT NOT NULL default '',
243 `gi_frequent_diarrhea` varchar(3) NOT NULL default 'N/A',
244 `gi_frequent_diarrhea_text` TEXT NOT NULL default '',
245 `gi_significant_constipation` varchar(3) NOT NULL default 'N/A',
246 `gi_significant_constipation_text` TEXT NOT NULL default '',
247 `gi_excessive_belching` varchar(3) NOT NULL default 'N/A',
248 `gi_excessive_belching_text` TEXT NOT NULL default '',
249 `gi_changed_bowel_habits` varchar(3) NOT NULL default 'N/A',
250 `gi_changed_bowel_habits_text` TEXT NOT NULL default '',
251 `gi_excessive_flatulence` varchar(3) NOT NULL default 'N/A',
252 `gi_excessive_flatulence_text` TEXT NOT NULL default '',
253 `gi_hematemesis` varchar(3) NOT NULL default 'N/A',
254 `gi_hematemesis_text` TEXT NOT NULL default '',
255 `gi_hemorrhoids` varchar(3) NOT NULL default 'N/A',
256 `gi_hemorrhoids_text` TEXT NOT NULL default '',
257 `gi_hepatitis` varchar(3) NOT NULL default 'N/A',
258 `gi_hepatitis_text` TEXT NOT NULL default '',
259 `gi_jaundice` varchar(3) NOT NULL default 'N/A',
260 `gi_jaundice_text` TEXT NOT NULL default '',
261 `gi_lactose_intolerance` varchar(3) NOT NULL default 'N/A',
262 `gi_lactose_intolerance_text` TEXT NOT NULL default '',
263 `gi_chronic_laxative_use` varchar(3) NOT NULL default 'N/A',
264 `gi_chronic_laxative_use_text` TEXT NOT NULL default '',
265 `gi_melena` varchar(3) NOT NULL default 'N/A',
266 `gi_melena_text` TEXT NOT NULL default '',
267 `gi_frequent_nausea` varchar(3) NOT NULL default 'N/A',
268 `gi_frequent_nausea_text` TEXT NOT NULL default '',
269 `gi_rectal_bleeding` varchar(3) NOT NULL default 'N/A',
270 `gi_rectal_bleeding_text` TEXT NOT NULL default '',
271 `gi_rectal_pain` varchar(3) NOT NULL default 'N/A',
272 `gi_rectal_pain_text` TEXT NOT NULL default '',
273 `gi_stool_caliber_change` varchar(3) NOT NULL default 'N/A',
274 `gi_stool_caliber_change_text` TEXT NOT NULL default '',
275 `integument_pallor` varchar(3) NOT NULL default 'N/A',
276 `integument_pallor_text` TEXT NOT NULL default '',
277 `integument_diaphoresis` varchar(3) NOT NULL default 'N/A',
278 `integument_diaphoresis_text` TEXT NOT NULL default '',
279 `integument_rash` varchar(3) NOT NULL default 'N/A',
280 `integument_rash_text` TEXT NOT NULL default '',
281 `integument_itching` varchar(3) NOT NULL default 'N/A',
282 `integument_itching_text` TEXT NOT NULL default '',
283 `integument_ulcers` varchar(3) NOT NULL default 'N/A',
284 `integument_ulcers_text` TEXT NOT NULL default '',
285 `integument_abscess` varchar(3) NOT NULL default 'N/A',
286 `integument_abscess_text` TEXT NOT NULL default '',
287 `integument_nodules` varchar(3) NOT NULL default 'N/A',
288 `integument_nodules_text` TEXT NOT NULL default '',
289 `integument_acne` varchar(3) NOT NULL default 'N/A',
290 `integument_acne_text` TEXT NOT NULL default '',
291 `integument_recurrent_boils` varchar(3) NOT NULL default 'N/A',
292 `integument_recurrent_boils_text` TEXT NOT NULL default '',
293 `integument_chronic_eczema` varchar(3) NOT NULL default 'N/A',
294 `integument_chronic_eczema_text` TEXT NOT NULL default '',
295 `integument_changing_moles` varchar(3) NOT NULL default 'N/A',
296 `integument_changing_moles_text` TEXT NOT NULL default '',
297 `integument_nail_abnormalities` varchar(3) NOT NULL default 'N/A',
298 `integument_nail_abnormalities_text` TEXT NOT NULL default '',
299 `integument_psoriasis` varchar(3) NOT NULL default 'N/A',
300 `integument_psoriasis_text` TEXT NOT NULL default '',
301 `integument_recurrent_hives` varchar(3) NOT NULL default 'N/A',
302 `integument_recurrent_hives_text` TEXT NOT NULL default '',
303 `musculoskeletal_deformity` varchar(3) NOT NULL default 'N/A',
304 `musculoskeletal_deformity_text` TEXT NOT NULL default '',
305 `musculoskeletal_edema` varchar(3) NOT NULL default 'N/A',
306 `musculoskeletal_edema_text` TEXT NOT NULL default '',
307 `musculoskeletal_pain` varchar(3) NOT NULL default 'N/A',
308 `musculoskeletal_pain_text` TEXT NOT NULL default '',
309 `musculoskeletal_limited_rom` varchar(3) NOT NULL default 'N/A',
310 `musculoskeletal_limited_rom_text` TEXT NOT NULL default '',
311 `musculoskeletal_gait` varchar(3) NOT NULL default 'N/A',
312 `musculoskeletal_gait_text` TEXT NOT NULL default '',
313 `musculoskeletal_arthritis` varchar(3) NOT NULL default 'N/A',
314 `musculoskeletal_arthritis_text` TEXT NOT NULL default '',
315 `musculoskeletal_neck_pain` varchar(3) NOT NULL default 'N/A',
316 `musculoskeletal_neck_pain_text` TEXT NOT NULL default '',
317 `musculoskeletal_mid_back_pain` varchar(3) NOT NULL default 'N/A',
318 `musculoskeletal_mid_back_pain_text` TEXT NOT NULL default '',
319 `musculoskeletal_low_back_pain` varchar(3) NOT NULL default 'N/A',
320 `musculoskeletal_low_back_pain_text` TEXT NOT NULL default '',
321 `musculoskeletal_bursitis` varchar(3) NOT NULL default 'N/A',
322 `musculoskeletal_bursitis_text` TEXT NOT NULL default '',
323 `musculoskeletal_gout` varchar(3) NOT NULL default 'N/A',
324 `musculoskeletal_gout_text` TEXT NOT NULL default '',
325 `musculoskeletal_joint_injury` varchar(3) NOT NULL default 'N/A',
326 `musculoskeletal_joint_injury_text` TEXT NOT NULL default '',
327 `musculoskeletal_joint_pain` varchar(3) NOT NULL default 'N/A',
328 `musculoskeletal_joint_pain_text` TEXT NOT NULL default '',
329 `musculoskeletal_joint_swelling` varchar(3) NOT NULL default 'N/A',
330 `musculoskeletal_joint_swelling_text` TEXT NOT NULL default '',
331 `musculoskeletal_myalgias` varchar(3) NOT NULL default 'N/A',
332 `musculoskeletal_myalgias_text` TEXT NOT NULL default '',
333 `musculoskeletal_sciatica` varchar(3) NOT NULL default 'N/A',
334 `musculoskeletal_sciatica_text` TEXT NOT NULL default '',
335 `musculoskeletal_scoliosis` varchar(3) NOT NULL default 'N/A',
336 `musculoskeletal_scoliosis_text` TEXT NOT NULL default '',
337 `hematological_anemia` varchar(3) NOT NULL default 'N/A',
338 `hematological_anemia_text` TEXT NOT NULL default '',
339 `hematological_pallor` varchar(3) NOT NULL default 'N/A',
340 `hematological_pallor_text` TEXT NOT NULL default '',
341 `hematological_bleeding_tendencies` varchar(3) NOT NULL default 'N/A',
342 `hematological_bleeding_tendencies_text` TEXT NOT NULL default '',
343 `hematological_bruising` varchar(3) NOT NULL default 'N/A',
344 `hematological_bruising_text` TEXT NOT NULL default '',
345 `endocrine_thyroid_problems` varchar(3) NOT NULL default 'N/A',
346 `endocrine_thyroid_problems_text` TEXT NOT NULL default '',
347 `endocrine_enlarged_thyroid` varchar(3) NOT NULL default 'N/A',
348 `endocrine_enlarged_thyroid_text` TEXT NOT NULL default '',
349 `endocrine_hyperglycemia` varchar(3) NOT NULL default 'N/A',
350 `endocrine_hyperglycemia_text` TEXT NOT NULL default '',
351 `endocrine_hypoglycemia` varchar(3) NOT NULL default 'N/A',
352 `endocrine_hypoglycemia_text` TEXT NOT NULL default '',
353 `endocrine_cold_intolerance` varchar(3) NOT NULL default 'N/A',
354 `endocrine_cold_intolerance_text` TEXT NOT NULL default '',
355 `endocrine_heat_intolerance` varchar(3) NOT NULL default 'N/A',
356 `endocrine_heat_intolerance_text` TEXT NOT NULL default '',
357 `endocrine_early_awakening` varchar(3) NOT NULL default 'N/A',
358 `endocrine_early_awakening_text` TEXT NOT NULL default '',
359 `endocrine_fatigue_unexplained` varchar(3) NOT NULL default 'N/A',
360 `endocrine_fatigue_unexplained_text` TEXT NOT NULL default '',
361 `endocrine_weight_gain` varchar(3) NOT NULL default 'N/A',
362 `endocrine_weight_gain_text` TEXT NOT NULL default '',
363 `endocrine_weight_loss` varchar(3) NOT NULL default 'N/A',
364 `endocrine_weight_loss_text` TEXT NOT NULL default '',
365 `endocrine_premenstrual_symptoms` varchar(3) NOT NULL default 'N/A',
366 `endocrine_premenstrual_symptoms_text` TEXT NOT NULL default '',
367 `endocrine_hair_no_change_or_no_loss` varchar(3) NOT NULL default 'N/A',
368 `endocrine_hair_no_change_or_no_loss_text` TEXT NOT NULL default '',
369 `endocrine_hot_flashes` varchar(3) NOT NULL default 'N/A',
370 `endocrine_hot_flashes_text` TEXT NOT NULL default '',
371 `lymphatic_swollen_lymph_nodes` varchar(3) NOT NULL default 'N/A',
372 `lymphatic_swollen_lymph_nodes_text` TEXT NOT NULL default '',
373 `lymphatic_swollen_extremities` varchar(3) NOT NULL default 'N/A',
374 `lymphatic_swollen_extremities_text` TEXT NOT NULL default '',
375 `psychiatric_compulsions` varchar(3) NOT NULL default 'N/A',
376 `psychiatric_compulsions_text` TEXT NOT NULL default '',
377 `psychiatric_depression` varchar(3) NOT NULL default 'N/A',
378 `psychiatric_depression_text` TEXT NOT NULL default '',
379 `psychiatric_fear` varchar(3) NOT NULL default 'N/A',
380 `psychiatric_fear_text` TEXT NOT NULL default '',
381 `psychiatric_anxiety` varchar(3) NOT NULL default 'N/A',
382 `psychiatric_anxiety_text` TEXT NOT NULL default '',
383 `psychiatric_hallucinations` varchar(3) NOT NULL default 'N/A',
384 `psychiatric_hallucinations_text` TEXT NOT NULL default '',
385 `psychiatric_loss_of_interest` varchar(3) NOT NULL default 'N/A',
386 `psychiatric_loss_of_interest_text` TEXT NOT NULL default '',
387 `psychiatric_memory_loss` varchar(3) NOT NULL default 'N/A',
388 `psychiatric_memory_loss_text` TEXT NOT NULL default '',
389 `psychiatric_mood_swings` varchar(3) NOT NULL default 'N/A',
390 `psychiatric_mood_swings_text` TEXT NOT NULL default '',
391 `psychiatric_pananoia` varchar(3) NOT NULL default 'N/A',
392 `psychiatric_pananoia_text` TEXT NOT NULL default '',
393 `psychiatric_insomnia` varchar(3) NOT NULL default 'N/A',
394 `psychiatric_insomnia_text` TEXT NOT NULL default '',
395 PRIMARY KEY (id)
396 ) ENGINE=InnoDB;