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_ranap

# Name Type Collation Attributes Null Default Comments Extra Action
1 varchar(15) latin1_swedish_ci No None
2 varchar(15) latin1_swedish_ci Yes NULL
3 varchar(15) latin1_swedish_ci No None
4 varchar(15) latin1_swedish_ci No None
5 varchar(15) latin1_swedish_ci No None
6 varchar(15) latin1_swedish_ci No None
7 varchar(15) latin1_swedish_ci No None
8 varchar(15) latin1_swedish_ci No None
9 varchar(15) latin1_swedish_ci No None
10 varchar(15) latin1_swedish_ci No None
11 varchar(15) latin1_swedish_ci No None
12 varchar(15) latin1_swedish_ci No None
13 varchar(15) latin1_swedish_ci No None
14 varchar(15) latin1_swedish_ci No None
15 varchar(15) latin1_swedish_ci No None
16 varchar(15) latin1_swedish_ci Yes NULL
17 varchar(15) latin1_swedish_ci No None
18 varchar(15) latin1_swedish_ci No None
19 varchar(15) latin1_swedish_ci No None
20 varchar(15) latin1_swedish_ci No None
21 varchar(15) latin1_swedish_ci No None
22 varchar(15) latin1_swedish_ci No None
23 varchar(15) latin1_swedish_ci No None
24 varchar(15) latin1_swedish_ci No None
25 varchar(15) latin1_swedish_ci No None
26 varchar(15) latin1_swedish_ci No None
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 No None
34 varchar(15) latin1_swedish_ci No None
35 varchar(15) latin1_swedish_ci No None
36 varchar(15) latin1_swedish_ci No None
37 varchar(15) latin1_swedish_ci No None
38 varchar(15) latin1_swedish_ci No None
39 varchar(15) latin1_swedish_ci No None
40 varchar(15) latin1_swedish_ci No None
41 varchar(15) latin1_swedish_ci No None
42 varchar(15) latin1_swedish_ci No None
43 varchar(15) latin1_swedish_ci No None
44 varchar(15) latin1_swedish_ci No None
45 varchar(15) latin1_swedish_ci No None
46 varchar(15) latin1_swedish_ci No None
47 varchar(15) latin1_swedish_ci No None
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 Yes NULL
52 varchar(15) latin1_swedish_ci Yes NULL
53 varchar(15) latin1_swedish_ci Yes NULL
54 varchar(15) latin1_swedish_ci Yes NULL
55 varchar(15) latin1_swedish_ci Yes NULL
56 varchar(15) latin1_swedish_ci Yes NULL
57 varchar(15) latin1_swedish_ci Yes NULL
58 varchar(15) latin1_swedish_ci No None
59 varchar(15) latin1_swedish_ci Yes NULL
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
    Suspen_Piutang_Tindakan_Ranap BTREE No No Suspen_Piutang_Tindakan_Ranap 0 A No
    Tindakan_Ranap BTREE No No Tindakan_Ranap 0 A Yes
    Beban_Jasa_Medik_Dokter_Tindakan_Ranap BTREE No No Beban_Jasa_Medik_Dokter_Tindakan_Ranap 0 A No
    Utang_Jasa_Medik_Dokter_Tindakan_Ranap BTREE No No Utang_Jasa_Medik_Dokter_Tindakan_Ranap 0 A No
    Beban_Jasa_Medik_Paramedis_Tindakan_Ranap BTREE No No Beban_Jasa_Medik_Paramedis_Tindakan_Ranap 0 A No
    Utang_Jasa_Medik_Paramedis_Tindakan_Ranap BTREE No No Utang_Jasa_Medik_Paramedis_Tindakan_Ranap 0 A No
    Beban_KSO_Tindakan_Ranap BTREE No No Beban_KSO_Tindakan_Ranap 0 A No
    Utang_KSO_Tindakan_Ranap BTREE No No Utang_KSO_Tindakan_Ranap 0 A No
    Suspen_Piutang_Laborat_Ranap BTREE No No Suspen_Piutang_Laborat_Ranap 0 A No
    Laborat_Ranap BTREE No No Laborat_Ranap 0 A Yes
    Beban_Jasa_Medik_Dokter_Laborat_Ranap BTREE No No Beban_Jasa_Medik_Dokter_Laborat_Ranap 0 A No
    Utang_Jasa_Medik_Dokter_Laborat_Ranap BTREE No No Utang_Jasa_Medik_Dokter_Laborat_Ranap 0 A No
    Beban_Jasa_Medik_Petugas_Laborat_Ranap BTREE No No Beban_Jasa_Medik_Petugas_Laborat_Ranap 0 A No
    Utang_Jasa_Medik_Petugas_Laborat_Ranap BTREE No No Utang_Jasa_Medik_Petugas_Laborat_Ranap 0 A No
    Beban_Kso_Laborat_Ranap BTREE No No Beban_Kso_Laborat_Ranap 0 A No
    Utang_Kso_Laborat_Ranap BTREE No No Utang_Kso_Laborat_Ranap 0 A No
    HPP_Persediaan_Laborat_Rawat_inap BTREE No No HPP_Persediaan_Laborat_Rawat_inap 0 A No
    Persediaan_BHP_Laborat_Rawat_Inap BTREE No No Persediaan_BHP_Laborat_Rawat_Inap 0 A No
    Suspen_Piutang_Radiologi_Ranap BTREE No No Suspen_Piutang_Radiologi_Ranap 0 A No
    Radiologi_Ranap BTREE No No Radiologi_Ranap 0 A Yes
    Beban_Jasa_Medik_Dokter_Radiologi_Ranap BTREE No No Beban_Jasa_Medik_Dokter_Radiologi_Ranap 0 A No
    Utang_Jasa_Medik_Dokter_Radiologi_Ranap BTREE No No Utang_Jasa_Medik_Dokter_Radiologi_Ranap 0 A No
    Beban_Jasa_Medik_Petugas_Radiologi_Ranap BTREE No No Beban_Jasa_Medik_Petugas_Radiologi_Ranap 0 A No
    Utang_Jasa_Medik_Petugas_Radiologi_Ranap BTREE No No Utang_Jasa_Medik_Petugas_Radiologi_Ranap 0 A No
    Beban_Kso_Radiologi_Ranap BTREE No No Beban_Kso_Radiologi_Ranap 0 A No
    Utang_Kso_Radiologi_Ranap BTREE No No Utang_Kso_Radiologi_Ranap 0 A No
    HPP_Persediaan_Radiologi_Rawat_Inap BTREE No No HPP_Persediaan_Radiologi_Rawat_Inap 0 A No
    Persediaan_BHP_Radiologi_Rawat_Inap BTREE No No Persediaan_BHP_Radiologi_Rawat_Inap 0 A No
    Obat_Ranap BTREE No No Obat_Ranap 0 A Yes
    Registrasi_Ranap BTREE No No Registrasi_Ranap 0 A Yes
    Service_Ranap BTREE No No Service_Ranap 0 A Yes
    Tambahan_Ranap BTREE No No Tambahan_Ranap 0 A Yes
    Potongan_Ranap BTREE No No Potongan_Ranap 0 A Yes
    Retur_Obat_Ranap BTREE No No Retur_Obat_Ranap 0 A Yes
    Resep_Pulang_Ranap BTREE No No Resep_Pulang_Ranap 0 A Yes
    Kamar_Inap BTREE No No Kamar_Inap 0 A Yes
    Operasi_Ranap BTREE No No Operasi_Ranap 0 A Yes
    Suspen_Piutang_Obat_Ranap BTREE No No Suspen_Piutang_Obat_Ranap 0 A No
    HPP_Obat_Rawat_Inap BTREE No No HPP_Obat_Rawat_Inap 0 A No
    Persediaan_Obat_Rawat_Inap BTREE No No Persediaan_Obat_Rawat_Inap 0 A No
    Suspen_Piutang_Operasi_Ranap BTREE No No Suspen_Piutang_Operasi_Ranap 0 A No
    Beban_Jasa_Medik_Dokter_Operasi_Ranap BTREE No No Beban_Jasa_Medik_Dokter_Operasi_Ranap 0 A No
    Utang_Jasa_Medik_Dokter_Operasi_Ranap BTREE No No Utang_Jasa_Medik_Dokter_Operasi_Ranap 0 A No
    Beban_Jasa_Medik_Paramedis_Operasi_Ranap BTREE No No Beban_Jasa_Medik_Paramedis_Operasi_Ranap 0 A No
    Utang_Jasa_Medik_Paramedis_Operasi_Ranap BTREE No No Utang_Jasa_Medik_Paramedis_Operasi_Ranap 0 A No
    HPP_Obat_Operasi_Ranap BTREE No No HPP_Obat_Operasi_Ranap 0 A No
    Beban_Jasa_Menejemen_Tindakan_Ranap BTREE No No Beban_Jasa_Menejemen_Tindakan_Ranap 0 A No
    Beban_Jasa_Sarana_Tindakan_Ranap BTREE No No Beban_Jasa_Sarana_Tindakan_Ranap 0 A No
    HPP_BHP_Tindakan_Ranap BTREE No No HPP_BHP_Tindakan_Ranap 0 A No
    Utang_Jasa_Menejemen_Tindakan_Ranap BTREE No No Utang_Jasa_Menejemen_Tindakan_Ranap 0 A No
    Utang_Jasa_Sarana_Tindakan_Ranap BTREE No No Utang_Jasa_Sarana_Tindakan_Ranap 0 A No
    Persediaan_BHP_Tindakan_Ranap BTREE No No Persediaan_BHP_Tindakan_Ranap 0 A No
    Beban_Jasa_Sarana_Laborat_Ranap BTREE No No Beban_Jasa_Sarana_Laborat_Ranap 0 A No
    Utang_Jasa_Sarana_Laborat_Ranap BTREE No No Utang_Jasa_Sarana_Laborat_Ranap 0 A No
    Beban_Jasa_Perujuk_Laborat_Ranap BTREE No No Beban_Jasa_Perujuk_Laborat_Ranap 0 A No
    Utang_Jasa_Perujuk_Laborat_Ranap BTREE No No Utang_Jasa_Perujuk_Laborat_Ranap 0 A No
    Beban_Jasa_Menejemen_Laborat_Ranap BTREE No No Beban_Jasa_Menejemen_Laborat_Ranap 0 A No
    Utang_Jasa_Menejemen_Laborat_Ranap BTREE No No Utang_Jasa_Menejemen_Laborat_Ranap 0 A No
    Beban_Jasa_Sarana_Radiologi_Ranap BTREE No No Beban_Jasa_Sarana_Radiologi_Ranap 0 A No
    Utang_Jasa_Sarana_Radiologi_Ranap BTREE No No Utang_Jasa_Sarana_Radiologi_Ranap 0 A No
    Beban_Jasa_Perujuk_Radiologi_Ranap BTREE No No Beban_Jasa_Perujuk_Radiologi_Ranap 0 A No
    Utang_Jasa_Perujuk_Radiologi_Ranap BTREE No No Utang_Jasa_Perujuk_Radiologi_Ranap 0 A No
    Beban_Jasa_Menejemen_Radiologi_Ranap BTREE No No Beban_Jasa_Menejemen_Radiologi_Ranap 0 A No
    Utang_Jasa_Menejemen_Radiologi_Ranap BTREE No No Utang_Jasa_Menejemen_Radiologi_Ranap 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 08:00 PM
    Last check Oct 07, 2026 at 08:00 PM