1 CREATE TABLE IF NOT EXISTS `form_progressnotes` (
\r
2 id bigint(20) NOT NULL auto_increment,
\r
3 date datetime default NULL,
\r
4 pid bigint(20) default NULL,
\r
5 user varchar(255) default NULL,
\r
6 groupname varchar(255) default NULL,
\r
7 authorized tinyint(4) default NULL,
\r
8 activity tinyint(4) default NULL,
\r
16 prog_last_pap_smear longtext,
\r
17 prog_last_td_booster longtext,
\r
18 prog_allergies longtext,
\r
19 prog_last_mammogram longtext,
\r
20 prog_present_complaint longtext,
\r
21 prog_skin_abn varchar(255),
\r
22 prog_skin_ne varchar(255),
\r
23 prog_head_abn varchar(255),
\r
24 prog_head_ne varchar(255),
\r
25 prog_eyes_abn varchar(255),
\r
26 prog_eyes_ne varchar(255),
\r
27 prog_ears_abn varchar(255),
\r
28 prog_ears_ne varchar(255),
\r
29 prog_nose_abn varchar(255),
\r
30 prog_nose_ne varchar(255),
\r
31 prog_throat_abn varchar(255),
\r
32 prog_throat_ne varchar(255),
\r
33 prog_teeth_abn varchar(255),
\r
34 prog_teeth_ne varchar(255),
\r
35 prog_neck_abn varchar(255),
\r
36 prog_neck_ne varchar(255),
\r
37 prog_chest_abn varchar(255),
\r
38 prog_chest_ne varchar(255),
\r
39 prog_breast_abn varchar(255),
\r
40 prog_breast_ne varchar(255),
\r
41 prog_lungs_abn varchar(255),
\r
42 prog_lungs_ne varchar(255),
\r
43 prog_heart_abn varchar(255),
\r
44 prog_heart_ne varchar(255),
\r
45 prog_abdomen_abn varchar(255),
\r
46 prog_abdomen_ne varchar(255),
\r
47 prog_spine_abn varchar(255),
\r
48 prog_spine_ne varchar(255),
\r
49 prog_extremeities_abn varchar(255),
\r
50 prog_extremeities_ne varchar(255),
\r
51 prog_lowback_abn varchar(255),
\r
52 prog_lowback_ne varchar(255),
\r
53 prog_neuro_abn varchar(255),
\r
54 prog_neuro_ne varchar(255),
\r
55 prog_rectal_abn varchar(255),
\r
56 prog_rectal_ne varchar(255),
\r
57 prog_pelvic_abn varchar(255),
\r
58 prog_pelvic_ne varchar(255),
\r
59 prog_assessment longtext,
\r
61 prog_breast_se longtext,
\r
62 prog_dental_h longtext,
\r
63 prog_diagnosis longtext,
\r
64 prog_injur_p longtext,
\r
65 prog_new_treat longtext,
\r
66 prog_nutrition_e longtext,
\r
67 prog_sexual_p longtext,
\r
68 prog_substance_a longtext,
\r