-- phpMyAdmin SQL Dump -- version 5.2.3 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Waktu pembuatan: 23 Sep 2026 pada 16.05 -- Versi server: 8.0.46-cll-lve -- Versi PHP: 8.4.25 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Basis data: `rnbmanag_production_siap_andalan` -- -- -------------------------------------------------------- -- -- Struktur dari tabel `employees` -- CREATE TABLE `employees` ( `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `employee_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Active', `is_event_project_admin` tinyint(1) NOT NULL DEFAULT '0', `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data untuk tabel `employees` -- INSERT INTO `employees` (`id`, `user_id`, `employee_code`, `status`, `is_event_project_admin`, `deleted_at`, `created_at`, `updated_at`) VALUES ('0CAA8F61-096F-8B09-AA10-1A1511FBE16A', 'E3148927-7021-8E52-97C7-0A7605F13FD9', 'EMP-OLD-0054', 'Active', 0, NULL, '2025-05-22 09:20:59', '2026-01-21 08:45:26'), ('14DC4277-2996-80ED-B450-B9BF18747B1B', '5EFE6D35-E751-86D8-ACE3-05DC2C46D32A', 'EMP-24711008', 'Active', 0, NULL, '2026-07-30 08:42:17', '2026-07-30 08:42:17'), ('1DCA9899-2189-8AB7-8FB3-0D424FA88460', '409AF458-5C52-83F1-B22A-7DC1E33946E7', 'EMP-OLD-0069', 'Active', 0, NULL, '2026-06-04 02:00:32', '2026-06-04 02:12:21'), ('20CA4A31-ABDE-8C4A-A549-DEB713E05932', 'AF59059D-C64C-88F9-8526-988429B8AE3C', 'EMP-OLD-0047', 'Active', 1, NULL, '2024-06-19 01:49:02', '2026-08-14 08:54:54'), ('2771F21E-51FA-8605-83EC-BD771E58BB58', 'A86BA6A2-B08D-8372-8D03-44F1583A49E4', 'EMP-OLD-0065', 'Active', 0, NULL, '2026-04-20 02:58:11', '2026-04-20 02:58:11'), ('27B0361C-2AE8-88B0-AF10-19B3BB385096', '2809878C-82B4-8BA1-9D29-6B755E3CCCBD', 'EMP-OLD-0056', 'Active', 0, NULL, '2025-07-07 02:59:02', '2025-07-07 02:59:02'), ('290007BF-8E2C-83C3-A1D9-D3A4EDD7639A', 'B45C33C3-ACEE-893F-8470-F664CF301CC8', 'EMP-SUPERADMIN', 'Active', 0, NULL, '2026-07-03 00:38:13', '2026-07-03 00:38:13'), ('304D94A7-7C26-87C0-B9B5-938D318970DF', 'CB7E07B6-0AAF-8705-ACB7-27090E624B5E', 'EMP-012013', 'Active', 1, NULL, '2023-02-23 06:56:24', '2026-08-14 08:54:44'), ('305ABA26-F2BB-8C9A-952B-F1648F4AA001', 'B2F34634-271F-8BD5-8A7F-260ED410E3BC', 'EMP-36560302', 'Active', 0, '2026-07-31 04:27:01', '2026-07-31 04:25:23', '2026-07-31 04:27:01'), ('30CFCD67-207E-88FA-9114-DA13D6044A79', '6112E43B-6FE8-8B76-9623-F8AF28D58C51', 'EMP-HILMI-ULWAN', 'Active', 0, NULL, '2026-07-03 00:38:12', '2026-07-03 00:38:12'), ('32B48658-2BC5-85F9-AEF2-87B6DD03BE6E', '5C631CD3-DC9A-80AC-BD1D-4AB5F12D9A8F', 'EMP-OLD-0060', 'Active', 0, NULL, '2026-07-06 18:14:35', '2026-07-06 18:14:35'), ('38310DA8-EF54-8FE6-AED5-3AAAB1BA2FDE', 'FF20B3EE-98D7-8FFD-A5CF-6AF6DF9BF3A2', 'EMP-011907', 'Active', 0, NULL, '2023-02-23 06:51:46', '2026-01-28 01:52:47'), ('6189CEFB-A66F-8855-984D-76A671333211', 'B6777EC9-AA39-87CE-8FA0-F14F545B930C', 'EMP-OLD-0067', 'Active', 0, NULL, '2026-06-02 10:04:37', '2026-06-10 01:34:55'), ('642743B1-69A5-8B90-A3C9-2D98E1CB027A', '0A69BA99-4D1C-86EE-88DB-F29C65A6E594', 'EMP-OLD-0045', 'Inactive', 0, NULL, '2024-02-15 03:16:01', '2025-05-27 02:00:42'), ('670B8416-4416-8E88-8508-1E9699526E4C', 'A835C03F-6042-8FBB-B655-734E78507E3F', 'EMP-OLD-0059', 'Active', 1, NULL, '2026-01-21 06:31:56', '2026-08-14 08:55:08'), ('7CD7AFA0-8873-8556-952F-E7B6F5BD74D1', '4EC4F35C-E048-862A-89F5-3B281A3CFD84', 'EMP-OLD-0066', 'Active', 0, NULL, '2026-04-21 04:32:23', '2026-04-21 04:32:23'), ('82D2AF54-6F5E-8E90-A5C4-2FE41428461E', 'CC5BB54B-D4D7-876E-A834-89E7F4AD84B6', 'EMP-011702', 'Inactive', 0, NULL, '2023-02-23 04:56:24', '2025-05-22 09:07:54'), ('88435C2E-9C78-88A0-A52B-72E07F55FD12', '8698A7E9-355D-8E52-A3EA-F4E87638825E', 'EMP-1', 'Inactive', 0, NULL, '2023-02-23 06:40:32', '2023-02-23 06:41:51'), ('91CE795B-E655-816B-803C-95C1D2DCEB00', 'DECD37AE-F934-858B-9CC5-03CCA0AB1119', 'EMP-OLD-0064', 'Active', 0, NULL, '2026-04-02 02:22:38', '2026-04-24 07:25:43'), ('9B1A78B1-5DD0-867D-8C61-AC3CC12A8BF8', 'B3752048-AAF8-8DE0-8DC8-070D6F26DE3C', 'EMP-16219458', 'Active', 0, NULL, '2026-08-31 03:51:35', '2026-08-31 03:51:35'), ('9DE3289E-457F-8CB7-8151-CA52AB49B180', '025DBE37-2ED2-8001-B927-B1E3219F3ECF', 'EMP-OLD-0063', 'Active', 0, NULL, '2026-02-10 02:41:49', '2026-02-10 02:41:49'), ('C45CE395-1D6B-822A-B36A-DA824DD048F3', 'F992F2CB-FD96-8B15-B59D-D048BDD9E093', 'EMP-OLD-0061', 'Active', 0, NULL, '2026-01-23 04:39:10', '2026-01-27 01:58:40'), ('C654C949-E7C2-8234-BF53-886D50203D23', '57DF23B1-A7DF-81DD-9682-69092EDEAA4D', 'EMP-OLD-0053', 'Active', 0, NULL, '2025-04-28 02:52:02', '2025-04-28 02:52:02'), ('CC6CD5A6-5933-8B36-8496-50622639AC98', 'F71C5EC1-711E-850B-8ADE-995A425CA55C', 'EMP-OLD-0019', 'Inactive', 0, NULL, '2023-02-23 07:01:02', '2023-04-04 02:47:40'), ('D2405803-5A9E-839E-8EE0-B32B2353A0E0', '97B9F93D-F793-8B90-AA47-E133590727F6', 'EMP-OLD-0042', 'Inactive', 0, NULL, '2023-05-24 02:00:47', '2023-11-26 03:07:35'), ('D2E2F1D7-C4E5-8DF4-9F00-D118D2AFF3A9', '6C951925-E929-8963-A778-F1B92E43CB5E', 'EMP-011701', 'Active', 0, NULL, '2023-02-23 04:54:27', '2023-07-05 14:46:20'), ('D55F9E5F-6272-87BA-8E11-11792E145F68', '4A657DAF-1E01-8BA9-BB90-C9C7CED0BFEF', 'EMP-011830', 'Active', 0, NULL, '2023-02-23 04:59:21', '2023-07-05 14:45:47'), ('E0673190-51C4-8CAC-93DF-93C8AAEA135D', '076E9555-67DA-8BDE-ADE2-F4BAEB9E0ACA', 'EMP-65393887', 'Active', 0, NULL, '2026-09-10 10:04:49', '2026-09-10 10:04:49'), ('E9938875-DB41-893B-A690-403C9102FBFE', 'A630207E-A834-8F18-ABAF-0E7B2BB45596', 'EMP-RULLY-PRIYATNO', 'Active', 0, NULL, '2026-07-03 00:38:12', '2026-07-03 00:38:12'), ('EA6DB678-5DBA-8B08-959E-509F1F2576F9', '6A4AB129-4740-8853-B550-FBD2E3286BA7', 'EMP-OLD-0044', 'Inactive', 0, NULL, '2024-02-15 03:13:32', '2025-05-27 02:00:34'), ('EDF937E0-DFC2-8017-B335-B9FFAA2594E3', 'DD9AC1FD-9769-8841-AF7A-A65AEE864352', 'EMP-17843127', 'Active', 0, NULL, '2026-07-30 12:43:34', '2026-07-30 12:43:34'), ('F21D4C0F-7842-8FA6-8AA9-77881EFE4298', '892717C4-8FE3-8B34-AB72-262397E5E20A', 'EMP-OLD-0016', 'Inactive', 0, NULL, '2023-02-23 06:59:42', '2023-05-03 02:26:48'), ('F913AE30-40D0-85FD-8766-F75ABAC5E084', '5AC134B6-2DDA-8FE8-9675-3AC651FF6B2D', 'EMP-011804', 'Active', 0, NULL, '2023-02-23 06:58:14', '2023-05-30 05:54:49'); -- -- Indeks untuk tabel yang dibuang -- -- -- Indeks untuk tabel `employees` -- ALTER TABLE `employees` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `employees_user_id_unique` (`user_id`), ADD UNIQUE KEY `employees_employee_code_unique` (`employee_code`), ADD KEY `employees_event_project_admin_index` (`is_event_project_admin`); -- -- Ketidakleluasaan untuk tabel pelimpahan (Dumped Tables) -- -- -- Ketidakleluasaan untuk tabel `employees` -- ALTER TABLE `employees` ADD CONSTRAINT `employees_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;