Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: arsip
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute queryPress 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:
1
arsip
{"j_tabs":{"arsip.anggota":1,"arsip.buku":1,"arsip.file_lelang":1,"arsip.legalitas":1,"arsip.lelang":1,"arsip.log_legalitas":1,"arsip.pengembalian":1,"arsip.transaksi":1,"arsip.user":1},"h_tabs":{"arsip.anggota":1,"arsip.buku":1,"arsip.file_lelang":1,"arsip.legalitas":1,"arsip.lelang":1,"arsip.log_legalitas":1,"arsip.pengembalian":1,"arsip.transaksi":1,"arsip.user":1}}
[]
[]
-1
1
Untitled *
vShow/Hide tables list View in fullscreen New page Open page Save page Save page as Delete pages Create table Create relation Choose column to display Reload Help Angular links / Direct links Snap to grid vSmall/Big All Toggle small/big Toggle relation lines Export schema > Move Menu > Pin text
v arsip anggota
*id_anggota : int(50)
*nim : varchar(50)
*nama_anggota : varchar(50)
*tempat_lahir : varchar(40)
*tgl_lahir : date
*jk : enum('Laki-laki','Perempuan')
*prodi : varchar(30)
*thn_masuk : year(4)
v arsip buku
*kode_buku : varchar(50)
*nama_dokumen : varchar(5000)
*pembuat : varchar(50)
*tahun : varchar(50)
*ket : text
*lampiran : varchar(300)
*lokasi : varchar(100)
*tgl_input : date
v arsip file_lelang
*id_file_lelang : int(100)
*id_lelang : int(50)
*nama_file : varchar(200)
*tgl_upload : date
v arsip legalitas
*id_legalitas : int(30)
*nama_legalitas : varchar(500)
*nomor : varchar(500)
*tgl_legalitas : varchar(400)
*masa_berlaku : varchar(400)
*waktu_proses : varchar(40)
*file_upload : varchar(1000)
*status : varchar(50)
*persyaratan : varchar(400)
*lokasi_pengurusan : varchar(400)
*pic : varchar(500)
*cara_pengurusan : text
v arsip lelang
*id_lelang : int(80)
*projek : varchar(500)
*OPD : varchar(500)
*kabkota : varchar(400)
*tahun : year(4)
v arsip log_legalitas
*id_log : int(255)
*username : varchar(500)
*field_legalitas : varchar(500)
*id_legalitas : int(255)
*keterangan : varchar(500)
*tgl : date
v arsip pengembalian
*id_kembali : int(40)
*kode_buku : varchar(40)
*nama_dokumen : varchar(50)
*pembuat : varchar(50)
*nama_anggota : varchar(50)
*tgl_pinjam : date
*tgl_kembali : date
*lama_pinjam : varchar(50)
v arsip transaksi
*id_transaksi : int(40)
*kode_buku : varchar(30)
*nama_dokumen : varchar(40)
*pembuat : varchar(40)
*nama_anggota : varchar(50)
*tgl_pinjam : date
*tgl_kembali : date
*ket : varchar(60)
v arsip user
*id_user : int(60)
*nama_user : varchar(50)
*username : varchar(50)
*pwd : varchar(50)
*email : varchar(50)
*foto : varchar(50)
*lvl : enum('admin','user')