--
-- Host: localhost    Database: mapping_collaborative_safety_com
-- ------------------------------------------------------


--
-- Table structure for table `general_configs`
--

CREATE TABLE `general_configs` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
  `tooltipval` mediumtext CHARACTER SET latin1,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` int(10) DEFAULT NULL,
  `updated_by` int(10) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `levels` varchar(20) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `general_configs`
--

INSERT INTO `general_configs` VALUES (1,'Government and Regulatory Body','Factors influenced by legislation or mandated standards',1,'2019-10-03 19:47:07','2020-06-03 18:29:06',1,79,NULL,'level_1'),(2,'External Entities','Influencing Factors that exist outside organization',1,'2019-10-08 23:43:09','2020-06-03 18:29:07',1,79,NULL,'level_2'),(3,'Organizational Factors (Central)','Operations that are controlled within the central operations',1,'2019-10-09 22:25:38','2020-06-03 18:29:07',1,79,NULL,'level_3'),(4,'Organizational Factors (Regional)','Contextual features of the region and operations',1,'2020-02-03 12:41:52','2020-06-03 18:29:07',1,79,NULL,'level_4'),(5,'Processes Conditions Actor Activities','Local (front-line) environment in which work was carried out',1,'2020-02-03 12:42:44','2020-06-03 18:29:07',1,79,NULL,'level_5'),(6,'Outcome','Outcome help!',0,'2020-01-03 05:30:51','2020-01-03 05:30:51',1,1,'2020-01-24 18:55:23','level_6');

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (1,'2020_02_18_030911_alter_reviewconfigs_table',1),(2,'2020_03_06_042230_add_gid_to_reviewconfigs_table',2);

--
-- Table structure for table `organization_users`
--

CREATE TABLE `organization_users` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `user_id` int(10) NOT NULL,
  `organization_id` int(10) NOT NULL,
  `title` varchar(255) CHARACTER SET latin1 NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` int(10) DEFAULT NULL,
  `updated_by` int(10) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `organization_users`
--

