Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: db_gudang
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
db_gudang
{"j_tabs":{"db_gudang.barang":1,"db_gudang.barangkeluar":1,"db_gudang.customer":1,"db_gudang.data_toko":1,"db_gudang.detail_keluar":1,"db_gudang.detail_terima":1,"db_gudang.inventaris":1,"db_gudang.penerimaan":1,"db_gudang.pengeluaran":1,"db_gudang.pengguna":1,"db_gudang.petugas":1,"db_gudang.supplier":1},"h_tabs":{"db_gudang.barang":1,"db_gudang.barangkeluar":1,"db_gudang.customer":1,"db_gudang.data_toko":1,"db_gudang.detail_keluar":1,"db_gudang.detail_terima":1,"db_gudang.inventaris":1,"db_gudang.penerimaan":1,"db_gudang.pengeluaran":1,"db_gudang.pengguna":1,"db_gudang.petugas":1,"db_gudang.supplier":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 db_gudang barang
*id : int(11)
*kode_barang : varchar(20)
*nama_barang : varchar(80)
*no_pinjaman : int(100)
*no_jaminan : int(100)
*kantor_cabang : varchar(100)
*stok : int(11)
*satuan : varchar(20)
*keterangan : char(50)
*tgl_masuk : datetime
*tgl_keluar : timestamp
*gambar : text
*jumlah_keluar : int(11)
*status : int(1)
v db_gudang barangkeluar
*id : int(11)
*tgl_keluar : date
*jam_keluar : varchar(10)
*jumlah_keluar : int(11)
v db_gudang customer
*id : int(11)
*kode : varchar(20)
*nama : varchar(80)
*email : varchar(100)
*telepon : varchar(15)
*alamat : varchar(255)
v db_gudang data_toko
*id : int(11)
*nama_toko : varchar(80)
*nama_pemilik : varchar(80)
*no_telepon : varchar(15)
*alamat : varchar(255)
v db_gudang detail_keluar
*no_keluar : varchar(25)
*nama_barang : varchar(80)
*jumlah : int(11)
*satuan : varchar(20)
*gambar : text
*keterangan : char(50)
v db_gudang detail_terima
*no_terima : varchar(25)
*nama_barang : varchar(80)
*jumlah : int(11)
*satuan : varchar(20)
*keterangan : char(50)
v db_gudang inventaris
*id : int(11)
*kode_barang : varchar(20)
*nama_barang : varchar(80)
*stok : int(11)
*satuan : varchar(20)
*keterangan : char(50)
*tgl_masuk : datetime
*gambar : text
v db_gudang penerimaan
*id : int(11)
*no_terima : varchar(25)
*tgl_terima : varchar(25)
*jam_terima : varchar(10)
*nama_customer : varchar(80)
*nama_petugas : varchar(80)
v db_gudang pengeluaran
*id : int(11)
*no_keluar : varchar(25)
*tgl_keluar : varchar(25)
*jam_keluar : varchar(10)
*nama_customer : varchar(80)
*nama_petugas : varchar(80)
*gambar : text
v db_gudang pengguna
*id : int(11)
*kode : varchar(20)
*nama : varchar(100)
*username : varchar(20)
*password : varchar(255)
v db_gudang petugas
*id : int(11)
*kode : varchar(20)
*nama : varchar(100)
*username : varchar(20)
*password : varchar(255)
v db_gudang supplier
*id : int(11)
*kode : varchar(20)
*nama : varchar(80)
*email : varchar(100)
*telepon : varchar(15)
*alamat : varchar(255)