Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press 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 :
Table structure

Settings for the table structure (list of columns).

Documentation Whether the table structure actions should be hidden.
Documentation Whether column comments should be shown in table structure view
Default transformations
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.

set_akun

# Name Type Collation Attributes Null Default Comments Extra Action
1 varchar(15) latin1_swedish_ci Yes NULL
2 varchar(15) latin1_swedish_ci Yes NULL
3 varchar(15) latin1_swedish_ci Yes NULL
4 varchar(15) latin1_swedish_ci Yes NULL
5 varchar(15) latin1_swedish_ci Yes NULL
6 varchar(15) latin1_swedish_ci Yes NULL
7 varchar(15) latin1_swedish_ci Yes NULL
8 varchar(15) latin1_swedish_ci Yes NULL
9 varchar(15) latin1_swedish_ci Yes NULL
10 varchar(15) latin1_swedish_ci Yes NULL
11 varchar(15) latin1_swedish_ci Yes NULL
12 varchar(15) latin1_swedish_ci Yes NULL
13 varchar(15) latin1_swedish_ci Yes NULL
14 varchar(15) latin1_swedish_ci Yes NULL
15 varchar(15) latin1_swedish_ci Yes NULL
16 varchar(15) latin1_swedish_ci Yes NULL
17 varchar(15) latin1_swedish_ci Yes NULL
18 varchar(15) latin1_swedish_ci Yes NULL
19 varchar(15) latin1_swedish_ci Yes NULL
20 varchar(15) latin1_swedish_ci Yes NULL
21 varchar(15) latin1_swedish_ci Yes NULL
22 varchar(15) latin1_swedish_ci Yes NULL
23 varchar(15) latin1_swedish_ci No None
24 varchar(15) latin1_swedish_ci No None
25 varchar(15) latin1_swedish_ci Yes NULL
26 varchar(15) latin1_swedish_ci Yes NULL
27 varchar(15) latin1_swedish_ci No None
28 varchar(15) latin1_swedish_ci No None
29 varchar(15) latin1_swedish_ci No None
30 varchar(15) latin1_swedish_ci No None
31 varchar(15) latin1_swedish_ci No None
32 varchar(15) latin1_swedish_ci Yes NULL
33 varchar(15) latin1_swedish_ci Yes NULL
34 varchar(15) latin1_swedish_ci No None
35 varchar(15) latin1_swedish_ci Yes NULL
36 varchar(15) latin1_swedish_ci Yes NULL
37 varchar(15) latin1_swedish_ci Yes NULL
38 varchar(15) latin1_swedish_ci Yes NULL
39 varchar(15) latin1_swedish_ci Yes NULL
40 varchar(15) latin1_swedish_ci Yes NULL
41 varchar(15) latin1_swedish_ci Yes NULL
42 varchar(15) latin1_swedish_ci Yes NULL
43 varchar(15) latin1_swedish_ci Yes NULL
44 varchar(15) latin1_swedish_ci Yes NULL
45 varchar(15) latin1_swedish_ci Yes NULL
46 varchar(15) latin1_swedish_ci Yes NULL
47 varchar(15) latin1_swedish_ci Yes NULL
48 varchar(15) latin1_swedish_ci Yes NULL
49 varchar(15) latin1_swedish_ci No None
50 varchar(15) latin1_swedish_ci No None
51 varchar(15) latin1_swedish_ci No None
52 varchar(15) latin1_swedish_ci No None
53 varchar(15) latin1_swedish_ci No None
54 varchar(15) latin1_swedish_ci No None
55 varchar(15) latin1_swedish_ci No None
56 varchar(15) latin1_swedish_ci No None
57 varchar(15) latin1_swedish_ci No None
58 varchar(15) latin1_swedish_ci No None
59 varchar(15) latin1_swedish_ci No None
60 varchar(15) latin1_swedish_ci No None
61 varchar(15) latin1_swedish_ci No None
62 varchar(15) latin1_swedish_ci No None
63 varchar(15) latin1_swedish_ci No None
64 varchar(15) latin1_swedish_ci No None

