cgc-cabuyao-main.mora-mackarel.ts.net / 127.0.0.1 / hr_portal_db / employees

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 (195 total, Query took 0.0043 seconds.)

SELECT * FROM `employees`

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

Filter rows:

			id	employee_code	salutation	first_name	last_name	middle_name	extension_name	nickname	gender	birth_date	nationality	marital_status	personal_email	work_email	mobile_number	telephone_number	address_street	city	province	zip_code	country	emergency_contact_name	emergency_contact_relation	emergency_contact_phone	sss_number	philhealth_number	pagibig_number	tin_number	drivers_license	passport_number	department_id	position	department_id_2	position_2	employment_status	status	date_hired	date_regularized	created_at	updated_at	profile_picture	sss_file	philhealth_file	pagibig_file	tin_file	branch	holiday_exempted	picture_2x2_file	coe_tor_file	birth_cert_file	nbi_clearance_file	police_clearance_file	cutoff_1	cutoff_2	payroll_1	payroll_2	salary_type	basic_salary	hourly_rate	fixed_rate	daily_rate
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`id` = 1	1	123		TEST	TEST		NULL	NULL	Male	2001-12-19	FILIPINO	Single	papphar19@gmail.com	papphar19@gmail.com	09999999999		TEST	TEST	TEST	4026	PHILIPPINES								NULL	NULL	2	FACULTY-COLLEGE	NULL		Full Time	Inactive	2025-07-08	NULL	2026-06-27 10:05:56	2026-07-13 15:49:08						CABUYAO	Yes						15	30	25	10	Hourly	21500.00	150.00	15000.00	NULL
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`id` = 2	2	1234	Mr.	TTEST	TTEST		NULL	NULL	Male	2001-12-19	FILIPINO	Single	babalajonhray19@gmail.com	babalajonhray19@gmail.com	09999999999		DASDASD	DASDAS	SDSAD	4026	PHILIPPINES				123132	123132132	123132132132	123132132132	NULL	NULL	6	IT OFFICER	NULL		Part Time	Inactive	2022-12-19	NULL	2026-06-27 10:07:40	2026-07-13 15:49:05						BIÑAN	No						10	25	15	30	Monthly	25000.00	NULL	15000.00	NULL
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`id` = 3	3	21059	Mr.	MAR ANGELO	TAGAO	BURAGA	NULL	NULL	Male	1995-11-15	FILIPINO	Single	tagao.marangelo@yahoo.com	tagao.marangelo@yahoo.com	09368335257		PHASE 4 BLK 56 LOT 23 VILLA ANTHURIUM SUBD. BRGY. ...	STA ROSA	LAGUNA	4026	PHILIPPINES				01-2280129-7	1211-1174-6809	06-025203700-7	442-217-788	NULL	NULL	6	ADMINISTRATIVE OFFICER	NULL		Regular	Active	2022-05-23	NULL	2026-08-08 10:34:07	2026-08-08 10:35:39						CABUYAO	No						10	25	15	30	Monthly	9999.99	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`id` = 4	4	17201	Mr.	VINCENT	FROYALDE	BARIZO	NULL	NULL	Male	1998-01-13	FILIPINO	Married	vincentfroyalde1131998@yahoo.com	vincentfroyalde1131998@yahoo.com	09667944109		JP RIZAL ST.	CABUYAO	LAGUNA	4025	PHILIPPINES				04-4079868-4	1212-2658-5487	08-026535985-3	353-556-175	NULL	NULL	6	ADMINISTRATIVE OFFICER	NULL		Regular	Active	2018-06-13	NULL	2026-08-08 10:39:14	2026-08-08 10:39:14						CABUYAO	No						10	25	15	30	Monthly	10000.00	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`id` = 5	5	17265	Mr.	JOB	APOSTOL	BURAGA	NULL	NULL	Male	1993-01-28	FILIPINO	Single	vincentfroyalde1131998@yahoo.com	vincentfroyalde1131998@yahoo.com	09972992714		BLK 18 LOT 11 POUND ST. BRGY. BUTONG	CABUYAO	LAGUNA	4025	PHILIPPINES				04-4098970-7	1212-2897-0617	08-051586433-8	347-910-761	NULL	NULL	6	ADMINISTRATIVE OFFICER	NULL		Contractual	Active	2018-01-03	NULL	2026-08-08 10:43:51	2026-08-08 10:43:51						CABUYAO	No						10	25	15	30	Monthly	10000.00	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`id` = 6	6	17357	Mr.	INOCENCIO	BURAGA JR.	CALLUENG	NULL	NULL	Male	1977-02-18	FILIPINO	Single	vincentfroyalde1131998@yahoo.com	vincentfroyalde1131998@yahoo.com	09163001819		BLK 8 LOT 11 POUND ST. SAINT JOSEPH VILL. 8, BRGY....	CABUYAO	LAGUNA	4025	PHILIPPINES				01-1438829-4	1211-7577-2562	06-201252646-1	334-231-823	NULL	NULL	6	ADMINISTRATIVE OFFICER	NULL		Regular	Active	2011-06-01	NULL	2026-08-08 10:47:07	2026-08-08 10:47:07						CABUYAO	No						10	25	15	30	Monthly	10000.00	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`id` = 7	7	24088	Mr.	KENNETH NEHEMIAH THEODORE	RAPSING	FERMIN	NULL	NULL	Male	1995-09-08	FILIPINO	Single	kennethf.rapsing@gmail.com	kennethf.rapsing@gmail.com	09958907523		BLK 10 LOT 9, ST. JOSEPH VILLAGE 8, BRGY. BUTONG	CABUYAO	LAGUNA	4025	PHILIPPINES				04-4211357-1	1212-9458-6054	09-025825881-8	510-589-742	NULL	NULL	6	ADMINISTRATIVE OFFICER	NULL		Contractual	Active	2024-07-15	NULL	2026-08-08 10:49:31	2026-08-08 10:49:31						CABUYAO	No						10	25	15	30	Monthly	9999.97	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`id` = 8	8	24129	Mr.	JOHN LLOYD	RAZO	MALAZA	NULL	NULL	Male	2001-04-18	FILIPINO	Single	johnlloydrazo18@gmail.com	johnlloydrazo18@gmail.com	09937509725		BLK 18 LOT 29 PH2 SV 5A, BRGY. LANGKIWA	BIÑAN	LAGUNA	4024	PHILIPPINES				04-4478906-8	1213-1302-2172	08-250996302-5	631-028-966	NULL	NULL	6	ADMINISTRATIVE OFFICER	NULL		Regular	Active	2024-08-12	NULL	2026-08-08 10:51:57	2026-08-08 10:51:57						BIÑAN	No						10	25	15	30	Monthly	10000.00	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`id` = 9	9	23162	Ms.	ROSELILY	BURAGA	AGABIN	NULL	NULL	Female	2001-01-28	FILIPINO	Single	arbeeburaga@gmail.com	arbeeburaga@gmail.com	09480696416		613 LABELLA HOMES, BRGY. SALA	CABUYAO	LAGUNA	4025	PHILIPPINES				04-4478905-5	1213-1303-1629	06-251824800-1	645-375-475	NULL	NULL	6	ADMINISTRATIVE OFFICER	NULL		Contractual	Active	2023-01-09	NULL	2026-08-08 10:54:25	2026-08-08 10:54:25						BAY	No						10	25	15	30	Monthly	10000.00	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`id` = 10	10	23171	Mr.	DENNIS	ABUCAY	HERNANDEZ	NULL	NULL	Male	1997-12-12	FILIPINO	Single	denn.abucay17@gmail.com	denn.abucay17@gmail.com	09663980539		BLK 23 LOT 34 P. SV4 BRGY. CAINGIN	STA ROSA	LAGUNA	4026	PHILIPPINES				34-6139115-1	1211-7820-7051	08-026164651-3	336-252-108	NULL	NULL	6	ADMINISTRATIVE OFFICER	NULL		Regular	Active	2024-01-03	NULL	2026-08-08 10:57:42	2026-08-08 10:57:42						CABUYAO	No						10	25	15	30	Monthly	10000.00	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`id` = 11	11	17247	Ms.	AMOR	CALDERON	GALANG	NULL	NULL	Female	1981-08-31	FILIPINO	Single	vincentfroyalde1131998@yahoo.com	vincentfroyalde1131998@yahoo.com	09104117827		294 BORJA SUBDIVISION, BRGY. PARIAN	CALAMBA	LAGUNA	4027	PHILIPPINES				04-1170492-4	1210-7189-4162	08-000062675-2	250-078-101	NULL	NULL	6	ADMINISTRATIVE OFFICER	NULL		Regular	Active	2018-05-20	NULL	2026-08-08 10:59:55	2026-08-08 10:59:55						CABUYAO	No						10	25	15	30	Monthly	10000.00	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`id` = 12	12	21023	Mr.	ROMEO	CHAVEZ	GUINGAB	NULL	NULL	Male	1968-03-09	FILIPINO	Single	chavezromeo973@gmail.com	chavezromeo973@gmail.com	09233516117		PUROK IV-C PEÑAFRANCIA BRGY. MAYAMOT	ANTIPOLO	RIZAL	1870	PHILIPPINES				33-1703847-4	1211-4712-6462	03-025184376-3	166-036-309	NULL	NULL	6	ADMINISTRATIVE OFFICER	NULL		Regular	Active	2021-03-15	NULL	2026-08-08 11:02:55	2026-08-08 11:02:55						SILANG CAVITE	No						10	25	15	30	Monthly	10000.00	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`id` = 13	13	23023	Mr.	CARL NICO	LEAGUE	PADILLA	NULL	NULL	Male	1999-02-08	FILIPINO	Single	cgcstarosa@gmail.com	cgcstarosa@gmail.com	09287470489		1033 CAPTAIN PERLAS ST. BRGY. POOC	STA ROSA	LAGUNA	4026	PHILIPPINES				34-6622505-7	1211-9436-0130	08-026257705-1	336-000-197	NULL	NULL	6	ADMINISTRATIVE OFFICER	NULL		Regular	Active	2023-03-27	NULL	2026-08-08 11:04:46	2026-08-08 11:04:46						CABUYAO	No						10	25	15	30	Monthly	10000.00	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`id` = 14	14	21050	Mr.	JONE	BALETA	ALICOY	NULL	NULL	Male	1981-04-05	FILIPINO	Single	jonebaleta@gmail.com	jonebaleta@gmail.com	09506438952		METROVILLE, BRGY. BALIBAGO	STA ROSA	LAGUNA	4026	PHILIPPINES				05-0913835-0	1211-8885-6140	10-201465010-2	431-873-484	NULL	NULL	6	ADMINISTRATIVE OFFICER	NULL		Regular	Active	2021-10-04	NULL	2026-08-08 11:06:54	2026-08-08 11:06:54						BIÑAN	No						10	25	15	30	Monthly	10000.00	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`id` = 15	15	17229	Mr.	MARGIL	ARMOLLAS	DUCAY	NULL	NULL	Male	1983-05-02	FILIPINO	Single	m_armollas08@yahoo.com	m_armollas08@yahoo.com	09357333812		NIA ROAD, BRGY SAN CRISTOBAL	CALAMBA	LAGUNA	4027	PHILIPPINES				05-0626687-2	1211-2404-4012	03-050325284-4	263-550-485	NULL	NULL	6	ADMINISTRATIVE OFFICER	NULL		Regular	Active	2020-09-01	NULL	2026-08-08 11:08:56	2026-08-08 11:08:56						CALAMBA	No						10	25	15	30	Monthly	10000.00	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`id` = 16	16	17195	Mr.	HENRY	PERFIÑAN	TAGLE	NULL	NULL	Male	1987-08-24	FILIPINO	Single	henry0824@gmail.com	henry0824@gmail.com	09214233852		BLK 2 LOT 15 ST. JOSEPH HOMES 1, BRGY. GULOD	CABUYAO	LAGUNA	4025	PHILIPPINES				04-1742811-0	1211-1176-0790	01-050382924-5	461-385-960	NULL	NULL	6	ADMINISTRATIVE OFFICER	NULL		Regular	Active	2014-01-03	NULL	2026-08-08 11:13:02	2026-08-08 11:13:02						CABUYAO	No						10	25	15	30	Monthly	10000.00	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`id` = 17	17	23027	Ms.	DIANNE	VALDEZ	MAMAUAG	NULL	NULL	Female	2001-08-11	FILIPINO	Single	diannevldz001@gmail.com	diannevldz001@gmail.com	09268790910		BLK 11 LOT 60, SV1, BRGY. MARINIG	CABUYAO	LAGUNA	4025	PHILIPPINES				35-0760762-8	1212-8724-4256	08-051655042-6	601-481-670	NULL	NULL	6	ADMINISTRATIVE OFFICER	NULL		Regular	Active	2023-07-18	NULL	2026-08-08 11:16:44	2026-08-08 11:16:44						CABUYAO	No						10	25	15	30	Monthly	10000.00	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`id` = 18	18	17314	Ms.	EVALINE	ALBEROS	FUGGAY	NULL	NULL	Female	1990-07-24	FILIPINO	Single	alberosevaline1990@gmail.com	alberosevaline1990@gmail.com	09072042407		196, PUROK 4, BRGY. BIGAA	CABUYAO	LAGUNA	4025	PHILIPPINES				04-2265296-8	1212-4919-5694	08-026587184-8	749-810-084	NULL	NULL	6	ADMINISTRATIVE OFFICER	NULL		Regular	Active	2019-06-10	NULL	2026-08-08 11:18:24	2026-08-08 11:18:24						CABUYAO	No						10	25	15	30	Monthly	10000.00	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`id` = 19	19	22014	Ms.	ROSE ANNE	ATA	GARCIA	NULL	NULL	Female	2000-03-15	FILIPINO	Single	roseannata7@gmail.com	roseannata7@gmail.com	09163296003		B49 L106 PH11, SOUTHVILLE 1, BRGY. NIUGAN	CABUYAO	LAGUNA	4025	PHILIPPINES				34-9546237-3	1213-0238-0549	08-026889352-4	613-329-881	NULL	NULL	6	ADMINISTRATIVE OFFICER	NULL		Regular	Active	2022-08-01	NULL	2026-08-08 11:20:15	2026-08-08 11:20:15						BAY	No						10	25	15	30	Monthly	10000.00	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`id` = 20	20	17328	Ms.	MIAH	RAMOS	MERILL	NULL	NULL	Female	1998-01-30	FILIPINO	Single	miahmerillramos@gmail.com	miahmerillramos@gmail.com	09383566911		195, PUROK 2 BRGY. GULOD	CABUYAO	LAGUNA	4025	PHILIPPINES				34-8430006-4	1212-4988-2402	08-026590896-2	749-335-461	NULL	NULL	6	ADMINISTRATIVE OFFICER	NULL		Regular	Active	2019-06-10	NULL	2026-08-08 11:21:45	2026-08-08 11:21:45						CABUYAO	No						10	25	15	30	Monthly	9999.97	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`id` = 21	21	24144	Mr.	ISMAEL	CALLUENG	BAUI	NULL	NULL	Male	2000-02-09	FILIPINO	Single	vincentfroyalde1131998@yahoo.com	vincentfroyalde1131998@yahoo.com	09163001819		BRGY. UNO	CABUYAO	LAGUNA	4025	PHILIPPINES				02-4823778-7	1213-1277-6434	06-252111484-9	608-683-581	NULL	NULL	6	ADMINISTRATIVE OFFICER	NULL		Regular	Active	2025-01-06	NULL	2026-08-08 11:23:34	2026-08-08 11:23:34						CABUYAO	No						10	25	15	30	Monthly	10000.00	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`id` = 22	22	17301	Mr.	ROLAN	BEA	BUSTOS	NULL	NULL	Male	1975-04-19	FILIPINO	Single	vincentfroyalde1131998@yahoo.com	vincentfroyalde1131998@yahoo.com	09163001819		295 BORJA SUBD. BRGY. PARIAN	CALAMBA	LAGUNA	4027	PHILIPPINES				34-0479020-1	1211-5632-1011	08-050995125-3	753-683-453	NULL	NULL	6	ADMINISTRATIVE OFFICER	NULL		Regular	Active	2019-06-26	NULL	2026-08-08 11:27:53	2026-08-08 11:27:53						CALAMBA	No						10	25	15	30	Monthly	9999.99	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`id` = 23	23	17101	Mr.	FERDINAND	DEFANTE	ALMOETE	NULL	NULL	Male	1980-09-12	FILIPINO	Single	vincentfroyalde1131998@yahoo.com	vincentfroyalde1131998@yahoo.com	09212848103		ST. FRANCIS 1 EXT., BRGY. SAN FRANCISCO	BIÑAN	LAGUNA	4024	PHILIPPINES				33-7192149-1	1211-0595-1978	08-050411251-2	310-815-073	NULL	NULL	6	ADMINISTRATIVE OFFICER	NULL		Regular	Active	2015-08-01	NULL	2026-08-08 11:29:53	2026-08-08 11:29:53						BIÑAN	No						10	25	15	30	Monthly	10000.00	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`id` = 24	24	22086	Mr.	RYAN REY	RACHO	UBANA	NULL	NULL	Male	1987-11-17	FILIPINO	Single	vincentfroyalde1131998@yahoo.com	vincentfroyalde1131998@yahoo.com	09122044592		0175 FELIX EXT. DR. ELSOL BRGY. POBLACION	CABUYAO	LAGUNA	4025	PHILIPPINES				05-0710183-9	1213-1114-4432	10-025157747-6	513-229-101	NULL	NULL	6	ADMINISTRATIVE OFFICER	NULL		Regular	Active	2022-08-01	NULL	2026-08-08 11:31:32	2026-08-08 11:31:32						CABUYAO	No						10	25	15	30	Monthly	9999.98	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM employees WHERE `employees`.`id` = 25	25	23005	Mrs.	BRENDA	BONGALA	VISTA	NULL	NULL	Female	1977-06-28	FILIPINO	Married	vincentfroyalde1131998@yahoo.com	vincentfroyalde1131998@yahoo.com	09163001819		ST. JOSEPH 7, BLK 25 LOT 22, BRGY. MARINIG	CABUYAO	LAGUNA	4025	PHILIPPINES				04-3340318-0	1212-6203-3519	08-025422279-1	759-033-991	NULL	NULL	6	ADMINISTRATIVE OFFICER	NULL		Regular	Active	2023-01-04	NULL	2026-08-08 11:33:35	2026-08-08 11:33:35						CABUYAO	No						10	25	15	30	Monthly	10000.00	NULL	NULL	NULL

Check all With selected:

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view