| blob | 6362913f2e1a0690259b4b5bdf4153120d4d3123 |
1 CREATE TABLE `form_ros` (
2 `id` int(11) NOT NULL auto_increment,
3 `pid` int(11) NOT NULL,
4 `activity` int(11) NOT NULL default '1',
5 `date` datetime default NULL,
6 `weight_change` varchar(3) NOT NULL default 'N/A',
7 `weakness` varchar(3) NOT NULL default 'N/A',
8 `fatigue` varchar(3) NOT NULL default 'N/A',
9 `anorexia` varchar(3) NOT NULL default 'N/A',
10 `fever` varchar(3) NOT NULL default 'N/A',
11 `chills` varchar(3) NOT NULL default 'N/A',
12 `night_sweats` varchar(3) NOT NULL default 'N/A',
13 `insomnia` varchar(3) NOT NULL default 'N/A',
14 `irritability` varchar(3) NOT NULL default 'N/A',
15 `heat_or_cold` varchar(3) NOT NULL default 'N/A',
16 `intolerance` varchar(3) NOT NULL default 'N/A',
17 `change_in_vision` varchar(3) NOT NULL default 'N/A',
18 `glaucoma_history` varchar(3) NOT NULL default 'N/A',
19 `eye_pain` varchar(3) NOT NULL default 'N/A',
20 `irritation` varchar(3) NOT NULL default 'N/A',
21 `redness` varchar(3) NOT NULL default 'N/A',
22 `excessive_tearing` varchar(3) NOT NULL default 'N/A',
23 `double_vision` varchar(3) NOT NULL default 'N/A',
24 `blind_spots` varchar(3) NOT NULL default 'N/A',
25 `photophobia` varchar(3) NOT NULL default 'N/A',
26 `hearing_loss` varchar(3) NOT NULL default 'N/A',
27 `discharge` varchar(3) NOT NULL default 'N/A',
28 `pain` varchar(3) NOT NULL default 'N/A',
29 `vertigo` varchar(3) NOT NULL default 'N/A',
30 `tinnitus` varchar(3) NOT NULL default 'N/A',
31 `frequent_colds` varchar(3) NOT NULL default 'N/A',
32 `sore_throat` varchar(3) NOT NULL default 'N/A',
33 `sinus_problems` varchar(3) NOT NULL default 'N/A',
34 `post_nasal_drip` varchar(3) NOT NULL default 'N/A',
35 `nosebleed` varchar(3) NOT NULL default 'N/A',
36 `snoring` varchar(3) NOT NULL default 'N/A',
37 `apnea` varchar(3) NOT NULL default 'N/A',
38 `breast_mass` varchar(3) NOT NULL default 'N/A',
39 `breast_discharge` varchar(3) NOT NULL default 'N/A',
40 `biopsy` varchar(3) NOT NULL default 'N/A',
41 `abnormal_mammogram` varchar(3) NOT NULL default 'N/A',
42 `cough` varchar(3) NOT NULL default 'N/A',
43 `sputum` varchar(3) NOT NULL default 'N/A',
44 `shortness_of_breath` varchar(3) NOT NULL default 'N/A',
45 `wheezing` varchar(3) NOT NULL default 'N/A',
46 `hemoptsyis` varchar(3) NOT NULL default 'N/A',
47 `asthma` varchar(3) NOT NULL default 'N/A',
48 `copd` varchar(3) NOT NULL default 'N/A',
49 `chest_pain` varchar(3) NOT NULL default 'N/A',
50 `palpitation` varchar(3) NOT NULL default 'N/A',
51 `syncope` varchar(3) NOT NULL default 'N/A',
52 `pnd` varchar(3) NOT NULL default 'N/A',
53 `doe` varchar(3) NOT NULL default 'N/A',
54 `orthopnea` varchar(3) NOT NULL default 'N/A',
55 `peripheal` varchar(3) NOT NULL default 'N/A',
56 `edema` varchar(3) NOT NULL default 'N/A',
57 `legpain_cramping` varchar(3) NOT NULL default 'N/A',
58 `history_murmur` varchar(3) NOT NULL default 'N/A',
59 `arrythmia` varchar(3) NOT NULL default 'N/A',
60 `heart_problem` varchar(3) NOT NULL default 'N/A',
61 `dysphagia` varchar(3) NOT NULL default 'N/A',
62 `heartburn` varchar(3) NOT NULL default 'N/A',
63 `bloating` varchar(3) NOT NULL default 'N/A',
64 `belching` varchar(3) NOT NULL default 'N/A',
65 `flatulence` varchar(3) NOT NULL default 'N/A',
66 `nausea` varchar(3) NOT NULL default 'N/A',
67 `vomiting` varchar(3) NOT NULL default 'N/A',
68 `hematemesis` varchar(3) NOT NULL default 'N/A',
69 `gastro_pain` varchar(3) NOT NULL default 'N/A',
70 `food_intolerance` varchar(3) NOT NULL default 'N/A',
71 `hepatitis` varchar(3) NOT NULL default 'N/A',
72 `jaundice` varchar(3) NOT NULL default 'N/A',
73 `hematochezia` varchar(3) NOT NULL default 'N/A',
74 `changed_bowel` varchar(3) NOT NULL default 'N/A',
75 `diarrhea` varchar(3) NOT NULL default 'N/A',
76 `constipation` varchar(3) NOT NULL default 'N/A',
77 `polyuria` varchar(3) NOT NULL default 'N/A',
78 `polydypsia` varchar(3) NOT NULL default 'N/A',
79 `dysuria` varchar(3) NOT NULL default 'N/A',
80 `hematuria` varchar(3) NOT NULL default 'N/A',
81 `frequency` varchar(3) NOT NULL default 'N/A',
82 `urgency` varchar(3) NOT NULL default 'N/A',
83 `incontinence` varchar(3) NOT NULL default 'N/A',
84 `renal_stones` varchar(3) NOT NULL default 'N/A',
85 `utis` varchar(3) NOT NULL default 'N/A',
86 `hesitancy` varchar(3) NOT NULL default 'N/A',
87 `dribbling` varchar(3) NOT NULL default 'N/A',
88 `stream` varchar(3) NOT NULL default 'N/A',
89 `nocturia` varchar(3) NOT NULL default 'N/A',
90 `erections` varchar(3) NOT NULL default 'N/A',
91 `ejaculations` varchar(3) NOT NULL default 'N/A',
92 `g` varchar(3) NOT NULL default 'N/A',
93 `p` varchar(3) NOT NULL default 'N/A',
94 `ap` varchar(3) NOT NULL default 'N/A',
95 `lc` varchar(3) NOT NULL default 'N/A',
96 `mearche` varchar(3) NOT NULL default 'N/A',
97 `menopause` varchar(3) NOT NULL default 'N/A',
98 `lmp` varchar(3) NOT NULL default 'N/A',
99 `f_frequency` varchar(3) NOT NULL default 'N/A',
100 `f_flow` varchar(3) NOT NULL default 'N/A',
101 `f_symptoms` varchar(3) NOT NULL default 'N/A',
102 `abnormal_hair_growth` varchar(3) NOT NULL default 'N/A',
103 `f_hirsutism` varchar(3) NOT NULL default 'N/A',
104 `joint_pain` varchar(3) NOT NULL default 'N/A',
105 `swelling` varchar(3) NOT NULL default 'N/A',
106 `m_redness` varchar(3) NOT NULL default 'N/A',
107 `m_warm` varchar(3) NOT NULL default 'N/A',
108 `m_stiffness` varchar(3) NOT NULL default 'N/A',
109 `muscle` varchar(3) NOT NULL default 'N/A',
110 `m_aches` varchar(3) NOT NULL default 'N/A',
111 `fms` varchar(3) NOT NULL default 'N/A',
112 `arthritis` varchar(3) NOT NULL default 'N/A',
113 `loc` varchar(3) NOT NULL default 'N/A',
114 `seizures` varchar(3) NOT NULL default 'N/A',
115 `stroke` varchar(3) NOT NULL default 'N/A',
116 `tia` varchar(3) NOT NULL default 'N/A',
117 `n_numbness` varchar(3) NOT NULL default 'N/A',
118 `n_weakness` varchar(3) NOT NULL default 'N/A',
119 `paralysis` varchar(3) NOT NULL default 'N/A',
120 `intellectual_decline` varchar(3) NOT NULL default 'N/A',
121 `memory_problems` varchar(3) NOT NULL default 'N/A',
122 `dementia` varchar(3) NOT NULL default 'N/A',
123 `n_headache` varchar(3) NOT NULL default 'N/A',
124 `s_cancer` varchar(3) NOT NULL default 'N/A',
125 `psoriasis` varchar(3) NOT NULL default 'N/A',
126 `s_acne` varchar(3) NOT NULL default 'N/A',
127 `s_other` varchar(3) NOT NULL default 'N/A',
128 `s_disease` varchar(3) NOT NULL default 'N/A',
129 `p_diagnosis` varchar(3) NOT NULL default 'N/A',
130 `p_medication` varchar(3) NOT NULL default 'N/A',
131 `depression` varchar(3) NOT NULL default 'N/A',
132 `anxiety` varchar(3) NOT NULL default 'N/A',
133 `social_difficulties` varchar(3) NOT NULL default 'N/A',
134 `thyroid_problems` varchar(3) NOT NULL default 'N/A',
135 `diabetes` varchar(3) NOT NULL default 'N/A',
136 `abnormal_blood` varchar(3) NOT NULL default 'N/A',
137 `anemia` varchar(3) NOT NULL default 'N/A',
138 `fh_blood_problems` varchar(3) NOT NULL default 'N/A',
139 `bleeding_problems` varchar(3) NOT NULL default 'N/A',
140 `allergies` varchar(3) NOT NULL default 'N/A',
141 `frequent_illness` varchar(3) NOT NULL default 'N/A',
142 `hiv` varchar(3) NOT NULL default 'N/A',
143 `hai_status` varchar(3) NOT NULL default 'N/A',
144 PRIMARY KEY (id)
145 ) ENGINE=InnoDB;