Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: laporan
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
laporan
{"j_tabs":{"laporan.bulan":1,"laporan.detail_laporan":1,"laporan.jenis_laporan":1,"laporan.nilai":1,"laporan.unit":1,"laporan.user":1},"h_tabs":{"laporan.bulan":1,"laporan.detail_laporan":1,"laporan.jenis_laporan":1,"laporan.nilai":1,"laporan.unit":1,"laporan.user":1}}
[{"":{"laporan.detail_laporan":{"id_jenis_laporan":["laporan.jenis_laporan","id_jenis_laporan"]}}},{"":{"laporan.jenis_laporan":{"id_unit":["laporan.unit","id_unit"]}}},{"":{"laporan.nilai":{"bulan":["laporan.bulan","id_bulan"]}}},{"":{"laporan.nilai":{"id_detail_laporan":["laporan.detail_laporan","id_detail_laporan"]}}},{"":{"laporan.user":{"id_unit":["laporan.unit","id_unit"]}}}]
[]
-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 laporan bulan
*id_bulan : int(11)
*nama_bulan : varchar(100)
v laporan detail_laporan
*id_detail_laporan : int(11)
*keterangan : varchar(255)
*id_jenis_laporan : int(11)
v laporan jenis_laporan
*id_jenis_laporan : int(11)
*jenis_laporan : varchar(255)
*kategori : varchar(100)
*id_unit : int(11)
v laporan nilai
*id_nilai : int(11)
*id_detail_laporan : int(11)
*bulan : int(11)
*tahun : int(11)
*nilai : double
*waktu_isi : datetime
v laporan unit
*id_unit : int(11)
*nama_unit : varchar(255)
*kode_unit : varchar(100)
v laporan user
*id_user : int(11)
*nama_user : varchar(255)
*password : varchar(255)
*username : varchar(100)
*id_unit : int(11)