-- https://www.phpmyadmin.net/
--
-- Waktu pembuatan: 06 Apr 2026 pada 02.28
-- Versi server: 11.8.6-MariaDB-log
-- Versi PHP: 7.2.34

START TRANSACTION;



--
-- Database: `u768956174_lmsinsida`
--

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

--
-- Struktur dari tabel `assignments`
--

CREATE TABLE `assignments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `meeting_id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `file_path` varchar(255) DEFAULT NULL,
  `start_date` datetime NOT NULL,
  `end_date` datetime NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `allow_late_submission` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data untuk tabel `assignments`
--

INSERT INTO `assignments` (`id`, `meeting_id`, `title`, `description`, `file_path`, `start_date`, `end_date`, `created_at`, `updated_at`, `allow_late_submission`) VALUES
(22, 94, 'asdfasd', NULL, 'assignments/BL8zNSbpZteOWjLSIWrEr8fMx288y5wB2lRIBHnx.xlsx', '2025-09-05 16:43:00', '2025-09-08 16:43:00', '2025-09-03 09:43:24', '2025-09-04 02:58:45', 0),
(24, 96, 'xasdasdsa', NULL, 'assignments/ewecT9GqxotbhPeC33esUc2EJ3bTQaNtr5nsAhbq.png', '2025-09-06 09:56:00', '2025-09-12 09:56:00', '2025-09-04 02:56:59', '2025-09-04 02:56:59', 0),
(25, 97, '2', NULL, 'assignments/XbK2JTevxoUdY5xHgAPLXPhkW88rdR1rby1BCzM2.png', '2025-09-06 09:57:00', '2025-09-08 09:57:00', '2025-09-04 02:58:06', '2025-09-06 09:39:15', 0),
(26, 99, 'Es', NULL, 'assignments/6AR1nT3PWfCtaESgh4NcZvuFYvw37kHG0HrLSZus.png', '2025-09-04 10:10:00', '2025-09-08 10:10:00', '2025-09-04 03:11:40', '2025-09-04 03:11:40', 0),
(28, 103, 'Tugas 1', NULL, 'assignments/RO0XsZvhshPZ7FLe5ziRbEsmW9W16SoTbCqegqCs.xlsx', '2025-09-06 14:01:00', '2025-09-06 16:01:00', '2025-09-06 07:02:04', '2025-09-06 07:02:04', 0),
(29, 108, 'UTS', NULL, 'assignments/iFYA2Sin2xaAoAIqvRd0VAoG3OysLnONUiNCr9nO.png', '2025-09-08 13:49:00', '2025-09-08 13:54:00', '2025-09-08 06:49:41', '2025-09-08 06:49:41', 0),
(30, 109, '12', NULL, 'assignments/RUonpYqXoAxs1j9gMGHhXMWBOULYREKSiQunuILI.png', '2025-09-08 13:49:00', '2025-09-08 13:54:00', '2025-09-08 06:50:00', '2025-09-08 06:50:00', 0),
(35, 122, 'Tugas', NULL, 'assignments/7P6w9Heh0ux383praPsIhLKgBN2e7AuzBjDYqrdv.pdf', '2025-09-10 12:20:00', '2025-09-17 12:20:00', '2025-09-10 05:20:13', '2025-09-10 05:20:13', 0),
(36, 130, 'Tugas', NULL, 'assignments/zKgK34UxWWEZ4mItp8jTY7mopa4ltfzQxHJWrwNe.pdf', '2025-09-12 09:45:00', '2025-09-18 09:45:00', '2025-09-11 02:45:34', '2025-09-11 02:45:34', 0),
(37, 134, 'Tugas 1', NULL, 'assignments/q1AG3Oij93o3eOH9OGUuHOxH5khK1UQzZkB1OStN.pdf', '2025-09-11 10:22:00', '2025-09-12 10:22:00', '2025-09-11 03:22:18', '2025-09-11 03:22:18', 0),
(38, 135, 'UTS', NULL, 'assignments/DLkkOhCzOWHz9Z743LaOXxJx3UHL98aaJsZbu5kd.pdf', '2025-09-11 10:23:00', '2025-09-11 12:23:00', '2025-09-11 03:23:53', '2025-09-11 03:23:53', 0);

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

--
-- Struktur dari tabel `attendances`
--

CREATE TABLE `attendances` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` varchar(12) NOT NULL,
  `meeting_id` bigint(20) UNSIGNED NOT NULL,
  `status` enum('present','absent','izin') NOT NULL DEFAULT 'present',
  `proof_path` varchar(255) DEFAULT NULL,
  `attended_at` timestamp NULL DEFAULT current_timestamp(),
  `created_by_user_id` varchar(12) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data untuk tabel `attendances`
--

INSERT INTO `attendances` (`id`, `user_id`, `meeting_id`, `status`, `proof_path`, `attended_at`, `created_by_user_id`, `created_at`, `updated_at`) VALUES
(21, '683e75af91f7', 98, 'present', NULL, '2025-09-06 02:21:50', '675bf741a3b0', '2025-09-06 02:21:50', '2025-09-08 02:16:13'),
(22, 'a20452bb-91f', 102, 'present', NULL, '2025-09-06 07:04:16', NULL, '2025-09-06 07:04:16', '2025-09-06 07:04:16'),
(23, 'a20452bb-91f', 105, 'present', NULL, '2025-09-06 09:50:12', NULL, '2025-09-06 09:50:12', '2025-09-06 09:50:12'),
(24, 'a20452bb-91f', 98, 'present', NULL, '2025-09-08 02:16:13', '675bf741a3b0', '2025-09-08 02:16:13', '2025-09-08 02:24:18'),
(25, 'a20452bb-91f', 110, 'present', NULL, '2025-09-08 09:26:50', NULL, '2025-09-08 09:26:50', '2025-09-08 09:26:50'),
(28, '455fa3b2-2d4', 123, 'present', NULL, '2025-09-10 05:32:53', NULL, '2025-09-10 05:32:53', '2025-09-10 05:32:53'),
(29, 'a20452bb-91f', 129, 'present', NULL, '2025-09-11 02:46:48', '6a066e7c-2bf', '2025-09-11 02:46:48', '2025-09-11 02:46:48'),
(30, '10eee191-1c6', 131, 'absent', NULL, '2025-09-11 03:20:15', 'eecc4bdc-0e7', '2025-09-11 03:20:15', '2025-09-11 03:20:35');

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

--
-- Struktur dari tabel `bobot`
--

CREATE TABLE `bobot` (
  `id` char(36) NOT NULL,
  `course_id` bigint(20) UNSIGNED NOT NULL,
  `nama_bobot` varchar(255) NOT NULL,
  `nilai_bobot` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data untuk tabel `bobot`
--

INSERT INTO `bobot` (`id`, `course_id`, `nama_bobot`, `nilai_bobot`, `created_at`, `updated_at`) VALUES
('0f44dcea-6b5a-44d2-87a4-0a03e44243a2', 84, 'uas', 40, '2025-09-08 09:47:08', '2025-09-08 09:47:08'),
('5191d650-472a-4966-beab-89463305e65e', 72, 'absensi', 10, '2025-09-09 06:44:26', '2025-09-09 06:44:26'),
('5a378306-eaca-4d8c-8986-5adabac7c38e', 72, 'uts', 30, '2025-09-09 06:44:26', '2025-09-09 06:44:26'),
('5c24a74e-57e2-44e6-b253-538378a06ac2', 72, 'uas', 50, '2025-09-09 06:44:26', '2025-09-09 06:44:26'),
('7ca94a68-294e-41ab-b179-fc2035934685', 87, 'absensi', 100, '2025-09-09 04:43:29', '2025-09-09 04:43:29'),
('a1c601f3-d48a-4a80-9ba4-9501e68495ae', 72, 'tugas', 10, '2025-09-09 06:44:26', '2025-09-09 06:44:26'),
('a531b3b6-44b4-4128-9f04-049c0bec485f', 84, 'uts', 40, '2025-09-08 09:47:08', '2025-09-08 09:47:08'),
('be5c8b8e-90d7-4842-93b2-60e9e87a20fb', 84, 'tugas', 20, '2025-09-08 09:47:08', '2025-09-08 09:47:08'),
('dd1b6afd-aa3a-418a-8a8e-96d2fd174624', 84, 'absensi', 0, '2025-09-08 09:47:08', '2025-09-08 09:47:08');

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

--
-- Struktur dari tabel `comments`
--

CREATE TABLE `comments` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` varchar(12) NOT NULL,
  `post_id` int(10) UNSIGNED NOT NULL,
  `parent_id` int(10) UNSIGNED DEFAULT NULL,
  `body` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data untuk tabel `comments`
