CREATE TABLE IF NOT EXISTS `form_reviewofs` (
id bigint(20) NOT NULL auto_increment,
date datetime default NULL,
pid bigint(20) default NULL,
user varchar(255) default NULL,
groupname varchar(255) default NULL,
authorized tinyint(4) default NULL,
activity tinyint(4) default NULL,
fever varchar(5),
chills varchar(5),
night_sweats varchar(5),
weight_loss varchar(5),
poor_appetite varchar(5),
insomnia varchar(5),
fatigued varchar(5),
depressed varchar(5),
hyperactive varchar(5),
exposure_to_foreign_countries varchar(5),
cataracts varchar(5),
cataract_surgery varchar(5),
glaucoma varchar(5),
double_vision varchar(5),
blurred_vision varchar(5),
poor_hearing varchar(5),
headaches varchar(5),
ringing_in_ears varchar(5),
bloody_nose varchar(5),
sinusitis varchar(5),
sinus_surgery varchar(5),
dry_mouth varchar(5),
strep_throat varchar(5),
tonsillectomy varchar(5),
swollen_lymph_nodes varchar(5),
throat_cancer varchar(5),
throat_cancer_surgery varchar(5),
heart_attack varchar(5),
irregular_heart_beat varchar(5),
chest_pains varchar(5),
shortness_of_breath varchar(5),
high_blood_pressure varchar(5),
heart_failure varchar(5),
poor_circulation varchar(5),
vascular_surgery varchar(5),
cardiac_catheterization varchar(5),
coronary_artery_bypass varchar(5),
heart_transplant varchar(5),
stress_test varchar(5),
emphysema varchar(5),
chronic_bronchitis varchar(5),
interstitial_lung_disease varchar(5),
shortness_of_breath_2 varchar(5),
lung_cancer varchar(5),
lung_cancer_surgery varchar(5),
pheumothorax varchar(5),
stomach_pains varchar(5),
peptic_ulcer_disease varchar(5),
gastritis varchar(5),
endoscopy varchar(5),
polyps varchar(5),
colonoscopy varchar(5),
colon_cancer varchar(5),
colon_cancer_surgery varchar(5),
ulcerative_colitis varchar(5),
crohns_disease varchar(5),
appendectomy varchar(5),
divirticulitis varchar(5),
divirticulitis_surgery varchar(5),
gall_stones varchar(5),
cholecystectomy varchar(5),
hepatitis varchar(5),
cirrhosis_of_the_liver varchar(5),
splenectomy varchar(5),
kidney_failure varchar(5),
kidney_stones varchar(5),
kidney_cancer varchar(5),
kidney_infections varchar(5),
bladder_infections varchar(5),
bladder_cancer varchar(5),
prostate_problems varchar(5),
prostate_cancer varchar(5),
kidney_transplant varchar(5),
sexually_transmitted_disease varchar(5),
burning_with_urination varchar(5),
discharge_from_urethra varchar(5),
rashes varchar(5),
infections varchar(5),
ulcerations varchar(5),
pemphigus varchar(5),
herpes varchar(5),
osetoarthritis varchar(5),
rheumotoid_arthritis varchar(5),
lupus varchar(5),
ankylosing_sondlilitis varchar(5),
swollen_joints varchar(5),
stiff_joints varchar(5),
broken_bones varchar(5),
neck_problems varchar(5),
back_problems varchar(5),
back_surgery varchar(5),
scoliosis varchar(5),
herniated_disc varchar(5),
shoulder_problems varchar(5),
elbow_problems varchar(5),
wrist_problems varchar(5),
hand_problems varchar(5),
hip_problems varchar(5),
knee_problems varchar(5),
ankle_problems varchar(5),
foot_problems varchar(5),
insulin_dependent_diabetes varchar(5),
noninsulin_dependent_diabetes varchar(5),
hypothyroidism varchar(5),
hyperthyroidism varchar(5),
cushing_syndrom varchar(5),
addison_syndrom varchar(5),
additional_notes longtext,
PRIMARY KEY (id)
) ENGINE=InnoDB;
