docmini.tail7d306e.ts.net / 127.0.0.1 / docmini / org_250740034654

`docmini`.`org_250740034654`

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

SELECT * FROM `org_250740034654`

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

Filter rows:

Sort by key:

			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	permission_date	position	position_detail	vacancy_code	permission_from	permission_to	decision_info	work_method	status	permission_file	created_at	updated_at	pfz_no	valid_from	valid_to
Edit	Copy	Delete DELETE FROM org_250740034654 WHERE `org_250740034654`.`id` = 11	11	NULL	EM4408523	CUI	GUOMING	NULL	1989-01-13	NULL	2024-05-08	2034-05-07	NATIONAL IMMIGRATION ADMINISTRATION, PRC	NULL	ПФЗ:ПФЗ-1	св2	2026-01-02	KZ50VDW00438610	2026-01-26	Неквалифицированный строительный рабочий	Неквалифицированные рабочие в сфере сроительства (...	PRa057dd3545e79f	2026-01-23	2027-01-22	РЕШЕНИЕ №45 от 23	ПОСТОЯННЫЙ	выбывание	perm_1786466500_0_71d2df.pdf	2026-08-11 19:38:17	2026-09-16 01:17:42	ПФЗ-1	NULL	NULL
Edit	Copy	Delete DELETE FROM org_250740034654 WHERE `org_250740034654`.`id` = 12	12	NULL	ER0636501	CUI	SHUKAI	NULL	1995-05-06	NULL	2025-12-26	2035-12-25	NATIONAL IMMIGRATION ADMINISTRATION, PRC	NULL	NULL	св2	2026-01-02	KZ23VDW00438611	2026-01-26	Неквалифицированный строительный рабочий	Неквалифицированные рабочие в сфере сроительства (...	PRa057dd3545e79f	2026-01-23	2027-01-22	РЕШЕНИЕ №45 от 23	ПОСТОЯННЫЙ	active	perm_1786466501_1_78828b.pdf	2026-08-11 19:38:17	2026-08-12 09:09:25	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_250740034654 WHERE `org_250740034654`.`id` = 13	13	NULL	EJ9090670	GUO	RUIJUN	NULL	1986-10-28	NULL	2023-02-17	2033-02-16	NATIONAL IMMIGRATION ADMINISTRATION, PRC	NULL	NULL	св2	2026-01-02	KZ93VDW00438612	2026-01-26	Неквалифицированный строительный рабочий	Неквалифицированные рабочие в сфере сроительства (...	PRa057dd3545e79f	2026-01-23	2027-01-22	РЕШЕНИЕ №45 от 23	ПОСТОЯННЫЙ	active	perm_1786466501_2_aa836f.pdf	2026-08-11 19:38:18	2026-08-12 09:09:25	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_250740034654 WHERE `org_250740034654`.`id` = 14	14	NULL	EC2929362	LI	CHAOLIN	NULL	1986-03-18	NULL	2018-02-07	2028-02-06	MPS EXIT & ENTRY ADMINISTRATION	NULL	NULL	св2	2026-01-02	KZ66VDW00438613	2026-01-26	Неквалифицированный строительный рабочий	Неквалифицированные рабочие в сфере сроительства (...	PRa057dd3545e79f	2026-01-23	2027-01-22	РЕШЕНИЕ №45 от 23	ПОСТОЯННЫЙ	active	perm_1786466502_3_167c39.pdf	2026-08-11 19:38:18	2026-08-12 09:09:25	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_250740034654 WHERE `org_250740034654`.`id` = 15	15	NULL	EJ2644420	LI	HAIQING	NULL	1971-11-06	NULL	2021-07-09	2031-07-08	NATIONAL IMMIGRATION ADMINISTRATION, PRC	NULL	NULL	св2	2026-01-02	KZ12VDW00438615	2026-01-26	Неквалифицированный строительный рабочий	Неквалифицированные рабочие в сфере сроительства (...	PRa057dd3545e79f	2026-01-23	2027-01-22	РЕШЕНИЕ №45 от 23	ПОСТОЯННЫЙ	active	perm_1786466503_4_aa6074.pdf	2026-08-11 19:38:18	2026-08-12 09:09:25	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_250740034654 WHERE `org_250740034654`.`id` = 16	16	NULL	E97044363	QIN	DONGFANG	NULL	1984-08-19	NULL	2017-02-22	2027-02-21	MPS EXIT & ENTRY ADMINISTRATION	NULL	ПФЗ:ПФЗ-1	св2	2026-01-02	KZ82VDW00438616	2026-01-26	Неквалифицированный строительный рабочий	Неквалифицированные рабочие в сфере сроительства (...	PRa057dd3545e79f	2026-01-23	2027-01-22	РЕШЕНИЕ №45 от 23	ПОСТОЯННЫЙ	выбывание	perm_1786466503_5_d98593.pdf	2026-08-11 19:38:18	2026-09-16 01:20:30	ПФЗ-1	NULL	NULL
Edit	Copy	Delete DELETE FROM org_250740034654 WHERE `org_250740034654`.`id` = 17	17	NULL	EP9645640	SONG	JINCAI	NULL	1977-07-03	NULL	2025-06-13	2035-06-12	NATIONAL IMMIGRATION ADMINISTRATION, PRC	NULL	NULL	св2	2026-01-02	KZ55VDW00438617	2026-01-26	Неквалифицированные рабочие в сфере строительства ...	СЕЗОННЫЕ РАБОЧИЕ	PRa057dd3545e79f	2026-01-23	2027-01-22	РЕШЕНИЕ №45 от 23	ПОСТОЯННЫЙ	active	perm_1787135942_0_fcd123.pdf	2026-08-11 19:38:18	2026-08-19 15:39:04	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_250740034654 WHERE `org_250740034654`.`id` = 18	18	NULL	ER0622191	WANG	GUOQIANG	NULL	1979-10-07	NULL	2025-12-19	2035-12-18	NATIONAL IMMIGRATION ADMINISTRATION, PRC	NULL	NULL	св2	2026-01-02	KZ28VDW00438618	2026-01-26	Неквалифицированный строительный рабочий	Неквалифицированные рабочие в сфере сроительства (...	PRa057dd3545e79f	2026-01-23	2027-01-22	РЕШЕНИЕ №45 от 23	ПОСТОЯННЫЙ	active	perm_1786466504_6_8e27b5.pdf	2026-08-11 19:38:18	2026-08-12 09:09:25	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_250740034654 WHERE `org_250740034654`.`id` = 19	19	NULL	ER0614618	WANG	YUNSHAN	NULL	1969-03-25	NULL	2025-12-16	2035-12-15	NATIONAL IMMIGRATION ADMINISTRATION, PRC	NULL	NULL	св2	2026-01-02	KZ01VDW00438619	2026-01-26	Неквалифицированный строительный рабочий	Неквалифицированные рабочие в сфере сроительства (...	PRa057dd3545e79f	2026-01-23	2027-01-22	РЕШЕНИЕ №45 от 23	ПОСТОЯННЫЙ	active	perm_1786466504_7_2af3f8.pdf	2026-08-11 19:38:18	2026-08-12 09:09:26	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_250740034654 WHERE `org_250740034654`.`id` = 20	20	NULL	ER0633700	YANG	MINGSHAN	NULL	1968-07-06	NULL	2025-12-25	2035-12-24	NATIONAL IMMIGRATION ADMINISTRATION, PRC	NULL	NULL	св2	2026-01-02	KZ71VDW00438620	2026-01-26	Неквалифицированный строительный рабочий	Неквалифицированные рабочие в сфере сроительства (...	PRa057dd3545e79f	2026-01-23	2027-01-22	РЕШЕНИЕ №45 от 23	ПОСТОЯННЫЙ	active	perm_1786466505_8_5e2139.pdf	2026-08-11 19:38:18	2026-08-12 09:09:26	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_250740034654 WHERE `org_250740034654`.`id` = 21	21	NULL	EQ9944503	HOU	JIANGHAI	NULL	1980-11-15	NULL	2025-12-05	2035-12-04	NATIONAL IMMIGRATION ADMINISTRATION, PRC	NULL	NULL	св3	2026-01-03	KZ44VDW00438621	2026-01-26	Неквалифицированный строительный рабочий	Неквалифицированные рабочие в сфере сроительства (...	PRa057dd3545e79f	2026-01-23	2027-01-22	РЕШЕНИЕ №46 от 23	ПОСТОЯННЫЙ	active	perm_1786466596_0_4fd493.pdf	2026-08-11 19:38:37	2026-08-12 09:09:35	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_250740034654 WHERE `org_250740034654`.`id` = 22	22	NULL	EJ5771511	LIU	HAIQING	NULL	1979-07-26	NULL	2022-06-24	2032-06-23	EMBASSY OF P.R.CHINA IN D.R.CONGO	NULL	NULL	св3	2026-01-03	KZ17VDW00438622	2026-01-26	Неквалифицированный строительный рабочий	Неквалифицированные рабочие в сфере сроительства (...	PRa057dd3545e79f	2026-01-23	2027-01-22	РЕШЕНИЕ №46 от 23	ПОСТОЯННЫЙ	active	perm_1786466597_1_5ad443.pdf	2026-08-11 19:38:38	2026-08-12 09:09:35	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_250740034654 WHERE `org_250740034654`.`id` = 23	23	NULL	EA2617471	LIU	XIANGBING	NULL	1974-09-25	NULL	2017-05-18	2027-05-17	MPS EXIT & ENTRY ADMINISTRATION	NULL	NULL	св3	2026-01-03	KZ87VDW00438623	2026-01-26	Неквалифицированный строительный рабочий	Неквалифицированные рабочие в сфере сроительства (...	PRa057dd3545e79f	2026-01-23	2027-01-22	РЕШЕНИЕ №46 от 23	ПОСТОЯННЫЙ	active	perm_1786466597_2_9939f7.pdf	2026-08-11 19:38:38	2026-08-12 09:09:35	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_250740034654 WHERE `org_250740034654`.`id` = 24	24	NULL	EE4573535	LIU	YONGSHENG	NULL	1980-01-14	NULL	2018-10-10	2028-10-09	MPS EXIT & ENTRY ADMINISTRATION	NULL	NULL	св3	2026-01-03	KZ60VDW00438624	2026-01-26	Неквалифицированный строительный рабочий	Неквалифицированные рабочие в сфере сроительства (...	PRa057dd3545e79f	2026-01-23	2027-01-22	РЕШЕНИЕ №46 от 23	ПОСТОЯННЫЙ	active	perm_1786466598_3_643b45.pdf	2026-08-11 19:38:38	2026-08-12 09:09:35	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_250740034654 WHERE `org_250740034654`.`id` = 25	25	NULL	EC2925682	LIU	ZHENHUA	NULL	1986-10-29	NULL	2018-02-06	2028-02-05	MPS EXIT & ENTRY ADMINISTRATION	NULL	NULL	св3	2026-01-03	KZ33VDW00438625	2026-01-26	Неквалифицированный строительный рабочий	Неквалифицированные рабочие в сфере сроительства (...	PRa057dd3545e79f	2026-01-23	2027-01-22	РЕШЕНИЕ №46 от 23	ПОСТОЯННЫЙ	active	perm_1786466599_4_9037c0.pdf	2026-08-11 19:38:38	2026-08-12 09:09:35	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_250740034654 WHERE `org_250740034654`.`id` = 26	26	NULL	EF6460413	WAN	GUOLI	NULL	1984-05-09	NULL	2019-03-04	2029-03-03	NATIONAL IMMIGRATION ADMINISTRATION, PRC	NULL	NULL	св3	2026-01-03	KZ06VDW00438626	2026-01-26	Неквалифицированный строительный рабочий	Неквалифицированные рабочие в сфере сроительства (...	PRa057dd3545e79f	2026-01-23	2027-01-22	РЕШЕНИЕ №46 от 23	ПОСТОЯННЫЙ	active	perm_1786466599_5_6906da.pdf	2026-08-11 19:38:38	2026-08-12 09:09:35	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_250740034654 WHERE `org_250740034654`.`id` = 27	27	NULL	EQ9951687	WANG	ZHIPENG	NULL	1990-03-31	NULL	2025-12-09	2035-12-08	NATIONAL IMMIGRATION ADMINISTRATION, PRC	NULL	NULL	св3	2026-01-03	KZ49VDW00438628	2026-01-26	Неквалифицированный строительный рабочий	Неквалифицированные рабочие в сфере сроительства (...	PRa057dd3545e79f	2026-01-23	2027-01-22	РЕШЕНИЕ №46 от 23	ПОСТОЯННЫЙ	active	perm_1786466600_6_166702.pdf	2026-08-11 19:38:38	2026-08-12 09:09:35	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_250740034654 WHERE `org_250740034654`.`id` = 28	28	NULL	EJ3570338	ZHANG	GUOFANG	NULL	1987-08-02	NULL	2023-01-09	2033-01-08	NATIONAL IMMIGRATION ADMINISTRATION, PRC	NULL	NULL	св3	2026-01-03	KZ76VDW00438627	2026-01-26	Неквалифицированный строительный рабочий	Неквалифицированные рабочие в сфере сроительства (...	PRa057dd3545e79f	2026-01-23	2027-01-22	РЕШЕНИЕ №46 от 23	ПОСТОЯННЫЙ	active	perm_1786466601_7_f552eb.pdf	2026-08-11 19:38:38	2026-08-12 09:09:35	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_250740034654 WHERE `org_250740034654`.`id` = 29	29	NULL	EC3202438	ZHANG	YONGQIANG	NULL	1985-02-25	NULL	2018-02-11	2028-02-10	MPS EXIT & ENTRY ADMINISTRATION	NULL	NULL	св3	2026-01-03	KZ22VDW00438629	2026-01-26	Неквалифицированный строительный рабочий	Неквалифицированные рабочие в сфере сроительства (...	PRa057dd3545e79f	2026-01-23	2027-01-22	РЕШЕНИЕ №46 от 23	ПОСТОЯННЫЙ	active	perm_1786466601_8_fcac96.pdf	2026-08-11 19:38:38	2026-08-12 09:09:35	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_250740034654 WHERE `org_250740034654`.`id` = 30	30	NULL	EC3235627	ZHAO	XUEMING	NULL	1985-01-08	NULL	2018-02-23	2028-02-22	MPS EXIT & ENTRY ADMINISTRATION	NULL	NULL	св3	2026-01-03	KZ92VDW00438630	2026-01-26	Неквалифицированный строительный рабочий	Неквалифицированные рабочие в сфере сроительства (...	PRa057dd3545e79f	2026-01-23	2027-01-22	РЕШЕНИЕ №46 от 23	ПОСТОЯННЫЙ	active	perm_1786466602_9_2a49ad.pdf	2026-08-11 19:38:38	2026-08-12 09:09:35	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_250740034654 WHERE `org_250740034654`.`id` = 31	31	NULL	EP9649681	LIU	CHENGLIANG	NULL	1984-04-29	NULL	2025-06-16	2035-06-15	NATIONAL IMMIGRATION ADMINISTRATION, PRC	NULL	NULL	св4	2026-01-04	KZ65VDW00438631	2026-01-26	Неквалифицированный строительный рабочий	Неквалифицированные рабочие в сфере сроительства (...	PRa057dd3545e79f	2026-01-23	2027-01-22	РЕШЕНИЕ №47 от 23	ПОСТОЯННЫЙ	active	perm_1786467008_0_596db6.pdf	2026-08-11 19:38:56	2026-08-12 09:09:40	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_250740034654 WHERE `org_250740034654`.`id` = 32	32	NULL	EC0846472	LIU	GUOLIN	NULL	1973-03-15	NULL	2018-01-08	2028-01-07	MPS EXIT & ENTRY ADMINISTRATION	NULL	NULL	св4	2026-01-04	KZ38VDW00438632	2026-01-26	Неквалифицированный строительный рабочий	Неквалифицированные рабочие в сфере сроительства (...	PRa057dd3545e79f	2026-01-23	2027-01-22	РЕШЕНИЕ №47 от 23	ПОСТОЯННЫЙ	active	perm_1786467008_1_a15043.pdf	2026-08-11 19:38:56	2026-08-12 09:09:41	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_250740034654 WHERE `org_250740034654`.`id` = 33	33	NULL	EC0129443	LIU	WANJIE	NULL	1992-10-19	NULL	2017-12-26	2027-12-25	MPS EXIT & ENTRY ADMINISTRATION	NULL	NULL	св4	2026-01-04	KZ81VDW00438634	2026-01-26	Неквалифицированный строительный рабочий	Неквалифицированные рабочие в сфере сроительства (...	PRa057dd3545e79f	2026-01-23	2027-01-22	РЕШЕНИЕ №47 от 23	ПОСТОЯННЫЙ	active	perm_1786467009_2_dc922a.pdf	2026-08-11 19:38:56	2026-08-12 09:09:41	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_250740034654 WHERE `org_250740034654`.`id` = 34	34	NULL	EH8970740	SUN	MINGSHUAN	NULL	1966-05-02	NULL	2019-12-10	2029-12-09	NATIONAL IMMIGRATION ADMINISTRATION, PRC	NULL	NULL	св4	2026-01-04	KZ11VDW00438633	2026-01-26	Неквалифицированный строительный рабочий	Неквалифицированные рабочие в сфере сроительства (...	PRa057dd3545e79f	2026-01-23	2027-01-22	РЕШЕНИЕ №47 от 23	ПОСТОЯННЫЙ	active	perm_1786467010_3_107e62.pdf	2026-08-11 19:38:56	2026-08-12 09:09:41	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM org_250740034654 WHERE `org_250740034654`.`id` = 35	35	NULL	EC0136332	SUN	QINGSHUAN	NULL	1970-01-13	NULL	2017-12-28	2027-12-27	MPS EXIT & ENTRY ADMINISTRATION	NULL	NULL	св4	2026-01-04	KZ00VDW00438637	2026-01-26	Неквалифицированный строительный рабочий	Неквалифицированные рабочие в сфере сроительства (...	PRa057dd3545e79f	2026-01-23	2027-01-22	РЕШЕНИЕ №47 от 23	ПОСТОЯННЫЙ	active	perm_1786467011_4_fbf666.pdf	2026-08-11 19:38:56	2026-08-12 09:09:41	NULL	NULL	NULL

Check all With selected:

Filter rows:

Sort by key:

Query results operations

Copy to clipboard

Export

Display chart

Create view