www.rsgrahayasmine.com / 127.0.0.1 / sik / referensi_mobilejkn_bpjs

There are no favorite tables.

Customize appearance of the navigation panel.

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.

Customize the navigation tree.

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
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

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 display options.

Databases

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables display options.

Tables

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 -

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 :

Browse mode

Customize browse mode.

Browse mode

Table navigation bar Use only icons, only text or both.
How to display various action links Use only icons, only text or both.
Allow to display all the rows Whether a user should be displayed a "show all (rows)" button.
Maximum number of rows to display Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Default sorting order `SMART` - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Highlight pointer Highlight row pointed by the mouse cursor.
Row marker Highlight selected rows.
Grid editing: trigger action
Grid editing: save all edited cells at once
Repeat headers Repeat the headers every X cells, `0` deactivates this feature.
Limit column characters Maximum number of characters shown in any non-numeric column on browse view.
Where to show the table row links These are Edit, Copy and Delete links.
Show row links anyway Whether to show row links even in the absence of a unique key.
Primary key default sort order Default sort order for tables with a primary key.
Remember table's sorting When browsing tables, the sorting of each table is remembered.
Relational display For display Options

Showing rows 0 - 24 (3184 total, Query took 0.0133 seconds.) [jeniskunjungan: 4 (RUJUKAN ANTAR RS)... - 3 (KONTROL)...]

SELECT * FROM `referensi_mobilejkn_bpjs` ORDER BY `jeniskunjungan` DESC

[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]

Filter rows:

			nobooking	no_rawat	nomorkartu	nik	nohp	kodepoli	pasienbaru	norm	tanggalperiksa	kodedokter	jampraktek	jeniskunjungan 1	nomorreferensi	nomorantrean	angkaantrean	estimasidilayani	sisakuotajkn	kuotajkn	sisakuotanonjkn	kuotanonjkn	status	validasi	statuskirim
