# model Deduplication Model - Catalog: `Odoo` - Schema: `data_merge` The data in this table is partitioned per value of the column. This is a read-only table. The Odoo API may not support changing the data or the Invantive SQL driver for Odoo does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Odoo API. ## Table Columns The columns of the table `model` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `active` | `boolean` | Active | ☐ | | | `create_date` | `datetime` | Created on | ☐ | | | `create_threshold` | `int32` | Suggestion Threshold | ☐ | Duplicates with a similarity below this threshold will not be suggested | | `create_uid_label` | `string` | | ☐ | | | `create_uid` | `string` | | ☐ | | | `custom_merge_method` | `boolean` | Custom Merge Method | ☐ | | | `display_name` | `string` | Display Name | ☐ | | | `domain` | `string` | Domain | ☐ | Records eligible for the deduplication process | | `id` | `int32` | ID | ☐ | | | `is_contextual_merge_action` | `boolean` | Merge action attached | ☐ | If True, this record is used for contextual menu action "Merge" on the target model. | | `last_notification` | `datetime` | Last Notification | ☐ | | | `merge_mode` | `string` | Merge Mode | ☐ | | | `merge_threshold` | `int32` | Similarity Threshold | ☐ | Records with a similarity percentage above this threshold will be automatically merged | | `mix_by_company` | `boolean` | Cross-Company | ☐ | When enabled, duplicates across different companies will be suggested | | `name` | `string` | Name | ☑ | | | `notify_frequency_period` | `string` | Notify Frequency Period | ☐ | | | `notify_frequency` | `int32` | Notify | ☐ | | | `notify_user_ids` | `string` | | ☐ | List of users to notify when there are new records to merge | | `records_to_merge_count` | `int32` | Records To Merge Count | ☐ | | | `removal_mode` | `string` | Duplicate Removal | ☐ | | | `res_model_id_label` | `string` | | ☐ | | | `res_model_id` | `string` | | ☐ | | | `res_model_name` | `string` | Model Name | ☐ | | | `rule_ids` | `string` | | ☐ | Suggest to merge records matching at least one of these rules | | `write_date` | `datetime` | Last Updated on | ☐ | | | `write_uid_label` | `string` | | ☐ | | | `write_uid` | `string` | | ☐ | |