2 -- Table structure for table `form_observation`
5 CREATE TABLE IF NOT EXISTS `form_observation` (
6 `id` bigint(20) NOT NULL,
7 `date` DATE DEFAULT NULL,
8 `pid` bigint(20) DEFAULT NULL,
9 `encounter` varchar(255) DEFAULT NULL,
10 `user` varchar(255) DEFAULT NULL,
11 `groupname` varchar(255) DEFAULT NULL,
12 `authorized` tinyint(4) DEFAULT NULL,
13 `activity` tinyint(4) DEFAULT NULL,
14 `code` varchar(255) DEFAULT NULL,
15 `observation` varchar(255) DEFAULT NULL,
16 `ob_value` varchar(255),
17 `ob_unit` varchar(255),
18 `description` varchar(255),
19 `code_type` varchar(255),
20 `table_code` varchar(255)