|
Server IP : 103.11.96.170 / Your IP : 3.148.241.210 Web Server : Microsoft-IIS/10.0 System : Windows NT WIN-F6SLGVICLOP 10.0 build 17763 (Windows Server 2016) AMD64 User : elibrary.unsap.ac.id ( 0) PHP Version : 7.4.19 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF Directory (0777) : D:/localhost/../UNSAP/LMS/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
/* Navicat Premium Data Transfer Source Server : mampp Source Server Type : MySQL Source Server Version : 50734 Source Host : localhost:3306 Source Schema : neofeeder_server Target Server Type : MySQL Target Server Version : 50734 File Encoding : 65001 Date: 06/01/2023 07:26:12 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for failed_jobs -- ---------------------------- DROP TABLE IF EXISTS `failed_jobs`; CREATE TABLE `failed_jobs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `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, PRIMARY KEY (`id`), UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- ---------------------------- -- Table structure for import_logs -- ---------------------------- DROP TABLE IF EXISTS `import_logs`; CREATE TABLE `import_logs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `act` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=590 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- ---------------------------- -- Table structure for kelas_kuliahs -- ---------------------------- DROP TABLE IF EXISTS `kelas_kuliahs`; CREATE TABLE `kelas_kuliahs` ( `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL, `id_prodi` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `id_semester` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `nama_kelas_kuliah` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `is_pddikti` int(11) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- ---------------------------- -- Table structure for kurikulums -- ---------------------------- DROP TABLE IF EXISTS `kurikulums`; CREATE TABLE `kurikulums` ( `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL, `nama_kurikulum` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `id_prodi` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `id_semester` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `jumlah_sks_lulus` int(11) NOT NULL, `jumlah_sks_wajib` int(11) NOT NULL, `jumlah_sks_pilihan` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `is_pddikti` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- ---------------------------- -- Table structure for master_agamas -- ---------------------------- DROP TABLE IF EXISTS `master_agamas`; CREATE TABLE `master_agamas` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `nama_agama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- ---------------------------- -- Table structure for matakul_kurikulums -- ---------------------------- DROP TABLE IF EXISTS `matakul_kurikulums`; CREATE TABLE `matakul_kurikulums` ( `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL, `id_kurikulum` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `id_matkul` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `semester` int(11) NOT NULL, `apakah_wajib` int(11) NOT NULL, `is_pddikti` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- ---------------------------- -- Table structure for matakuliahs -- ---------------------------- DROP TABLE IF EXISTS `matakuliahs`; CREATE TABLE `matakuliahs` ( `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL, `kode_mata_kuliah` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `nama_mata_kuliah` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `id_prodi` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `sks_mata_kuliah` int(11) NOT NULL, `sks_tatap_muka` int(11) NOT NULL, `sks_praktek` int(11) NOT NULL, `is_pddikti` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- ---------------------------- -- Table structure for migrations -- ---------------------------- DROP TABLE IF EXISTS `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=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- ---------------------------- -- Table structure for neomahasiswas -- ---------------------------- DROP TABLE IF EXISTS `neomahasiswas`; CREATE TABLE `neomahasiswas` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `nim` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `nama_mahasiswa` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `nisn` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `nik` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `tempat_lahir` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `tanggal_lahir` date NOT NULL, `jenis_kelamin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `handphone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `agama` int(11) NOT NULL, `kelurahan` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `kodewilayah` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `nama_ibu_kandung` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `kodeprodi` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `tanggal_masuk` date DEFAULT NULL, `semester_masuk` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `jenis_daftar` int(11) NOT NULL, `sks_diakui` int(11) DEFAULT NULL, `kode_pt_asal` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `kode_prodi_asal` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `biaya_awal_masuk` int(11) DEFAULT NULL, `konfirmasi` int(11) NOT NULL, `negara` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `provinsi` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `kota` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `kecamatan` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `id_registrasi_mahasiswa` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `pddikti` int(11) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `neomahasiswas_nim_unique` (`nim`) ) ENGINE=InnoDB AUTO_INCREMENT=2197 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- ---------------------------- -- Table structure for nilai_kuliahs -- ---------------------------- DROP TABLE IF EXISTS `nilai_kuliahs`; CREATE TABLE `nilai_kuliahs` ( `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL, `id_registrasi_mata_kuliah` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `id_mahasiswa` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `nilai_kehadiran` int(11) NOT NULL, `nilai_tugas` int(11) NOT NULL, `nilai_uts` int(11) NOT NULL, `nilai_uas` int(11) NOT NULL, `nilai_akhir` int(11) NOT NULL, `nilai_mutu` varchar(11) COLLATE utf8mb4_unicode_ci NOT NULL, `id_pddikti` int(11) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- ---------------------------- -- Table structure for password_resets -- ---------------------------- DROP TABLE IF EXISTS `password_resets`; CREATE TABLE `password_resets` ( `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, KEY `password_resets_email_index` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- ---------------------------- -- Table structure for pe3_fakultas -- ---------------------------- DROP TABLE IF EXISTS `pe3_fakultas`; CREATE TABLE `pe3_fakultas` ( `kode_fakultas` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, `nama_fakultas` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `urut` int(11) NOT NULL, `nim_kode` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`kode_fakultas`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- ---------------------------- -- Table structure for pe3_prodi -- ---------------------------- DROP TABLE IF EXISTS `pe3_prodi`; CREATE TABLE `pe3_prodi` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `kode_prodi` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL, `kode_fakultas` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `nama_prodi` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `nama_prodi_alias` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `kode_jenjang` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL, `nama_jenjang` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL, `config` text COLLATE utf8mb4_unicode_ci, `nim_kode` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL, `nim_jenjang` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `pe3_prodi_kode_prodi_unique` (`kode_prodi`), KEY `pe3_prodi_kode_fakultas_index` (`kode_fakultas`), KEY `pe3_prodi_kode_jenjang_index` (`kode_jenjang`), CONSTRAINT `pe3_prodi_kode_fakultas_foreign` FOREIGN KEY (`kode_fakultas`) REFERENCES `pe3_fakultas` (`kode_fakultas`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `pe3_prodi_kode_jenjang_foreign` FOREIGN KEY (`kode_jenjang`) REFERENCES `pe3_jenjang_studi` (`kode_jenjang`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- ---------------------------- -- Table structure for personal_access_tokens -- ---------------------------- DROP TABLE IF EXISTS `personal_access_tokens`; CREATE TABLE `personal_access_tokens` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `tokenable_id` bigint(20) unsigned NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, `abilities` text COLLATE utf8mb4_unicode_ci, `last_used_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `personal_access_tokens_token_unique` (`token`), KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- ---------------------------- -- Table structure for registrasi_kuliahs -- ---------------------------- DROP TABLE IF EXISTS `registrasi_kuliahs`; CREATE TABLE `registrasi_kuliahs` ( `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL, `id_mata_kuliah` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `id_dosen` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `id_kelas` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `jadwal` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `jam` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ruangan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- ---------------------------- -- Table structure for settings -- ---------------------------- DROP TABLE IF EXISTS `settings`; CREATE TABLE `settings` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `url_live` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `url_sandbox` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `mode` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- ---------------------------- -- Table structure for user_siuters -- ---------------------------- DROP TABLE IF EXISTS `user_siuters`; CREATE TABLE `user_siuters` ( `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL, `nidn` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `google_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `kodeprodi` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `role` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `user_siuters_nidn_unique` (`nidn`), UNIQUE KEY `user_siuters_email_unique` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- ---------------------------- -- Table structure for users -- ---------------------------- DROP TABLE IF EXISTS `users`; CREATE TABLE `users` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `users_email_unique` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; SET FOREIGN_KEY_CHECKS = 1;