docmini.tail7d306e.ts.net / 127.0.0.1 / docmini / org_110941022050

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

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

SELECT * FROM `org_110941022050`

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

Filter rows:

			id	series	number	last_name	first_name	middle_name	birth_date	birth_place	issue_date	expiry_date	issued_by	iin	notes	svedenie_no	load_date	permission_number Номер разрешения KZ...	permission_date Дата выдачи разрешения	position Должность/профессия	position_detail Уточнение должности	vacancy_code	permission_from Срок действия с	permission_to Срок действия по	decision_info Основание (решение)	work_method Метод работы	status active / replaced / cancelled	permission_file Путь к PDF разрешения	created_at	updated_at	pfz_no	valid_from	valid_to
Edit	Copy	Delete DELETE FROM org_110941022050 WHERE `org_110941022050`.`id` = 1	1	NULL	ER4525403	AI	SULIANG	NULL	1987-09-21	NULL	2026-03-03	2036-03-02	NATIONAL IMMIGRATION ADMINISTRATION, PRC	NULL	NULL	св1	2026-06-08	KZ63VDW00457873	2026-06-23	СЕЗОННЫЕ РАБОЧИЕ	Неквалифицированные рабочие в сфере строительства ...	NULL	2026-06-11	2027-06-10	РЕШЕНИЕ №453 от 11.06.2026	ПОСТОЯННЫЙ	active	perm_1786450350_16_d21fe2.pdf	2026-08-11 15:58:18	2026-08-11 17:12:52	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_110941022050 WHERE `org_110941022050`.`id` = 2	2	NULL	EJ6705571	AI	WANTAO	NULL	1976-10-25	NULL	2023-01-16	2033-01-15	NATIONAL IMMIGRATION ADMINISTRATION, PRC	NULL	NULL	св1	2026-06-08	KZ09VDW00457875	2026-06-23	СЕЗОННЫЕ РАБОЧИЕ	Неквалифицированные рабочие в сфере строительства ...	NULL	2026-06-11	2027-06-10	РЕШЕНИЕ №453 от 11.06.2026	ПОСТОЯННЫЙ	active	perm_1786450341_2_89d33f.pdf	2026-08-11 15:58:18	2026-08-11 17:12:51	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_110941022050 WHERE `org_110941022050`.`id` = 3	3	NULL	EJ0540900	CAO	YUBO	NULL	1979-03-17	NULL	2020-01-09	2030-01-08	NATIONAL IMMIGRATION ADMINISTRATION, PRC	NULL	NULL	св1	2026-06-08	KZ52VDW00457877	2026-06-23	СЕЗОННЫЕ РАБОЧИЕ	Неквалифицированные рабочие в сфере строительства ...	NULL	2026-06-11	2027-06-10	РЕШЕНИЕ №453 от 11.06.2026	ПОСТОЯННЫЙ	active	perm_1786450348_13_c83793.pdf	2026-08-11 15:58:18	2026-08-11 17:12:52	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_110941022050 WHERE `org_110941022050`.`id` = 4	4	NULL	EL5656575	DAI	LONGTAO	NULL	1978-05-04	NULL	2024-01-04	2034-01-03	NATIONAL IMMIGRATION ADMINISTRATION, PRC	NULL	NULL	св1	2026-06-08	KZ95VDW00457879	2026-06-23	СЕЗОННЫЕ РАБОЧИЕ	Неквалифицированные рабочие в сфере строительства ...	NULL	2026-06-11	2027-06-10	РЕШЕНИЕ №453 от 11.06.2026	ПОСТОЯННЫЙ	active	perm_1786450355_24_1a3b6e.pdf	2026-08-11 15:58:18	2026-08-11 17:12:53	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_110941022050 WHERE `org_110941022050`.`id` = 5	5	NULL	EM1808190	GUO	HONGWEI	NULL	1975-07-05	NULL	2024-03-25	2034-03-24	NATIONAL IMMIGRATION ADMINISTRATION, PRC	NULL	NULL	св1	2026-06-08	KZ41VDW00457881	2026-06-23	СЕЗОННЫЕ РАБОЧИЕ	Неквалифицированные рабочие в сфере строительства ...	NULL	2026-06-11	2027-06-10	РЕШЕНИЕ №453 от 11.06.2026	ПОСТОЯННЫЙ	active	perm_1786450346_10_e0f0e1.pdf	2026-08-11 15:58:19	2026-08-11 17:12:52	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_110941022050 WHERE `org_110941022050`.`id` = 6	6	NULL	EF8826408	HAN	ZHONGHUA	NULL	1971-06-08	NULL	2019-04-02	2029-04-01	NATIONAL IMMIGRATION ADMINISTRATION, PRC	NULL	NULL	св1	2026-06-08	KZ84VDW00457883	2026-06-23	СЕЗОННЫЕ РАБОЧИЕ	Неквалифицированные рабочие в сфере строительства ...	NULL	2026-06-11	2027-06-10	РЕШЕНИЕ №453 от 11.06.2026	ПОСТОЯННЫЙ	active	perm_1786450353_21_5fa51b.pdf	2026-08-11 15:58:19	2026-08-11 17:12:52	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_110941022050 WHERE `org_110941022050`.`id` = 7	7	NULL	EJ3483741	HE	CHANGJUN	NULL	1993-06-29	NULL	2022-02-25	2032-02-24	NATIONAL IMMIGRATION ADMINISTRATION, PRC	NULL	NULL	св1	2026-06-08	KZ30VDW00457885	2026-06-23	СЕЗОННЫЕ РАБОЧИЕ	Неквалифицированные рабочие в сфере строительства ...	NULL	2026-06-11	2027-06-10	РЕШЕНИЕ №453 от 11.06.2026	ПОСТОЯННЫЙ	active	perm_1786450344_7_97c775.pdf	2026-08-11 15:58:19	2026-08-11 17:12:52	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_110941022050 WHERE `org_110941022050`.`id` = 8	8	NULL	EL0621358	LI	JIANQIANG	NULL	1976-09-16	NULL	2023-09-15	2033-09-14	NATIONAL IMMIGRATION ADMINISTRATION, PRC	NULL	NULL	св1	2026-06-08	KZ73VDW00457887	2026-06-23	СЕЗОННЫЕ РАБОЧИЕ	Неквалифицированные рабочие в сфере строительства ...	NULL	2026-06-11	2027-06-10	РЕШЕНИЕ №453 от 11.06.2026	ПОСТОЯННЫЙ	active	perm_1786450351_18_e47192.pdf	2026-08-11 15:58:19	2026-08-11 17:12:52	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_110941022050 WHERE `org_110941022050`.`id` = 9	9	NULL	EN6267913	LI	XIAODONG	NULL	1990-08-10	NULL	2024-11-19	2034-11-18	NATIONAL IMMIGRATION ADMINISTRATION, PRC	NULL	NULL	св1	2026-06-08	KZ19VDW00457889	2026-06-23	СЕЗОННЫЕ РАБОЧИЕ	Неквалифицированные рабочие в сфере строительства ...	NULL	2026-06-11	2027-06-10	РЕШЕНИЕ №453 от 11.06.2026	ПОСТОЯННЫЙ	active	perm_1786450342_4_dc43c6.pdf	2026-08-11 15:58:19	2026-08-11 17:12:52	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_110941022050 WHERE `org_110941022050`.`id` = 10	10	NULL	EN9253677	LIU	CHENGQI	NULL	1967-08-24	NULL	2025-02-10	2035-02-09	NATIONAL IMMIGRATION ADMINISTRATION, PRC	NULL	NULL	св1	2026-06-08	KZ62VDW00457891	2026-06-23	СЕЗОННЫЕ РАБОЧИЕ	Неквалифицированные рабочие в сфере строительства ...	NULL	2026-06-11	2027-06-10	РЕШЕНИЕ №453 от 11.06.2026	ПОСТОЯННЫЙ	active	perm_1786450349_15_d4493c.pdf	2026-08-11 15:58:19	2026-08-11 17:12:52	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_110941022050 WHERE `org_110941022050`.`id` = 11	11	NULL	ER2790681	LIU	HUASHENG	NULL	1982-03-25	NULL	2026-02-13	2036-02-12	NATIONAL IMMIGRATION ADMINISTRATION, PRC	NULL	NULL	св1	2026-06-08	KZ08VDW00457893	2026-06-23	СЕЗОННЫЕ РАБОЧИЕ	Неквалифицированные рабочие в сфере строительства ...	NULL	2026-06-11	2027-06-10	РЕШЕНИЕ №453 от 11.06.2026	ПОСТОЯННЫЙ	active	perm_1786450340_1_14c623.pdf	2026-08-11 15:58:19	2026-08-11 17:12:51	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_110941022050 WHERE `org_110941022050`.`id` = 12	12	NULL	EQ9824223	LIU	QIUCAI	NULL	1971-04-05	NULL	2025-12-26	2035-12-25	NATIONAL IMMIGRATION ADMINISTRATION, PRC	NULL	NULL	св1	2026-06-08	KZ51VDW00457895	2026-06-23	СЕЗОННЫЕ РАБОЧИЕ	Неквалифицированные рабочие в сфере строительства ...	NULL	2026-06-11	2027-06-10	РЕШЕНИЕ №453 от 11.06.2026	ПОСТОЯННЫЙ	active	perm_1786450347_12_9802dd.pdf	2026-08-11 15:58:19	2026-08-11 17:12:52	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_110941022050 WHERE `org_110941022050`.`id` = 13	13	NULL	EH8404933	LU	YUEWU	NULL	1983-01-23	NULL	2019-11-29	2029-11-28	NATIONAL IMMIGRATION ADMINISTRATION, PRC	NULL	NULL	св1	2026-06-08	KZ94VDW00457897	2026-06-23	СЕЗОННЫЕ РАБОЧИЕ	Неквалифицированные рабочие в сфере строительства ...	NULL	2026-06-11	2027-06-10	РЕШЕНИЕ №453 от 11.06.2026	ПОСТОЯННЫЙ	active	perm_1786450354_23_bdd1b0.pdf	2026-08-11 15:58:19	2026-08-11 17:12:52	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_110941022050 WHERE `org_110941022050`.`id` = 14	14	NULL	ER2760604	SHAO	YOUSHENG	NULL	1985-09-21	NULL	2026-02-04	2036-02-03	NATIONAL IMMIGRATION ADMINISTRATION, PRC	NULL	NULL	св1	2026-06-08	KZ40VDW00457899	2026-06-23	СЕЗОННЫЕ РАБОЧИЕ	Неквалифицированные рабочие в сфере строительства ...	NULL	2026-06-11	2027-06-10	РЕШЕНИЕ №453 от 11.06.2026	ПОСТОЯННЫЙ	active	perm_1786450345_9_99169b.pdf	2026-08-11 15:58:19	2026-08-11 17:12:52	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_110941022050 WHERE `org_110941022050`.`id` = 15	15	NULL	EL5655906	SHI	GANG	NULL	1987-09-20	NULL	2024-01-04	2034-01-03	NATIONAL IMMIGRATION ADMINISTRATION, PRC	NULL	NULL	св1	2026-06-08	KZ83VDW00457901	2026-06-23	СЕЗОННЫЕ РАБОЧИЕ	Неквалифицированные рабочие в сфере строительства ...	NULL	2026-06-11	2027-06-10	РЕШЕНИЕ №453 от 11.06.2026	ПОСТОЯННЫЙ	active	perm_1786450353_20_8855e8.pdf	2026-08-11 15:58:19	2026-08-11 17:12:52	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_110941022050 WHERE `org_110941022050`.`id` = 16	16	NULL	EJ6397323	WANG	JIAN	NULL	1982-04-06	NULL	2022-10-17	2032-10-16	NATIONAL IMMIGRATION ADMINISTRATION, PRC	NULL	NULL	св1	2026-06-08	KZ29VDW00457903	2026-06-23	СЕЗОННЫЕ РАБОЧИЕ	Неквалифицированные рабочие в сфере строительства ...	NULL	2026-06-11	2027-06-10	РЕШЕНИЕ №453 от 11.06.2026	ПОСТОЯННЫЙ	active	perm_1786450344_6_6d5978.pdf	2026-08-11 15:58:19	2026-08-11 17:12:52	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_110941022050 WHERE `org_110941022050`.`id` = 17	17	NULL	EK4069736	WU	YONGKANG	NULL	1992-12-21	NULL	2023-05-12	2033-05-11	NATIONAL IMMIGRATION ADMINISTRATION, PRC	NULL	NULL	св1	2026-06-08	KZ72VDW00457905	2026-06-23	СЕЗОННЫЕ РАБОЧИЕ	Неквалифицированные рабочие в сфере строительства ...	NULL	2026-06-11	2027-06-10	РЕШЕНИЕ №453 от 11.06.2026	ПОСТОЯННЫЙ	active	perm_1786450351_17_45f587.pdf	2026-08-11 15:58:19	2026-08-11 17:12:52	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_110941022050 WHERE `org_110941022050`.`id` = 18	18	NULL	EJ3485181	XIE	HOUBING	NULL	1974-12-29	NULL	2022-03-15	2032-03-14	NATIONAL IMMIGRATION ADMINISTRATION, PRC	NULL	NULL	св1	2026-06-08	KZ18VDW00457907	2026-06-23	СЕЗОННЫЕ РАБОЧИЕ	Неквалифицированные рабочие в сфере строительства ...	NULL	2026-06-11	2027-06-10	РЕШЕНИЕ №453 от 11.06.2026	ПОСТОЯННЫЙ	active	perm_1786450342_3_948393.pdf	2026-08-11 15:58:20	2026-08-11 17:12:51	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_110941022050 WHERE `org_110941022050`.`id` = 19	19	NULL	EJ5895826	YANG	XINGKAI	NULL	1971-01-17	NULL	2022-06-13	2032-06-12	NATIONAL IMMIGRATION ADMINISTRATION, PRC	NULL	NULL	св1	2026-06-08	KZ88VDW00457908	2026-06-23	СЕЗОННЫЕ РАБОЧИЕ	Неквалифицированные рабочие в сфере строительства ...	NULL	2026-06-11	2027-06-10	РЕШЕНИЕ №453 от 11.06.2026	ПОСТОЯННЫЙ	active	perm_1786450354_22_4ac188.pdf	2026-08-11 15:58:20	2026-08-11 17:12:52	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_110941022050 WHERE `org_110941022050`.`id` = 20	20	NULL	EJ2215323	YANG	XINGPING	NULL	1968-10-14	NULL	2020-03-18	2030-03-17	NATIONAL IMMIGRATION ADMINISTRATION, PRC	NULL	NULL	св1	2026-06-08	KZ61VDW00457909	2026-06-23	СЕЗОННЫЕ РАБОЧИЕ	Неквалифицированные рабочие в сфере строительства ...	NULL	2026-06-11	2027-06-10	РЕШЕНИЕ №453 от 11.06.2026	ПОСТОЯННЫЙ	active	perm_1786450349_14_953efd.pdf	2026-08-11 15:58:20	2026-08-11 17:12:52	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_110941022050 WHERE `org_110941022050`.`id` = 21	21	NULL	EP2962722	YI	JUN	NULL	1982-06-19	NULL	2025-02-19	2035-02-18	NATIONAL IMMIGRATION ADMINISTRATION, PRC	NULL	NULL	св1	2026-06-08	KZ34VDW00457910	2026-06-23	СЕЗОННЫЕ РАБОЧИЕ	Неквалифицированные рабочие в сфере строительства ...	NULL	2026-06-11	2027-06-10	РЕШЕНИЕ №453 от 11.06.2026	ПОСТОЯННЫЙ	active	perm_1786450345_8_f68d7e.pdf	2026-08-11 15:58:20	2026-08-11 17:12:52	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_110941022050 WHERE `org_110941022050`.`id` = 22	22	NULL	EB8033430	YUAN	ZETAO	NULL	1990-08-08	NULL	2017-11-27	2027-11-26	MPS EXIT & ENTRY ADMINISTRATION	NULL	NULL	св1	2026-06-08	KZ07VDW00457911	2026-06-23	СЕЗОННЫЕ РАБОЧИЕ	Неквалифицированные рабочие в сфере строительства ...	NULL	2026-06-11	2027-06-10	РЕШЕНИЕ №453 от 11.06.2026	ПОСТОЯННЫЙ	active	perm_1786450340_0_f7c6f3.pdf	2026-08-11 15:58:20	2026-08-11 17:12:51	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_110941022050 WHERE `org_110941022050`.`id` = 23	23	NULL	EJ5899408	ZHA	JINHENG	NULL	1979-03-15	NULL	2022-07-05	2032-07-04	NATIONAL IMMIGRATION ADMINISTRATION, PRC	NULL	NULL	св1	2026-06-08	KZ77VDW00457912	2026-06-23	СЕЗОННЫЕ РАБОЧИЕ	Неквалифицированные рабочие в сфере строительства ...	NULL	2026-06-11	2027-06-10	РЕШЕНИЕ №453 от 11.06.2026	ПОСТОЯННЫЙ	active	perm_1786450352_19_ca70c7.pdf	2026-08-11 15:58:20	2026-08-11 17:12:52	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_110941022050 WHERE `org_110941022050`.`id` = 24	24	NULL	EJ8470699	ZHANG	AIGUO	NULL	1973-11-26	NULL	2023-02-08	2033-02-07	NATIONAL IMMIGRATION ADMINISTRATION, PRC	NULL	NULL	св1	2026-06-08	KZ50VDW00457913	2026-06-23	СЕЗОННЫЕ РАБОЧИЕ	Неквалифицированные рабочие в сфере строительства ...	NULL	2026-06-11	2027-06-10	РЕШЕНИЕ №453 от 11.06.2026	ПОСТОЯННЫЙ	active	perm_1786450347_11_1cc72c.pdf	2026-08-11 15:58:20	2026-08-11 17:12:52	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_110941022050 WHERE `org_110941022050`.`id` = 25	25	NULL	EJ3483740	ZHANG	FENGMING	NULL	1992-09-09	NULL	2022-02-25	2032-02-24	NATIONAL IMMIGRATION ADMINISTRATION, PRC	NULL	NULL	св1	2026-06-08	KZ23VDW00457914	2026-06-23	СЕЗОННЫЕ РАБОЧИЕ	Неквалифицированные рабочие в сфере строительства ...	NULL	2026-06-11	2027-06-10	РЕШЕНИЕ №453 от 11.06.2026	ПОСТОЯННЫЙ	active	perm_1786450343_5_d8ee4e.pdf	2026-08-11 15:58:20	2026-08-11 17:12:52	NULL	NULL	NULL

Check all With selected:

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view