kebumeneyecenter.id / localhost / sik / _temp_set_akun

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

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-

Server: localhost »

Database: sik »

Table: _temp_set_akun

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken

No bookmarks

Label: Target database: Share this bookmark

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 :

Foreign key constraints

Actions	Constraint properties	Column Creating a foreign key over a non-indexed column would automatically create an index on it. Alternatively, you can define an index below, before creating the foreign key.	Foreign key constraint (INNODB)
			Database	Table	Column
	ON DELETE ON UPDATE	+ Add column
+ Add constraint

Internal relationships

Column	Internal relation An internal relation is not necessary when a corresponding FOREIGN KEY relation exists.
Pengadaan_Obat
Pemesanan_Obat
Kontra_Pemesanan_Obat
Bayar_Pemesanan_Obat
Penjualan_Obat
Piutang_Obat
Kontra_Piutang_Obat
Retur_Ke_Suplayer
Kontra_Retur_Ke_Suplayer
Retur_Dari_pembeli
Kontra_Retur_Dari_Pembeli
Retur_Piutang_Obat
Kontra_Retur_Piutang_Obat
Pengadaan_Ipsrs
Stok_Keluar_Ipsrs
Kontra_Stok_Keluar_Ipsrs
Bayar_Piutang_Pasien
Pengambilan_Utd
Kontra_Pengambilan_Utd
Pengambilan_Penunjang_Utd
Kontra_Pengambilan_Penunjang_Utd
Penyerahan_Darah
Stok_Keluar_Medis
Kontra_Stok_Keluar_Medis
HPP_Obat_Jual_Bebas
Persediaan_Obat_Jual_Bebas
Penerimaan_NonMedis
Kontra_Penerimaan_NonMedis
Bayar_Pemesanan_Non_Medis
Hibah_Obat
Kontra_Hibah_Obat
Penerimaan_Toko
Kontra_Penerimaan_Toko
Pengadaan_Toko
Bayar_Pemesanan_Toko
Penjualan_Toko
HPP_Barang_Toko
Persediaan_Barang_Toko
Piutang_Toko
Kontra_Piutang_Toko
Retur_Beli_Toko
Kontra_Retur_Beli_Toko
Retur_Beli_Non_Medis
Kontra_Retur_Beli_Non_Medis
Retur_Jual_Toko
Kontra_Retur_Jual_Toko
Retur_Piutang_Toko
Kontra_Retur_Piutang_Toko
Kerugian_Klaim_BPJS_RVP
Lebih_Bayar_Klaim_BPJS_RVP
Piutang_BPJS_RVP
Kontra_Penerimaan_AsetInventaris
Kontra_Hibah_Aset
Hibah_Non_Medis
Kontra_Hibah_Non_Medis
Bayar_JM_Dokter
PPN_Masukan
Pengadaan_Dapur
Stok_Keluar_Dapur
Kontra_Stok_Keluar_Dapur
PPN_Keluaran
Diskon_Piutang
Piutang_Tidak_Terbayar
Lebih_Bayar_Piutang

Choose column to display:

Indexes

