1 CREATE TABLE IF NOT EXISTS `form_dub_soap` (
2 /* both extended and encounter forms need a last modified date */
3 date datetime default NULL comment 'last modified date',
4 /* these fields are common to all encounter forms. */
5 id bigint(20) NOT NULL auto_increment,
6 pid bigint(20) NOT NULL default 0,
7 user varchar(255) default NULL,
8 groupname varchar(255) default NULL,
9 authorized tinyint(4) default NULL,
10 activity tinyint(4) default NULL,
11 menstrual_history varchar(255),
12 previous_sonogram varchar(255),
13 previous_blood_work varchar(255),
14 previous_needs_rx varchar(255),
16 dub_objective varchar(255),
18 plan_lab_work varchar(255),
19 plan_tests_procedures varchar(255),
20 plan_medications varchar(255),
23 INSERT IGNORE INTO list_options SET list_id='lists',
24 option_id='DUB_Menstrual_History',
25 title='DUB Menstrual History';
26 INSERT IGNORE INTO list_options SET list_id='DUB_Menstrual_History',
28 title='Bleeding Interval',
30 INSERT IGNORE INTO list_options SET list_id='DUB_Menstrual_History',
34 INSERT IGNORE INTO list_options SET list_id='DUB_Menstrual_History',
38 INSERT IGNORE INTO list_options SET list_id='DUB_Menstrual_History',
42 INSERT IGNORE INTO list_options SET list_id='DUB_Menstrual_History',
44 title='Menometrorrhagia',
46 INSERT IGNORE INTO list_options SET list_id='DUB_Menstrual_History',
50 INSERT IGNORE INTO list_options SET list_id='DUB_Menstrual_History',
54 INSERT IGNORE INTO list_options SET list_id='DUB_Menstrual_History',
58 INSERT IGNORE INTO list_options SET list_id='DUB_Menstrual_History',
62 INSERT IGNORE INTO list_options SET list_id='DUB_Menstrual_History',
66 INSERT IGNORE INTO list_options SET list_id='lists',
67 option_id='DUB_Objective',
68 title='DUB Objective';
69 INSERT IGNORE INTO list_options SET list_id='DUB_Objective',
73 INSERT IGNORE INTO list_options SET list_id='DUB_Objective',
77 INSERT IGNORE INTO list_options SET list_id='DUB_Objective',
81 INSERT IGNORE INTO list_options SET list_id='DUB_Objective',
85 INSERT IGNORE INTO list_options SET list_id='DUB_Objective',
89 INSERT IGNORE INTO list_options SET list_id='lists',
90 option_id='DUB_Diagnosis',
91 title='DUB Diagnosis';
92 INSERT IGNORE INTO list_options SET list_id='DUB_Diagnosis',
96 INSERT IGNORE INTO list_options SET list_id='DUB_Diagnosis',
100 INSERT IGNORE INTO list_options SET list_id='DUB_Diagnosis',
102 title='Oral Contraception Breakthrough',
104 INSERT IGNORE INTO list_options SET list_id='DUB_Diagnosis',
106 title='Dysmenorrhea',
108 INSERT IGNORE INTO list_options SET list_id='DUB_Diagnosis',
110 title='Endometriosis',
112 INSERT IGNORE INTO list_options SET list_id='DUB_Diagnosis',
116 INSERT IGNORE INTO list_options SET list_id='DUB_Diagnosis',
118 title='Perimenopause',
120 INSERT IGNORE INTO list_options SET list_id='DUB_Diagnosis',
124 INSERT IGNORE INTO list_options SET list_id='DUB_Diagnosis',
128 INSERT IGNORE INTO list_options SET list_id='DUB_Diagnosis',
132 INSERT IGNORE INTO list_options SET list_id='lists',
133 option_id='DUB_Lab_Work',
134 title='DUB Lab Work';
135 INSERT IGNORE INTO list_options SET list_id='DUB_Lab_Work',
139 INSERT IGNORE INTO list_options SET list_id='DUB_Lab_Work',
143 INSERT IGNORE INTO list_options SET list_id='DUB_Lab_Work',
147 INSERT IGNORE INTO list_options SET list_id='DUB_Lab_Work',
149 title='FSH/Estradiol(E2)',
151 INSERT IGNORE INTO list_options SET list_id='DUB_Lab_Work',
155 INSERT IGNORE INTO list_options SET list_id='DUB_Lab_Work',
159 INSERT IGNORE INTO list_options SET list_id='DUB_Lab_Work',
163 INSERT IGNORE INTO list_options SET list_id='lists',
164 option_id='DUB_Tests_Procedures',
165 title='DUB Tests Procedures';
166 INSERT IGNORE INTO list_options SET list_id='DUB_Tests_Procedures',
170 INSERT IGNORE INTO list_options SET list_id='DUB_Tests_Procedures',
174 INSERT IGNORE INTO list_options SET list_id='DUB_Tests_Procedures',
178 INSERT IGNORE INTO list_options SET list_id='DUB_Tests_Procedures',
182 INSERT IGNORE INTO list_options SET list_id='DUB_Tests_Procedures',
184 title='Hysteroscopy',
186 INSERT IGNORE INTO list_options SET list_id='DUB_Tests_Procedures',
190 INSERT IGNORE INTO list_options SET list_id='DUB_Tests_Procedures',
194 INSERT IGNORE INTO list_options SET list_id='lists',
195 option_id='DUB_Medications',
196 title='DUB Tests Procedures';
197 INSERT IGNORE INTO list_options SET list_id='DUB_Medications',
199 title='Provera/Prometrium',
201 INSERT IGNORE INTO list_options SET list_id='DUB_Medications',
203 title='Oral Contraception',
205 INSERT IGNORE INTO list_options SET list_id='DUB_Medications',
209 INSERT IGNORE INTO list_options SET list_id='DUB_Medications',
211 title='Anti-inflammatories',
213 INSERT IGNORE INTO list_options SET list_id='DUB_Medications',
217 INSERT IGNORE INTO list_options SET list_id='DUB_Medications',
221 INSERT IGNORE INTO list_options SET list_id='DUB_Medications',
225 INSERT IGNORE INTO list_options SET list_id='DUB_Medications',