Edit	Copy	Delete DELETE FROM referensi_mobilejkn_bpjs WHERE `referensi_mobilejkn_bpjs`.`nobooking` = '20250318000006'	20250318000006	2025/03/18/000018	0003072188147	1406135704920003	081276120825	OBG	0	013773	2025-03-18	311573	07:30-09:45	4 (Rujukan Antar RS)	0401R0060325B000178	004-005	005	1742260800000	95	100	95	100	Checkin	2025-03-18 08:59:43	Sudah
Edit	Copy	Delete DELETE FROM referensi_mobilejkn_bpjs WHERE `referensi_mobilejkn_bpjs`.`nobooking` = '20250516000007'	20250516000007	2025/05/16/000024	0002310125231	1472017112620282	085272899278	INT	1	015500	2025-05-16	550132	13:00-15:00	4 (Rujukan Antar RS)	0071R0020525B000025	P006 -006	006	1747378800000	94	100	94	100	Checkin	2025-05-16 13:22:08	Belum
Edit	Copy	Delete DELETE FROM referensi_mobilejkn_bpjs WHERE `referensi_mobilejkn_bpjs`.`nobooking` = '20250517000002'	20250517000002	2025/05/17/000005	0001860583465	1472016107410021	085271814841	INT	0	015508	2025-05-17	550132	09:00-12:00	4 (Rujukan Antar RS)	0071R0020525B000040	P006 -004	004	1747449600000	96	100	96	100	Checkin	2025-05-17 10:12:49	Belum
Edit	Copy	Delete DELETE FROM referensi_mobilejkn_bpjs WHERE `referensi_mobilejkn_bpjs`.`nobooking` = '20240801000004'	20240801000004	2024/08/01/000005	0003592346141	1304015006530002	081374460909	MAT	0	010441	2024-08-01	23037	15:00-17:00	4 (Rujukan Antar RS)	0069R0080724B000299	008 -002	002	1722500400000	98	100	98	100	Checkin	2024-08-01 15:52:23	Sudah
Edit	Copy	Delete DELETE FROM referensi_mobilejkn_bpjs WHERE `referensi_mobilejkn_bpjs`.`nobooking` = '20251018000002'	20251018000002	2025/10/18/000002	0003779362631	1472072508250001	085263059969	ANA	0	016882	2025-10-18	272901	14:00-16:00	4 (Rujukan Antar RS)	0069R0080925B000167	005 -001	001	1760598600000	99	100	99	100	Batal	2025-10-17 08:18:44	Sudah
Edit	Copy	Delete DELETE FROM referensi_mobilejkn_bpjs WHERE `referensi_mobilejkn_bpjs`.`nobooking` = '20241018000008'	20241018000008	2024/10/18/000031	0001497781721	1472015206790042	081275375133	INT	0	006301	2024-10-18	550132	13:00-16:00	4 (Rujukan Antar RS)	0401R0060924B000370	006 -016	016	1729240800000	85	100	85	100	Checkin	2024-10-18 13:52:31	Belum
Edit	Copy	Delete DELETE FROM referensi_mobilejkn_bpjs WHERE `referensi_mobilejkn_bpjs`.`nobooking` = '20241112000010'	20241112000010	2024/11/12/000026	0003015492963	1472010301930042	081268483330	MAT	0	004555	2024-11-12	23037	15:00-17:00	4 (Rujukan Antar RS)	0071R0021124B000020	008 -013	013	1731406200000	87	100	87	100	Checkin	2024-11-12 16:22:42	Belum
Edit	Copy	Delete DELETE FROM referensi_mobilejkn_bpjs WHERE `referensi_mobilejkn_bpjs`.`nobooking` = '20250516000008'	20250516000008	2025/05/16/000027	0001439839822	1472024210680002	082173646155	INT	1	015501	2025-05-16	550132	13:00-15:00	4 (Rujukan Antar RS)	0071R0020525B000029	P006 -007	007	1747379400000	93	100	93	100	Checkin	2025-05-16 13:43:39	Belum
Edit	Copy	Delete DELETE FROM referensi_mobilejkn_bpjs WHERE `referensi_mobilejkn_bpjs`.`nobooking` = '20251022000018'	20251022000018	2025/10/22/000036	0003779362631	1472072508250001	085263059969	ANA	0	016882	2025-10-22	272901	17:00-19:00	4 (Rujukan Antar RS)	0069R0080925B000167	005 -006	006	1761130800000	95	100	95	100	Checkin	2025-10-22 17:53:27	Sudah
Edit	Copy	Delete DELETE FROM referensi_mobilejkn_bpjs WHERE `referensi_mobilejkn_bpjs`.`nobooking` = '20250430000006'	20250430000006	2025/04/30/000028	0000202347437	1472020302810043	081370824834	INT	1	015271	2025-04-30	550132	12:00-15:00	4 (Rujukan Antar RS)	0071R0020425B000065	P006 -003	003	1745991000000	97	100	97	100	Checkin	2025-04-30 13:22:06	Belum
Edit	Copy	Delete DELETE FROM referensi_mobilejkn_bpjs WHERE `referensi_mobilejkn_bpjs`.`nobooking` = '20251022000001'	20251022000001	2025/10/22/000001	0003779362631	1472072508250001	085263059969	ANA	0	016882	2025-10-22	272901	17:00-19:00	4 (Rujukan Antar RS)	0069R0080925B000167	005 -001	001	1760955000000	99	100	99	100	Batal	2025-10-21 19:38:09	Belum
Edit	Copy	Delete DELETE FROM referensi_mobilejkn_bpjs WHERE `referensi_mobilejkn_bpjs`.`nobooking` = '20250107000001'	20250107000001	2025/01/07/000001	0001497990576	1401116705740002	081277290410	MAT	0	013746	2025-01-07	23037	15:00-17:00	4 (Rujukan Antar RS)	0071R0020125B000006	008 -001	001	1736151000000	99	100	99	100	Batal	2025-01-08 12:13:41	Sudah
Edit	Copy	Delete DELETE FROM referensi_mobilejkn_bpjs WHERE `referensi_mobilejkn_bpjs`.`nobooking` = '20240709000001'	20240709000001	2024/07/09/000001	0002832336876	1403114104980001	081298751849	OBG	0	010416	2024-07-09	22389	13:00-16:50	3 (Kontrol)	0071R0030724K000028	004-001	001	1719900600000	99	100	99	100	Checkin	2024-07-09 13:13:14	Sudah
Edit	Copy	Delete DELETE FROM referensi_mobilejkn_bpjs WHERE `referensi_mobilejkn_bpjs`.`nobooking` = '20251222000001'	20251222000001	2025/12/22/000001	0001903051473	1472045009000001	082247178830	OBG	0	008856	2025-12-22	311573	07:30-09:50	3 (Kontrol)	0071R0031225K000213	004-001	001	1766363580000	99	100	99	100	Belum	0000-00-00 00:00:00	Belum
Edit	Copy	Delete DELETE FROM referensi_mobilejkn_bpjs WHERE `referensi_mobilejkn_bpjs`.`nobooking` = '20240704000003'	20240704000003	2024/07/04/000008	0000022335243	1472016008830061	082350159729	OBG	0	009488	2024-07-04	23020	13:00-15:00	3 (Kontrol)	0071R0030624K000391	004-001	001	1720073400000	99	100	99	100	Checkin	2024-07-04 13:23:45	Sudah
Edit	Copy	Delete DELETE FROM referensi_mobilejkn_bpjs WHERE `referensi_mobilejkn_bpjs`.`nobooking` = '20240705000001'	20240705000001	2024/07/05/000001	0002928471906	1210024505010009	082284554968	OBG	0	010364	2024-07-05	22389	13:00-16:00	3 (Kontrol)	0071R0030624K000387	004-001	001	1719555000000	99	100	99	100	Batal	2024-07-05 15:30:48	Sudah
Edit	Copy	Delete DELETE FROM referensi_mobilejkn_bpjs WHERE `referensi_mobilejkn_bpjs`.`nobooking` = '20240708000005'	20240708000005	2024/07/08/000009	0001798352526	1402041604820003	082385985554	INT	0	004835	2024-07-08	550132	13:00-16:00	3 (Kontrol)	0071R0030724K000117	006 -004	004	1720420800000	96	100	96	100	Checkin	2024-07-08 12:50:10	Sudah
Edit	Copy	Delete DELETE FROM referensi_mobilejkn_bpjs WHERE `referensi_mobilejkn_bpjs`.`nobooking` = '20240708000001'	20240708000001	2024/07/08/000001	0002441766824	1472014511720021	0895337664786	INT	0	002468	2024-07-08	513787	12:30-14:30	3 (Kontrol)	0071R0030724K000020	006 -001	001	1719812400000	99	100	99	100	Batal	2024-07-08 08:55:49	Sudah
Edit	Copy	Delete DELETE FROM referensi_mobilejkn_bpjs WHERE `referensi_mobilejkn_bpjs`.`nobooking` = '20240710000002'	20240710000002	2024/07/10/000002	0001690794235	1472014503830004	085212186939	OBG	0	010405	2024-07-10	311573	07:30-09:50	3 (Kontrol)	0071R0030724K000038	004-002	002	1720054200000	98	100	98	100	Checkin	2024-07-10 09:46:01	Sudah
Edit	Copy	Delete DELETE FROM referensi_mobilejkn_bpjs WHERE `referensi_mobilejkn_bpjs`.`nobooking` = '20240709000003'	20240709000003	2024/07/09/000007	0001340226707	1271132003480002	081342531521	MAT	0	010204	2024-07-09	23037	15:00-17:00	3 (Kontrol)	0071R0030724K000032	008 -002	002	1720513200000	98	100	98	100	Checkin	2024-07-09 15:42:29	Sudah
Edit	Copy	Delete DELETE FROM referensi_mobilejkn_bpjs WHERE `referensi_mobilejkn_bpjs`.`nobooking` = '20240708000004'	20240708000004	2024/07/08/000006	0002441766824	1472014511720021	0895337664786	INT	0	002468	2024-07-08	550132	13:00-16:00	3 (Kontrol)	0071R0030724K000020	006 -003	003	1720420200000	97	100	97	100	Checkin	2024-07-08 13:51:01	Sudah
Edit	Copy	Delete DELETE FROM referensi_mobilejkn_bpjs WHERE `referensi_mobilejkn_bpjs`.`nobooking` = '20240704000002'	20240704000002	2024/07/04/000006	0002452678367	1472035903840002	085363132508	OBG	0	010365	2024-07-04	311573	07:30-09:50	3 (Kontrol)	0071R0030724K000050	004-002	002	1720054200000	98	100	98	100	Checkin	2024-07-04 08:49:02	Sudah
Edit	Copy	Delete DELETE FROM referensi_mobilejkn_bpjs WHERE `referensi_mobilejkn_bpjs`.`nobooking` = '20240710000001'	20240710000001	2024/07/10/000001	0001497952394	1472034910890022	082390567098	OBG	0	010418	2024-07-10	311573	07:30-09:50	3 (Kontrol)	0071R0030724K000037	004-001	001	1719967200000	99	100	99	100	Checkin	2024-07-10 09:05:32	Sudah
Edit	Copy	Delete DELETE FROM referensi_mobilejkn_bpjs WHERE `referensi_mobilejkn_bpjs`.`nobooking` = '20240708000003'	20240708000003	2024/07/08/000003	0001497639609	1472016708700002	082391912951	INT	0	010403	2024-07-08	550132	13:00-16:00	3 (Kontrol)	0071R0030724K000017	006 -002	002	1720419600000	98	100	98	100	Checkin	2024-07-08 12:43:38	Sudah
Edit	Copy	Delete DELETE FROM referensi_mobilejkn_bpjs WHERE `referensi_mobilejkn_bpjs`.`nobooking` = '20240708000002'	20240708000002	2024/07/08/000002	0002481110021	1407066206910003	089506529220	INT	0	004423	2024-07-08	550132	13:00-16:00	3 (Kontrol)	0071R0030724K000048	006 -001	001	1719987000000	99	100	99	100	Checkin	2024-07-08 13:40:30	Sudah

Check all With selected:

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view