INSERT INTO `organization_users` VALUES (2,81,9,'Test user',NULL,NULL,NULL,NULL,NULL),(3,85,9,'Admin',NULL,NULL,NULL,NULL,NULL),(7,89,12,'Assistant Commissioner',NULL,NULL,NULL,NULL,NULL),(8,90,13,'DHS',NULL,NULL,NULL,NULL,NULL),(12,91,13,'DHS',NULL,NULL,NULL,NULL,NULL),(13,93,13,'DHS',NULL,NULL,NULL,NULL,NULL),(14,92,13,'DHS',NULL,NULL,NULL,NULL,NULL),(19,96,14,'DCF',NULL,NULL,NULL,NULL,NULL),(20,97,14,'DCF',NULL,NULL,NULL,NULL,NULL),(21,98,14,'DCF',NULL,NULL,NULL,NULL,NULL),(32,107,21,'CSTraining7',NULL,NULL,NULL,NULL,NULL),(33,108,21,'CSTraining9',NULL,NULL,NULL,NULL,NULL),(37,109,17,'WI DCF',NULL,NULL,NULL,NULL,NULL),(38,110,17,'WI DCF',NULL,NULL,NULL,NULL,NULL),(39,111,17,'WI DCF',NULL,NULL,NULL,NULL,NULL),(40,112,17,'WI DCF',NULL,NULL,NULL,NULL,NULL),(41,113,17,'WI DCF',NULL,NULL,NULL,NULL,NULL),(42,114,17,'WI DCF',NULL,NULL,NULL,NULL,NULL),(44,116,17,'WI DCF',NULL,NULL,NULL,NULL,NULL),(45,117,17,'WI DCF',NULL,NULL,NULL,NULL,NULL),(46,115,17,'WI DCF',NULL,NULL,NULL,NULL,NULL),(49,94,12,'Safety Analyst',NULL,NULL,NULL,NULL,NULL),(55,88,12,'Director',NULL,NULL,NULL,NULL,NULL),(56,87,12,'Director',NULL,NULL,NULL,NULL,NULL),(57,106,21,'CSTraining5',NULL,NULL,NULL,NULL,NULL),(58,105,21,'CSTraining3',NULL,NULL,NULL,NULL,NULL),(63,100,17,'WI DCF',NULL,NULL,NULL,NULL,NULL),(64,99,17,'WI DCF',NULL,NULL,NULL,NULL,NULL),(71,120,12,'NY ACS',NULL,NULL,NULL,NULL,NULL),(75,119,12,'NY ACS',NULL,NULL,NULL,NULL,NULL),(77,121,12,'NY ACS',NULL,NULL,NULL,NULL,NULL),(78,104,21,'CSTraining1',NULL,NULL,NULL,NULL,NULL),(79,122,12,'OCFS Liaison',NULL,NULL,NULL,NULL,NULL),(80,118,12,'NY ACS',NULL,NULL,NULL,NULL,NULL),(82,123,10,'MN DSD',NULL,NULL,NULL,NULL,NULL),(84,124,10,'MN DSD',NULL,NULL,NULL,NULL,NULL),(85,95,19,'Hennepin DHS',NULL,NULL,NULL,NULL,NULL),(86,125,19,'Hennepin DHS',NULL,NULL,NULL,NULL,NULL),(88,127,19,'Hennepin DHS',NULL,NULL,NULL,NULL,NULL),(89,128,19,'Hennepin DHS',NULL,NULL,NULL,NULL,NULL),(90,129,19,'Hennepin DHS',NULL,NULL,NULL,NULL,NULL),(91,130,19,'Hennepin DHS',NULL,NULL,NULL,NULL,NULL),(92,131,19,'Hennepin DHS',NULL,NULL,NULL,NULL,NULL),(93,132,22,'SLR II Demo',NULL,NULL,NULL,NULL,NULL),(94,133,22,'SLR II Demo',NULL,NULL,NULL,NULL,NULL),(95,134,22,'SLR II Demo',NULL,NULL,NULL,NULL,NULL),(96,135,22,'SLR II Demo',NULL,NULL,NULL,NULL,NULL),(97,136,22,'SLR II Demo',NULL,NULL,NULL,NULL,NULL),(98,137,22,'SLR II Demo',NULL,NULL,NULL,NULL,NULL),(99,138,22,'SLR II Demo',NULL,NULL,NULL,NULL,NULL),(100,126,19,'Hennepin DHS',NULL,NULL,NULL,NULL,NULL),(101,139,23,'HCS',NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `organizations`
--

CREATE TABLE `organizations` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET latin1 NOT NULL,
  `email` varchar(255) CHARACTER SET latin1 NOT NULL,
  `phone` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` int(10) DEFAULT NULL,
  `updated_by` int(10) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `organizations`
--

INSERT INTO `organizations` VALUES (1,'5 row','',NULL,1,'2020-06-03 09:36:34','2020-06-03 09:38:28',1,1,'2020-06-03 09:38:28'),(2,'five row q','',NULL,1,'2020-06-03 10:49:27','2020-06-03 10:50:55',1,1,'2020-06-03 10:50:55'),(3,'Org. Row 5','',NULL,1,'2020-06-03 11:56:12','2020-06-03 13:36:23',72,72,'2020-06-03 13:36:23'),(4,'Org. Row 4','',NULL,1,'2020-06-03 11:56:35','2020-06-03 13:36:23',72,72,'2020-06-03 13:36:23'),(5,'Org. Row 3','',NULL,1,'2020-06-03 11:56:46','2020-06-03 13:36:23',72,72,'2020-06-03 13:36:23'),(6,'Org. Row 2','',NULL,1,'2020-06-03 11:57:03','2020-06-03 13:36:23',72,72,'2020-06-03 13:36:23'),(7,'Org. Row 1','',NULL,1,'2020-06-03 11:57:16','2020-06-03 13:36:23',72,72,'2020-06-03 13:36:23'),(8,'Demo Agency','',NULL,1,'2020-06-03 16:25:32','2020-06-03 18:36:39',79,79,'2020-06-03 18:36:39'),(9,'Mapping Demo','',NULL,1,'2020-06-03 18:33:31','2020-06-03 18:33:31',79,79,NULL),(10,'MN DSD','',NULL,1,'2020-06-10 15:39:05','2020-06-10 15:39:05',80,80,NULL),(11,'DevDigital Test','',NULL,1,'2020-06-12 06:19:42','2020-06-12 06:24:52',1,1,'2020-06-12 06:24:52'),(12,'NY ACS','',NULL,1,'2020-06-24 14:09:30','2020-06-24 14:09:30',80,80,NULL),(13,'MN DHS','',NULL,1,'2020-06-24 14:56:33','2020-06-24 14:56:33',80,80,NULL),(14,'NJ DCF','',NULL,1,'2020-07-13 14:27:40','2020-07-13 14:27:40',80,80,NULL),(15,'KY DCBS','',NULL,1,'2020-07-13 14:28:17','2020-07-13 14:28:17',80,80,NULL),(16,'Utah DCFS','',NULL,1,'2020-07-13 14:28:45','2020-07-13 14:28:45',80,80,NULL),(17,'WI DCF','',NULL,1,'2020-07-13 14:29:13','2020-07-13 14:29:13',80,80,NULL),(18,'Hennepin County ES','',NULL,1,'2020-07-13 14:30:01','2020-07-17 02:22:39',80,80,NULL),(19,'Hennepin County DHS','',NULL,1,'2020-07-17 02:22:53','2020-08-20 14:02:34',80,80,NULL),(20,'test','',NULL,1,'2020-07-31 12:07:07','2020-07-31 12:09:04',1,1,'2020-07-31 12:09:04'),(21,'Training','',NULL,1,'2020-08-03 19:26:40','2020-08-03 19:26:40',80,80,NULL),(22,'SLR II Demo','',NULL,1,'2020-08-24 18:54:11','2020-08-24 18:54:11',79,79,NULL),(23,'Heritage Christian Services','',NULL,1,'2020-10-01 19:29:58','2020-10-01 19:29:58',80,80,NULL),(24,'Test SLR','',NULL,1,'2020-10-19 19:30:53','2020-10-19 19:40:21',80,80,'2020-10-19 19:40:21');

--
-- Table structure for table `reviewconfigs`
--

CREATE TABLE `reviewconfigs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `gid` int(11) DEFAULT NULL,
  `organization_id` int(10) unsigned DEFAULT NULL,
  `review_id` int(10) unsigned DEFAULT NULL,
  `levels` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tooltipval` mediumtext COLLATE utf8mb4_unicode_ci,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `created_by` int(10) unsigned DEFAULT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=109 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `reviewconfigs`
--

INSERT INTO `reviewconfigs` VALUES (1,1,1,NULL,'level_1','Government and Regulatory Body','Tool tip goes here!',1,1,1,'2020-06-03 09:36:34','2020-06-03 09:36:34',NULL),(2,2,1,NULL,'level_2','External Entities','Tool tip goes here!',1,1,1,'2020-06-03 09:36:34','2020-06-03 09:36:34',NULL),(3,3,1,NULL,'level_3','Organizational Factors (Central)','Tool tip goes here!',1,1,1,'2020-06-03 09:36:34','2020-06-03 09:36:34',NULL),(4,4,1,NULL,'level_4','Organizational Factors (Regional)','Tool tip goes here!',1,1,1,'2020-06-03 09:36:34','2020-06-03 09:36:34',NULL),(5,5,1,NULL,'level_5','Processes Conditions Actor Activities','Tool tip goes here!',1,1,1,'2020-06-03 09:36:34','2020-06-03 09:36:34',NULL),(6,1,2,NULL,'level_1','Government and Regulatory Body','Tool tip goes here!',1,1,1,'2020-06-03 10:49:27','2020-06-03 10:49:27',NULL),(7,2,2,NULL,'level_2','External Entities','Tool tip goes here!',1,1,1,'2020-06-03 10:49:27','2020-06-03 10:49:27',NULL),(8,3,2,NULL,'level_3','Organizational Factors (Central)','Tool tip goes here!',1,1,1,'2020-06-03 10:49:27','2020-06-03 10:49:27',NULL),(9,4,2,NULL,'level_4','Organizational Factors (Regional)','Tool tip goes here!',1,1,1,'2020-06-03 10:49:27','2020-06-03 10:49:27',NULL),(10,5,2,NULL,'level_5','Processes Conditions Actor Activities','Tool tip goes here!',1,1,1,'2020-06-03 10:49:27','2020-06-03 10:49:27',NULL),(11,1,3,NULL,'level_1','Row 5','Row 5 Tool tip!',1,72,72,'2020-06-03 11:56:12','2020-06-03 11:56:12',NULL),(12,2,3,NULL,'level_2','Row 4','Row 4 Tool tip!',1,72,72,'2020-06-03 11:56:12','2020-06-03 11:56:12',NULL),(13,3,3,NULL,'level_3','Row 3','Row 3 Tool tip!',1,72,72,'2020-06-03 11:56:12','2020-06-03 11:56:12',NULL),(14,4,3,NULL,'level_4','Row 2','Row 2 Tool tip!',1,72,72,'2020-06-03 11:56:12','2020-06-03 11:56:12',NULL),(15,5,3,NULL,'level_5','Row 1','Row 1 Tool tip!',1,72,72,'2020-06-03 11:56:12','2020-06-03 11:56:12',NULL),(16,2,4,NULL,'level_2','Row 4','Row 4 Tool tip!',1,72,72,'2020-06-03 11:56:35','2020-06-03 11:56:35',NULL),(17,3,4,NULL,'level_3','Row 3','Row 3 Tool tip!',1,72,72,'2020-06-03 11:56:35','2020-06-03 11:56:35',NULL),(18,4,4,NULL,'level_4','Row 2','Row 2 Tool tip!',1,72,72,'2020-06-03 11:56:35','2020-06-03 11:56:35',NULL),(19,5,4,NULL,'level_5','Row 1','Row 1 Tool tip!',1,72,72,'2020-06-03 11:56:35','2020-06-03 11:56:35',NULL),(20,3,5,NULL,'level_3','Row 3','Row 3 Tool tip!',1,72,72,'2020-06-03 11:56:46','2020-06-03 11:56:46',NULL),(21,4,5,NULL,'level_4','Row 2','Row 2 Tool tip!',1,72,72,'2020-06-03 11:56:46','2020-06-03 11:56:46',NULL),(22,5,5,NULL,'level_5','Row 1','Row 1 Tool tip!',1,72,72,'2020-06-03 11:56:46','2020-06-03 11:56:46',NULL),(23,4,6,NULL,'level_4','Row 2','Row 2 Tool tip!',1,72,72,'2020-06-03 11:57:03','2020-06-03 11:57:03',NULL),(24,5,6,NULL,'level_5','Row 1','Row 1 Tool tip!',1,72,72,'2020-06-03 11:57:03','2020-06-03 11:57:03',NULL),(25,5,7,NULL,'level_5','Row 1','Row 1 Tool tip!',1,72,72,'2020-06-03 11:57:16','2020-06-03 11:57:16',NULL),(26,1,8,NULL,'level_1','Government and Regulatory Body','Tool tip goes here!',1,79,79,'2020-06-03 16:25:32','2020-06-03 16:25:32',NULL),(27,2,8,NULL,'level_2','External Entities','Tool tip goes here!',1,79,79,'2020-06-03 16:25:32','2020-06-03 16:25:32',NULL),(28,3,8,NULL,'level_3','Organizational Factors (Central)','Tool tip goes here!',1,79,79,'2020-06-03 16:25:32','2020-06-03 16:25:32',NULL),(29,4,8,NULL,'level_4','Organizational Factors (Regional)','Tool tip goes here!',1,79,79,'2020-06-03 16:25:32','2020-06-03 16:25:32',NULL),(30,5,8,NULL,'level_5','Processes Conditions Actor Activities','Tool tip goes here!',1,79,79,'2020-06-03 16:25:32','2020-06-03 16:25:32',NULL),(31,31,9,NULL,'level_1','Government and Regulatory Body','Factors influenced by legislation or mandated standards',1,79,1,'2020-06-03 18:33:31','2020-08-26 10:21:06',NULL),(32,32,9,NULL,'level_2','External Entities','Influencing Factors that exist outside organization',1,79,1,'2020-06-03 18:33:31','2020-08-26 10:21:06',NULL),(33,33,9,NULL,'level_3','Organizational Factors (Central)','Operations that are controlled within the central operations',1,79,1,'2020-06-03 18:33:31','2020-08-26 10:21:06',NULL),(34,34,9,NULL,'level_4','Organizational Factors (Regional)','Contextual features of the region and operations',1,79,1,'2020-06-03 18:33:31','2020-08-26 10:21:06',NULL),(35,35,9,NULL,'level_5','Processes Conditions Actor Activities','Local (front-line) environment in which work was carried out',1,79,1,'2020-06-03 18:33:31','2020-08-26 10:21:06',NULL),(36,36,10,NULL,'level_1','Government and Regulatory Body','Factors influenced by State & Federal legislation or mandated standards',1,80,80,'2020-06-10 15:39:05','2020-08-14 15:45:55',NULL),(37,37,10,NULL,'level_2','External Factors','Influencing Factors that exist outside of organization',1,80,80,'2020-06-10 15:39:05','2020-08-14 15:45:55',NULL),(38,38,10,NULL,'level_3','County / Regional Factors','Operations that are controlled within the County or Regional operations',1,80,80,'2020-06-10 15:39:05','2020-08-14 15:45:55',NULL),(39,39,10,NULL,'level_4','Provider Factors','Environmental features of the provider organization',1,80,80,'2020-06-10 15:39:06','2020-08-14 15:45:55',NULL),(40,40,10,NULL,'level_5','Processes Conditions Actor Activities','Local (front-line) environment in which work was carried out',1,80,80,'2020-06-10 15:39:06','2020-08-14 15:45:55',NULL),(41,1,11,NULL,'level_1','Government and Regulatory Body','Factors influenced by legislation or mandated standards',1,1,1,'2020-06-12 06:19:42','2020-06-12 06:19:42',NULL),(42,2,11,NULL,'level_2','External Entities','Influencing Factors that exist outside organization',1,1,1,'2020-06-12 06:19:42','2020-06-12 06:19:42',NULL),(43,3,11,NULL,'level_3','Organizational Factors (Central)','Operations that are controlled within the central operations',1,1,1,'2020-06-12 06:19:42','2020-06-12 06:19:42',NULL),(44,4,11,NULL,'level_4','Organizational Factors (Regional)','Contextual features of the region and operations',1,1,1,'2020-06-12 06:19:42','2020-06-12 06:19:42',NULL),(45,5,11,NULL,'level_5','Processes Conditions Actor Activities','Local (front-line) environment in which work was carried out',1,1,1,'2020-06-12 06:19:42','2020-06-12 06:19:42',NULL),(46,1,12,NULL,'level_1','Government and Regulatory Body','Factors influenced by legislation or mandated standards',1,80,80,'2020-06-24 14:09:30','2020-06-24 14:09:30',NULL),(47,2,12,NULL,'level_2','External Entities','Influencing Factors that exist outside organization',1,80,80,'2020-06-24 14:09:30','2020-06-24 14:09:30',NULL),(48,3,12,NULL,'level_3','Organizational Factors (Central)','Operations that are controlled within the central operations',1,80,80,'2020-06-24 14:09:30','2020-06-24 14:09:30',NULL),(49,4,12,NULL,'level_4','Organizational Factors (Regional)','Contextual features of the region and operations',1,80,80,'2020-06-24 14:09:30','2020-06-24 14:09:30',NULL),(50,5,12,NULL,'level_5','Processes Conditions Actor Activities','Local (front-line) environment in which work was carried out',1,80,80,'2020-06-24 14:09:30','2020-06-24 14:09:30',NULL),(51,1,13,NULL,'level_1','Government and Regulatory Body','Factors influenced by legislation or mandated standards',1,80,80,'2020-06-24 14:56:33','2020-06-24 14:56:33',NULL),(52,2,13,NULL,'level_2','External Entities','Influencing Factors that exist outside organization',1,80,80,'2020-06-24 14:56:33','2020-06-24 14:56:33',NULL),(53,3,13,NULL,'level_3','Organizational Factors (Central)','Operations that are controlled within the central operations',1,80,80,'2020-06-24 14:56:33','2020-06-24 14:56:33',NULL),(54,4,13,NULL,'level_4','Organizational Factors (Regional)','Contextual features of the region and operations',1,80,80,'2020-06-24 14:56:33','2020-06-24 14:56:33',NULL),(55,5,13,NULL,'level_5','Processes Conditions Actor Activities','Local (front-line) environment in which work was carried out',1,80,80,'2020-06-24 14:56:33','2020-06-24 14:56:33',NULL),(56,1,14,NULL,'level_1','Government and Regulatory Body','Factors influenced by legislation or mandated standards',1,80,80,'2020-07-13 14:27:40','2020-07-13 14:27:40',NULL),(57,2,14,NULL,'level_2','External Entities','Influencing Factors that exist outside organization',1,80,80,'2020-07-13 14:27:40','2020-07-13 14:27:40',NULL),(58,3,14,NULL,'level_3','Organizational Factors (Central)','Operations that are controlled within the central operations',1,80,80,'2020-07-13 14:27:40','2020-07-13 14:27:40',NULL),(59,4,14,NULL,'level_4','Organizational Factors (Regional)','Contextual features of the region and operations',1,80,80,'2020-07-13 14:27:40','2020-07-13 14:27:40',NULL),(60,5,14,NULL,'level_5','Processes Conditions Actor Activities','Local (front-line) environment in which work was carried out',1,80,80,'2020-07-13 14:27:40','2020-07-13 14:27:40',NULL),(61,1,15,NULL,'level_1','Government and Regulatory Body','Factors influenced by legislation or mandated standards',1,80,80,'2020-07-13 14:28:17','2020-07-13 14:28:17',NULL),(62,2,15,NULL,'level_2','External Entities','Influencing Factors that exist outside organization',1,80,80,'2020-07-13 14:28:17','2020-07-13 14:28:17',NULL),(63,3,15,NULL,'level_3','Organizational Factors (Central)','Operations that are controlled within the central operations',1,80,80,'2020-07-13 14:28:17','2020-07-13 14:28:17',NULL),(64,4,15,NULL,'level_4','Organizational Factors (Regional)','Contextual features of the region and operations',1,80,80,'2020-07-13 14:28:17','2020-07-13 14:28:17',NULL),(65,5,15,NULL,'level_5','Processes Conditions Actor Activities','Local (front-line) environment in which work was carried out',1,80,80,'2020-07-13 14:28:17','2020-07-13 14:28:17',NULL),(66,1,16,NULL,'level_1','Government and Regulatory Body','Factors influenced by legislation or mandated standards',1,80,80,'2020-07-13 14:28:45','2020-07-13 14:28:45',NULL),(67,2,16,NULL,'level_2','External Entities','Influencing Factors that exist outside organization',1,80,80,'2020-07-13 14:28:45','2020-07-13 14:28:45',NULL),(68,3,16,NULL,'level_3','Organizational Factors (Central)','Operations that are controlled within the central operations',1,80,80,'2020-07-13 14:28:45','2020-07-13 14:28:45',NULL),(69,4,16,NULL,'level_4','Organizational Factors (Regional)','Contextual features of the region and operations',1,80,80,'2020-07-13 14:28:45','2020-07-13 14:28:45',NULL),(70,5,16,NULL,'level_5','Processes Conditions Actor Activities','Local (front-line) environment in which work was carried out',1,80,80,'2020-07-13 14:28:45','2020-07-13 14:28:45',NULL),(71,71,17,NULL,'level_1','Government and Regulatory Bodies (Federal & State)','Factors influenced by legislation or mandated standards',1,80,80,'2020-07-13 14:29:13','2020-08-04 14:43:07',NULL),(72,72,17,NULL,'level_2','External Entities (community partners, stakeholders)','Influencing Factors that exist outside organization',1,80,80,'2020-07-13 14:29:13','2020-08-04 14:43:07',NULL),(73,73,17,NULL,'level_3','State Organizational Factors (DCF policy, standards, expectations)','Operations that are controlled within the central operations',1,80,80,'2020-07-13 14:29:13','2020-08-04 14:43:07',NULL),(74,74,17,NULL,'level_4','County Organizational Factors (County board, county norms, etc.)','Contextual features of the region and operations',1,80,80,'2020-07-13 14:29:13','2020-08-04 14:43:07',NULL),(75,75,17,NULL,'level_5','Local Worker Activities, Conditions, & Processes (case worker decisions, training, technology)','Local (front-line) environment in which work was carried out',1,80,80,'2020-07-13 14:29:13','2020-08-04 14:43:07',NULL),(76,1,18,NULL,'level_1','Government and Regulatory Body','Factors influenced by legislation or mandated standards',1,80,80,'2020-07-13 14:30:01','2020-07-13 14:30:01',NULL),(77,2,18,NULL,'level_2','External Entities','Influencing Factors that exist outside organization',1,80,80,'2020-07-13 14:30:01','2020-07-13 14:30:01',NULL),(78,3,18,NULL,'level_3','Organizational Factors (Central)','Operations that are controlled within the central operations',1,80,80,'2020-07-13 14:30:01','2020-07-13 14:30:01',NULL),(79,4,18,NULL,'level_4','Organizational Factors (Regional)','Contextual features of the region and operations',1,80,80,'2020-07-13 14:30:01','2020-07-13 14:30:01',NULL),(80,5,18,NULL,'level_5','Processes Conditions Actor Activities','Local (front-line) environment in which work was carried out',1,80,80,'2020-07-13 14:30:01','2020-07-13 14:30:01',NULL),(81,81,19,NULL,'level_1','Control Factors','Control Factors',1,80,80,'2020-07-17 02:22:53','2020-10-06 15:25:50',NULL),(82,82,19,NULL,'level_2','Conditional Factors','Conditional Factors',1,80,80,'2020-07-17 02:22:53','2020-10-06 15:25:50',NULL),(83,83,19,NULL,'level_3','Human Factors','Human Factors',1,80,80,'2020-07-17 02:22:53','2020-10-06 15:25:50',NULL),(84,84,19,NULL,'level_4','Learning Point(s)','Learning Point(s)',1,80,80,'2020-07-17 02:22:53','2020-10-06 15:25:50',NULL),(85,85,19,NULL,'level_5','Processes Conditions Actor Activities','Local (front-line) environment in which work was carried out',1,80,80,'2020-07-17 02:22:53','2020-10-06 15:25:50','2020-10-06 15:25:50'),(86,86,20,NULL,'level_1','Government and Regulatory Body','Factors influenced by legislation or mandated standards',1,1,1,'2020-07-31 12:07:08','2020-07-31 12:07:21',NULL),(87,87,20,NULL,'level_2','External Entities','Influencing Factors that exist outside organization',1,1,1,'2020-07-31 12:07:08','2020-07-31 12:07:21',NULL),(88,88,20,NULL,'level_3','Organizational Factors (Central)','Operations that are controlled within the central operations',1,1,1,'2020-07-31 12:07:08','2020-07-31 12:07:21',NULL),(89,4,20,NULL,'level_4','Organizational Factors (Regional)','Contextual features of the region and operations',1,1,1,'2020-07-31 12:07:08','2020-07-31 12:07:21','2020-07-31 12:07:21'),(90,90,20,NULL,'level_5','Processes Conditions Actor Activities','Local (front-line) environment in which work was carried out',1,1,1,'2020-07-31 12:07:08','2020-07-31 12:07:21',NULL),(91,1,21,NULL,'level_1','Government and Regulatory Body','Factors influenced by legislation or mandated standards',1,80,80,'2020-08-03 19:26:40','2020-08-03 19:26:40',NULL),(92,2,21,NULL,'level_2','External Entities','Influencing Factors that exist outside organization',1,80,80,'2020-08-03 19:26:40','2020-08-03 19:26:40',NULL),(93,3,21,NULL,'level_3','Organizational Factors (Central)','Operations that are controlled within the central operations',1,80,80,'2020-08-03 19:26:40','2020-08-03 19:26:40',NULL),(94,4,21,NULL,'level_4','Organizational Factors (Regional)','Contextual features of the region and operations',1,80,80,'2020-08-03 19:26:40','2020-08-03 19:26:40',NULL),(95,5,21,NULL,'level_5','Processes Conditions Actor Activities','Local (front-line) environment in which work was carried out',1,80,80,'2020-08-03 19:26:40','2020-08-03 19:26:40',NULL),(96,2,22,NULL,'level_2','Control Factors','Control Factors',1,79,79,'2020-08-24 18:54:11','2020-08-24 18:54:11',NULL),(97,3,22,NULL,'level_3','Condiitonal Factors','Condiitonal Factors',1,79,79,'2020-08-24 18:54:11','2020-08-24 18:54:11',NULL),(98,4,22,NULL,'level_4','Human Factors','Human Factors',1,79,79,'2020-08-24 18:54:11','2020-08-24 18:54:11',NULL),(99,5,22,NULL,'level_5','Learning Point(s)','Learning Point (s)',1,79,79,'2020-08-24 18:54:11','2020-08-24 18:54:11',NULL),(100,1,23,NULL,'level_1','Government and Regulatory Body','Factors influenced by legislation or mandated standards',1,80,80,'2020-10-01 19:29:58','2020-10-01 19:29:58',NULL),(101,2,23,NULL,'level_2','External Entities','Influencing Factors that exist outside organization',1,80,80,'2020-10-01 19:29:58','2020-10-01 19:29:58',NULL),(102,3,23,NULL,'level_3','Organizational Factors (Central)','Operations that are controlled within the central operations',1,80,80,'2020-10-01 19:29:58','2020-10-01 19:29:58',NULL),(103,4,23,NULL,'level_4','Organizational Factors (Regional)','Contextual features of the region and operations',1,80,80,'2020-10-01 19:29:59','2020-10-01 19:29:59',NULL),(104,5,23,NULL,'level_5','Processes Conditions Actor Activities','Local (front-line) environment in which work was carried out',1,80,80,'2020-10-01 19:29:59','2020-10-01 19:29:59',NULL),(105,2,24,NULL,'level_2','Control Factors','Control Factors',1,80,80,'2020-10-19 19:30:53','2020-10-19 19:30:53',NULL),(106,3,24,NULL,'level_3','Conditional Factors','Conditional Factors',1,80,80,'2020-10-19 19:30:53','2020-10-19 19:30:53',NULL),(107,4,24,NULL,'level_4','Human Factors','Human Factors',1,80,80,'2020-10-19 19:30:53','2020-10-19 19:30:53',NULL),(108,5,24,NULL,'level_5','Learning Point(s)','Learning Point(s)',1,80,80,'2020-10-19 19:30:53','2020-10-19 19:30:53',NULL);

--
-- Table structure for table `reviews`
--

CREATE TABLE `reviews` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `user_id` int(10) NOT NULL,
  `organization_id` int(10) NOT NULL,
  `title` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `review_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `edit_by` int(10) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` int(10) DEFAULT NULL,
  `updated_by` int(10) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=105 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `reviews`
--

INSERT INTO `reviews` VALUES (1,0,1,'5 row review','graph_1.xml','',0,'2020-06-03 09:36:56','2020-06-03 09:38:15',1,1,'2020-06-03 09:38:15'),(2,0,3,'Test Review 1','graph_2.xml','',73,'2020-06-03 12:19:46','2020-06-03 13:06:21',72,73,'2020-06-03 13:06:21'),(3,0,3,'Org. User 1 Review','graph_3.xml','',73,'2020-06-03 12:37:19','2020-06-03 13:06:21',73,73,'2020-06-03 13:06:21'),(4,0,3,'Org. User 2 Review','graph_4.xml','',74,'2020-06-03 12:37:37','2020-06-03 13:06:21',74,74,'2020-06-03 13:06:21'),(5,0,3,'My Own DevDigital Review','graph_5.xml','',0,'2020-06-03 12:55:20','2020-06-03 13:06:21',74,73,'2020-06-03 13:06:21'),(6,0,3,'Org. Row 5 Review 1','graph_6.xml','',0,'2020-06-03 13:06:48','2020-06-03 13:23:50',72,72,'2020-06-03 13:23:50'),(7,0,3,'Org. Row 5 Review 2','graph_7.xml','',0,'2020-06-03 13:10:08','2020-06-03 13:23:50',72,74,'2020-06-03 13:23:50'),(8,0,3,'Shahrukh Devdigital','','',72,'2020-06-03 13:11:48','2020-06-03 13:23:50',74,72,'2020-06-03 13:23:50'),(9,0,3,'Shahrukh Gmail','','',72,'2020-06-03 13:12:18','2020-06-03 13:23:50',73,72,'2020-06-03 13:23:50'),(10,0,3,'Admin Review 1','graph_10.xml','',74,'2020-06-03 13:26:18','2020-06-03 13:36:13',72,74,'2020-06-03 13:36:13'),(11,0,3,'Admin Review 2','graph_11.xml','',73,'2020-06-03 13:26:49','2020-06-03 13:36:13',72,73,'2020-06-03 13:36:13'),(12,0,3,'Devdigital Review 1','','',73,'2020-06-03 13:31:37','2020-06-03 13:33:14',74,73,'2020-06-03 13:33:14'),(13,0,3,'Gmail Review 1','','',0,'2020-06-03 13:31:46','2020-06-03 13:33:14',73,73,'2020-06-03 13:33:14'),(14,0,3,'Gmail Review 2','','',0,'2020-06-03 13:31:56','2020-06-03 13:33:14',73,73,'2020-06-03 13:33:14'),(15,0,3,'Devdigital Review 2','','',0,'2020-06-03 13:32:08','2020-06-03 13:33:14',74,74,'2020-06-03 13:33:14'),(16,0,3,'Devdigital Review 1','graph_16.xml','',74,'2020-06-03 13:33:30','2020-06-03 13:36:13',74,74,'2020-06-03 13:36:13'),(17,0,3,'Devdigital Review 2','','',73,'2020-06-03 13:33:39','2020-06-03 13:36:13',74,73,'2020-06-03 13:36:13'),(18,0,8,'Test','graph_18.xml','',0,'2020-06-03 16:26:59','2020-06-03 18:37:27',79,79,'2020-06-03 18:37:27'),(19,0,9,'Test the mapping software','graph_19.xml','',79,'2020-06-03 16:27:21','2020-09-25 14:36:40',80,79,NULL),(20,0,9,'Test-1','graph_20.xml','',79,'2020-06-03 18:34:18','2020-09-04 15:38:23',79,79,NULL),(21,0,9,'Child Fatality Review AF-23-65','graph_21.xml','',81,'2020-06-03 19:40:37','2020-08-17 14:56:19',80,81,'2020-08-17 14:56:19'),(22,0,9,'Commercial Superintendent - Nashville','graph_22.xml','',1,'2020-06-04 06:01:45','2020-06-12 06:19:00',1,1,NULL),(23,0,9,'Test Map 3','graph_23.xml','',81,'2020-06-10 15:40:56','2020-10-14 17:30:58',80,81,'2020-10-14 17:30:58'),(24,0,11,'Test Review 1','graph_24.xml','',86,'2020-06-12 06:22:17','2020-06-12 06:24:36',1,86,'2020-06-12 06:24:36'),(25,0,9,'test123456','graph_25.xml','',81,'2020-06-18 20:06:03','2020-10-14 17:30:58',81,81,'2020-10-14 17:30:58'),(26,0,9,'ACS Test','graph_26.xml','',81,'2020-06-23 17:16:55','2020-10-14 17:30:58',81,81,'2020-10-14 17:30:58'),(27,0,9,'test 1004','graph_27.xml','',79,'2020-06-24 15:21:03','2020-10-14 17:30:58',83,79,'2020-10-14 17:30:58'),(28,0,13,'New name of review','graph_28.xml','',0,'2020-06-26 17:34:51','2020-06-26 17:45:40',80,80,'2020-06-26 17:45:40'),(29,0,9,'check 123','graph_29.xml','',81,'2020-06-26 17:54:31','2020-08-25 17:31:14',81,81,'2020-08-25 17:31:14'),(30,0,13,'SCIR Region 2 LP1','graph_30.xml','',92,'2020-06-26 17:57:32','2020-07-13 16:17:09',92,92,NULL),(31,0,13,'SCIR Region 7','graph_31.xml','',92,'2020-07-13 16:13:36','2020-07-13 16:16:31',92,92,NULL),(32,0,14,'Test','graph_32.xml','',97,'2020-07-28 17:04:51','2020-10-14 17:31:36',97,80,'2020-10-14 17:31:36'),(33,0,14,'Test','graph_33.xml','',97,'2020-07-28 17:05:56','2020-10-14 17:31:36',97,97,'2020-10-14 17:31:36'),(34,0,17,'Test 07 28 20','graph_34.xml','',100,'2020-07-28 17:18:01','2020-07-29 14:59:08',100,80,'2020-07-29 14:59:08'),(35,0,9,'WI Map test','graph_35.xml','',81,'2020-07-29 14:09:07','2020-07-29 14:09:35',81,81,NULL),(36,0,17,'Test 07 28 20','graph_36.xml','',0,'2020-07-29 14:59:48','2020-07-29 15:01:32',80,80,'2020-07-29 15:01:32'),(37,0,17,'Test_7-29-20','graph_37.xml','',100,'2020-07-29 18:52:43','2020-08-11 19:17:50',100,100,'2020-08-11 19:17:50'),(38,0,17,'20-Q3_Test-0001_8-6-20','graph_38.xml','',100,'2020-08-03 18:56:40','2020-08-03 18:57:00',100,100,NULL),(39,0,21,'Test Map 1','graph_39.xml','',0,'2020-08-03 20:14:05','2020-08-14 18:16:15',80,83,NULL),(40,0,21,'Test Map 2','graph_40.xml','',108,'2020-08-03 20:16:03','2020-08-03 20:16:16',108,108,NULL),(41,0,21,'Test Map 3','graph_41.xml','',108,'2020-08-03 20:16:35','2020-08-03 20:16:40',108,108,NULL),(42,0,21,'Test Map 4','graph_42.xml','',108,'2020-08-03 20:16:57','2020-08-03 20:17:02',108,108,NULL),(43,0,17,'Test - Wisconsin','graph_43.xml','',99,'2020-08-06 18:11:45','2020-08-10 16:15:41',99,80,'2020-08-10 16:15:41'),(44,0,17,'Test- Wisconsin','','',99,'2020-08-06 18:42:10','2020-08-10 16:15:41',99,99,'2020-08-10 16:15:41'),(45,0,9,'test 8/6/20','graph_45.xml','',81,'2020-08-06 20:01:28','2020-08-06 20:01:43',81,81,NULL),(46,0,17,'Test - WI','graph_46.xml','',99,'2020-08-06 22:56:10','2020-08-10 16:36:25',99,99,'2020-08-10 16:36:25'),(47,0,17,'New Test Review','graph_47.xml','',115,'2020-08-10 13:46:35','2020-08-10 16:14:33',115,80,NULL),(48,0,17,'New Test Review','','',115,'2020-08-10 13:48:28','2020-08-10 13:48:33',115,115,NULL),(49,0,17,'New WI Test Review','graph_49.xml','',115,'2020-08-10 13:51:49','2020-08-10 14:43:16',115,115,NULL),(50,0,17,'New WI Test Review','','',115,'2020-08-10 14:25:08','2020-08-10 14:26:14',115,115,NULL),(51,0,17,'20-Q3_Milw-962_KO1_8-11-20','graph_51.xml','',100,'2020-08-10 14:44:56','2020-08-10 14:45:56',100,100,NULL),(52,0,17,'20-Q3_Keno-968_KO2_8-11-20','graph_52.xml','',100,'2020-08-10 14:53:29','2020-08-10 15:25:20',100,100,NULL),(53,0,17,'20-Q3_Milw-973_KO1_8-12-20','graph_53.xml','',100,'2020-08-10 14:59:05','2020-08-10 14:59:22',100,100,NULL),(54,0,17,'20-Q3_Milw-973_KO2_8-12-20','graph_54.xml','',100,'2020-08-10 15:00:17','2020-08-10 15:00:32',100,100,NULL),(55,0,17,'20-Q3_Brown-991_KO1_8-18-20','graph_55.xml','',100,'2020-08-10 15:01:17','2020-08-10 15:01:29',100,100,NULL),(56,0,17,'20-Q3_Keno-968_KO1_8-11-20','graph_56.xml','',100,'2020-08-10 15:26:49','2020-08-11 15:35:13',100,100,NULL),(57,0,12,'20-02','graph_57.xml','',87,'2020-08-11 02:48:07','2020-08-11 02:48:23',87,87,NULL),(58,0,12,'20-89','graph_58.xml','',87,'2020-08-11 15:34:37','2020-08-11 15:34:51',87,87,NULL),(59,0,12,'20-90','graph_59.xml','',87,'2020-08-11 16:21:41','2020-08-11 16:21:58',87,87,NULL),(60,0,12,'Crystal test','graph_60.xml','',94,'2020-08-11 16:38:25','2020-08-11 16:38:44',94,94,NULL),(61,0,17,'V2_20-Q3_Milw-973_KO1_8-12-20','graph_61.xml','',99,'2020-08-12 14:20:05','2020-08-12 14:20:27',99,99,NULL),(62,0,12,'18-42','graph_62.xml','',120,'2020-08-12 15:54:50','2020-08-12 18:33:23',120,120,NULL),(63,0,12,'19-01','graph_63.xml','',120,'2020-08-12 18:28:37','2020-08-12 18:28:51',120,120,NULL),(64,0,12,'Sophia Test','graph_64.xml','',121,'2020-08-13 13:00:52','2020-08-13 13:01:33',121,121,NULL),(65,0,12,'Lakesha Test','graph_65.xml','',119,'2020-08-13 13:58:23','2020-08-13 13:58:50',119,119,NULL),(66,0,9,'test 1004','','',83,'2020-08-13 17:04:15','2020-08-13 17:04:19',83,83,NULL),(67,0,9,'Mapping test for MN DSD','graph_67.xml','',81,'2020-08-14 15:25:55','2020-08-14 15:26:13',81,81,NULL),(68,0,14,'JT Mapping 8/18/20','graph_68.xml','',1,'2020-08-17 16:26:55','2020-08-28 06:20:32',82,1,NULL),(69,0,17,'20_Q3_Brown_991_KO1','graph_69.xml','',99,'2020-08-18 13:41:25','2020-08-18 13:41:42',99,99,NULL),(70,0,17,'20_Q3_Brown_991_KO1_Version 2','graph_70.xml','',99,'2020-08-18 13:49:23','2020-08-18 13:49:46',99,99,NULL),(71,0,22,'SLR II Demo','graph_71.xml','',79,'2020-08-24 18:54:34','2020-09-11 19:37:12',79,79,NULL),(72,0,9,'test999','graph_72.xml','',1,'2020-08-25 17:10:58','2020-08-28 13:31:22',80,1,NULL),(73,0,9,'test26','graph_73.xml','',0,'2020-08-26 05:26:04','2020-08-28 13:31:14',1,1,NULL),(74,0,22,'NH OCA Test','graph_74.xml','',79,'2020-08-27 13:02:39','2020-08-27 13:02:53',79,79,NULL),(75,0,22,'Test123456','graph_75.xml','',0,'2020-08-27 17:36:07','2020-08-27 18:42:05',80,80,NULL),(76,0,22,'CASE 1','graph_76.xml','',135,'2020-08-27 18:51:12','2020-09-11 18:08:47',135,79,NULL),(77,0,22,'Test','graph_77.xml','',134,'2020-08-27 18:51:58','2020-09-16 21:09:45',134,79,NULL),(78,0,22,'Cold','graph_78.xml','',133,'2020-08-27 18:52:02','2020-08-27 18:54:08',133,133,NULL),(79,0,22,'CaseID 123456','graph_79.xml','',138,'2020-08-27 18:52:03','2020-08-27 18:52:24',138,138,NULL),(80,0,22,'Test','','',0,'2020-08-27 18:54:27','2020-08-27 18:54:27',133,133,NULL),(81,0,22,'Test #1','graph_81.xml','',133,'2020-08-27 18:54:48','2020-08-27 18:55:01',133,133,NULL),(82,0,22,'test','graph_82.xml','',135,'2020-08-27 18:55:27','2020-08-27 18:55:43',135,135,NULL),(83,0,19,'419309806','graph_83.xml','',95,'2020-08-28 15:42:58','2020-08-28 15:43:50',95,95,NULL),(84,0,9,'Test','graph_84.xml','',79,'2020-09-04 15:37:13','2020-10-14 17:31:36',79,79,'2020-10-14 17:31:36'),(85,0,22,'whatever you want','','',0,'2020-09-11 18:09:27','2020-09-11 18:09:27',132,132,NULL),(86,0,22,'Whatever you want','','',134,'2020-09-11 18:09:31','2020-09-11 18:09:42',134,134,NULL),(87,0,22,'TGIF','graph_87.xml','',133,'2020-09-11 18:10:37','2020-09-11 18:11:02',133,133,NULL),(88,0,22,'whatever you want','','',0,'2020-09-11 18:10:37','2020-09-11 18:10:37',133,133,NULL),(89,0,22,'Today','graph_89.xml','',133,'2020-09-11 18:11:06','2020-09-11 18:11:19',133,133,NULL),(90,0,13,'Testing - RH','','',90,'2020-09-23 11:41:45','2020-09-23 11:41:53',90,90,NULL),(91,0,13,'Test - RH','graph_91.xml','',90,'2020-09-23 11:46:26','2020-09-23 11:46:41',90,90,NULL),(92,0,12,'20-05','graph_92.xml','',121,'2020-09-23 14:59:25','2020-09-23 15:02:54',121,121,NULL),(93,0,9,'Test review 123','graph_93.xml','',81,'2020-10-01 19:12:10','2020-10-14 17:31:36',81,81,'2020-10-14 17:31:36'),(94,0,9,'Hennepin Test1','graph_94.xml','',81,'2020-10-05 18:11:24','2020-10-14 17:31:36',81,81,'2020-10-14 17:31:36'),(95,0,19,'SSIS # 419309806','graph_95.xml','',95,'2020-10-06 14:53:26','2020-10-06 14:53:43',95,95,NULL),(96,0,19,'Test Map SLR','graph_96.xml','',0,'2020-10-06 15:26:20','2020-10-19 18:53:14',80,80,'2020-10-19 18:53:14'),(97,0,19,'MC-SLR','graph_97.xml','',95,'2020-10-06 15:43:26','2020-10-06 15:43:40',95,95,NULL),(98,0,23,'test map','graph_98.xml','',0,'2020-10-14 17:28:57','2020-10-14 17:30:41',80,80,'2020-10-14 17:30:41'),(99,0,19,'test 03','','',0,'2020-10-14 17:30:17','2020-10-14 17:30:41',80,80,'2020-10-14 17:30:41'),(100,0,9,'Case test 123','graph_100.xml','',81,'2020-10-19 18:17:24','2020-10-19 19:32:36',81,81,'2020-10-19 19:32:36'),(101,0,19,'Test 123 TEST','graph_101.xml','',0,'2020-10-19 18:21:28','2020-10-19 18:53:14',80,80,'2020-10-19 18:53:14'),(102,0,23,'HCS SCIR 2005 Bata','graph_102.xml','',139,'2020-10-19 19:12:00','2020-10-19 19:22:44',139,139,NULL),(103,0,24,'test1','graph_103.xml','',0,'2020-10-19 19:31:12','2020-10-19 19:33:10',80,80,'2020-10-19 19:33:10'),(104,0,19,'testing SLR layout','graph_104.xml','',0,'2020-10-19 19:42:00','2020-10-19 19:42:40',80,80,NULL);

--
-- Table structure for table `site_configs`
--

CREATE TABLE `site_configs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `val` mediumtext COLLATE utf8mb4_unicode_ci,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `type` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` int(10) DEFAULT NULL,
  `updated_by` int(10) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `site_configs`
--

INSERT INTO `site_configs` VALUES (1,'app_name','Collaborative Safety, LLC | Transforming culture, together.',1,'string','2019-07-10 03:16:47','2020-06-03 11:53:34',1,72,NULL),(2,'image','GH78FUUXuSP2X8YlJ1k0401qyOU9J1WD9w3zHWur.png',1,'string','2019-07-10 03:16:47','2019-07-10 03:31:07',1,1,NULL),(3,'records_per_page','100',1,'int','2019-07-10 03:16:47','2020-03-19 07:18:01',1,47,NULL),(4,'footer_title_for_admin','Collaborative Safety, LLC. All rights reserved.',1,'string','2019-07-10 03:16:47','2020-04-29 05:54:13',1,47,NULL),(5,'site_title','Home | Collaborative Safety',1,'string','2019-07-10 03:16:47','2020-01-02 13:12:51',1,30,NULL),(6,'tagline','',1,'string','2019-07-10 03:16:47','2019-10-02 00:44:03',1,1,NULL),(7,'copyright_text','© 2019 All Rights Reserved by Collaborative Safety',1,'string','2019-07-10 03:16:47','2020-01-02 13:10:28',1,30,NULL),(8,'phone','123-456-7890',1,'string','2019-07-10 03:16:47','2020-01-02 13:12:30',1,30,NULL),(9,'from_name','Collaborative Safety, LLC | Transforming culture, together.',1,'string','2019-07-10 03:16:48','2020-06-03 11:53:34',1,72,NULL),(10,'from_email','mapping@collaborative-safety.com',1,'email','2019-07-10 03:16:48','2020-06-03 11:53:34',1,72,NULL),(11,'admin_email','mapping@collaborative-safety.com',1,'email','2019-07-10 03:16:48','2020-06-03 11:53:34',1,72,NULL),(12,'robots_meta_tag',NULL,1,'string','2019-07-10 03:16:48','2020-06-03 11:23:47',1,1,NULL),(13,'google_analytics_code',NULL,1,'string','2019-07-10 03:16:48','2019-07-10 03:16:48',1,1,NULL),(14,'advantage_title','Why The laravelmvc Systems?',1,'string','2019-07-11 06:36:58','2019-07-11 06:37:13',1,1,NULL),(15,'advantage_sub_title','Our advantages',1,'string','2019-07-11 06:36:58','2019-07-11 06:37:13',1,1,NULL),(16,'our_team_title','Why The laravelmvc Team?',1,'string','2019-07-11 06:41:41','2019-07-11 06:42:05',1,1,NULL),(17,'our_team_sub_title','Who are we',1,'string','2019-07-11 06:41:41','2019-07-11 06:42:05',1,1,NULL),(18,'disadvantage_title','The Not So Pure Alternatives',1,'string','2019-07-11 06:45:09','2019-07-11 06:45:09',1,1,NULL),(19,'disadvantage_sub_title','Disadvantages of others',1,'string','2019-07-11 06:45:09','2019-07-11 06:45:09',1,1,NULL),(20,'contact_title','Leave a request \r\nand our manager will contact you',1,'string','2019-07-11 06:50:03','2019-07-15 02:51:44',1,1,NULL),(21,'contact_sub_title','Any questions?',1,'string','2019-07-11 06:50:03','2019-07-15 04:04:33',1,1,NULL),(22,'email','monali.rana@devdigital.com',1,'string','2019-07-11 06:51:58','2019-08-05 05:52:44',1,1,NULL),(23,'disadvantage_left_section_title','Bottles & Jugs',1,'string','2019-07-11 06:59:59','2019-07-11 06:59:59',1,1,NULL),(24,'disadvantage_right_section_title','Water Fountains, Bottle Fillers, Non RO Systems',1,'string','2019-07-11 06:59:59','2019-07-11 06:59:59',1,1,NULL),(25,'contact_thank_you_message','Thank you for contacting us. We will respond to you as soon as possible.',1,'string','2019-07-14 22:57:46','2019-07-15 04:04:13',1,1,NULL),(26,'freetrial_title','Leave a request to schedule a free trial',1,'string','2019-07-15 02:51:06','2019-07-15 02:51:06',1,1,NULL),(27,'freetrial_thank_you_message_title','Great water is on the way!',1,'string','2019-07-15 02:51:06','2019-07-15 02:51:06',1,1,NULL),(28,'freetrial_thank_you_message_description','Your H2O Consultant will\r\ncontact you shortly',1,'string','2019-07-15 02:51:06','2019-07-15 03:16:03',1,1,NULL),(29,'referral_title','Share Your Love for\r\nlaravelmvc and Earn Cash',1,'string','2019-07-15 02:51:21','2019-07-15 03:19:10',1,1,NULL),(30,'referral_description','If you know of anyone who is using the 5-gallon jugs, or anyone who would enjoy our solution, please fill out the information below',1,'string','2019-07-15 02:51:21','2019-07-15 02:51:21',1,1,NULL),(31,'referral_thank_you_message','Thank you for referring the Contact. Our H2O Consultant will contact you shortly.',1,'string','2019-07-15 02:51:21','2019-07-17 00:00:20',1,1,NULL),(32,'logo',NULL,1,'file','2019-08-06 01:09:10','2019-08-06 01:09:10',1,1,NULL),(33,'blog_title','The Not So Pure Alternatives',1,'string','2019-08-06 06:59:36','2019-08-06 06:59:36',2,2,NULL),(34,'blog_sub_title','Sub Blog',1,'string','2019-08-06 06:59:36','2019-08-06 06:59:36',2,2,NULL),(35,'meta_description_for_front','',1,'string','2019-10-02 00:44:04','2019-10-02 00:44:04',1,1,NULL),(36,'company_name','Collaborative Safety',1,'string','2019-10-02 00:44:04','2019-10-25 20:27:39',1,24,NULL),(37,'company_address_line1','TEA Building 801 2nd Ave. N. 3rd Floor',1,'string','2019-10-02 00:44:04','2020-01-02 13:12:30',1,30,NULL),(38,'company_address_line2','',1,'string','2019-10-02 00:44:04','2019-10-02 00:44:04',1,1,NULL),(39,'company_city','Nashville',1,'string','2019-10-02 00:44:04','2020-01-02 13:12:30',1,30,NULL),(40,'company_state','TENNESSEE',1,'string','2019-10-02 00:44:04','2020-01-02 13:12:30',1,30,NULL),(41,'company_country','United States',1,'string','2019-10-02 00:44:04','2020-01-02 13:12:30',1,30,NULL),(42,'company_zipcode','37201',1,'string','2019-10-02 00:44:04','2020-01-02 13:12:30',1,30,NULL),(43,'company_email','contact@collaborativesafety.com',1,'email','2019-10-02 00:44:04','2020-01-02 13:12:30',1,30,NULL),(44,'password_strength','Strong',1,'string','2019-10-02 00:44:05','2020-06-03 11:45:56',1,1,NULL),(45,'login_attempt','3',1,'int','2019-10-02 00:44:05','2020-03-19 07:17:20',1,47,NULL),(46,'minimum_password_length','5',1,'int','2019-10-02 00:44:05','2020-06-03 11:45:44',1,1,NULL),(47,'user_block_time','1',1,'int','2019-10-02 00:44:05','2019-10-02 00:44:05',1,1,NULL);

--
-- Table structure for table `user_types`
--

CREATE TABLE `user_types` (
  `id` tinyint(4) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` int(10) DEFAULT NULL,
  `updated_by` int(10) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_types`
--

INSERT INTO `user_types` VALUES (1,'Super Admin',1,'2019-07-02 18:30:00','2019-07-02 18:30:00',1,1,NULL),(2,'Admin',1,'2019-07-02 18:30:00','2019-07-02 18:30:00',1,1,NULL),(3,'organization user',1,'2019-07-02 18:30:00','2019-07-02 18:30:00',1,1,NULL);