Action		Keyname	Type	Unique	Packed	Column	Collation	Null
Edit	Drop	Bayar_JM_Dokter	BTREE	No	No	Bayar_JM_Dokter	A	No
Edit	Drop	Bayar_Pemesanan_Non_Medis	BTREE	No	No	Bayar_Pemesanan_Non_Medis	A	No
Edit	Drop	Bayar_Pemesanan_Obat	BTREE	No	No	Bayar_Pemesanan_Obat	A	Yes
Edit	Drop	Bayar_Pemesanan_Toko	BTREE	No	No	Bayar_Pemesanan_Toko	A	Yes
Edit	Drop	Bayar_Piutang_Pasien	BTREE	No	No	Bayar_Piutang_Pasien	A	Yes
Edit	Drop	Diskon_Piutang	BTREE	No	No	Diskon_Piutang	A	No
Edit	Drop	Hibah_Non_Medis	BTREE	No	No	Hibah_Non_Medis	A	No
Edit	Drop	Hibah_Obat	BTREE	No	No	Hibah_Obat	A	No
Edit	Drop	HPP_Barang_Toko	BTREE	No	No	HPP_Barang_Toko	A	Yes
Edit	Drop	HPP_Obat_Jual_Bebas	BTREE	No	No	HPP_Obat_Jual_Bebas	A	Yes
Edit	Drop	Kerugian_Klaim_BPJS	BTREE	No	No	Kerugian_Klaim_BPJS_RVP	A	No
Edit	Drop	Kontra_Hibah_Aset	BTREE	No	No	Kontra_Hibah_Aset	A	No
Edit	Drop	Kontra_Hibah_Non_Medis	BTREE	No	No	Kontra_Hibah_Non_Medis	A	No
Edit	Drop	Kontra_Hibah_Obat	BTREE	No	No	Kontra_Hibah_Obat	A	No
Edit	Drop	Kontra_Pemesanan_Obat	BTREE	No	No	Kontra_Pemesanan_Obat	A	Yes
Edit	Drop	Kontra_Penerimaan_AsetInventaris	BTREE	No	No	Kontra_Penerimaan_AsetInventaris	A	No
Edit	Drop	Kontra_Penerimaan_NonMedis	BTREE	No	No	Kontra_Penerimaan_NonMedis	A	No
Edit	Drop	Kontra_Penerimaan_Toko	BTREE	No	No	Kontra_Penerimaan_Toko	A	Yes
Edit	Drop	Kontra_Pengambilan_Penunjang_Utd	BTREE	No	No	Kontra_Pengambilan_Penunjang_Utd	A	Yes
Edit	Drop	Kontra_Pengambilan_Utd	BTREE	No	No	Kontra_Pengambilan_Utd	A	Yes
Edit	Drop	Kontra_Piutang_Obat	BTREE	No	No	Kontra_Piutang_Obat	A	Yes
Edit	Drop	Kontra_Piutang_Toko	BTREE	No	No	Kontra_Piutang_Toko	A	Yes
Edit	Drop	Kontra_Retur_Beli_Non_Medis	BTREE	No	No	Kontra_Retur_Beli_Non_Medis	A	Yes
Edit	Drop	Kontra_Retur_Beli_Toko	BTREE	No	No	Kontra_Retur_Beli_Toko	A	Yes
Edit	Drop	Kontra_Retur_Dari_Pembeli	BTREE	No	No	Kontra_Retur_Dari_Pembeli	A	Yes
Edit	Drop	Kontra_Retur_Jual_Toko	BTREE	No	No	Kontra_Retur_Jual_Toko	A	Yes
Edit	Drop	Kontra_Retur_Ke_Suplayer	BTREE	No	No	Kontra_Retur_Ke_Suplayer	A	Yes
Edit	Drop	Kontra_Retur_Piutang_Obat	BTREE	No	No	Kontra_Retur_Piutang_Obat	A	Yes
Edit	Drop	Kontra_Retur_Piutang_Toko	BTREE	No	No	Kontra_Retur_Piutang_Toko	A	Yes
Edit	Drop	Kontra_Stok_Keluar_Dapur	BTREE	No	No	Kontra_Stok_Keluar_Dapur	A	No
Edit	Drop	Kontra_Stok_Keluar_Ipsrs	BTREE	No	No	Kontra_Stok_Keluar_Ipsrs	A	Yes
Edit	Drop	Kontra_Stok_Keluar_Medis	BTREE	No	No	Kontra_Stok_Keluar_Medis	A	No
Edit	Drop	Lebih_Bayar_Klaim_BPJS	BTREE	No	No	Lebih_Bayar_Klaim_BPJS_RVP	A	No
Edit	Drop	Lebih_Bayar_Piutang	BTREE	No	No	Lebih_Bayar_Piutang	A	No
Edit	Drop	Pemesanan_Obat	BTREE	No	No	Pemesanan_Obat	A	Yes
Edit	Drop	Penerimaan_NonMedis	BTREE	No	No	Penerimaan_NonMedis	A	No
Edit	Drop	Penerimaan_Toko	BTREE	No	No	Penerimaan_Toko	A	Yes
Edit	Drop	Pengadaan_Dapur	BTREE	No	No	Pengadaan_Dapur	A	No
Edit	Drop	Pengadaan_Ipsrs	BTREE	No	No	Pengadaan_Ipsrs	A	Yes
Edit	Drop	Pengadaan_Obat	BTREE	No	No	Pengadaan_Obat	A	Yes
Edit	Drop	Pengadaan_Toko	BTREE	No	No	Pengadaan_Toko	A	No
Edit	Drop	Pengambilan_Penunjang_Utd	BTREE	No	No	Pengambilan_Penunjang_Utd	A	Yes
Edit	Drop	Pengambilan_Utd	BTREE	No	No	Pengambilan_Utd	A	Yes
Edit	Drop	Penjualan_Obat	BTREE	No	No	Penjualan_Obat	A	Yes
Edit	Drop	Penjualan_Toko	BTREE	No	No	Penjualan_Toko	A	Yes
Edit	Drop	Penyerahan_Darah	BTREE	No	No	Penyerahan_Darah	A	Yes
Edit	Drop	Persediaan_Barang_Toko	BTREE	No	No	Persediaan_Barang_Toko	A	Yes
Edit	Drop	Persediaan_Obat_Jual_Bebas	BTREE	No	No	Persediaan_Obat_Jual_Bebas	A	Yes
Edit	Drop	Piutang_BPJS_RVP	BTREE	No	No	Piutang_BPJS_RVP	A	No
Edit	Drop	Piutang_Obat	BTREE	No	No	Piutang_Obat	A	Yes
Edit	Drop	Piutang_Tidak_Terbayar	BTREE	No	No	Piutang_Tidak_Terbayar	A	No
Edit	Drop	Piutang_Toko	BTREE	No	No	Piutang_Toko	A	Yes
Edit	Drop	PPN_Keluaran	BTREE	No	No	PPN_Keluaran	A	No
Edit	Drop	PPN_Masukan_Obat	BTREE	No	No	PPN_Masukan	A	No
Edit	Drop	Retur_Beli_Non_Medis	BTREE	No	No	Retur_Beli_Non_Medis	A	Yes
Edit	Drop	Retur_Beli_Toko	BTREE	No	No	Retur_Beli_Toko	A	Yes
Edit	Drop	Retur_Dari_pembeli	BTREE	No	No	Retur_Dari_pembeli	A	Yes
Edit	Drop	Retur_Jual_Toko	BTREE	No	No	Retur_Jual_Toko	A	Yes
Edit	Drop	Retur_Ke_Suplayer	BTREE	No	No	Retur_Ke_Suplayer	A	Yes
Edit	Drop	Retur_Piutang_Obat	BTREE	No	No	Retur_Piutang_Obat	A	Yes
Edit	Drop	Retur_Piutang_Toko	BTREE	No	No	Retur_Piutang_Toko	A	Yes
Edit	Drop	Stok_Keluar_Dapur	BTREE	No	No	Stok_Keluar_Dapur	A	No
Edit	Drop	Stok_Keluar_Ipsrs	BTREE	No	No	Stok_Keluar_Ipsrs	A	Yes
Edit	Drop	Stok_Keluar_Medis	BTREE	No	No	Stok_Keluar_Medis	A	No