--

INSERT INTO `comments` (`id`, `user_id`, `post_id`, `parent_id`, `body`, `created_at`, `updated_at`) VALUES
(1, '978NutghekKl', 2, NULL, 'A', '2025-09-10 09:36:48', '2025-09-10 09:36:48'),
(3, '978NutghekKl', 2, NULL, 'Ts', '2025-09-10 09:37:55', '2025-09-10 09:37:55'),
(4, 'eecc4bdc-0e7', 3, NULL, 'Ayo coba isi, sebarkan pengetahuanmu', '2025-09-11 03:46:12', '2025-09-11 03:46:12'),
(5, '10eee191-1c6', 3, NULL, 'Jadi gini', '2025-09-11 03:46:57', '2025-09-11 03:46:57'),
(6, 'eecc4bdc-0e7', 3, NULL, 'Komen lagi', '2025-09-11 03:47:16', '2025-09-11 03:47:16');

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

--
-- Struktur dari tabel `courses`
--

CREATE TABLE `courses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `id_jurusan` varchar(255) DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `lecturer_name` varchar(255) NOT NULL,
  `code` varchar(255) NOT NULL,
  `base_code` varchar(50) DEFAULT NULL,
  `image_path` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `number_of_meetings` int(11) NOT NULL DEFAULT 14,
  `semester` enum('Ganjil','Genap','Pendek') NOT NULL DEFAULT 'Ganjil',
  `academic_year` varchar(10) NOT NULL DEFAULT '2025/2026'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `courses`
--

INSERT INTO `courses` (`id`, `id_jurusan`, `title`, `description`, `lecturer_name`, `code`, `base_code`, `image_path`, `created_at`, `updated_at`, `number_of_meetings`, `semester`, `academic_year`) VALUES
(72, '1b6e3f60-d66c-48dd-aa6f-b9d807ab1981', 'Keperawatan Maternitas', NULL, 'reni', 'KEP204', 'KEP204', 'image/course/bg2.png', '2025-09-03 09:11:04', '2025-09-08 03:55:58', 14, 'Ganjil', '2025/2026'),
(73, '1b6e3f60-d66c-48dd-aa6f-b9d807ab1981', 'Gizi dalam Keperawatan', NULL, 'bebelacsaiga', 'KEP105', 'KEP105', 'image/course/bg1.png', '2025-09-03 09:26:10', '2025-09-03 09:26:10', 14, 'Ganjil', '2025/2026'),
(74, '1b6e3f60-d66c-48dd-aa6f-b9d807ab1981', 'Keperawatan Gawat Darurat', NULL, 'bebelacsaiga', 'KEP205', 'KEP205', 'image/course/bg1.png', '2025-09-03 09:26:17', '2025-09-06 09:47:58', 14, 'Ganjil', '2025/2026'),
(75, '1b6e3f60-d66c-48dd-aa6f-b9d807ab1981', 'Etika dan Hukum Keperawatan', NULL, 'testing dosen', 'KEP102', 'KEP102', 'image/course/bg9.png', '2025-09-03 09:26:32', '2025-09-03 09:26:32', 14, 'Ganjil', '2025/2026'),
(76, '4529c966-0a40-4778-844f-06065c948e87', 'CSS', NULL, 'bebelacsaiga', 'TI202512', 'TI202512', 'image/course/footer1.png', '2025-09-06 07:00:26', '2025-09-06 09:59:46', 15, 'Ganjil', '2025/2026'),
(80, 'a0f2e5e0-108b-43c3-beb2-5c78fc790f89', 'Farmakologi', NULL, 'bebelacsaiga', 'SSI105', 'SSI105', 'image/course/bg3.png', '2025-09-08 08:16:35', '2025-09-08 08:16:35', 14, 'Ganjil', '2025/2026'),
(81, 'a0f2e5e0-108b-43c3-beb2-5c78fc790f89', 'Keperawatan Maternitas', NULL, 'bebelacsaiga', 'SSI108', 'SSI108', 'image/course/bg5.png', '2025-09-08 08:19:10', '2025-09-08 08:19:10', 14, 'Ganjil', '2025/2026'),
(84, 'a0f2e5e0-108b-43c3-beb2-5c78fc790f89', 'Keperawatan Anak', NULL, 'bebelacsaiga', 'SSI107', 'SSI107', 'image/course/bg7.png', '2025-09-08 09:47:08', '2025-09-08 09:47:08', 14, 'Ganjil', '2025/2026'),
(85, 'a0f2e5e0-108b-43c3-beb2-5c78fc790f89', 'Etika dan Hukum Keperawatan', NULL, 'bebelacsaiga', 'SSI102', 'SSI102', 'image/course/bg10.png', '2025-09-08 09:56:55', '2025-09-08 09:56:55', 14, 'Ganjil', '2025/2026'),
(86, 'a0f2e5e0-108b-43c3-beb2-5c78fc790f89', 'Keperawatan Medikal Bedah I', NULL, 'bebelacsaiga', 'SSI104', 'SSI104', 'image/course/bg11.png', '2025-09-08 10:00:30', '2025-09-08 10:00:30', 14, 'Ganjil', '2025/2026'),
(87, 'a0f2e5e0-108b-43c3-beb2-5c78fc790f89', 'Keperawatan Gawat Darurat', NULL, 'bebelacsaiga', 'SSI109', 'SSI109', 'image/course/bg5.png', '2025-09-09 04:43:28', '2025-09-09 04:43:28', 14, 'Ganjil', '2025/2026'),
(91, '4529c966-0a40-4778-844f-06065c948e87', '1111', NULL, 'bebelacsaiga', '1-G2502', '1', 'image/course/bg11.png', '2025-09-09 07:17:54', '2025-09-09 07:17:54', 14, 'Ganjil', '2025/2026'),
(93, '4529c966-0a40-4778-844f-06065c948e87', '1111', NULL, 'bebelacsaiga', '1-E2502', '1', 'image/course/bg9.png', '2025-09-09 07:20:24', '2025-09-09 07:20:24', 14, 'Genap', '2025/2026'),
(94, '4529c966-0a40-4778-844f-06065c948e87', '1111', NULL, 'bebelacsaiga', '1-G2602', '1', 'image/course/bg8.png', '2025-09-09 07:20:44', '2025-09-09 07:20:44', 14, 'Ganjil', '2026/2027'),
(97, '1c5b025c-f211-4dc2-b1a8-cc3244733a92', 'Sejarah Kebudayaan Islam', NULL, 'dosen005', 'PAI102-G2502-G2502', 'PAI102-G2502', 'image/course/bg6.png', '2025-09-10 04:58:56', '2025-09-10 04:58:56', 14, 'Ganjil', '2025/2026'),
(98, '1c5b025c-f211-4dc2-b1a8-cc3244733a92', 'Ilmu Fikih', NULL, 'dosen005', 'PAI103-G2502', 'PAI103', 'image/course/bg3.png', '2025-09-10 05:01:52', '2025-09-10 05:01:52', 14, 'Ganjil', '2025/2026'),
(99, '1c5b025c-f211-4dc2-b1a8-cc3244733a92', 'Ilmu Fikih', NULL, 'dosen005', 'PAI103-E2502', 'PAI103', 'image/course/bg1.png', '2025-09-10 06:02:06', '2025-09-10 06:02:06', 14, 'Genap', '2025/2026'),
(100, '8f860a88-9c64-4c98-a445-932011d30f3e', 'Tes Matkul', NULL, 'dosen005', 'Tes-G2502', 'Tes', 'image/course/footer1.png', '2025-09-11 02:43:17', '2025-09-11 02:43:17', 14, 'Ganjil', '2025/2026'),
(101, '84c0857b-8584-4ac1-8b5c-1c40cea7b2d1', 'Algoritma Pemrograman', NULL, 'Dosen STMIK Arung Binang', 'MI3212-G2502', 'MI3212', 'image/course/bg6.png', '2025-09-11 03:14:51', '2025-09-11 03:18:53', 14, 'Ganjil', '2025/2026');

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

--
-- Struktur dari tabel `enrolments`
--

CREATE TABLE `enrolments` (
  `enrol_id` bigint(20) NOT NULL,
  `user_id` varchar(20) DEFAULT NULL,
  `course_id` bigint(20) DEFAULT NULL,
  `final_grade` varchar(2) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data untuk tabel `enrolments`
--

INSERT INTO `enrolments` (`enrol_id`, `user_id`, `course_id`, `final_grade`, `created_at`, `updated_at`) VALUES
(32, '675bf741a320', 1, NULL, '2025-08-21 20:32:27', '2025-08-21 20:32:27'),
(33, '6788b5a79eff', 1, NULL, '2025-08-21 20:32:45', '2025-08-21 20:32:45'),
(34, '6788b5a79eff', 2, NULL, '2025-08-21 20:33:20', '2025-08-21 20:33:20'),
(40, '83bfe5e3-1a0', 3, NULL, '2025-08-22 01:35:51', '2025-08-22 01:35:51'),
(42, '6cfd2a32-a28', 1, NULL, '2025-08-23 06:04:15', '2025-08-23 06:04:15'),
(43, '6cfd2a32-a28', 2, NULL, '2025-08-23 09:17:11', '2025-08-23 09:17:11'),
(61, '67b426db8b5b', 1, NULL, '2025-08-24 03:17:30', '2025-08-29 14:44:21'),
(65, '67b426db8b5b', 4, NULL, '2025-08-26 03:20:24', '2025-08-29 14:44:25'),
(66, '6788b5a79eff', 15, NULL, '2025-08-26 04:50:16', '2025-08-26 04:50:16'),
(67, '675bf741a320', 15, NULL, '2025-08-26 04:59:51', '2025-08-26 04:59:51'),
(70, '67b426db8b5b', 37, NULL, '2025-08-27 07:19:13', '2025-08-29 14:44:29'),
(72, '67b426db8b5b', 39, NULL, '2025-08-27 07:19:22', '2025-08-29 14:45:06'),
(73, '67b426db8b5b', 40, NULL, '2025-08-27 07:19:29', '2025-08-29 14:45:12'),
(74, '978NutghekKl', 41, NULL, '2025-08-27 07:19:40', '2025-08-27 07:19:40'),
(75, '978NutghekKl', 42, NULL, '2025-08-27 07:19:58', '2025-08-27 07:19:58'),
(79, '683e75af91f7', 1, NULL, '2025-08-28 07:29:11', '2025-08-28 07:29:11'),
(83, '683e75af91f7', 44, NULL, '2025-08-28 09:37:21', '2025-08-28 09:37:21'),
(84, '6788b5a79eff', 38, NULL, '2025-08-29 06:40:17', '2025-08-29 06:40:17'),
(85, '675bf741a3b0', 47, NULL, '2025-08-29 07:52:20', '2025-08-29 07:52:20'),
(88, '6788b5a79eff', 49, NULL, '2025-08-29 09:52:54', '2025-08-29 09:52:54'),
(89, '978NutghekKl', 1, NULL, '2025-08-30 02:08:20', '2025-08-30 02:08:20'),
(90, '683e75af91f7', 50, NULL, '2025-08-30 02:13:48', '2025-08-30 02:13:48'),
(91, '6788b5a79eff', 50, NULL, '2025-08-30 02:16:16', '2025-08-30 02:16:16'),
(101, '1cd1a406-d18', 73, NULL, '2025-09-04 02:19:10', '2025-09-04 02:19:10'),
(102, '675bf741a320', 73, NULL, '2025-09-04 02:19:46', '2025-09-04 02:19:46'),
(103, '978NutghekKl', 74, NULL, '2025-09-04 02:20:11', '2025-09-04 02:20:11'),
(104, '978NutghekKl', 75, NULL, '2025-09-04 02:23:55', '2025-09-04 02:23:55'),
(105, '978NutghekKl', 73, NULL, '2025-09-04 02:24:20', '2025-09-04 02:24:20'),
(106, '675bf741a3b0', 72, NULL, '2025-09-04 02:26:30', '2025-09-04 02:26:30'),
(108, 'a20452bb-91f', 72, 'E', '2025-09-04 04:26:08', '2025-09-08 02:59:21'),
(109, 'a20452bb-91f', 74, NULL, '2025-09-04 04:40:53', '2025-09-04 04:40:53'),
(111, '1cd1a406-d18', 76, NULL, '2025-09-06 07:01:10', '2025-09-06 07:01:10'),
(112, 'a20452bb-91f', 76, NULL, '2025-09-06 07:04:02', '2025-09-06 07:04:02'),
(113, '978NutghekKl', 72, NULL, '2025-09-09 04:10:14', '2025-09-09 04:10:14'),
(114, '683e75af91f7', 72, NULL, '2025-09-09 04:58:45', '2025-09-09 04:58:45'),
(115, '6a066e7c-2bf', 95, NULL, '2025-09-10 03:03:52', '2025-09-10 03:03:52'),
(116, '455fa3b2-2d4', 95, 'E', '2025-09-10 03:05:12', '2025-09-10 03:12:32'),
(117, '6a066e7c-2bf', 98, NULL, '2025-09-10 05:02:15', '2025-09-10 05:02:15'),
(118, '455fa3b2-2d4', 98, 'E', '2025-09-10 05:20:37', '2025-09-10 05:24:25'),
(119, '6a066e7c-2bf', 100, NULL, '2025-09-11 02:44:21', '2025-09-11 02:44:21'),
(120, 'a20452bb-91f', 100, 'E', '2025-09-11 02:45:56', '2025-09-11 02:46:39'),
(121, 'eecc4bdc-0e7', 101, NULL, '2025-09-11 03:17:52', '2025-09-11 03:17:52'),
(122, '10eee191-1c6', 101, 'E', '2025-09-11 03:18:16', '2025-09-11 03:23:09');

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

--
-- Struktur dari tabel `jurusan`
--

CREATE TABLE `jurusan` (
  `id` varchar(36) NOT NULL,
  `nama` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data untuk tabel `jurusan`
--

INSERT INTO `jurusan` (`id`, `nama`, `created_at`, `updated_at`) VALUES
('17d85773-ff1b-4d98-a247-e029cb8a3c23', 'S1 Pendidikan Agama Islam', '2025-09-10 02:54:29', '2025-09-10 02:54:29'),
('1b6e3f60-d66c-48dd-aa6f-b9d807ab1981', 'Keperawatan', '2025-09-03 03:17:24', '2025-09-08 07:11:47'),
('1c5b025c-f211-4dc2-b1a8-cc3244733a92', 'S1 Ilmu Hukum Islam', '2025-09-10 02:58:46', '2025-09-10 02:58:46'),
('4529c966-0a40-4778-844f-06065c948e87', 'S1 Teknik Informatika', '2025-09-06 06:57:31', '2025-09-06 06:57:31'),
('47124af2-b173-4656-bccc-47712b2c055f', 'S1 Testing', '2025-09-11 02:22:06', '2025-09-11 02:22:06'),
('5930bd94-a029-4778-af32-890c35c72475', 'Kebidanan', '2025-09-03 03:17:38', '2025-09-03 03:17:38'),
('84c0857b-8584-4ac1-8b5c-1c40cea7b2d1', 'D3 Manajemen Informatik', '2025-09-11 03:12:01', '2025-09-11 03:12:01'),
('8f860a88-9c64-4c98-a445-932011d30f3e', 'S1 Ekosyar', '2025-09-11 02:17:59', '2025-09-11 02:17:59'),
('a0f2e5e0-108b-43c3-beb2-5c78fc790f89', 'S1 Sistem Informasi', '2025-09-08 06:05:29', '2025-09-08 06:05:29');

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

--
-- Struktur dari tabel `mata_kuliah`
--

CREATE TABLE `mata_kuliah` (
  `id` varchar(36) NOT NULL,
  `kode_mk` varchar(255) NOT NULL,
  `judul_mk` varchar(255) NOT NULL,
  `sks` int(11) NOT NULL,
  `smt` enum('1','2','3','4','5','6','7','8','Umum') NOT NULL DEFAULT 'Umum',
  `jurusan_id` varchar(36) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data untuk tabel `mata_kuliah`
--

INSERT INTO `mata_kuliah` (`id`, `kode_mk`, `judul_mk`, `sks`, `smt`, `jurusan_id`, `created_at`, `updated_at`) VALUES
('131801a2-1eff-48b6-ae3f-a8ca76b5dcaa', 'SSI104', 'Keperawatan Medikal Bedah I', 4, '3', 'a0f2e5e0-108b-43c3-beb2-5c78fc790f89', '2025-09-08 06:05:29', '2025-09-08 06:05:29'),
('14f61686-6981-4ffd-b58d-4b0f01b60769', 'TES137', 'Ilmu Dasar Keperawatan I', 6, '4', '47124af2-b173-4656-bccc-47712b2c055f', '2025-09-11 02:31:43', '2025-09-11 02:31:43'),
('1e2ed33a-b58e-4b5c-b8b3-20b2f4c50a67', 'TES139', 'Ilmu Dasar Keperawatan I', 5, '6', '47124af2-b173-4656-bccc-47712b2c055f', '2025-09-11 02:35:08', '2025-09-11 02:35:08'),
('20f9b8f4-185d-42be-bb1b-2a27fc00b55b', 'TES140', 'Ilmu Dasar Keperawatan I', 5, '7', '47124af2-b173-4656-bccc-47712b2c055f', '2025-09-11 02:35:08', '2025-09-11 02:35:08'),
('29710964-2325-4228-8a8a-bc6fd9c37d6c', 'KEP105', 'Gizi dalam Keperawatan', 2, 'Umum', '1b6e3f60-d66c-48dd-aa6f-b9d807ab1981', '2025-09-03 04:45:51', '2025-09-03 04:45:51'),
('395390e5-b3bd-465a-9c27-5ed7f330a4ea', 'PAI102', 'Sejarah Kebudayaan Islam', 3, '1', '1c5b025c-f211-4dc2-b1a8-cc3244733a92', '2025-09-10 02:58:46', '2025-09-10 02:58:46'),
('3c03120d-e444-4be1-aa36-d2ef8f6264b9', 'SSI110', 'Gizi dalam Keperawatan', 2, 'Umum', 'a0f2e5e0-108b-43c3-beb2-5c78fc790f89', '2025-09-08 06:05:29', '2025-09-08 06:05:29'),
('3f638946-22ae-4402-9c25-cd4139338317', 'TES136', 'Ilmu Dasar Keperawatan I', 5, '3', '47124af2-b173-4656-bccc-47712b2c055f', '2025-09-11 02:31:43', '2025-09-11 02:31:43'),
('45534869-ce1c-4b00-9007-fba97855f90a', 'SSI105', 'Farmakologi', 3, '4', 'a0f2e5e0-108b-43c3-beb2-5c78fc790f89', '2025-09-08 06:05:29', '2025-09-08 06:05:29'),
('47d172ed-6946-45e4-bd98-d9bd99ac8a55', 'TES134', 'Ilmu Dasar Keperawatan I', 3, '1', '47124af2-b173-4656-bccc-47712b2c055f', '2025-09-11 02:29:06', '2025-09-11 02:29:06'),
('49eef24f-db3c-4063-afcf-b7896585ce29', 'KEP205', 'Keperawatan Gawat Darurat', 3, 'Umum', '1b6e3f60-d66c-48dd-aa6f-b9d807ab1981', '2025-09-03 04:45:51', '2025-09-03 04:45:51'),
('4a4e8ea8-54ae-40ea-b8fd-5800d88c91dd', 'KEP103', 'Komunikasi dalam Keperawatan', 3, 'Umum', '1b6e3f60-d66c-48dd-aa6f-b9d807ab1981', '2025-09-03 04:45:51', '2025-09-03 04:45:51'),
('4c1dd1d4-790b-4f7f-9833-4a01eca866a5', 'TES119', 'Ilmu Dasar Keperawatan I', 3, '1', '47124af2-b173-4656-bccc-47712b2c055f', '2025-09-11 02:31:43', '2025-09-11 02:31:43'),
('4ed3e39e-d8d0-438f-84a0-31864a4afa12', 'SSI109', 'Keperawatan Gawat Darurat', 3, '8', 'a0f2e5e0-108b-43c3-beb2-5c78fc790f89', '2025-09-08 06:05:29', '2025-09-08 06:05:29'),
('54e6481b-47cf-4101-8278-9b1108879051', 'TES124', 'Ilmu Dasar Keperawatan I', 3, '1', '47124af2-b173-4656-bccc-47712b2c055f', '2025-09-11 02:28:05', '2025-09-11 02:28:05'),
('55096d0f-8b0c-4a83-9e79-d328a72af5e5', 'TES135', 'Ilmu Dasar Keperawatan I', 4, '2', '47124af2-b173-4656-bccc-47712b2c055f', '2025-09-11 02:31:43', '2025-09-11 02:31:43'),
('57dc64d9-69eb-4429-a5cf-a51595aff0d2', 'TES142', 'Ilmu Dasar Keperawatan I', 5, '8', '47124af2-b173-4656-bccc-47712b2c055f', '2025-09-11 02:35:08', '2025-09-11 02:35:08'),
('5b2c5328-bfe5-45b2-b9a0-b10c2943db44', 'TI202512', 'CSS', 4, '1', '4529c966-0a40-4778-844f-06065c948e87', '2025-09-06 06:59:52', '2025-09-10 04:49:48'),
('6967bca0-0e91-427d-a331-589f67645cf4', 'SSI102', 'Etika dan Hukum Keperawatan', 2, '1', 'a0f2e5e0-108b-43c3-beb2-5c78fc790f89', '2025-09-08 06:05:29', '2025-09-08 06:05:29'),
('6fdc1ecb-4b51-4349-8777-093d85d6ed22', 'T1232', 'Tes Matkul', 2, 'Umum', '1b6e3f60-d66c-48dd-aa6f-b9d807ab1981', '2025-09-03 04:42:14', '2025-09-03 04:42:14'),
('707695b4-252b-4094-bef5-d256de4bee16', 'Tes', 'Tes Matkul', 1, 'Umum', '8f860a88-9c64-4c98-a445-932011d30f3e', '2025-09-11 02:22:27', '2025-09-11 02:22:27'),
('762ad85f-9eb8-4ee3-a27d-bc38474cae60', 'SSI101', 'Ilmu Dasar Keperawatan I', 3, '1', 'a0f2e5e0-108b-43c3-beb2-5c78fc790f89', '2025-09-08 06:05:29', '2025-09-08 06:05:29'),
('7db6e7e9-c72c-4500-8bc7-72303b070f36', 'SSI106', 'Keperawatan Jiwa', 4, '5', 'a0f2e5e0-108b-43c3-beb2-5c78fc790f89', '2025-09-08 06:05:29', '2025-09-08 06:05:29'),
('8355ad72-aba6-4efc-997d-8abe6e203e56', 'KEP10122', 'Ilmu Dasar Keperawatan I', 3, '1', '1b6e3f60-d66c-48dd-aa6f-b9d807ab1981', '2025-09-08 06:15:05', '2025-09-08 06:15:05'),
('94d95bea-927f-4447-8f9c-133eb60a9e73', 'TES146', 'Ilmu Dasar Keperawatan I', 5, '8', '47124af2-b173-4656-bccc-47712b2c055f', '2025-09-11 02:35:08', '2025-09-11 02:35:08'),
('99259372-edb8-484a-9b88-336dc9223a30', 'KEP102', 'Etika dan Hukum Keperawatan', 2, 'Umum', '1b6e3f60-d66c-48dd-aa6f-b9d807ab1981', '2025-09-03 04:45:51', '2025-09-03 04:45:51'),
('9a7f9618-ee10-40b6-b105-43bbed023025', 'MI3212', 'Algoritma Pemrograman', 2, '1', '84c0857b-8584-4ac1-8b5c-1c40cea7b2d1', '2025-09-11 03:12:39', '2025-09-11 03:12:39'),
('9c7e0400-33f2-4e4f-af89-8986104fa828', '2903', 'rama runcandel99', 3, 'Umum', '5930bd94-a029-4778-af32-890c35c72475', '2025-09-04 03:58:54', '2025-09-08 07:14:22'),
('a3b1465d-f5da-4643-a8c3-2bc8f8eba15b', 'TES141', 'Ilmu Dasar Keperawatan I', 5, '8', '47124af2-b173-4656-bccc-47712b2c055f', '2025-09-11 02:35:08', '2025-09-11 02:35:08'),
('a572c0c8-25bd-438b-9782-14c286fa3cc9', 'SSI107', 'Keperawatan Anak', 4, '6', 'a0f2e5e0-108b-43c3-beb2-5c78fc790f89', '2025-09-08 06:05:29', '2025-09-08 06:05:29'),
('af8bb77c-19b0-4ff2-83ea-31ac6cff19da', 'TES144', 'Ilmu Dasar Keperawatan I', 5, '8', '47124af2-b173-4656-bccc-47712b2c055f', '2025-09-11 02:35:08', '2025-09-11 02:35:08'),
('c0d1e473-c063-4697-bac2-b68b1ad6735c', 'KEP2333', 'Ilmu Dasar Keperawatan I', 3, '1', '8f860a88-9c64-4c98-a445-932011d30f3e', '2025-09-11 02:17:59', '2025-09-11 02:17:59'),
('c1dce2ac-8760-4858-b9c2-efda4366d0ee', 'PAI103', 'Ilmu Fikih', 2, '1', '1c5b025c-f211-4dc2-b1a8-cc3244733a92', '2025-09-10 02:58:46', '2025-09-10 02:58:46'),
('c60065de-7949-4c7a-a873-b1d1fd82c3c9', '1', '1111', 1, '7', '4529c966-0a40-4778-844f-06065c948e87', '2025-09-08 04:36:04', '2025-09-08 04:44:14'),
('c66f8c5d-0b30-402d-9c7b-8bca263a4664', 'KEP202', 'Keperawatan Jiwa', 4, 'Umum', '1b6e3f60-d66c-48dd-aa6f-b9d807ab1981', '2025-09-03 04:45:51', '2025-09-03 04:45:51'),
('c9a4a06f-25a6-49e4-9c5c-b00af13be785', 'KEP104', 'Keperawatan Medikal Bedah I', 4, 'Umum', '1b6e3f60-d66c-48dd-aa6f-b9d807ab1981', '2025-09-03 04:45:51', '2025-09-03 04:45:51'),
('c9eb46a7-0963-4f85-94fa-8c7b626b5f8e', 'TES145', 'Ilmu Dasar Keperawatan I', 5, '8', '47124af2-b173-4656-bccc-47712b2c055f', '2025-09-11 02:35:08', '2025-09-11 02:35:08'),
('cd11cec7-7bb5-4bca-a4f5-7dcbd7155c9b', 'TES143', 'Ilmu Dasar Keperawatan I', 5, '8', '47124af2-b173-4656-bccc-47712b2c055f', '2025-09-11 02:35:08', '2025-09-11 02:35:08'),
('cf0cfbbc-6221-4c5e-8f5e-2a0eca5b539c', 'TES123', 'Ilmu Dasar Keperawatan I', 3, '1', '47124af2-b173-4656-bccc-47712b2c055f', '2025-09-11 02:22:06', '2025-09-11 02:22:06'),
('cfe74de5-2316-420f-ace3-5316de22aef2', 'SSI103', 'Komunikasi dalam Keperawatan', 3, '2', 'a0f2e5e0-108b-43c3-beb2-5c78fc790f89', '2025-09-08 06:05:29', '2025-09-08 06:05:29'),
('de567388-9357-485a-b62b-9a4168acd13e', 'KEP201', 'Farmakologi', 3, 'Umum', '1b6e3f60-d66c-48dd-aa6f-b9d807ab1981', '2025-09-03 04:45:51', '2025-09-03 04:45:51'),
('e958c79d-7614-441a-9d18-0d49fe96d36d', 'KEP101', 'Ilmu Dasar Keperawatan I', 3, 'Umum', '1b6e3f60-d66c-48dd-aa6f-b9d807ab1981', '2025-09-03 04:45:51', '2025-09-03 04:45:51'),
('f2d206ea-7eec-487f-b6a7-6fc256c5e51a', 'SSI108', 'Keperawatan Maternitas', 4, '7', 'a0f2e5e0-108b-43c3-beb2-5c78fc790f89', '2025-09-08 06:05:29', '2025-09-08 06:05:29'),
('f7f91d5f-314e-439a-8b22-84a7751c46d7', 'KEP203', 'Keperawatan Anak', 4, 'Umum', '1b6e3f60-d66c-48dd-aa6f-b9d807ab1981', '2025-09-03 04:45:51', '2025-09-03 04:45:51'),
('fb20d782-90f0-4c89-afee-ee9afd91abe6', 'KEP204', 'Keperawatan Maternitas', 4, 'Umum', '1b6e3f60-d66c-48dd-aa6f-b9d807ab1981', '2025-09-03 04:45:51', '2025-09-09 03:22:02');

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

--
-- Struktur dari tabel `materials`
--

CREATE TABLE `materials` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `meeting_id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `file_path` varchar(255) DEFAULT NULL,
  `video_link` varchar(255) 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 `materials`
