smkssyaum.my.id:8080 / 127.0.0.1 / candyschool

Navigation panel
Navigation tree
Servers
Databases
Tables

Navigation panel

Customize appearance of the navigation panel.

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Navigation tree

Customize the navigation tree.

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers

Servers display options.

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases

Databases display options.

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables

Tables display options.

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift + Enter. To make this permanent, view settings.
Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :

Untitled *

v		candyschool agenda_kegiatan
jadwal_id : int(11) unsigned
rpp_id : int(11) unsigned
user_id : int(11) unsigned
rangkuman : text
created_at : int(11) unsigned
updated_at : int(11) unsigned

v		candyschool approvals_presence_guru
id : int(11) unsigned
user_id : int(11) unsigned
status : enum('1','2','3','4')
approval_description : text
presence_status : enum('1','2','3','4')
approver_description : text
tanggal : date
edited_by : int(11) unsigned
created_at : int(11) unsigned
updated_at : int(11) unsigned

v		candyschool approvals_presence_siswa
id : int(11) unsigned
siswa_id : int(11) unsigned
status : enum('1','2','3','4')
approval_description : text
presence_status : enum('1','2','3','4')
approver_description : text
tanggal : date
edited_by : int(11) unsigned
created_at : int(11) unsigned
updated_at : int(11) unsigned

v		candyschool attendance_solution_device
id : int(11) unsigned
nama : varchar(255)
ip : char(64)
port : char(64)
commKey : char(64)
is_connected : enum('1','0')
is_active : enum('1','0')
disconnected_at : int(11)
sync_at : int(11)
updated_at : int(11)
created_at : int(11)

v		candyschool berita_acara
id : int(11) unsigned
jadwal_id : int(11) unsigned
nomor_induk_proktor : char(32)
nama_proktor : varchar(255)
catatan : text
created_at : int(11) unsigned
updated_at : int(11) unsigned

v		candyschool daily_presence_guru
user_id : int(11) unsigned
latIn : float(10,6)
lonIn : float(10,6)
latOut : float(10,6)
lonOut : float(10,6)
methodIn : enum('qr','map','rf')
methodOut : enum('qr','map','rf')
status : enum('1','2','3','4')
suhuIn : double(5,2)
suhuOut : double(5,2)
timeIn : int(11) unsigned
timeOut : int(11) unsigned
created_at : int(11) unsigned
updated_at : int(11) unsigned

v		candyschool daily_presence_karyawan
user_id : int(11) unsigned
latIn : float(10,6)
lonIn : float(10,6)
latOut : float(10,6)
lonOut : float(10,6)
methodIn : enum('qr','map','rf')
methodOut : enum('qr','map','rf')
status : enum('1','2','3','4')
suhuIn : double(5,2)
suhuOut : double(5,2)
timeIn : int(11) unsigned
timeOut : int(11) unsigned
created_at : int(11) unsigned
updated_at : int(11) unsigned

v		candyschool daily_presence_siswa
siswa_id : int(11) unsigned
latIn : float(10,6)
lonIn : float(10,6)
latOut : float(10,6)
lonOut : float(10,6)
methodIn : enum('qr','map','rf')
methodOut : enum('qr','map','rf')
status : enum('1','2','3','4')
suhuIn : double(5,2)
suhuOut : double(5,2)
timeIn : int(11) unsigned
timeOut : int(11) unsigned
created_at : int(11) unsigned
updated_at : int(11) unsigned

v		candyschool draft_soal
draft_id : int(11) unsigned
soal_id : int(11) unsigned

v		candyschool draft_ujian
id : int(11) unsigned
nama : varchar(255)
bank_soal_id : int(11) unsigned
order_soal : varchar(255)
mapel_id : int(11) unsigned
bobot_tf : int(3)
bobot_esai : int(3)
acak_soal : enum('1','0')
acak_opsi : enum('1','0')
timeout : int(8)
minFinishTime : int(11)

