Gecko [ elibrary.unsap.ac.id ]

Name	Size	Permission	Date
download_u8620162_1672302870_94575.tar	[ DIR ]	drwxrwxrwx	2022-12-30 22:24
download_u8620162_1672384957_13422.tar	[ DIR ]	drwxrwxrwx	2022-12-30 22:25
homedir	[ DIR ]	drwxrwxrwx	2022-12-30 22:24
u8620162_lms.sql	[ DIR ]	drwxrwxrwx	2022-12-29 23:15
Oracle_VM_VirtualBox_Extension_Pack-6.1.12-139181.vbox-extpack	10.63 MB	-rw-rw-rw-	2020-07-12 02:00
Oracle_VM_VirtualBox_Extension_Pack-6.1.12.vbox-extpack	10.63 MB	-rw-rw-rw-	2020-07-12 02:00
Oracle_VM_VirtualBox_Extension_Pack-6.1.32-149290.vbox-extpack	10.62 MB	-rw-rw-rw-	2022-01-14 04:31
[PATCH]NEO FEEDER v2.0.0(64 bit).exe	26.98 MB	-rwxrwxrwx	2023-01-02 11:40
download_u8620162_1672302870_94575.tar.gz	9.64 GB	-rw-rw-rw-	2022-12-30 00:21
download_u8620162_1672384957_13422.tar.gz	100.45 MB	-rw-rw-rw-	2022-12-30 22:17
neofeeder_server.sql	14.17 KB	-rw-rw-rw-	2023-01-06 07:19
u8620162_lms.sql.gz	78.88 MB	-rw-rw-rw-	2022-12-29 23:12

Rename

/*
 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;