pleytedts.online / 127.0.0.1 / palo_db / document_table

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 (1334 total, Query took 0.0220 seconds.) [records_outgoing_receiver: ... - ...]

SELECT * FROM `document_table` ORDER BY `records_outgoing_receiver` ASC

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

Filter rows:

			id	records_transactionno	records_processor	records_section	records_workgroup	records_sender	records_address	records_daterecv	records_subject	records_documentsource	records_doctype	records_documentstatus	records_officeorigin	records_dateprocessed	records_time	records_receiver	cenro_recvdate	cenro_recvtime	cenro_processor	cenro_workgroup	cenro_section	cenro_priority	cenro_action	cenro_action_others	cenro_receiver	cenro_dateprocessed	cenro_time	section_recvdate	section_recvtime	section_processor	section_workgroup	section_section	section_priority	section_action	section_action_others	section_receiver	section_dateprocessed	section_time	focal_recvdate	focal_recvtime	focal_processor	focal_workgroup	focal_section	focal_action	focal_dateprocessed	focal_time	focal_receiver	section_outgoing_recvdate	section_outgoing_recvtime	section_outgoing_processor	section_outgoing_workgroup	section_outgoing_section	section_outgoing_action	section_outgoing_dateprocessed	section_outgoing_time	section_outgoing_receiver	cenro_outgoing_recvdate	cenro_outgoing_recvtime	cenro_outgoing_processor	cenro_outgoing_workgroup	cenro_outgoing_section	cenro_outgoing_action	cenro_outgoing_dateprocessed	cenro_outgoing_time	cenro_outgoing_receiver	records_outgoing_recvdate	records_outgoing_recvtime	records_outgoing_processor	records_outgoing_workgroup	records_outgoing_section	records_outgoing_action	records_outgoing_dateprocessed	records_outgoing_time	records_outgoing_receiver 1	section_reroute_recvdate	section_reroute_recvtime	section_reroute_processor	section_reroute_workgroup	section_reroute_section	section_reroute_remarks	section_reroute_dateprocessed	section_reroute_time	section_reroute_receiver	focal_reroute_recvdate	focal_reroute_recvtime	focal_reroute_processor	focal_reroute_workgroup	focal_reroute_section	focal_reroute_remarks	focal_reroute_dateprocessed	focal_reroute_time	focal_reroute_receiver
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 256	256	CP-2025-00161	JANELY MESIAS	RECORDS	RECORDS	CRISTINA B. ASIS, PEDRO P	BRGY. SANTARIN BARUGO, LEYTE	2025-04-24	LETTER PROTEST OF LOT NO. 937, 938, 939, & 940, PL...	WALK IN	PROTEST	FORWARDED FROM RPS	CRISTINA B. ASIS, PEDRO P	2025-04-24	04:02 PM		2025-04-25	02:28 PM	ALMA ARANCINA	CENRO	CENRO	Priority	FOR APPROPRIATE ACTION		RPS	02:29 PM	2025-04-25	2025-04-25	03:46 PM	MARLON CONTAPAY	RPS	Section Chief	Normal	FOR APPROPRIATE ACTION		PATENT PROCESSING AND ISSUANCE	04:48 PM	2025-05-07
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 512	512	CP-2025-00417	JANELY MESIAS	RECORDS	RECORDS	JOHN KEVIN R. ASTORGA	MAHARLIKA HIGHWAY, CAMPETIC PALO, LEYTE	2025-05-15	REQUEST FOR 3 NARRA, 5 TOOG, 10 BANABA, 7 BANI, & ...	WALK IN	LETTER	FORWARDED FROM CENRO	JOHN KEVIN R. ASTORGA	2025-05-15	04:18 PM		2025-05-16	09:04 AM	ALMA ARANCINA	CENRO	CENRO	Priority	FOR APPROPRIATE ACTION, OTHERS	ENGP UNIT	CDS	03:32 PM	2025-05-19
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 768	768	CP-2025-00673	JANELY MESIAS	RECORDS	RECORDS	GEMMA L. TOR	BRGY. PAGSULHUGON BABATNGON, LEYTE	2025-06-02	REQUEST FOR LAND CLASSIFICATION STATUS OF LOT NO. ...	WALK IN	A&D CERTIFICATION	FORWARDED FROM RECORDS	GEMMA L. TOR	2025-06-02	04:24 PM
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 1024	1024	CP-2025-00927	JANELY MESIAS	RECORDS	RECORDS	RUBY R. ATILLO	83 A BURAYAN TACLOBAN CITY	2025-06-18	REQUEST FOR CERTIFIED TRUE COPY OF SUPPORTING DOCU...	WALK IN	PERMITS	FORWARDED FROM RECORDS	RUBY R. ATILLO	2025-06-18	04:09 PM
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 1280	1280	CP-2025-01183	JANELY MESIAS	RECORDS	RECORDS	RINBERT EMMANUEL M. LAUS	BURAYAN ST., BRGY. 83-A TACLOBAN CITY	2025-07-09	REQUEST FOR CERTIFIED TRUE COPY OF SUPPORTING DOCU...	WALK IN	CERTIFIED TRUE COPY OF DO	FORWARDED FROM RECORDS	RINBERT EMMANUEL M. LAUS	2025-07-09	08:57 AM
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 257	257	CP-2025-00162	JANELY MESIAS	RECORDS	RECORDS	ELMER D. PATANO	BRGY. CALAASAN, SITIO CABILAO, ALANG-ALANG, LEYTE	2025-04-24	REQUEST FOR TREE CUTTING PERMIT OF ONE (1) MAHOGAN...	WALK IN	PERMITS	FORWARDED FROM RPS	ELMER D. PATANO	2025-04-24	04:04 PM		2025-04-25	02:26 PM	ALMA ARANCINA	CENRO	CENRO	Priority	FOR APPROPRIATE ACTION		RPS	02:27 PM	2025-04-25	2025-04-25	03:46 PM	MARLON CONTAPAY	RPS	Section Chief	Normal	FOR APPROPRIATE ACTION		FOREST PERMITTING	04:48 PM	2025-05-07
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 513	513	CP-2025-00418	JANELY MESIAS	RECORDS	RECORDS	WILMA T. BARLOSO	ZONE 6, BRGY. SAN ROQUE MAYORGA, LEYTE	2025-05-15	REQUEST FOR A&D CERTIFICATION OF 4683, 492, 1592, ...	WALK IN	A&D CERTIFICATION	FORWARDED FROM RECORDS	WILMA T. BARLOSO	2025-05-15	04:31 PM
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 769	769	CP-2025-00674	JANELY MESIAS	RECORDS	RECORDS	ANALIZA S. HINLAYAGAN, RP	BRGY. CANDAHUG PALO, LEYTE	2025-06-02	MEMO: SUBMISSION OF REPORT ON THE COLLECTIONS AND ...	WALK IN	MEMORANDUM	FORWARDED FROM RECORDS	CENRO - PALO	2025-06-02	05:11 PM		2025-06-03	09:40 AM
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 1025	1025	CP-2025-00928	JANELY MESIAS	RECORDS	RECORDS	MARISSA L. PERALTA	BRGY. MAGHUBAS BURAUEN, LEYTE	2025-06-18	REQUEST FOR LAND CLASSIFICATION STATUS OF LOT NO....	WALK IN	A&D CERTIFICATION	FORWARDED FROM RECORDS	MARISSA L. PERALTA	2025-06-18	04:16 PM
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 1281	1281	CP-2025-01184	JANELY MESIAS	RECORDS	RECORDS	AILEEN ESCARLAN	ZONE 6, BRGY. RIZAL DULAG, LEYTE	2025-07-09	REQUEST FOR LAND CLASSIFICATION STATUS CERTIFICA...	WALK IN	CERTIFIED TRUE COPY OF DO	FORWARDED FROM RECORDS	AILEEN ESCARLAN	2025-07-09	08:58 AM		2025-07-10	09:41 AM
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 258	258	CP-2025-00163	CHERRY LEE DIBABAO	RECORDS	RECORDS	IRAN ROSE VILLAS	BRGY. BANGON TANAUAN, LEYTE	2025-04-25	REQUEST FOR CERTIFIED DOCUMENTS OF LOT NO. 13446, ...	WALK IN	CERTIFIED TRUE COPY OF DO	FORWARDED FROM RECORDS	IRAN ROSE VILLAS	2025-04-25	03:56 PM
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 514	514	CP-2025-00419	JANELY MESIAS	RECORDS	RECORDS	WILMA T. BARLOSO	ZONE 6, BRGY. SAN ROQUE MAYORGA, LEYTE	2025-05-15	REQUEST FOR CERTIFIED TRUE COPY OF DOCUMENTS OF L...	WALK IN	CERTIFIED TRUE COPY OF DO	FORWARDED FROM RECORDS	WILMA T. BARLOSO	2025-05-15	04:36 PM
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 770	770	CP-2025-00675	JANELY MESIAS	RECORDS	RECORDS	ANGELITO VILLAUEVA	MAGSAYSAY BOULEVARD TACLOBAN CITY	2025-06-02	MEMO: MODIFICATION OF ACTIVITY OF 1,263 HECTARES U...	EMAIL	MEMORANDUM	FORWARDED FROM CENRO	DENR RO8	2025-06-02	05:14 PM		2025-06-03	09:41 AM	ALMA ARANCINA	CENRO	CENRO	Priority	FOR APPROPRIATE ACTION		CDS	2025-06-04	01:49 PM
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 1026	1026	CP-2025-00929	JANELY MESIAS	RECORDS	RECORDS	SHIRLEY D. MONTEJO	BRGY. BARAS PALO, LEYTE	2025-06-18	REQUEST FOR LAND CLASSIFICATION STATUS OF LOT NO....	WALK IN	A&D CERTIFICATION	FORWARDED FROM RECORDS	SHIRLEY D. MONTEJO	2025-06-18	04:18 PM
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 1282	1282	CP-2025-01185	JANELY MESIAS	RECORDS	RECORDS	NENITA D. PASCUAL	REAL ST., GUINDAPUNAN WEST CARIGARA, LEYTE	2025-07-09	REQUEST FOR LOT STATUS CERTIFICATION OF LOT NO. ...	WALK IN	CERTIFICATION	FORWARDED FROM RECORDS	NENITA D. PASCUAL	2025-07-09	11:12 AM
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 259	259	CP-2025-00164	CHERRY LEE DIBABAO	RECORDS	RECORDS	FERNANDA M. RINTANTAN	TANAUAN, LEYTE	2025-04-25	REQUEST FOR CERTIFIED TRUE COPY OF SUPPORTING DOCU...	WALK IN	CERTIFIED TRUE COPY OF DO	FORWARDED FROM CENRO	FERNANDA M. RINTANTAN	2025-04-25	04:05 PM		2025-04-28	01:17 PM	ALMA ARANCINA	CENRO	CENRO	Priority	FOR APPROPRIATE ACTION, OTHERS	RECORDS UNIT	ADMIN OFFICE	01:18 PM	2025-04-28
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 515	515	CP-2025-00420	JANELY MESIAS	RECORDS	RECORDS	ARTURO N. SALAZAR, D.M.,	MAGSAYSAY BOULEVARD TACLOBAN CITY	2025-05-16	MEMO: TRANSMITTAL OF COPIES OF CANCELLED CERTIFICA...	EMAIL	MEMORANDUM	FORWARDED FROM CENRO	DENR RO8	2025-05-16	11:13 AM		2025-05-19	10:12 AM	ALMA ARANCINA	CENRO	CENRO	Priority	FOR APPROPRIATE ACTION		MES	01:15 PM	2025-05-21
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 771	771	CP-2025-00676	JANELY MESIAS	RECORDS	RECORDS	ATTY. DARIO O. SUAREZ	MAGSAYSAY BOULEVARD TACLOBAN CITY	2025-06-02	NOMINATION FORM FOR THE DENR EXTERNAL ENVIRONMENTA...	EMAIL	MEMORANDUM	FORWARDED FROM CENRO	DENR RO8	2025-06-02	05:16 PM		2025-06-03	09:41 AM	ALMA ARANCINA	CENRO	CENRO	Priority	FOR APPROPRIATE ACTION		CDS	2025-06-04	02:03 PM
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 1027	1027	CP-2025-00930	JANELY MESIAS	RECORDS	RECORDS	ENGR. VIRGILIO C. ROSEÑO	#31 KALIPAYAN ST., SAGKAHAN TACLOBAN CITY	2025-06-18	REQUEST FOR LAND CLASSIFICATION STATUS OF LOT NO....	WALK IN	A&D CERTIFICATION	FORWARDED FROM RECORDS	ENGR. VIRGILIO C. ROSEÑO	2025-06-18	04:22 PM
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 1283	1283	CP-2025-01186	JANELY MESIAS	RECORDS	RECORDS	NICANDRO A. MOLON	BRGY. SAN MIGUEL TANAUAN, LEYTE	2025-07-09	REQUEST FOR LOT STATUS CERTIFICATION OF LOT NO. ...	WALK IN	CERTIFICATION	FORWARDED FROM RECORDS	NICANDRO A. MOLON	2025-07-09	11:14 AM
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 260	260	CP-2025-00165	CHERRY LEE DIBABAO	RECORDS	RECORDS	ERLINDA G. CAPAMBICRISPIN	PASTRANA, LEYTE	2025-04-25	REQUEST FOR CERTIFIED TRUE COPY OF SUPPORTING DOCU...	WALK IN	CERTIFIED TRUE COPY OF DO	FORWARDED FROM CENRO	ERLINDA G. CAPAMBICRISPIN	2025-04-25	04:07 PM		2025-04-28	01:18 PM	ALMA ARANCINA	CENRO	CENRO	Priority	FOR APPROPRIATE ACTION, OTHERS	RECORDS UNIT	ADMIN OFFICE	01:18 PM	2025-04-28
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 516	516	CP-2025-00421	JANELY MESIAS	RECORDS	RECORDS	DR. CARLOS PRIMO C. DAVID	VISAYAS AVENUE DILIMAN QUEZON CITY	2025-05-16	SPECIAL ORDER NO. 2025-305. SUBJECT: AUTHORIZING T...	EMAIL	SPECIAL ORDER	FORWARDED FROM CENRO	DENR CENTRAL OFFICE	2025-05-16	02:46 PM		2025-05-19	10:11 AM	ALMA ARANCINA	CENRO	CENRO	Priority	FOR APPROPRIATE ACTION		ADMIN OFFICE	01:12 PM	2025-05-21
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 772	772	CP-2025-00677	JANELY MESIAS	RECORDS	RECORDS	ANGELITO B. VILLANUEVA	MAGSAYSAY BOULEVARD TACLOBAN CITY	2025-06-02	MEMO: REQUEST FOR USE OF A SERVICE VEHICLE FOR THE...	EMAIL	MEMORANDUM	FORWARDED FROM RECORDS	DENR RO8	2025-06-02	05:19 PM		2025-06-03	09:42 AM
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 1028	1028	CP-2025-00931	JANELY MESIAS	RECORDS	RECORDS	ELENA MARIE M. CAPANASNGC	TACLOBAN CITY	2025-06-18	REQUEST FOR LAND CLASSIFICATION STATUS OF LOT NO....	WALK IN	A&D CERTIFICATION	FORWARDED FROM RECORDS	ELENA MARIE M. CAPANASNGC	2025-06-18	04:24 PM
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 1284	1284	CP-2025-01187	JANELY MESIAS	RECORDS	RECORDS	MARILYN L. SEGURA	BRGY. KILING TANAUAN, LEYTE	2025-07-09	REQUEST FOR CERTIFIED TRUE COPY OF SUPPORTING DOCU...	WALK IN	CERTIFIED TRUE COPY OF DO	FORWARDED FROM RECORDS	MARILYN L. SEGURA	2025-07-09	11:15 AM

Check all With selected:

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view