v		candyschool group_conversations
id : varchar(255)
group_type : enum('private','group')
group_name : varchar(255)
created_at : int(11) unsigned
updated_at : int(11) unsigned

v		candyschool group_conversations_member
id : varchar(255)
gc_id : varchar(255)
user_id : int(11) unsigned
created_at : int(11) unsigned
updated_at : int(11) unsigned

v		candyschool jadwal_absensi_siswa
jadwal_id : int(11) unsigned
siswa_id : int(11) unsigned
keterangan : enum('0','1','2','3','4')
created_at : int(11) unsigned
updated_at : int(11) unsigned

v		candyschool jadwal_diskusi
id : varchar(255)
jadwal_id : int(11) unsigned
user_id : varchar(255)
user_type : enum('staff','mobile')
conversation : text
created_at : int(11) unsigned
updated_at : int(11) unsigned

v		candyschool jadwal_libur
id : int(11) unsigned
tanggal : date
title : varchar(255)
is_nasional : enum('1','0')
created_at : datetime
updated_at : datetime

v		candyschool jadwal_materi
id : int(11) unsigned
jadwal_id : int(11) unsigned
kompetensi_id : int(11) unsigned
judul : varchar(255)
is_active : enum('0','1')
isi : text
file : text
created_at : int(11) unsigned
updated_at : int(11) unsigned

v		candyschool jadwal_pelajaran
id : int(11) unsigned
mapel_id : int(11) unsigned
kelas_id : int(11) unsigned
tahun_id : int(11) unsigned
user_id : int(11) unsigned
startDay : enum('1','2','3','4','5','6','7')
countJam : int(11) unsigned
startTime : time
endTime : time
created_at : int(11) unsigned
updated_at : int(11) unsigned

v		candyschool jadwal_tugas
id : int(11) unsigned
jadwal_id : int(11) unsigned
kompetensi_id : int(11) unsigned
judul : varchar(255)
deskripsi : text
file : text
is_active : enum('0','1')
dueDate : int(11) unsigned
created_at : int(11) unsigned
updated_at : int(11) unsigned

v		candyschool jadwal_ujian
id : int(11) unsigned
nama : varchar(255)
tahun_id : int(11) unsigned
draft_id : int(11) unsigned
ruang_id : int(11) unsigned
jenis_id : int(11) unsigned
pengawas_id : int(11) unsigned
cache_soal : enum('0','1')
multi_login : enum('0','1')
status : enum('0','1')
strict : int(11) unsigned
afktimeout : int(11) unsigned
maxCheatCount : int(1)
startDateTime : int(11) unsigned
endDateTime : int(11) unsigned
use_token : enum('0','1')
show_point : enum('0','1')
token : varchar(128)

v		candyschool jawaban_esai_temp_ujian_siswa
ujian_id : bigint(32) unsigned
soal_id : int(11) unsigned
esai : text
nilai : float(10,2)
created_at : int(11) unsigned
updated_at : int(11) unsigned

v		candyschool jawaban_esai_ujian_siswa
ujian_id : bigint(32) unsigned
soal_id : int(11) unsigned
esai : text
nilai : float(10,2)
created_at : int(11) unsigned
updated_at : int(11) unsigned

v		candyschool jawaban_pgcouple_temp_ujian_siswa
ujian_id : bigint(32) unsigned
soal_id : int(11) unsigned
couple_id : int(11) unsigned
opsi_id : int(11) unsigned
created_at : int(11) unsigned

v		candyschool jawaban_pgcouple_ujian_siswa
ujian_id : bigint(32) unsigned
soal_id : int(11) unsigned
couple_id : int(11) unsigned
opsi_id : int(11) unsigned
created_at : int(11) unsigned

v		candyschool jawaban_pgmulti_temp_ujian_siswa
ujian_id : bigint(32) unsigned
soal_id : int(11) unsigned
opsi_id : int(11) unsigned
created_at : int(11) unsigned

v		candyschool jawaban_pgmulti_ujian_siswa
ujian_id : bigint(32) unsigned
soal_id : int(11) unsigned
opsi_id : int(11) unsigned
created_at : int(11) unsigned