--

INSERT INTO `materials` (`id`, `meeting_id`, `title`, `description`, `file_path`, `video_link`, `created_at`, `updated_at`) VALUES
(21, 132, 'Materi 1', NULL, 'materials/NMPbECpgfoOn26iX9OC75E3NioR2Y6yYGdk7aOZn.pdf', NULL, '2025-09-11 03:21:11', '2025-09-11 03:21:11');

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

--
-- Struktur dari tabel `meetings`
--

CREATE TABLE `meetings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `course_code` varchar(255) NOT NULL,
  `meeting_number` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` longtext DEFAULT NULL,
  `type` varchar(50) NOT NULL DEFAULT 'materi',
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime 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 `meetings`
--

INSERT INTO `meetings` (`id`, `course_code`, `meeting_number`, `title`, `description`, `type`, `start_date`, `end_date`, `created_at`, `updated_at`) VALUES
(94, 'KEP105', 1, 'asdfasd', NULL, 'tugas', NULL, NULL, '2025-09-03 09:43:24', '2025-09-03 09:43:24'),
(96, 'KEP102', 1, 'xasdasdsa', NULL, 'tugas', NULL, NULL, '2025-09-04 02:56:59', '2025-09-04 02:56:59'),
(97, 'KEP205', 1, '2', NULL, 'tugas', NULL, NULL, '2025-09-04 02:58:06', '2025-09-06 09:38:59'),
(98, 'KEP204', 1, 'a', NULL, 'absensi', '2025-09-08 09:24:09', '2025-09-08 09:24:12', '2025-09-04 03:06:56', '2025-09-08 03:16:51'),
(99, 'KEP204', 1, 'Es', NULL, 'tugas', NULL, NULL, '2025-09-04 03:11:40', '2025-09-04 03:11:40'),
(101, 'KEP204', 1, 'Tes', NULL, 'url', NULL, NULL, '2025-09-04 04:00:43', '2025-09-04 04:00:43'),
(102, 'TI202512', 1, 'Absensi 1', NULL, 'absensi', '2025-09-06 14:01:40', '2025-09-06 19:01:00', '2025-09-06 07:01:40', '2025-09-06 07:01:40'),
(103, 'TI202512', 1, 'Tugas 1', NULL, 'tugas', NULL, NULL, '2025-09-06 07:02:04', '2025-09-06 07:02:04'),
(105, 'TI202512', 2, 'Absensi 2', NULL, 'absensi', '2025-09-06 16:50:05', '2025-09-06 16:50:18', '2025-09-06 07:02:46', '2025-09-06 09:50:18'),
(106, 'TI202512', 1, 'S', NULL, 'url', NULL, NULL, '2025-09-06 09:57:25', '2025-09-06 09:57:25'),
(108, 'KEP204', 7, 'UTS', NULL, 'uts', NULL, NULL, '2025-09-08 06:49:41', '2025-09-08 06:49:41'),
(109, 'KEP204', 2, '12', NULL, 'tugas', NULL, NULL, '2025-09-08 06:50:00', '2025-09-08 06:50:00'),
(110, 'KEP204', 3, 'Ab', NULL, 'absensi', '2025-09-08 16:27:00', '2025-09-08 22:26:00', '2025-09-08 09:26:19', '2025-09-10 03:58:11'),
(122, 'PAI103-G2502', 1, 'Tugas', NULL, 'tugas', NULL, NULL, '2025-09-10 05:20:13', '2025-09-10 05:20:13'),
(123, 'PAI103-G2502', 1, 'Ab', NULL, 'absensi', '2025-09-10 12:32:00', '2025-09-17 12:32:00', '2025-09-10 05:32:41', '2025-09-10 05:32:41'),
(126, 'KEP204', 2, 'Forum Diskusi Pertemuan 2', 'Forum diskusi untuk pertemuan ini.', 'forum', NULL, NULL, '2025-09-10 09:23:23', '2025-09-10 09:23:23'),
(127, 'KEP204', 3, 'Forum Diskusi Pertemuan 3', 'Forum diskusi untuk pertemuan ini.', 'forum', NULL, NULL, '2025-09-10 09:29:37', '2025-09-10 09:29:37'),
(128, 'KEP204', 4, 'Forum Diskusi Pertemuan 4', 'Forum diskusi untuk pertemuan ini.', 'forum', NULL, NULL, '2025-09-10 09:30:35', '2025-09-10 09:30:35'),
(129, 'Tes-G2502', 1, 'Absen1', NULL, 'absensi', '2025-09-11 09:44:00', '2025-09-20 09:44:00', '2025-09-11 02:44:54', '2025-09-11 02:45:03'),
(130, 'Tes-G2502', 1, 'Tugas', NULL, 'tugas', NULL, NULL, '2025-09-11 02:45:34', '2025-09-11 02:45:34'),
(131, 'MI3212-G2502', 1, 'Absensi', NULL, 'absensi', '2025-09-11 10:19:00', '2025-09-11 10:20:37', '2025-09-11 03:19:15', '2025-09-11 03:20:37'),
(132, 'MI3212-G2502', 1, 'Materi 1', NULL, 'materi', NULL, NULL, '2025-09-11 03:21:11', '2025-09-11 03:21:11'),
(133, 'MI3212-G2502', 2, 'Absensi 2', NULL, 'absensi', '2025-09-18 10:21:00', '2025-09-18 13:21:00', '2025-09-11 03:21:34', '2025-09-11 03:21:34'),
(134, 'MI3212-G2502', 2, 'Tugas 1', NULL, 'tugas', NULL, NULL, '2025-09-11 03:22:18', '2025-09-11 03:22:18'),
(135, 'MI3212-G2502', 7, 'UTS', NULL, 'uts', NULL, NULL, '2025-09-11 03:23:53', '2025-09-11 03:23:53'),
(136, 'MI3212-G2502', 2, 'Link Referensi jurnal', NULL, 'url', NULL, NULL, '2025-09-11 03:25:08', '2025-09-11 03:25:08'),
(137, 'MI3212-G2502', 1, 'Forum Diskusi Pertemuan 1', 'Forum diskusi untuk pertemuan ini.', 'forum', NULL, NULL, '2025-09-11 03:44:52', '2025-09-11 03:44:52');

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

