2 -- Table structure for table `form_transfer_summary`
5 CREATE TABLE IF NOT EXISTS `form_transfer_summary` (
6 `id` bigint(20) NOT NULL AUTO_INCREMENT,
7 `date` datetime DEFAULT NULL,
8 `pid` bigint(20) DEFAULT NULL,
9 `user` varchar(255) DEFAULT NULL,
10 `groupname` varchar(255) DEFAULT NULL,
11 `authorized` tinyint(4) DEFAULT NULL,
12 `activity` tinyint(4) DEFAULT NULL,
13 `client_name` varchar(255) DEFAULT NULL,
14 `provider` varchar(255) DEFAULT NULL,
15 `transfer_to` varchar(255) DEFAULT NULL,
16 `transfer_date` date DEFAULT NULL,
17 `status_of_admission` text,
19 `intervention_provided` text,
20 `overall_status_of_discharge` text,