nceFPYfS

1CREATE TABLE IF NOT EXISTS `cell_members` (
2  `id` bigint(20) NOT NULL AUTO_INCREMENT,
3  `office_id` bigint(20) DEFAULT NULL,
4  `office_unit_organogram_id` bigint(20) DEFAULT NULL,
5  `employee_record_id` bigint(20) DEFAULT NULL,
6  `cell_office_unit_organogram_id` bigint(20) DEFAULT NULL,
7  `is_gro` tinyint(1) DEFAULT NULL,
8  `is_ao` tinyint(1) DEFAULT NULL,
9  `created_by` int(11) DEFAULT NULL,
10  `modified_by` int(11) DEFAULT NULL,
11  `created_at` datetime DEFAULT NULL,
12  `modified_at` datetime DEFAULT NULL,
13  `status` int(11) DEFAULT NULL,
14  PRIMARY KEY (`id`)
15) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
16
17-- Dumping data for table grs_test_6.cell_members: ~4 rows (approximately)
18DELETE FROM `cell_members`;
19/*!40000 ALTER TABLE `cell_members` DISABLE KEYS */;
20INSERT INTO `cell_members` (`id`, `office_id`, `office_unit_organogram_id`, `employee_record_id`, `cell_office_unit_organogram_id`, `is_gro`, `is_ao`, `created_by`, `modified_by`, `created_at`, `modified_at`, `status`) VALUES
21	(1, 28, 10762, 77027, 1, 1, 0, NULL, NULL, NULL, NULL, 1),
22	(2, 28, 10807, 77259, 2, 0, 1, NULL, NULL, NULL, NULL, 1),
23	(3, 53, 2138, 422, 3, 0, 0, NULL, NULL, NULL, NULL, 1),
24	(22, 8, 16339, 79414, 4, 0, 0, NULL, NULL, NULL, NULL, NULL);