MariaDB [prodgishargeisa]> select * from transaction_documents where transaction_id = 15616 and document_name like "%city planning map%"; +--------+----------------+------------------+-------------------+----------+------------+--------------------------------------+---------------+---------------------+---------------------+----------------+-----------+-------+------------+ | id | transaction_id | document_type_id | document_name | comments | updated_by | document_id | document_type | created_at | updated_at | auto_generated | signature | image | is_deleted | +--------+----------------+------------------+-------------------+----------+------------+--------------------------------------+---------------+---------------------+---------------------+----------------+-----------+-------+------------+ | 283729 | 15616 | 20 | City Planning Map | NULL | 31 | b9eddc47-ad44-4594-9add-1c929f42b335 | pdf | 2021-08-14 13:03:17 | 2021-08-14 13:03:17 | N | 0 | 0 | 0 | | 398311 | 15616 | 20 | City Planning Map | NULL | 219 | 15329997-6d84-4fe0-9719-ceb0dc1a66ac | pdf | 2022-01-26 08:35:33 | 2022-01-26 08:35:33 | N | 0 | 0 | 0 | +--------+----------------+------------------+-------------------+----------+------------+--------------------------------------+---------------+---------------------+---------------------+----------------+-----------+-------+------------+ 2 rows in set (0.002 sec) MariaDB [prodgishargeisa]> Update transaction_documents set is_deleted = 1 where id = "283729"; Query OK, 1 row affected (0.002 sec) Rows matched: 1 Changed: 1 Warnings: 0 MariaDB [prodgishargeisa]> select * from transaction_documents where transaction_id = 10850 and document_name like "%city planning map%"; +--------+----------------+------------------+-------------------+----------+------------+--------------------------------------+---------------+---------------------+---------------------+----------------+-----------+-------+------------+ | id | transaction_id | document_type_id | document_name | comments | updated_by | document_id | document_type | created_at | updated_at | auto_generated | signature | image | is_deleted | +--------+----------------+------------------+-------------------+----------+------------+--------------------------------------+---------------+---------------------+---------------------+----------------+-----------+-------+------------+ | 196361 | 10850 | 20 | City Planning Map | NULL | 31 | 3c3e8d20-b8e8-4222-b783-42b355167ccf | pdf | 2021-03-01 20:17:14 | 2021-03-01 20:17:14 | N | 0 | 0 | 0 | +--------+----------------+------------------+-------------------+----------+------------+--------------------------------------+---------------+---------------------+---------------------+----------------+-----------+-------+------------+ 1 row in set (0.001 sec) MariaDB [prodgishargeisa]> Update transaction_documents set is_deleted = 1 where id = "196361"; Query OK, 1 row affected (0.001 sec) Rows matched: 1 Changed: 1 Warnings: 0 MariaDB [prodgishargeisa]> MariaDB [prodgishargeisa]> select * from transaction_documents where transaction_id = 1109 and document_name like "%city planning map%"; +--------+----------------+------------------+-------------------+----------+------------+--------------------------------------+---------------+---------------------+---------------------+----------------+-----------+-------+------------+ | id | transaction_id | document_type_id | document_name | comments | updated_by | document_id | document_type | created_at | updated_at | auto_generated | signature | image | is_deleted | +--------+----------------+------------------+-------------------+----------+------------+--------------------------------------+---------------+---------------------+---------------------+----------------+-----------+-------+------------+ | 17453 | 1109 | 20 | city planning map | NULL | 31 | 5e6fc603-c6c5-4c30-8ddd-8dd8fdacb7aa | pdf | 2020-01-13 11:36:43 | 2020-01-13 11:36:43 | N | 0 | 0 | 0 | | 363528 | 1109 | 20 | city planning map | NULL | 31 | 809ecfec-720d-4b6e-9766-cd885d3fd414 | pdf | 2021-12-11 07:28:19 | 2021-12-11 07:28:19 | N | 0 | 0 | 0 | +--------+----------------+------------------+-------------------+----------+------------+--------------------------------------+---------------+---------------------+---------------------+----------------+-----------+-------+------------+ 2 rows in set (0.001 sec) MariaDB [prodgishargeisa]> Update transaction_documents set is_deleted = 1 where id = "17453"; Query OK, 1 row affected (0.001 sec) Rows matched: 1 Changed: 1 Warnings: 0 MariaDB [prodgishargeisa]> MariaDB [prodgishargeisa]> select * from transaction_documents where transaction_id = 407 and document_name like "%city planning map%"; +--------+----------------+------------------+-------------------+----------+------------+--------------------------------------+---------------+---------------------+---------------------+----------------+-----------+-------+------------+ | id | transaction_id | document_type_id | document_name | comments | updated_by | document_id | document_type | created_at | updated_at | auto_generated | signature | image | is_deleted | +--------+----------------+------------------+-------------------+----------+------------+--------------------------------------+---------------+---------------------+---------------------+----------------+-----------+-------+------------+ | 7616 | 407 | 20 | city planning map | NULL | 71 | 0513bc37-ac08-466e-bf18-838eb83ed1a7 | pdf | 2019-11-29 15:51:48 | 2019-11-29 15:51:48 | N | 0 | 0 | 0 | | 330767 | 407 | 20 | city planning map | NULL | 31 | df900fbc-e12a-49d7-b6a4-a231e74b6740 | pdf | 2021-10-24 09:08:18 | 2021-10-24 09:08:18 | N | 0 | 0 | 0 | +--------+----------------+------------------+-------------------+----------+------------+--------------------------------------+---------------+---------------------+---------------------+----------------+-----------+-------+------------+ 2 rows in set (0.001 sec) MariaDB [prodgishargeisa]> Update transaction_documents set is_deleted = 1 where id = "7616"; Query OK, 1 row affected (0.001 sec) Rows matched: 1 Changed: 1 Warnings: 0 MariaDB [prodgishargeisa]> MariaDB [prodgishargeisa]> select * from transaction_documents where transaction_id = 407 and document_name like "%city planning map%"; +--------+----------------+------------------+-------------------+----------+------------+--------------------------------------+---------------+---------------------+---------------------+----------------+-----------+-------+------------+ | id | transaction_id | document_type_id | document_name | comments | updated_by | document_id | document_type | created_at | updated_at | auto_generated | signature | image | is_deleted | +--------+----------------+------------------+-------------------+----------+------------+--------------------------------------+---------------+---------------------+---------------------+----------------+-----------+-------+------------+ | 7616 | 407 | 20 | city planning map | NULL | 71 | 0513bc37-ac08-466e-bf18-838eb83ed1a7 | pdf | 2019-11-29 15:51:48 | 2019-11-29 15:51:48 | N | 0 | 0 | 1 | | 330767 | 407 | 20 | city planning map | NULL | 31 | df900fbc-e12a-49d7-b6a4-a231e74b6740 | pdf | 2021-10-24 09:08:18 | 2021-10-24 09:08:18 | N | 0 | 0 | 0 | +--------+----------------+------------------+-------------------+----------+------------+--------------------------------------+---------------+---------------------+---------------------+----------------+-----------+-------+------------+ 2 rows in set (0.000 sec) MariaDB [prodgishargeisa]> Update transaction_documents set is_deleted = 1 where id = "330767"; Query OK, 1 row affected (0.002 sec) Rows matched: 1 Changed: 1 Warnings: 0