--
-- Struktur dari tabel `meeting_urls`
--

CREATE TABLE `meeting_urls` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `meeting_id` bigint(20) UNSIGNED NOT NULL,
  `url_link` varchar(2048) NOT NULL,
  `url_title` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data untuk tabel `meeting_urls`
--

INSERT INTO `meeting_urls` (`id`, `meeting_id`, `url_link`, `url_title`, `created_at`, `updated_at`) VALUES
(1, 101, 'https://books.google.co.id/books?hl=en&lr=&id=d5jJDAAAQBAJ&oi=fnd&pg=PA1&dq=sejarah+perkembangan+software+dan+hardware&ots=CS8EYyp4zi&sig=QYKtv2p36D_ks-Iq2ozhzxKaoKU&redir_esc=y#v=onepage&q=sejarah%20perkembangan%20software%20dan%20hardware&f=false', 'Buku 123', '2025-09-04 04:00:43', '2025-09-10 03:51:32'),
(3, 101, 'https://books.google.co.id/books?hl=en&lr=&id=d5jJDAAAQBAJ&oi=fnd&pg=PA1&dq=sejarah+perkembangan+software+dan+hardware&ots=CS8EYyp4zi&sig=QYKtv2p36D_ks-Iq2ozhzxKaoKU&redir_esc=y#v=onepage&q=sejarah%20perkembangan%20software%20dan%20hardware&f=false', NULL, '2025-09-04 04:10:27', '2025-09-10 03:51:32'),
(5, 106, 'https://books.google.co.id/books?hl=en&lr=&id=d5jJDAAAQBAJ&oi=fnd&pg=PA1&dq=sejarah+perkembangan+software+dan+hardware&ots=CS8EYyp4zi&sig=QYKtv2p36D_ks-Iq2ozhzxKaoKU&redir_esc=y#v=onepage&q=sejarah%20perkembangan%20software%20dan%20hardware&f=false', 'Buku CSS', '2025-09-06 09:57:25', '2025-09-06 09:57:25'),
(7, 136, 'https://books.google.co.id/books?hl=en&lr=&id=d5jJDAAAQBAJ&oi=fnd&pg=PA1&dq=sejarah+perkembangan+software+dan+hardware&ots=CS8EYyp4zi&sig=QYKtv2p36D_ks-Iq2ozhzxKaoKU&redir_esc=y#v=onepage&q=sejarah%20perkembangan%20software%20dan%20hardware&f=false', 'Jurnal algoritma pemrograman', '2025-09-11 03:25:08', '2025-09-11 03:25:08');

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

