kebumeneyecenter.id / localhost / sik / 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: 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 :

Table structure

Table structure

Settings for the table structure (list of columns).

Default transformations
Hide table structure actions Whether the table structure actions should be hidden.
Show column comments Whether column comments should be shown in table structure view
Default transformations for Hex Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.	2
Default transformations for Substring Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.	0 all …
Default transformations for Bool2Text Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.	T F
Default transformations for External Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.	0 -f /dev/null -i -wrap -q 1 1
Default transformations for PreApPend Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
Default transformations for DateFormat Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.	0 local
Default transformations for Inline Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.	100 100
Default transformations for TextImageLink Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.	100 50
Default transformations for TextLink Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.

#	Name	Type	Collation	Null	Default	Action
1	Pengadaan_Obat	varchar(15)	latin1_swedish_ci	Yes	NULL	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
2	Pemesanan_Obat	varchar(15)	latin1_swedish_ci	Yes	NULL	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
3	Kontra_Pemesanan_Obat	varchar(15)	latin1_swedish_ci	Yes	NULL	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
4	Bayar_Pemesanan_Obat	varchar(15)	latin1_swedish_ci	Yes	NULL	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
5	Penjualan_Obat	varchar(15)	latin1_swedish_ci	Yes	NULL	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
6	Piutang_Obat	varchar(15)	latin1_swedish_ci	Yes	NULL	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
7	Kontra_Piutang_Obat	varchar(15)	latin1_swedish_ci	Yes	NULL	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
8	Retur_Ke_Suplayer	varchar(15)	latin1_swedish_ci	Yes	NULL	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
9	Kontra_Retur_Ke_Suplayer	varchar(15)	latin1_swedish_ci	Yes	NULL	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
10	Retur_Dari_pembeli	varchar(15)	latin1_swedish_ci	Yes	NULL	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
11	Kontra_Retur_Dari_Pembeli	varchar(15)	latin1_swedish_ci	Yes	NULL	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
12	Retur_Piutang_Obat	varchar(15)	latin1_swedish_ci	Yes	NULL	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
13	Kontra_Retur_Piutang_Obat	varchar(15)	latin1_swedish_ci	Yes	NULL	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
14	Pengadaan_Ipsrs	varchar(15)	latin1_swedish_ci	Yes	NULL	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
15	Stok_Keluar_Ipsrs	varchar(15)	latin1_swedish_ci	Yes	NULL	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
16	Kontra_Stok_Keluar_Ipsrs	varchar(15)	latin1_swedish_ci	Yes	NULL	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
17	Bayar_Piutang_Pasien	varchar(15)	latin1_swedish_ci	Yes	NULL	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
18	Pengambilan_Utd	varchar(15)	latin1_swedish_ci	Yes	NULL	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
19	Kontra_Pengambilan_Utd	varchar(15)	latin1_swedish_ci	Yes	NULL	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
20	Pengambilan_Penunjang_Utd	varchar(15)	latin1_swedish_ci	Yes	NULL	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
21	Kontra_Pengambilan_Penunjang_Utd	varchar(15)	latin1_swedish_ci	Yes	NULL	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
22	Penyerahan_Darah	varchar(15)	latin1_swedish_ci	Yes	NULL	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
23	Stok_Keluar_Medis	varchar(15)	latin1_swedish_ci	No	None	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
24	Kontra_Stok_Keluar_Medis	varchar(15)	latin1_swedish_ci	No	None	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
25	HPP_Obat_Jual_Bebas	varchar(15)	latin1_swedish_ci	Yes	NULL	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
26	Persediaan_Obat_Jual_Bebas	varchar(15)	latin1_swedish_ci	Yes	NULL	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
27	Penerimaan_NonMedis	varchar(15)	latin1_swedish_ci	No	None	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
28	Kontra_Penerimaan_NonMedis	varchar(15)	latin1_swedish_ci	No	None	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
29	Bayar_Pemesanan_Non_Medis	varchar(15)	latin1_swedish_ci	No	None	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
30	Hibah_Obat	varchar(15)	latin1_swedish_ci	No	None	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
31	Kontra_Hibah_Obat	varchar(15)	latin1_swedish_ci	No	None	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
32	Penerimaan_Toko	varchar(15)	latin1_swedish_ci	Yes	NULL	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
33	Kontra_Penerimaan_Toko	varchar(15)	latin1_swedish_ci	Yes	NULL	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
34	Pengadaan_Toko	varchar(15)	latin1_swedish_ci	No	None	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
35	Bayar_Pemesanan_Toko	varchar(15)	latin1_swedish_ci	Yes	NULL	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
36	Penjualan_Toko	varchar(15)	latin1_swedish_ci	Yes	NULL	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
37	HPP_Barang_Toko	varchar(15)	latin1_swedish_ci	Yes	NULL	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
38	Persediaan_Barang_Toko	varchar(15)	latin1_swedish_ci	Yes	NULL	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
39	Piutang_Toko	varchar(15)	latin1_swedish_ci	Yes	NULL	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
40	Kontra_Piutang_Toko	varchar(15)	latin1_swedish_ci	Yes	NULL	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
41	Retur_Beli_Toko	varchar(15)	latin1_swedish_ci	Yes	NULL	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
42	Kontra_Retur_Beli_Toko	varchar(15)	latin1_swedish_ci	Yes	NULL	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
43	Retur_Beli_Non_Medis	varchar(15)	latin1_swedish_ci	Yes	NULL	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
44	Kontra_Retur_Beli_Non_Medis	varchar(15)	latin1_swedish_ci	Yes	NULL	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
45	Retur_Jual_Toko	varchar(15)	latin1_swedish_ci	Yes	NULL	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
46	Kontra_Retur_Jual_Toko	varchar(15)	latin1_swedish_ci	Yes	NULL	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
47	Retur_Piutang_Toko	varchar(15)	latin1_swedish_ci	Yes	NULL	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
48	Kontra_Retur_Piutang_Toko	varchar(15)	latin1_swedish_ci	Yes	NULL	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
49	Kerugian_Klaim_BPJS_RVP	varchar(15)	latin1_swedish_ci	No	None	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
50	Lebih_Bayar_Klaim_BPJS_RVP	varchar(15)	latin1_swedish_ci	No	None	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
51	Piutang_BPJS_RVP	varchar(15)	latin1_swedish_ci	No	None	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
52	Kontra_Penerimaan_AsetInventaris	varchar(15)	latin1_swedish_ci	No	None	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
53	Kontra_Hibah_Aset	varchar(15)	latin1_swedish_ci	No	None	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
54	Hibah_Non_Medis	varchar(15)	latin1_swedish_ci	No	None	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
55	Kontra_Hibah_Non_Medis	varchar(15)	latin1_swedish_ci	No	None	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
56	Bayar_JM_Dokter	varchar(15)	latin1_swedish_ci	No	None	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
57	PPN_Masukan	varchar(15)	latin1_swedish_ci	No	None	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
58	Pengadaan_Dapur	varchar(15)	latin1_swedish_ci	No	None	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
59	Stok_Keluar_Dapur	varchar(15)	latin1_swedish_ci	No	None	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
60	Kontra_Stok_Keluar_Dapur	varchar(15)	latin1_swedish_ci	No	None	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
61	PPN_Keluaran	varchar(15)	latin1_swedish_ci	No	None	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
62	Diskon_Piutang	varchar(15)	latin1_swedish_ci	No	None	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns
63	Piutang_Tidak_Terbayar	varchar(15)	latin1_swedish_ci	No	None	Change	Drop	More Primary Unique Index Spatial Fulltext Distinct values Add to central columns

Check all With selected:

Propose table structure

Track table

Move columns

Normalize

Add column(s)

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	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

Partitions

No partitioning defined!

Information

Space usage
Data	16.0	KiB
Index	1.0	MiB
Overhead
Effective	1.0	MiB
Total	1.0	MiB

Row statistics
Format	dynamic
Options	row_format=DYNAMIC
Collation	latin1_swedish_ci
Next autoindex	0
Creation	Jul 16, 2024 at 11:26 AM
Last update	May 04, 2025 at 08:26 PM
Last check	May 04, 2025 at 08:26 PM