1 CREATE TABLE IF NOT EXISTS `form_soap2` (
2 `id` bigint(20) NOT NULL auto_increment,
3 `date` datetime DEFAULT NULL,
4 `pid` bigint(20) NOT NULL DEFAULT 0,
5 `user` varchar(255) DEFAULT NULL,
6 `groupname` varchar(255) DEFAULT NULL,
7 `authorized` tinyint(4) NOT NULL DEFAULT 0,
8 `activity` tinyint(4) NOT NULL DEFAULT 0,
9 `subjective` text NOT NULL DEFAULT '',
10 `objective` text NOT NULL DEFAULT '',
11 `assessment` text NOT NULL DEFAULT '',
12 `plan` text NOT NULL DEFAULT '',
13 `general` varchar(255) NOT NULL DEFAULT '',
14 `neurological` varchar(255) NOT NULL DEFAULT '',
15 `heent` varchar(255) NOT NULL DEFAULT '',
16 `respiratory` varchar(255) NOT NULL DEFAULT '',
17 `cardio` varchar(255) NOT NULL DEFAULT '',
18 `gastro` varchar(255) NOT NULL DEFAULT '',
19 `skin` varchar(255) NOT NULL DEFAULT '',
20 `extremities` varchar(255) NOT NULL DEFAULT '',
21 `neck` varchar(255) NOT NULL DEFAULT '',
22 `breasts` varchar(255) NOT NULL DEFAULT '',
23 `abdomen` varchar(255) NOT NULL DEFAULT '',
24 `mentalstatus` varchar(255) NOT NULL DEFAULT '',