v		candyschool jawaban_pgtf_temp_ujian_siswa
ujian_id : bigint(32) unsigned
soal_id : int(11) unsigned
opsi_id : int(11) unsigned
tf : enum('1','0')
created_at : int(11) unsigned

v		candyschool jawaban_pgtf_ujian_siswa
ujian_id : bigint(32) unsigned
soal_id : int(11) unsigned
opsi_id : int(11) unsigned
tf : enum('1','0')
created_at : int(11) unsigned

v		candyschool jawaban_pg_temp_ujian_siswa
ujian_id : bigint(32) unsigned
soal_id : int(11) unsigned
opsi_id : int(11) unsigned
created_at : int(11) unsigned
updated_at : int(11) unsigned

v		candyschool jawaban_pg_ujian_siswa
ujian_id : bigint(32) unsigned
soal_id : int(11) unsigned
opsi_id : int(11) unsigned
created_at : int(11) unsigned
updated_at : int(11) unsigned

v		candyschool jawaban_shortentry_temp_ujian_siswa
ujian_id : bigint(32) unsigned
soal_id : int(11) unsigned
respond : text
created_at : int(11) unsigned
updated_at : int(11) unsigned

v		candyschool jawaban_shortentry_ujian_siswa
ujian_id : bigint(32) unsigned
soal_id : int(11) unsigned
respond : text
created_at : int(11) unsigned
updated_at : int(11) unsigned

v		candyschool kelas_data
kelas_id : int(11) unsigned
tingkat_id : int(11) unsigned
jurusan_id : int(11) unsigned
tahun_pelajaran_id : int(11) unsigned

v		candyschool kompetensi_dasar
id : int(11) unsigned
nomor : int(11) unsigned
nama : varchar(255)
kode : enum('KP','KK')
mapel_id : int(11) unsigned
tingkat_id : int(11) unsigned
user_id : int(11) unsigned
created_at : datetime
updated_at : datetime

v		candyschool log_activity
user_id : int(11) unsigned
fullname : varchar(255)
user_type : enum('1','2')
detail : text
ip : char(64)
created_at : int(11) unsigned

v		candyschool migrations
id : bigint(20) unsigned
version : varchar(255)
class : varchar(255)
group : varchar(255)
namespace : varchar(255)
time : int(11)
batch : int(11) unsigned

v		candyschool m_banksoal
id : int(11) unsigned
user_id : int(11) unsigned
kode : char(128)
deskripsi : text
created_at : int(11) unsigned
updated_at : int(11) unsigned

v		candyschool m_jenisujian
id : int(11) unsigned
kode : char(30)
nama : varchar(255)

v		candyschool m_jurusan
id : int(11) unsigned
kode : char(30)
nama : varchar(255)

v		candyschool m_kelas
id : int(11) unsigned
nama : varchar(255)
kode : varchar(255)
is_alumni : enum('0','1')

v		candyschool m_mapel
id : int(11) unsigned
kode : char(30)
nama : varchar(255)

v		candyschool m_ruangujian
id : int(11) unsigned
kode : char(32)
nama : varchar(255)

v		candyschool m_siswa
id : int(11) unsigned
nomor_induk : char(128)
rfid : char(64)
nama : varchar(255)
email : varchar(255)
phone : char(20)
agama : enum('islam','katolik','protestan','hindu','buddha','konghucu')
jenis_kelamin : enum('L','P')
tempat_lahir : varchar(255)
tanggal_lahir : date
alamat : text
password_hash : blob
attendance_solution_id : char(128)
kelas_id : int(11) unsigned
ruang_id : int(11) unsigned
photo : varchar(255)
status : enum('1','0')
created_at : int(11) unsigned
updated_at : int(11) unsigned
active_at : int(11) unsigned

v		candyschool m_tingkat
id : int(11) unsigned
kode : varchar(255)

v		candyschool options
option_id : int(11) unsigned
option_name : varchar(255)
option_value : text
autoload : enum('no','yes')

