Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Untitled *
v Show/Hide tables list View in fullscreen Add tables from other databases New page Open page Save page Save page as Delete pages Create table Create relationship Choose column to display Reload Help Angular links / Direct links Snap to grid v Small/Big All Toggle small/big Toggle relationship lines Export schema > Move Menu > Pin text
Number of tables: 0
v e-learning_mts anggota_kelas
* id : bigint(20) unsigned
* kelas_id : bigint(20) unsigned
* siswa_id : bigint(20) unsigned
* nomor_absen : tinyint(3) unsigned
* status_anggota : varchar(255)
* created_at : timestamp
* updated_at : timestamp
v e-learning_mts asesmen
* id : bigint(20) unsigned
* pertemuan_id : bigint(20) unsigned
* jenis_asesmen : varchar(255)
* mode_asesmen : varchar(255)
* judul : varchar(255)
* instruksi : text
* mode_pengumpulan : varchar(255)
* nilai_maksimal : int(10) unsigned
* boleh_revisi : tinyint(1)
* tanggal_mulai : datetime
* tanggal_selesai : datetime
* durasi_menit : smallint(5) unsigned
* batas_percobaan : int(10) unsigned
* acak_soal : tinyint(1)
* tampilkan_hasil_langsung : tinyint(1)
* dibuat_oleh : bigint(20) unsigned
* created_at : timestamp
* updated_at : timestamp
v e-learning_mts asesmen_lampiran
* id : bigint(20) unsigned
* asesmen_id : bigint(20) unsigned
* file_upload_id : bigint(20) unsigned
* created_at : timestamp
* updated_at : timestamp
v e-learning_mts asesmen_soal
* id : bigint(20) unsigned
* asesmen_id : bigint(20) unsigned
* soal_id : bigint(20) unsigned
* bobot_nilai : decimal(8,2)
* urutan : int(10) unsigned
* created_at : timestamp
* updated_at : timestamp
v e-learning_mts backup_operasional
* id : bigint(20) unsigned
* kode_backup : varchar(120)
* nama_backup : varchar(180)
* jenis_backup : varchar(40)
* status_backup : varchar(40)
* disk_zip : varchar(40)
* path_zip : varchar(255)
* nama_file_zip : varchar(255)
* ukuran_byte : bigint(20) unsigned
* checksum_sha256 : varchar(64)
* versi_manifest : varchar(40)
* ringkasan : longtext
* metadata_backup : longtext
* dibuat_oleh : bigint(20) unsigned
* dipulihkan_oleh : bigint(20) unsigned
* dipulihkan_pada : datetime
* created_at : timestamp
* updated_at : timestamp
v e-learning_mts bank_soal
* id : bigint(20) unsigned
* kursus_id : bigint(20) unsigned
* asesmen_id : bigint(20) unsigned
* mata_pelajaran_id : bigint(20) unsigned
* judul : varchar(255)
* sumber_input : varchar(255)
* dibuat_oleh : bigint(20) unsigned
* created_at : timestamp
* updated_at : timestamp
v e-learning_mts cache
* key : varchar(255)
* value : mediumtext
* expiration : bigint(20)
v e-learning_mts cache_locks
* key : varchar(255)
* owner : varchar(255)
* expiration : bigint(20)
v e-learning_mts diskusi_pertemuan
* id : bigint(20) unsigned
* pertemuan_id : bigint(20) unsigned
* judul : varchar(255)
* petunjuk : text
* minimal_reply : int(10) unsigned
* minimal_karakter : int(10) unsigned
* is_wajib : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v e-learning_mts diskusi_pesan
* id : bigint(20) unsigned
* diskusi_pertemuan_id : bigint(20) unsigned
* pengguna_id : bigint(20) unsigned
* parent_id : bigint(20) unsigned
* isi_pesan : text
* is_valid : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v e-learning_mts diskusi_pesan_file
* id : bigint(20) unsigned
* diskusi_pesan_id : bigint(20) unsigned
* file_upload_id : bigint(20) unsigned
* created_at : timestamp
* updated_at : timestamp
v e-learning_mts failed_jobs
* id : bigint(20) unsigned
* uuid : varchar(255)
* connection : text
* queue : text
* payload : longtext
* exception : longtext
* failed_at : timestamp
v e-learning_mts file_upload
* id : bigint(20) unsigned
* nama_asli : varchar(255)
* nama_file : varchar(255)
* disk : varchar(255)
* path_file : varchar(255)
* mime_type : varchar(255)
* ukuran_byte : bigint(20) unsigned
* diunggah_oleh : bigint(20) unsigned
* created_at : timestamp
* updated_at : timestamp
v e-learning_mts guru
* id : bigint(20) unsigned
* user_id : bigint(20) unsigned
* nip : varchar(255)
* nuptk : varchar(255)
* jenis_kelamin : varchar(255)
* tempat_lahir : varchar(255)
* tanggal_lahir : date
* alamat : text
* no_hp : varchar(255)
* status_guru : varchar(255)
* created_at : timestamp
* updated_at : timestamp
v e-learning_mts jawaban_asesmen
* id : bigint(20) unsigned
* percobaan_asesmen_id : bigint(20) unsigned
* soal_id : bigint(20) unsigned
* opsi_soal_id : bigint(20) unsigned
* urutan_tampilan : int(10) unsigned
* is_benar : tinyint(1)
* nilai_diperoleh : decimal(8,2)
* created_at : timestamp
* updated_at : timestamp
v e-learning_mts jobs
* id : bigint(20) unsigned
* queue : varchar(255)
* payload : longtext
* attempts : tinyint(3) unsigned
* reserved_at : int(10) unsigned
* available_at : int(10) unsigned
* created_at : int(10) unsigned
v e-learning_mts job_batches
* id : varchar(255)
* name : varchar(255)
* total_jobs : int(11)
* pending_jobs : int(11)
* failed_jobs : int(11)
* failed_job_ids : longtext
* options : mediumtext
* cancelled_at : int(11)
* created_at : int(11)
* finished_at : int(11)
v e-learning_mts kelas
* id : bigint(20) unsigned
* tahun_ajaran_id : bigint(20) unsigned
* tingkat_kelas_id : bigint(20) unsigned
* wali_kelas_id : bigint(20) unsigned
* nama : varchar(255)
* kapasitas : int(10) unsigned
* is_aktif : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v e-learning_mts kursus
* id : bigint(20) unsigned
* pengampu_kelas_mapel_id : bigint(20) unsigned
* nama_kursus : varchar(255)
* deskripsi : text
* kkm : tinyint(3) unsigned
* is_publikasi : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v e-learning_mts log_audit_admin
* id : bigint(20) unsigned
* admin_user_id : bigint(20) unsigned
* modul_key : varchar(80)
* aksi : varchar(80)
* entitas_tipe : varchar(120)
* entitas_id : bigint(20) unsigned
* entitas_label : varchar(255)
* ringkasan : varchar(255)
* metadata : longtext
* ip_address : varchar(45)
* user_agent : text
* created_at : timestamp
v e-learning_mts mata_pelajaran
* id : bigint(20) unsigned
* kode : varchar(255)
* nama : varchar(255)
* deskripsi : text
* kkm_default : tinyint(3) unsigned
* is_aktif : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v e-learning_mts materi_pertemuan
* id : bigint(20) unsigned
* pertemuan_id : bigint(20) unsigned
* judul : varchar(255)
* jenis_materi : varchar(255)
* isi_materi : longtext
* url_materi : varchar(255)
* file_upload_id : bigint(20) unsigned
* urutan : int(10) unsigned
* is_wajib : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v e-learning_mts migrations
* id : int(10) unsigned
* migration : varchar(255)
* batch : int(11)
v e-learning_mts opsi_soal
* id : bigint(20) unsigned
* soal_id : bigint(20) unsigned
* kode_opsi : varchar(5)
* teks_opsi : text
* is_benar : tinyint(1)
* urutan : tinyint(3) unsigned
* created_at : timestamp
* updated_at : timestamp
v e-learning_mts password_reset_tokens
* email : varchar(255)
* token : varchar(255)
* created_at : timestamp
v e-learning_mts pengampu_kelas_mapel
* id : bigint(20) unsigned
* guru_id : bigint(20) unsigned
* mata_pelajaran_id : bigint(20) unsigned
* kelas_id : bigint(20) unsigned
* semester_id : bigint(20) unsigned
* status_pengampu : varchar(255)
* created_at : timestamp
* updated_at : timestamp
v e-learning_mts pengguna_role
* id : bigint(20) unsigned
* user_id : bigint(20) unsigned
* role_id : bigint(20) unsigned
* created_at : timestamp
* updated_at : timestamp
v e-learning_mts pengumpulan_asesmen
* id : bigint(20) unsigned
* asesmen_id : bigint(20) unsigned
* siswa_id : bigint(20) unsigned
* status_pengumpulan : varchar(255)
* nilai : decimal(5,2)
* catatan_guru : text
* dinilai_oleh : bigint(20) unsigned
* tanggal_dinilai : datetime
* created_at : timestamp
* updated_at : timestamp
v e-learning_mts pengumpulan_tugas
* id : bigint(20) unsigned
* tugas_id : bigint(20) unsigned
* siswa_id : bigint(20) unsigned
* status_pengumpulan : varchar(255)
* nilai : decimal(5,2)
* catatan_guru : text
* dinilai_oleh : bigint(20) unsigned
* tanggal_dinilai : datetime
* created_at : timestamp
* updated_at : timestamp
v e-learning_mts percobaan_asesmen
* id : bigint(20) unsigned
* asesmen_id : bigint(20) unsigned
* siswa_id : bigint(20) unsigned
* percobaan_ke : int(10) unsigned
* tanggal_mulai : datetime
* tanggal_submit : datetime
* batas_waktu_pada : datetime
* status_percobaan : varchar(255)
* total_nilai : decimal(8,2)
* created_at : timestamp
* updated_at : timestamp
v e-learning_mts permintaan_perubahan_email
* id : bigint(20) unsigned
* user_id : bigint(20) unsigned
* email_baru : varchar(255)
* expires_at : timestamp
* verified_at : timestamp
* created_at : timestamp
* updated_at : timestamp
v e-learning_mts pertemuan
* id : bigint(20) unsigned
* kursus_id : bigint(20) unsigned
* jenis_pertemuan : varchar(255)
* pertemuan_ke : smallint(5) unsigned
* judul : varchar(255)
* deskripsi : text
* tujuan_pembelajaran : text
* tanggal_pertemuan : date
* tanggal_buka : datetime
* tanggal_tutup : datetime
* status : varchar(255)
* is_publikasi : tinyint(1)
* dibuat_oleh : bigint(20) unsigned
* created_at : timestamp
* updated_at : timestamp
v e-learning_mts peserta_kursus
* id : bigint(20) unsigned
* kursus_id : bigint(20) unsigned
* siswa_id : bigint(20) unsigned
* tanggal_gabung : date
* status_peserta : varchar(255)
* created_at : timestamp
* updated_at : timestamp
v e-learning_mts progres_materi_siswa
* id : bigint(20) unsigned
* materi_pertemuan_id : bigint(20) unsigned
* siswa_id : bigint(20) unsigned
* sudah_dibuka : tinyint(1)
* sudah_download : tinyint(1)
* ditandai_selesai : tinyint(1)
* tanggal_dibuka : datetime
* tanggal_download : datetime
* tanggal_selesai : datetime
* created_at : timestamp
* updated_at : timestamp
v e-learning_mts progres_pertemuan_siswa
* id : bigint(20) unsigned
* pertemuan_id : bigint(20) unsigned
* siswa_id : bigint(20) unsigned
* pretest_selesai : tinyint(1)
* materi_selesai : tinyint(1)
* jumlah_reply_valid : int(10) unsigned
* reply_minimal_karakter_terpenuhi : tinyint(1)
* diskusi_selesai : tinyint(1)
* tugas_selesai : tinyint(1)
* posttest_selesai : tinyint(1)
* status_kehadiran : varchar(255)
* status_pertemuan : varchar(255)
* tanggal_hadir : datetime
* tanggal_selesai : datetime
* created_at : timestamp
* updated_at : timestamp
v e-learning_mts revisi_pengumpulan_asesmen
* id : bigint(20) unsigned
* pengumpulan_asesmen_id : bigint(20) unsigned
* versi : int(10) unsigned
* jawaban_teks : longtext
* tanggal_submit : datetime
* created_at : timestamp
* updated_at : timestamp
v e-learning_mts revisi_pengumpulan_asesmen_file
* id : bigint(20) unsigned
* revisi_pengumpulan_asesmen_id : bigint(20) unsigned
* file_upload_id : bigint(20) unsigned
* created_at : timestamp
* updated_at : timestamp
v e-learning_mts revisi_pengumpulan_tugas
* id : bigint(20) unsigned
* pengumpulan_tugas_id : bigint(20) unsigned
* versi : int(10) unsigned
* jawaban_teks : longtext
* tanggal_submit : datetime
* created_at : timestamp
* updated_at : timestamp
v e-learning_mts revisi_pengumpulan_tugas_file
* id : bigint(20) unsigned
* revisi_pengumpulan_tugas_id : bigint(20) unsigned
* file_upload_id : bigint(20) unsigned
* created_at : timestamp
* updated_at : timestamp
v e-learning_mts role
* id : bigint(20) unsigned
* kode : varchar(255)
* nama : varchar(255)
* created_at : timestamp
* updated_at : timestamp
v e-learning_mts semester
* id : bigint(20) unsigned
* tahun_ajaran_id : bigint(20) unsigned
* nama : varchar(255)
* urutan : tinyint(3) unsigned
* tanggal_mulai : date
* tanggal_selesai : date
* is_aktif : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v e-learning_mts sessions
* id : varchar(255)
* user_id : bigint(20) unsigned
* ip_address : varchar(45)
* user_agent : text
* payload : longtext
* last_activity : int(11)
v e-learning_mts siswa
* id : bigint(20) unsigned
* user_id : bigint(20) unsigned
* nis : varchar(255)
* nisn : varchar(255)
* jenis_kelamin : varchar(255)
* tempat_lahir : varchar(255)
* tanggal_lahir : date
* alamat : text
* nama_wali : varchar(255)
* no_hp_wali : varchar(255)
* tahun_masuk : smallint(5) unsigned
* status_siswa : varchar(255)
* created_at : timestamp
* updated_at : timestamp
v e-learning_mts soal
* id : bigint(20) unsigned
* bank_soal_id : bigint(20) unsigned
* jenis_soal : varchar(255)
* pertanyaan : longtext
* is_aktif : tinyint(1)
* dibuat_oleh : bigint(20) unsigned
* created_at : timestamp
* updated_at : timestamp
v e-learning_mts tahun_ajaran
* id : bigint(20) unsigned
* nama : varchar(255)
* tanggal_mulai : date
* tanggal_selesai : date
* is_aktif : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v e-learning_mts tingkat_kelas
* id : bigint(20) unsigned
* nama : varchar(255)
* urutan : tinyint(3) unsigned
* created_at : timestamp
* updated_at : timestamp
v e-learning_mts tugas
* id : bigint(20) unsigned
* pertemuan_id : bigint(20) unsigned
* judul : varchar(255)
* instruksi : text
* mode_pengumpulan : varchar(255)
* batas_pengumpulan : datetime
* boleh_revisi : tinyint(1)
* nilai_maksimal : int(10) unsigned
* dibuat_oleh : bigint(20) unsigned
* created_at : timestamp
* updated_at : timestamp
v e-learning_mts users
* id : bigint(20) unsigned
* username : varchar(255)
* email : varchar(255)
* email_verified_at : timestamp
* password : varchar(255)
* nama_lengkap : varchar(255)
* foto : varchar(255)
* is_aktif : tinyint(1)
* terakhir_login_pada : timestamp
* remember_token : varchar(100)
* created_at : timestamp
* updated_at : timestamp
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship