|
Server IP : 103.11.96.170 / Your IP : 3.149.237.146 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/../backup/../ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
/* Navicat Premium Data Transfer Source Server : maria db Source Server Type : MySQL Source Server Version : 101002 Source Host : localhost:3306 Source Schema : pmb_unsap Target Server Type : MySQL Target Server Version : 101002 File Encoding : 65001 Date: 19/02/2023 23:42:29 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for neomahasiswas -- ---------------------------- DROP TABLE IF EXISTS `neomahasiswas`; CREATE TABLE `neomahasiswas` ( `id` char(36) NOT NULL, `id_operator` varchar(255) DEFAULT NULL, `nim` varchar(255) DEFAULT NULL, `id_reg_mahasiswa` varchar(255) DEFAULT NULL, `nomor_pendaftaran` varchar(255) DEFAULT NULL, `pin` varchar(255) DEFAULT NULL, `is_aktif` int(11) DEFAULT NULL, `nama_mahasiswa` varchar(255) NOT NULL, `nisn` varchar(255) DEFAULT NULL, `nik` varchar(255) NOT NULL, `tempat_lahir` varchar(255) DEFAULT NULL, `tanggal_lahir` date DEFAULT NULL, `jenis_kelamin` varchar(255) NOT NULL, `handphone` varchar(255) NOT NULL, `agama` int(11) DEFAULT NULL, `kelurahan` varchar(255) DEFAULT NULL, `kodewilayah` varchar(255) DEFAULT NULL, `alamat_rumah` tinytext DEFAULT NULL, `nama_ibu_kandung` varchar(255) DEFAULT NULL, `kodeprodi_satu` varchar(255) DEFAULT NULL, `kodeprodi_dua` varchar(255) DEFAULT NULL, `tanggal_masuk` date DEFAULT NULL, `semester_masuk` varchar(255) DEFAULT NULL, `jenis_daftar` int(11) DEFAULT NULL, `sks_diakui` int(11) DEFAULT NULL, `asal_sekolah` varchar(255) DEFAULT NULL, `nomor_ijasah` varchar(255) DEFAULT NULL, `tahun_lulus` varchar(255) DEFAULT NULL, `jenis_pmb_daftar` int(11) DEFAULT NULL, `kode_pt_asal` varchar(255) DEFAULT NULL, `kode_prodi_asal` varchar(255) DEFAULT NULL, `biaya_awal_masuk` int(11) DEFAULT NULL, `konfirmasi` int(11) DEFAULT NULL, `negara` varchar(255) DEFAULT NULL, `provinsi` varchar(255) DEFAULT NULL, `kota` varchar(255) DEFAULT NULL, `kecamatan` varchar(255) DEFAULT NULL, `tahun_masuk` int(11) DEFAULT NULL, `kewarganegaraan` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `catatan` tinytext DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `neomahasiswas_handphone_unique` (`handphone`), UNIQUE KEY `neomahasiswas_nim_unique` (`nim`), UNIQUE KEY `neomahasiswas_id_reg_mahasiswa_unique` (`id_reg_mahasiswa`), UNIQUE KEY `neomahasiswas_nomor_pendaftaran_unique` (`nomor_pendaftaran`), UNIQUE KEY `neomahasiswas_pin_unique` (`pin`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; SET FOREIGN_KEY_CHECKS = 1;