-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `rating`
--

-- --------------------------------------------------------

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

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

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2021_05_15_141906_create_scores_table', 2);

-- --------------------------------------------------------

--
-- Table structure for table `scores`
--

CREATE TABLE `scores` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `msisdn` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `month_id` int(10) UNSIGNED DEFAULT NULL,
  `prov_id` int(10) UNSIGNED DEFAULT NULL,
  `housing_score` int(11) NOT NULL,
  `life_style_class_score` decimal(20,14) NOT NULL,
  `persona_score` decimal(20,14) NOT NULL,
  `financial_class_score` decimal(20,14) NOT NULL,
  `final_score` decimal(20,14) NOT NULL,
  `housing_level` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `life_style_risk_level` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `persona_level` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `financial_risk_level` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `final_risk_level` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch_score_data` datetime NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `scores`
--

INSERT INTO `scores` (`id`, `user_id`, `msisdn`, `month_id`, `prov_id`, `housing_score`, `life_style_class_score`, `persona_score`, `financial_class_score`, `final_score`, `housing_level`, `life_style_risk_level`, `persona_level`, `financial_risk_level`, `final_risk_level`, `batch_score_data`, `created_at`, `updated_at`) VALUES
(1, 1, '85CD1879A25513EE3077184045869711330335881026A175', 202011, 11, 3, '1.89192625556262', '1.57647058823529', '2.36263736263736', '2.33725027913263', 'high', 'very low', 'high', 'low', 'high', '2021-04-25 06:28:22', '2021-05-15 19:10:58', NULL),
(2, 2, '95291D89525F53623337EB4035F891517802C5EA12A6C470', 202011, 11, 1, '1.81609195402299', '1.51764705882353', '1.98901098901099', '1.55906705600012', 'high', 'very low', 'high', 'very low', 'high', '2021-04-25 06:28:22', '2021-05-15 19:10:58', NULL),
(3, 3, '358B1F49A75EB3A33BC7BF4DE5349AE1B40CD5CB1446847A', 202011, 11, 4, '1.97882637628554', '1.72941176470588', '2.20879120879121', '2.65468504777312', 'medium', 'medium', 'high', 'very low', 'high', '2021-04-25 06:28:22', '2021-05-15 19:18:35', NULL),
(4, 4, '95751549D25473613EF7A742359E9031EA0925E51ED6247F', 202011, 19, 4, '1.76478067387158', '1.92941176470588', '2.97802197802198', '2.87036422401128', 'medium', 'low', 'high', 'medium', 'high', '2021-04-25 06:28:22', '2021-05-15 19:18:35', NULL),
(5, 5, '95B816B90352D31A3B47B14835EA9E31EC0E75261AD6DF77', 202011, 11, 2, '1.36479128856624', '1.68235294117647', '1.98901098901099', '1.80613385077611', 'medium', 'medium', 'high', 'very low', 'high', '2021-04-25 06:28:22', '2021-05-15 19:26:00', NULL),
(6, 6, 'B50A11F9145283753037F24A251896911907E57516A61F7C', 202011, 10, 3, '1.82708200890019', '1.72941176470588', '2.64835164835165', '2.43316941881648', 'low', 'low', 'low', 'low', 'high', '2021-04-25 06:28:22', '2021-05-15 19:26:00', NULL),
(7, 7, 'A5921B99D958C3723BF78C4EE54A9F71760975711FC6EF7F', 202011, 11, 1, '1.51493960584870', '1.57647058823529', '2.52747252747253', '1.66376376564612', 'low', 'medium', 'low', 'low', 'very high', '2021-04-25 06:28:22', '2021-05-15 19:29:11', NULL),
(8, 8, '757218696A54B3C53F77C84AF5FB90E19C0455C01FC64E74', 202011, 11, 4, '1.56019358741682', '1.30588235294118', '1.86813186813187', '2.39262332614185', 'medium', 'medium', 'low', 'very low', 'very high', '2021-04-25 06:28:22', '2021-05-15 19:29:11', NULL),
(9, 9, '054F17F9E15DE3C13117594DD5F897719A0BC5AC10C69D71', 202011, 11, 1, '1.56325492689129', '1.84705882352941', '2.06593406593407', '1.57922571546101', 'medium', 'high', 'low', 'very low', 'very high', '2021-04-25 06:28:22', '2021-05-15 19:32:02', NULL),
(10, 10, '05AD1FC9F550E3E13BE7964F25029731C40095121356D178', 202011, 11, 1, '1.76769509981851', '1.67058823529412', '1.81318681318681', '1.52014308356318', 'very high', 'low', 'low', 'very low', 'high', '2021-04-25 06:28:22', '2021-05-15 19:32:02', NULL),
(11, 11, '850B1EA91A53733A30271F4555949DB1D80CA5341B96A97F', 202011, 11, 1, '2.02857142857143', '3.31578947368421', '1.50000000000000', '1.74681203007519', 'very high', 'very low', 'low', 'very low', 'high', '2021-04-25 06:28:22', '2021-05-15 19:34:57', NULL),
(12, 12, '855E1029115233E230078744250C9161CC0895AD1EE6DB70', 202011, 11, 1, '1.53528289891926', '1.71764705882353', '2.08791208791209', '1.55895939354763', 'medium', 'low', 'medium', 'very low', 'high', '2021-04-25 06:28:22', '2021-05-15 19:34:57', NULL),
(13, 25, '855E1029115233E230078744250C9161CC0895AD1EE6DB70', 202011, 11, 1, '1.53528289891926', '1.71764705882353', '2.08791208791209', '1.55895939354763', 'medium', 'high', 'medium', 'very low', 'very high', '2021-04-25 06:28:22', '2021-05-15 19:34:57', NULL),
(14, 26, '855E1029115233E230078744250C9161CC0895AD1EE6DB70', 202011, 11, 1, '1.53528289891926', '1.71764705882353', '2.08791208791209', '1.55895939354763', 'medium', 'low', 'medium', 'very low', 'high', '2021-04-25 06:28:22', '2021-05-15 19:34:57', NULL),
(15, 27, '855E1029115233E230078744250C9161CC0895AD1EE6DB70', 202011, 11, 1, '1.53528289891926', '1.71764705882353', '2.08791208791209', '1.55895939354763', 'medium', 'high', 'medium', 'very low', 'very high', '2021-04-25 06:28:22', '2021-05-15 19:34:57', NULL),
(16, 28, '855E1029115233E230078744250C9161CC0895AD1EE6DB70', 202011, 11, 1, '1.53528289891926', '1.71764705882353', '2.08791208791209', '1.55895939354763', 'high', 'very low', 'medium', 'very low', 'high', '2021-04-25 06:28:22', '2021-05-15 19:34:57', NULL),
(17, 29, '855E1029115233E230078744250C9161CC0895AD1EE6DB70', 202011, 11, 1, '1.53528289891926', '1.71764705882353', '2.08791208791209', '1.55895939354763', 'high', 'very low', 'medium', 'very low', 'high', '2021-04-25 06:28:22', '2021-05-15 19:34:57', NULL),
(18, 30, '855E1029115233E230078744250C9161CC0895AD1EE6DB70', 202011, 11, 1, '1.53528289891926', '1.71764705882353', '2.08791208791209', '1.55895939354763', 'medium', 'very low', 'high', 'very low', 'high', '2021-04-25 06:28:22', '2021-05-15 19:34:57', NULL),
(19, 31, '855E1029115233E230078744250C9161CC0895AD1EE6DB70', 202011, 11, 1, '1.53528289891926', '1.71764705882353', '2.08791208791209', '1.55895939354763', 'medium', 'low', 'medium', 'very low', 'high', '2021-04-25 06:28:22', '2021-05-15 19:34:57', NULL),
(20, 32, '855E1029115233E230078744250C9161CC0895AD1EE6DB70', 202011, 11, 1, '1.53528289891926', '1.71764705882353', '2.08791208791209', '1.55895939354763', 'medium', 'medium', 'medium', 'very low', 'high', '2021-04-25 06:28:22', '2021-05-15 19:34:57', NULL),
(21, 33, '855E1029115233E230078744250C9161CC0895AD1EE6DB70', 202011, 11, 1, '1.53528289891926', '1.71764705882353', '2.08791208791209', '1.55895939354763', 'medium', 'medium', 'medium', 'very low', 'very high', '2021-04-25 06:28:22', '2021-05-15 19:34:57', NULL),
(22, 34, '855E1029115233E230078744250C9161CC0895AD1EE6DB70', 202011, 11, 1, '1.53528289891926', '1.71764705882353', '2.08791208791209', '1.55895939354763', 'medium', 'low', 'medium', 'very low', 'high', '2021-04-25 06:28:22', '2021-05-15 19:34:57', NULL),
(23, 35, '855E1029115233E230078744250C9161CC0895AD1EE6DB70', 202011, 11, 1, '1.53528289891926', '1.71764705882353', '2.08791208791209', '1.55895939354763', 'medium', 'high', 'medium', 'very low', 'very high', '2021-04-25 06:28:22', '2021-05-15 19:34:57', NULL),
(24, 36, '855E1029115233E230078744250C9161CC0895AD1EE6DB70', 202011, 11, 1, '1.53528289891926', '1.71764705882353', '2.08791208791209', '1.55895939354763', 'medium', 'medium', 'medium', 'very low', 'high', '2021-04-25 06:28:22', '2021-05-15 19:34:57', NULL),
(25, 37, '855E1029115233E230078744250C9161CC0895AD1EE6DB70', 202011, 11, 1, '1.53528289891926', '1.71764705882353', '2.08791208791209', '1.55895939354763', 'very low', 'medium', 'medium', 'very low', 'low', '2021-04-25 06:28:22', '2021-05-15 19:34:57', NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `scores`
--
ALTER TABLE `scores`
  ADD PRIMARY KEY (`id`),
  ADD KEY `scores_user_id_foreign` (`user_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `scores`
--
ALTER TABLE `scores`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `scores`
--
ALTER TABLE `scores`
  ADD CONSTRAINT `scores_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);
COMMIT;