--
-- Struktur dari tabel `panduan`
--

CREATE TABLE `panduan` (
  `id_panduan` int(10) NOT NULL,
  `kategori` text DEFAULT NULL,
  `file` varchar(55) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data untuk tabel `panduan`
--

INSERT INTO `panduan` (`id_panduan`, `kategori`, `file`, `created_at`, `updated_at`) VALUES
(13, 'pkkmb', 'panduan/E8WqVucrdy03VB5CsPgVbTheZIfE2N9YNKu7hqdr.pdf', '2025-09-11 03:15:34', '2025-09-11 03:15:34');

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

--
-- Struktur dari tabel `posts`
--

CREATE TABLE `posts` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` varchar(12) NOT NULL,
  `meeting_id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `body` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data untuk tabel `posts`
--

INSERT INTO `posts` (`id`, `user_id`, `meeting_id`, `title`, `body`, `created_at`, `updated_at`) VALUES
(1, '978NutghekKl', 128, 'Tes', 'Tes', '2025-09-10 09:31:21', '2025-09-10 09:31:21'),
(2, '978NutghekKl', 128, 'Tes 2', 'Tes 2', '2025-09-10 09:33:13', '2025-09-10 09:33:13'),
(3, 'eecc4bdc-0e7', 137, 'Diskusi terkait database', 'Kenapa relational lebih cocok untuk data mahasiswa?', '2025-09-11 03:45:44', '2025-09-11 03:45:44'),
(4, '10eee191-1c6', 137, 'Topik Baru', 'Topik Baru lagi', '2025-09-11 03:46:47', '2025-09-11 03:46:47');

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

--
-- Struktur dari tabel `semester`
--

CREATE TABLE `semester` (
  `id` varchar(36) NOT NULL,
  `nama` varchar(255) NOT NULL,
  `tahun_akademik` varchar(255) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 0,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Struktur dari tabel `submissions`
--

CREATE TABLE `submissions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `assignment_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` varchar(20) NOT NULL,
  `file_path` varchar(255) DEFAULT NULL,
  `submission_date` datetime NOT NULL,
  `grade` int(11) DEFAULT NULL,
  `feedback` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `status` varchar(20) NOT NULL DEFAULT 'on-time'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data untuk tabel `submissions`
--

INSERT INTO `submissions` (`id`, `assignment_id`, `user_id`, `file_path`, `submission_date`, `grade`, `feedback`, `created_at`, `updated_at`, `status`) VALUES
(21, 26, '683e75af91f7', 'submissions/1EO48TzdtWxaQW0KwKfniTBPua0h95jjO0iSkuan.png', '2025-09-06 08:58:34', 90, NULL, '2025-09-06 01:58:34', '2025-09-06 02:00:21', 'on-time'),
(22, 28, 'a20452bb-91f', 'submissions/66FWPEbNiNdCTEHJpXpVYyrhF9ST1izwI8PqTubW.jpg', '2025-09-06 14:04:33', 83, NULL, '2025-09-06 07:04:33', '2025-09-06 07:04:48', 'on-time'),
(24, 29, 'a20452bb-91f', NULL, '2025-09-08 13:53:47', 100, NULL, '2025-09-08 06:53:47', '2025-09-08 06:53:47', 'not submitted'),
(25, 29, '683e75af91f7', NULL, '2025-09-08 13:53:47', 89, NULL, '2025-09-08 06:53:47', '2025-09-08 06:53:47', 'not submitted'),
(26, 30, 'a20452bb-91f', NULL, '2025-09-08 14:13:57', 50, NULL, '2025-09-08 07:13:57', '2025-09-08 07:13:57', 'not submitted'),
(27, 30, '683e75af91f7', NULL, '2025-09-08 14:13:57', 59, NULL, '2025-09-08 07:13:57', '2025-09-08 07:13:57', 'not submitted'),
(28, 26, 'a20452bb-91f', 'submissions/OeH946KIBTy8TFMUcxIGzu9rCT7QqQC1UaMgSjFm.jpg', '2025-09-09 10:46:43', NULL, NULL, '2025-09-09 03:46:30', '2025-09-09 03:46:43', 'on-time'),
(33, 35, '455fa3b2-2d4', NULL, '2025-09-10 12:24:25', 90, NULL, '2025-09-10 05:24:25', '2025-09-10 05:24:25', 'not submitted'),
(34, 36, 'a20452bb-91f', 'submissions/WyWuZDOAOMhla43THsNnK3oq0Ayve3Z4UBVv69MS.pdf', '2025-09-11 09:46:09', 100, NULL, '2025-09-11 02:46:09', '2025-09-11 02:46:39', 'on-time'),
(35, 37, '10eee191-1c6', 'submissions/P7EaXOIDs2962syPUMQJ5EQtdPWnFDMcC76tJzHf.pdf', '2025-09-11 10:22:50', 86, NULL, '2025-09-11 03:22:50', '2025-09-11 03:23:09', 'on-time'),
(36, 38, '10eee191-1c6', NULL, '2025-09-11 10:24:18', 0, NULL, '2025-09-11 03:24:18', '2025-09-11 03:24:18', 'not submitted');

--
-- Indexes for dumped tables
--

--
-- Indeks untuk tabel `assignments`
--
ALTER TABLE `assignments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_assignments_meeting_id` (`meeting_id`);

--
-- Indeks untuk tabel `attendances`
--
ALTER TABLE `attendances`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `attendances_user_id_meeting_id_unique` (`user_id`,`meeting_id`),
  ADD KEY `attendances_meeting_id_foreign` (`meeting_id`),
  ADD KEY `attendances_user_id_foreign` (`user_id`);

--
-- Indeks untuk tabel `bobot`
--
ALTER TABLE `bobot`
  ADD PRIMARY KEY (`id`),
  ADD KEY `course_id` (`course_id`);

--
-- Indeks untuk tabel `comments`
--
ALTER TABLE `comments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `post_id` (`post_id`),
  ADD KEY `parent_id` (`parent_id`);

--
-- Indeks untuk tabel `courses`
--
ALTER TABLE `courses`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `courses_code_unique` (`code`);

--
-- Indeks untuk tabel `enrolments`
--
ALTER TABLE `enrolments`
  ADD PRIMARY KEY (`enrol_id`);

--
-- Indeks untuk tabel `jurusan`
--
ALTER TABLE `jurusan`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `mata_kuliah`
--
ALTER TABLE `mata_kuliah`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `kode_mk_unique` (`kode_mk`),
  ADD KEY `mata_kuliah_ibfk_1` (`jurusan_id`);

--
-- Indeks untuk tabel `materials`
--
ALTER TABLE `materials`
  ADD PRIMARY KEY (`id`),
  ADD KEY `materials_meeting_id_foreign` (`meeting_id`);

--
-- Indeks untuk tabel `meetings`
--
ALTER TABLE `meetings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_meetings_course_code` (`course_code`);

--
-- Indeks untuk tabel `meeting_urls`
--
ALTER TABLE `meeting_urls`
  ADD PRIMARY KEY (`id`),
  ADD KEY `meeting_urls_meeting_id_foreign` (`meeting_id`);

--
-- Indeks untuk tabel `panduan`
--
ALTER TABLE `panduan`
  ADD PRIMARY KEY (`id_panduan`);

--
-- Indeks untuk tabel `posts`
--
ALTER TABLE `posts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `meeting_id` (`meeting_id`);

--
-- Indeks untuk tabel `semester`
--
ALTER TABLE `semester`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `submissions`
--
ALTER TABLE `submissions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_submissions_assignment_id` (`assignment_id`),
  ADD KEY `fk_submissions_user_id` (`user_id`);

--
-- AUTO_INCREMENT untuk tabel yang dibuang
--

--
-- AUTO_INCREMENT untuk tabel `assignments`
--
ALTER TABLE `assignments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39;

--
-- AUTO_INCREMENT untuk tabel `attendances`
--
ALTER TABLE `attendances`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT untuk tabel `comments`
--
ALTER TABLE `comments`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT untuk tabel `courses`
--
ALTER TABLE `courses`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=102;

--
-- AUTO_INCREMENT untuk tabel `enrolments`
--
ALTER TABLE `enrolments`
  MODIFY `enrol_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=123;

--
-- AUTO_INCREMENT untuk tabel `materials`
--
ALTER TABLE `materials`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT untuk tabel `meetings`
--
ALTER TABLE `meetings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=138;

--
-- AUTO_INCREMENT untuk tabel `meeting_urls`
--
ALTER TABLE `meeting_urls`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT untuk tabel `panduan`
--
ALTER TABLE `panduan`
  MODIFY `id_panduan` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT untuk tabel `posts`
--
ALTER TABLE `posts`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT untuk tabel `submissions`
--
ALTER TABLE `submissions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;

--
-- Ketidakleluasaan untuk tabel pelimpahan (Dumped Tables)
--

--
-- Ketidakleluasaan untuk tabel `assignments`
--
ALTER TABLE `assignments`
  ADD CONSTRAINT `fk_assignments_meeting_id` FOREIGN KEY (`meeting_id`) REFERENCES `meetings` (`id`) ON DELETE CASCADE;

--
-- Ketidakleluasaan untuk tabel `attendances`
--
ALTER TABLE `attendances`
  ADD CONSTRAINT `attendances_meeting_id_foreign` FOREIGN KEY (`meeting_id`) REFERENCES `meetings` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `attendances_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `user` (`id_user`) ON DELETE CASCADE;

--
-- Ketidakleluasaan untuk tabel `bobot`
--
ALTER TABLE `bobot`
  ADD CONSTRAINT `bobot_ibfk_1` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE CASCADE;

--
-- Ketidakleluasaan untuk tabel `comments`
--
ALTER TABLE `comments`
  ADD CONSTRAINT `comments_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id_user`) ON DELETE CASCADE,
  ADD CONSTRAINT `comments_ibfk_2` FOREIGN KEY (`post_id`) REFERENCES `posts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `comments_ibfk_3` FOREIGN KEY (`parent_id`) REFERENCES `comments` (`id`) ON DELETE CASCADE;

--
-- Ketidakleluasaan untuk tabel `mata_kuliah`
--
ALTER TABLE `mata_kuliah`
  ADD CONSTRAINT `mata_kuliah_ibfk_1` FOREIGN KEY (`jurusan_id`) REFERENCES `jurusan` (`id`) ON DELETE CASCADE;

--
-- Ketidakleluasaan untuk tabel `materials`
--
ALTER TABLE `materials`
  ADD CONSTRAINT `materials_meeting_id_foreign` FOREIGN KEY (`meeting_id`) REFERENCES `meetings` (`id`) ON DELETE CASCADE;

--
-- Ketidakleluasaan untuk tabel `meetings`
--
ALTER TABLE `meetings`
  ADD CONSTRAINT `fk_meetings_course_code` FOREIGN KEY (`course_code`) REFERENCES `courses` (`code`) ON DELETE CASCADE;

--
-- Ketidakleluasaan untuk tabel `meeting_urls`
--
ALTER TABLE `meeting_urls`
  ADD CONSTRAINT `meeting_urls_meeting_id_foreign` FOREIGN KEY (`meeting_id`) REFERENCES `meetings` (`id`) ON DELETE CASCADE;

--
-- Ketidakleluasaan untuk tabel `posts`
--
ALTER TABLE `posts`
  ADD CONSTRAINT `posts_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id_user`) ON DELETE CASCADE,
  ADD CONSTRAINT `posts_ibfk_2` FOREIGN KEY (`meeting_id`) REFERENCES `meetings` (`id`) ON DELETE CASCADE;

--
-- Ketidakleluasaan untuk tabel `submissions`
--
ALTER TABLE `submissions`
  ADD CONSTRAINT `fk_submissions_assignment_id` FOREIGN KEY (`assignment_id`) REFERENCES `assignments` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_submissions_user_id` FOREIGN KEY (`user_id`) REFERENCES `user` (`id_user`) ON DELETE CASCADE;
COMMIT;

