converter.dvl.to / mysql / a04004_magelan / aci_payment_session

There are no favorite tables.

Navigation panel
Navigation tree
Servers
Databases
Tables

Navigation panel

Customize appearance of the 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.

Navigation tree

Customize the 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

Servers display options.

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

Databases display options.

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

Tables

Tables display options.

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 Bookmark Query failed Database : Queried time :

Browse mode

Browse mode

Customize 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 (416 total, Query took 0.0006 seconds.)

SELECT * FROM `aci_payment_session`

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

Filter rows:

			id	bases_id	date_update	date_create	code последний код ответа по сессии	session_id Идентификатор сессии операции	payment_id Идентификатор успешной операции	status 0-new. 1 - pending, 2 - decline, 3 - success	entity_id Идентификатор клиентского модуля	mz_id Идентификатор заказа ЛК op_mz.id	deadline Expire payment link	payment_profile JSON data for recurring transactions, e.g. {"id":"…	refunded_amount Сумма уже выполненных возвратов	checker GUID Ð¿Ñ€Ð¾Ñ†ÐµÑÑÐ°, Ð¾Ð±Ñ€Ð°Ð±Ð°Ñ‚Ñ‹Ð²Ð°ÑŽÑ‰ÐµÐ…	last_check_time Ð’Ñ€ÐµÐ¼Ñ Ð¿Ð¾ÑÐ»ÐµÐ´Ð½ÐµÐ¹ Ð¿Ñ€Ð¾Ð²ÐµÑ€ÐºÐ¸ ÑÑ…
Edit	Copy	Delete DELETE FROM aci_payment_session WHERE `aci_payment_session`.`id` = 1	1	58	2025-08-14 12:18:14	2023-11-10 14:12:26	000.200.100	DF69CFA5B2DC8C6F495F19D6E927893D.uat01-vm-tx03	8ac7a4a08bb97dfd018bb993ee0f2afc	3	8ac7a4c9870371c401870383cdff0047	278	2025-08-13 00:00:00	NULL	0.00	NULL	NULL
Edit	Copy	Delete DELETE FROM aci_payment_session WHERE `aci_payment_session`.`id` = 2	2	58	2023-11-10 16:24:40	2023-11-10 16:24:27	000.100.110	C1E38789AF359DC5759085B074E06532.uat01-vm-tx04	8ac7a4a08bb97dfd018bba0cbf4d12b8	3	8ac7a4c9870371c401870383cdff0047	279	NULL	NULL	0.00	NULL	NULL
Edit	Copy	Delete DELETE FROM aci_payment_session WHERE `aci_payment_session`.`id` = 3	3	58	2026-02-23 13:11:19	2023-11-13 12:05:06	200.300.404	C69C3483AADBE291DEB38CA051FBDEA8.uat01-vm-tx04	8ac7a49f8bc84a23018bc892664d2a3c	2	8ac7a4c9870371c401870383cdff0047	280	2023-11-14 12:05:06	NULL	0.00	NULL	2026-02-23 12:51:01
Edit	Copy	Delete DELETE FROM aci_payment_session WHERE `aci_payment_session`.`id` = 4	4	58	2023-11-13 12:15:45	2023-11-13 12:15:34	000.100.110	455F4AF3828DA97E0B4B7515AEE72A17.uat01-vm-tx02	8ac7a4a28bc85239018bc89bf37a2193	3	8ac7a4c9870371c401870383cdff0047	281	NULL	NULL	0.00	NULL	NULL
Edit	Copy	Delete DELETE FROM aci_payment_session WHERE `aci_payment_session`.`id` = 5	5	58	2023-11-13 12:18:50	2023-11-13 12:18:39	000.100.110	CE327B6C352A3CD780B5F8BEB2833F07.uat01-vm-tx01	8ac7a49f8bc84a23018bc89ec47748b5	3	8ac7a4c9870371c401870383cdff0047	282	NULL	NULL	0.00	NULL	NULL
Edit	Copy	Delete DELETE FROM aci_payment_session WHERE `aci_payment_session`.`id` = 6	6	58	2023-11-13 12:22:38	2023-11-13 12:22:23	000.100.110	083E6646D95E976DB87D35DFB58BD431.uat01-vm-tx02	8ac7a4a08bc8520c018bc8a23bf62c3e	3	8ac7a4c9870371c401870383cdff0047	283	NULL	NULL	0.00	NULL	NULL
Edit	Copy	Delete DELETE FROM aci_payment_session WHERE `aci_payment_session`.`id` = 7	7	58	2023-11-13 12:33:50	2023-11-13 12:33:38	000.100.110	3E3CC0090C42C2BA8BDD8BDA80D46BC6.uat01-vm-tx02	8ac7a4a28bc85239018bc8ac7f2a3f6f	3	8ac7a4c9870371c401870383cdff0047	284	NULL	NULL	0.00	NULL	NULL
Edit	Copy	Delete DELETE FROM aci_payment_session WHERE `aci_payment_session`.`id` = 8	8	58	2023-11-13 12:35:30	2023-11-13 12:35:19	000.100.110	55A83578F8D0A5B480B77EA812EF892C.uat01-vm-tx03	8ac7a4a18bc84a26018bc8ae05b8633b	3	8ac7a4c9870371c401870383cdff0047	285	NULL	NULL	0.00	NULL	NULL
Edit	Copy	Delete DELETE FROM aci_payment_session WHERE `aci_payment_session`.`id` = 9	9	58	2026-02-23 13:11:19	2023-11-13 12:36:56	200.300.404	4FE6C58CEF56B509E0FC6E9F389AFDC0.uat01-vm-tx01	8ac7a4a28bc85239018bc8af88ac45ed	2	8ac7a4c9870371c401870383cdff0047	286	2023-11-14 12:36:56	NULL	0.00	NULL	2026-02-23 12:51:01
Edit	Copy	Delete DELETE FROM aci_payment_session WHERE `aci_payment_session`.`id` = 10	10	58	2026-02-23 13:11:19	2023-11-13 13:25:42	200.300.404	C1AA3362543D3A0836FE62BB5AB7433C.uat01-vm-tx03	8ac7a49f8bc84a23018bc8dc29384780	2	8ac7a4c9870371c401870383cdff0047	287	2023-11-14 13:25:42	NULL	0.00	NULL	2026-02-23 12:51:01
Edit	Copy	Delete DELETE FROM aci_payment_session WHERE `aci_payment_session`.`id` = 11	11	58	2026-02-23 13:11:19	2023-11-28 14:15:48	800.900.300			2		288	2023-11-29 14:15:48	NULL	0.00	NULL	2026-02-23 12:49:01
Edit	Copy	Delete DELETE FROM aci_payment_session WHERE `aci_payment_session`.`id` = 12	12	58	2026-02-23 13:11:19	2023-11-28 14:16:27	800.900.300			2		289	2023-11-29 14:16:27	NULL	0.00	NULL	2026-02-23 12:49:01
Edit	Copy	Delete DELETE FROM aci_payment_session WHERE `aci_payment_session`.`id` = 13	13	58	2026-02-23 13:11:19	2023-11-28 14:19:32	800.900.300			2		290	2023-11-29 14:19:32	NULL	0.00	NULL	2026-02-23 12:49:01
Edit	Copy	Delete DELETE FROM aci_payment_session WHERE `aci_payment_session`.`id` = 14	14	58	2026-02-23 13:11:19	2023-11-28 14:20:23	800.900.300			2		291	2023-11-29 14:20:23	NULL	0.00	NULL	2026-02-23 12:49:01
Edit	Copy	Delete DELETE FROM aci_payment_session WHERE `aci_payment_session`.`id` = 15	15	58	2023-11-28 14:31:34	2023-11-28 14:26:43	000.100.110	7970AFCE4061CD5B472664D631A193FD.uat01-vm-tx03	8ac7a4a28c13ee68018c1657ad4d6c6a	3	8ac7a4c9870371c401870383cdff0047	292	NULL	NULL	0.00	NULL	NULL
Edit	Copy	Delete DELETE FROM aci_payment_session WHERE `aci_payment_session`.`id` = 16	16	58	2023-11-28 14:33:18	2023-11-28 14:32:42	000.100.110	D2B23831588F6674A285C0DDFE18DABE.uat01-vm-tx04	8ac7a49f8c13e6a5018c165942de1c65	3	8ac7a4c9870371c401870383cdff0047	293	NULL	NULL	0.00	NULL	NULL
Edit	Copy	Delete DELETE FROM aci_payment_session WHERE `aci_payment_session`.`id` = 17	17	58	2026-02-23 13:11:19	2023-11-28 14:39:50	200.300.404	9504B8B69B925C6CD9E9BF1E6EE1C613.uat01-vm-tx01	8ac7a4a08c13ee65018c1665256905da	2	8ac7a4c9870371c401870383cdff0047	294	2023-11-29 14:39:50	NULL	0.00	NULL	2026-02-23 12:51:01
Edit	Copy	Delete DELETE FROM aci_payment_session WHERE `aci_payment_session`.`id` = 18	18	58	2026-02-23 13:11:19	2023-11-28 14:49:55	200.300.404	CA68349BCA92CD68D62976DB9AE6F276.uat01-vm-tx02	8ac7a4a28c13ee68018c1668b7c512b2	2	8ac7a4c9870371c401870383cdff0047	295	2023-11-29 14:49:55	NULL	0.00	NULL	2026-02-23 12:51:01
Edit	Copy	Delete DELETE FROM aci_payment_session WHERE `aci_payment_session`.`id` = 19	19	58	2023-11-28 14:51:33	2023-11-28 14:51:09	000.100.110	F03CD7C5DCD2906CF428FD806735B968.uat01-vm-tx01	8ac7a4a18c13e6a3018c1669faf045fb	3	8ac7a4c9870371c401870383cdff0047	296	NULL	NULL	0.00	NULL	NULL
Edit	Copy	Delete DELETE FROM aci_payment_session WHERE `aci_payment_session`.`id` = 20	20	58	2023-11-28 14:54:53	2023-11-28 14:54:32	000.100.110	344614E5E8A3178E92483450F4E755F5.uat01-vm-tx01	8ac7a4a28c13ee68018c166d05481ce7	3	8ac7a4c9870371c401870383cdff0047	297	NULL	NULL	0.00	NULL	NULL
Edit	Copy	Delete DELETE FROM aci_payment_session WHERE `aci_payment_session`.`id` = 21	21	58	2026-02-23 13:11:19	2023-11-28 15:04:56	000.200.100	578FB8317071FF604B835BE2EDD47601.uat01-vm-tx03		2	8ac7a4c9870371c401870383cdff0047	298	2023-11-29 15:04:56	NULL	0.00	NULL	2026-02-23 12:49:01
Edit	Copy	Delete DELETE FROM aci_payment_session WHERE `aci_payment_session`.`id` = 22	22	58	2023-12-04 14:50:50	2023-12-04 14:30:08	000.100.110	0F800650EB33A937905BBCFF7AC69CCB.uat01-vm-tx03	8ac7a49f8c31bce0018c354f781864d3	3	8ac7a4c9870371c401870383cdff0047	300	NULL	NULL	0.00	NULL	NULL
Edit	Copy	Delete DELETE FROM aci_payment_session WHERE `aci_payment_session`.`id` = 23	23	58	2023-12-04 14:52:21	2023-12-04 14:51:52	000.100.110	7D3F1D59211FEA06C32F4BBE36FEAC29.uat01-vm-tx04	8ac7a4a18c31bce1018c3550dc3358b0	3	8ac7a4c9870371c401870383cdff0047	301	NULL	NULL	0.00	NULL	NULL
Edit	Copy	Delete DELETE FROM aci_payment_session WHERE `aci_payment_session`.`id` = 24	24	58	2023-12-04 15:13:56	2023-12-04 15:13:38	000.100.110	3A324B4DE8B19C07763E26D267CE5EBC.uat01-vm-tx03	8ac7a4a28c31c122018c356499b27ff0	3	8ac7a4c9870371c401870383cdff0047	302	NULL	NULL	0.00	NULL	NULL
Edit	Copy	Delete DELETE FROM aci_payment_session WHERE `aci_payment_session`.`id` = 25	25	58	2026-02-23 13:11:19	2023-12-07 14:33:31	000.200.100	8E46C8AA97773D4B31484218362DE165.uat01-vm-tx02		2	8ac7a4c9870371c401870383cdff0047	309	2023-12-08 14:33:31	NULL	0.00	NULL	2026-02-23 12:49:01

Check all With selected:

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view