Move the columns by dragging them up and down.

    Add column  Add column(s)  
    Indexes Documentation
    Action Keyname Type Unique Packed Column Cardinality Collation Null Comment
    Pengadaan_Obat BTREE No No Pengadaan_Obat 0 A Yes
    Pemesanan_Obat BTREE No No Pemesanan_Obat 0 A Yes
    Kontra_Pemesanan_Obat BTREE No No Kontra_Pemesanan_Obat 0 A Yes
    Bayar_Pemesanan_Obat BTREE No No Bayar_Pemesanan_Obat 0 A Yes
    Penjualan_Obat BTREE No No Penjualan_Obat 0 A Yes
    Piutang_Obat BTREE No No Piutang_Obat 0 A Yes
    Kontra_Piutang_Obat BTREE No No Kontra_Piutang_Obat 0 A Yes
    Retur_Ke_Suplayer BTREE No No Retur_Ke_Suplayer 0 A Yes
    Kontra_Retur_Ke_Suplayer BTREE No No Kontra_Retur_Ke_Suplayer 0 A Yes
    Retur_Dari_pembeli BTREE No No Retur_Dari_pembeli 0 A Yes
    Kontra_Retur_Dari_Pembeli BTREE No No Kontra_Retur_Dari_Pembeli 0 A Yes
    Retur_Piutang_Obat BTREE No No Retur_Piutang_Obat 0 A Yes
    Kontra_Retur_Piutang_Obat BTREE No No Kontra_Retur_Piutang_Obat 0 A Yes
    Pengadaan_Ipsrs BTREE No No Pengadaan_Ipsrs 0 A Yes
    Stok_Keluar_Ipsrs BTREE No No Stok_Keluar_Ipsrs 0 A Yes
    Kontra_Stok_Keluar_Ipsrs BTREE No No Kontra_Stok_Keluar_Ipsrs 0 A Yes
    Bayar_Piutang_Pasien BTREE No No Bayar_Piutang_Pasien 0 A Yes
    Pengambilan_Utd BTREE No No Pengambilan_Utd 0 A Yes
    Kontra_Pengambilan_Utd BTREE No No Kontra_Pengambilan_Utd 0 A Yes
    Pengambilan_Penunjang_Utd BTREE No No Pengambilan_Penunjang_Utd 0 A Yes
    Kontra_Pengambilan_Penunjang_Utd BTREE No No Kontra_Pengambilan_Penunjang_Utd 0 A Yes
    Penyerahan_Darah BTREE No No Penyerahan_Darah 0 A Yes
    Stok_Keluar_Medis BTREE No No Stok_Keluar_Medis 0 A No
    Kontra_Stok_Keluar_Medis BTREE No No Kontra_Stok_Keluar_Medis 0 A No
    HPP_Obat_Jual_Bebas BTREE No No HPP_Obat_Jual_Bebas 0 A Yes
    Persediaan_Obat_Jual_Bebas BTREE No No Persediaan_Obat_Jual_Bebas 0 A Yes
    Penerimaan_NonMedis BTREE No No Penerimaan_NonMedis 0 A No
    Kontra_Penerimaan_NonMedis BTREE No No Kontra_Penerimaan_NonMedis 0 A No
    Bayar_Pemesanan_Non_Medis BTREE No No Bayar_Pemesanan_Non_Medis 0 A No
    Hibah_Obat BTREE No No Hibah_Obat 0 A No
    Kontra_Hibah_Obat BTREE No No Kontra_Hibah_Obat 0 A No
    Penerimaan_Toko BTREE No No Penerimaan_Toko 0 A Yes
    Kontra_Penerimaan_Toko BTREE No No Kontra_Penerimaan_Toko 0 A Yes
    Pengadaan_Toko BTREE No No Pengadaan_Toko 0 A No
    Bayar_Pemesanan_Toko BTREE No No Bayar_Pemesanan_Toko 0 A Yes
    Penjualan_Toko BTREE No No Penjualan_Toko 0 A Yes
    HPP_Barang_Toko BTREE No No HPP_Barang_Toko 0 A Yes
    Persediaan_Barang_Toko BTREE No No Persediaan_Barang_Toko 0 A Yes
    Piutang_Toko BTREE No No Piutang_Toko 0 A Yes
    Kontra_Piutang_Toko BTREE No No Kontra_Piutang_Toko 0 A Yes
    Retur_Beli_Toko BTREE No No Retur_Beli_Toko 0 A Yes
    Kontra_Retur_Beli_Toko BTREE No No Kontra_Retur_Beli_Toko 0 A Yes
    Retur_Beli_Non_Medis BTREE No No Retur_Beli_Non_Medis 0 A Yes
    Kontra_Retur_Beli_Non_Medis BTREE No No Kontra_Retur_Beli_Non_Medis 0 A Yes
    Retur_Jual_Toko BTREE No No Retur_Jual_Toko 0 A Yes
    Kontra_Retur_Jual_Toko BTREE No No Kontra_Retur_Jual_Toko 0 A Yes
    Retur_Piutang_Toko BTREE No No Retur_Piutang_Toko 0 A Yes
    Kontra_Retur_Piutang_Toko BTREE No No Kontra_Retur_Piutang_Toko 0 A Yes
    Kerugian_Klaim_BPJS BTREE No No Kerugian_Klaim_BPJS_RVP 0 A No
    Lebih_Bayar_Klaim_BPJS BTREE No No Lebih_Bayar_Klaim_BPJS_RVP 0 A No
    Piutang_BPJS_RVP BTREE No No Piutang_BPJS_RVP 0 A No
    Kontra_Penerimaan_AsetInventaris BTREE No No Kontra_Penerimaan_AsetInventaris 0 A No
    Kontra_Hibah_Aset BTREE No No Kontra_Hibah_Aset 0 A No
    Hibah_Non_Medis BTREE No No Hibah_Non_Medis 0 A No
    Kontra_Hibah_Non_Medis BTREE No No Kontra_Hibah_Non_Medis 0 A No
    PPN_Masukan_Obat BTREE No No PPN_Masukan 0 A No
    Pengadaan_Dapur BTREE No No Pengadaan_Dapur 0 A No
    Stok_Keluar_Dapur BTREE No No Stok_Keluar_Dapur 0 A No
    Kontra_Stok_Keluar_Dapur BTREE No No Kontra_Stok_Keluar_Dapur 0 A No
    PPN_Keluaran BTREE No No PPN_Keluaran 0 A No
    Diskon_Piutang BTREE No No Diskon_Piutang 0 A No
    Piutang_Tidak_Terbayar BTREE No No Piutang_Tidak_Terbayar 0 A No
    Lebih_Bayar_Piutang BTREE No No Lebih_Bayar_Piutang 0 A No
    Bayar_JM_Dokter BTREE No No Beban_Hutang_Lain 0 A No
    Partitions Documentation
    Information
    Space usage
    Data 16.0 KiB
    Index 1.0 MiB
    Overhead 3.0 MiB
    Effective -2,080,768 B
    Total 1.0 MiB
    Row statistics
    Format dynamic
    Collation latin1_swedish_ci
    Next autoindex 0
    Creation Jun 05, 2026 at 12:47 AM
    Last update Oct 07, 2026 at 07:04 PM
    Last check Oct 07, 2026 at 07:04 PM