v		candyschool panel_conversations
id : varchar(255)
gc_id : varchar(255)
user_id : int(11) unsigned
message : text
created_at : int(11) unsigned
updated_at : int(11) unsigned

v		candyschool pengumuman
id : int(11) unsigned
judul : varchar(255)
tujuan : enum('1','2')
body : text
created_at : datetime

v		candyschool roles
id : int(11) unsigned
name : varchar(128)
description : varchar(255)

v		candyschool rpp
id : int(11) unsigned
file : text
user_id : int(11) unsigned
kompetensi_id : int(11) unsigned
tahun_id : int(11) unsigned
created_at : datetime
updated_at : datetime

v		candyschool siswa_viewed_materi
materi_id : int(11) unsigned
siswa_id : int(11) unsigned
created_at : int(11) unsigned
updated_at : int(11) unsigned

v		candyschool soal_data
id : int(11) unsigned
bank_id : int(11) unsigned
jenis_soal : enum('1','2','3','4','5','6')
true_default_point : float(10,2)
false_default_point : float(10,2)
question : text
shortentry : text
created_at : int(11) unsigned
updated_at : int(11) unsigned

v		candyschool soal_data_couple
id : int(11) unsigned
soal_id : int(11) unsigned
body : text

v		candyschool soal_opsi
id : int(11) unsigned
soal_couple_id : int(11) unsigned
soal_id : int(11) unsigned
body : text
is_key : enum('1','0')

v		candyschool tahun_pelajaran
id : int(11) unsigned
kode : varchar(128)
nama : varchar(255)
semester : enum('Ganjil','Genap')
is_active : enum('1','0')
created_at : datetime
updated_at : datetime

v		candyschool tugas_siswa
tugas_id : int(11) unsigned
siswa_id : int(11) unsigned
comment : tinytext
answer : tinytext
point : int(11) unsigned
created_at : int(11) unsigned
updated_at : int(11) unsigned

v		candyschool tugas_siswa_file
file_id : int(11) unsigned
tugas_id : int(11) unsigned
siswa_id : int(11) unsigned
file : text
created_at : int(11) unsigned

v		candyschool ujian_siswa
id : bigint(32) unsigned
jadwal_id : int(11) unsigned
siswa_id : int(11) unsigned
status : enum('1','0','2')
pg_benar : int(3) unsigned
pgtf_benar : int(3) unsigned
pgmulti_benar : int(3) unsigned
pgcouple_benar : int(3) unsigned
shortentry_benar : int(3) unsigned
total_pg : int(11)
total_shortentry : int(11)
nilai_pg : float(10,2)
nilai_esai : float(15,2)
ip_address : char(24)
jwt : text
hasCheating : enum('0','1')
soal_generated : int(11) unsigned
start_at : int(11) unsigned
end_at : int(11) unsigned

v		candyschool users
id : int(11) unsigned
nomor_induk : char(30)
rfid : char(64)
username : char(128)
fullname : varchar(255)
attendance_solution_id : char(128)
kelas_id : int(11) unsigned
cover : varchar(255)
photo : varchar(255)
about_me : text
password_hash : varchar(255)
status : enum('1','0')
phone : char(20)
created_at : int(11) unsigned
updated_at : int(11) unsigned
active_at : int(11) unsigned
deleted_at : int(11) unsigned

v		candyschool users_roles
role_id : int(11) unsigned
user_id : int(11) unsigned

v		candyschool whatsapp_device
id : int(11) unsigned
device_id : char(64)
nama : varchar(255)
nomor : char(15)
is_default : enum('1','0')
is_connected : enum('1','0')
status : enum('1','0')
updated_at : int(11) unsigned
created_at : int(11) unsigned

v		candyschool whatsapp_message
id : int(11) unsigned
user_id : int(11) unsigned
device_id : int(11) unsigned
nomor : char(15)
message : text
updated_at : int(11) unsigned
created_at : int(11) unsigned

Create relationship
FOREIGN KEY
on delete
on update