--- title: Table Definition slug: contact-center/table-definition docTags: createdAt: 2026-01-27T12:21:15.470Z --- In this tab, you can create, edit, and delete table definitions. ::Image[]{src="https://api.archbee.com/api/optimize/SK2urIgCC2ml99YyqWOSl/Jl_vRaIsj9atyijPH79PG-20260729-060302.png" size="90" width="1171" height="334" position="center" caption="Figure: Table Settings in "System Configuration" showCaption="true"} After creating the table definitions here, you can use "Mapping" tab to create the mapping and "Filter" tab to create the filters. *** ### Create Table Definition **To create a new data table, follow these steps:** 1. Click the **Create Table **button. A pop-up window will appear. ::Image[]{src="https://api.archbee.com/api/optimize/SK2urIgCC2ml99YyqWOSl/9BVaJ3MYCvR5L6XEDje7_-20260729-060301.png" size="90" width="1022" height="661" position="center" caption="Figure: Create Table" showCaption="true"} 2. Provide the following details\:Following is a screenshot of a table containing different columns. **A. System:** This contains the system ID which is taken by default. **B.Table Definition Name:** Enter the name of the table. Only the underscore (\_) is allowed as a special character; other special characters are not permitted. **C. Description:** Enter a description for the table. **D. Column Definition:** Perform the following steps to add a column. - Click **Add **to add a column. A new row will appear. ::Image[]{src="https://api.archbee.com/api/optimize/SK2urIgCC2ml99YyqWOSl/mfqx3fXyKzrGOE3_KcoL--20260729-060259.png" size="90" width="993" height="326" darkWidth="993" darkHeight="326" position="center" showCaption="false"} - Provide values for the column fields: - ** Name:** Column name to be provided. You can use only "\_" (underscore) as a special character while providing a name for a Column. Other special characters are not allowed. - ** Type:** Select any of the following options to specify the type of input received in this column. - *Integer*: Select it to accept only whole numbers. It will not accept the decimals. - *Numeric*: Select it to accept the numbers including decimals. - *Boolean*: Select it to accept only two values that are "true" and "false". - *Varchar*: Select it to accept the alphabets with numbers. - *Date*: Select it to accept the date. - *Time*: Select it to accept the time. - *Timestamp*: Select it to accept the timestamp. - **Nullable:** Select it to let any cell in the column to remain blank. If unchecked, it will be mandatory to enter some value in the cell. - **Unique Key:** Select it to let the column accept only unique values in its cells. - **Primary Key:** Select it to make the column primary. - **Non-Unmaskable (Licensable):** It provides the option to mask the values stored in a field. :::hint{type="info"} The feature to unmask the already masked values will not be provided. So, use this feature consciously. ::: All or only important fields can be masked. If the Administrator selects a field to be maksed, then whatever data will be stored in this field will be masked at User Interface of the entire Ameyo System, in Customer Manager API, and at the backend, in the databases of PostgreSQL. For example, the data will be masked in `AmeyoRefresh` and `CustomerProspect` tables. Except the last 4 characters, all characters in the data will be masked with "X" letter such as XXXXXX1234. :::hint{type="info"} If you are modifying an existing Table Definition or creating a new one in an already existing Ameyo Setup, only the new data will be masked in the field selected for masking, however, the old data will not be masked. ::: **Perform the following steps to enable the masked Data Processor** 1. Execute the following query to verify whether the maskDataPreProcessor is available or not. :::BlockQuote SELECT \* FROM system\_configuration\_parameter WHERE name = 'customerManagerPreprocessorsNames'; ::: 2. Execute the following query to enable the maskDataPreProcessor if it is not available. :::BlockQuote update system\_configuration\_parameter set value='duplicatePreprocessor,numberRegexMatcherPreprocessor,standardNumberFormaterPreprocessor,maskDataPreProcessor' where name='customerManagerPreprocessorsNames'; ::: 3. Run the following query. :::BlockQuote update column\_definition set masking\_policy\_type='FIRST\_X\_LAST\_Y\_UNMASKED' where name=''; Update column\_definition set masking\_policy\_properties='\{"last\_y\_characters":"4","masked\_string":"","first\_x\_characters":"6"}' where name='\'; ::: It is configurable that how many digits of the data has to be masked or unmasked from starting and how many digits has to be masked or unmasked from the end. Suppose the card number of 10 digits has to be masked. If it is configured that first 5 digits will be unmasked and the last 5 digits will be unmasked, then the complete number will remain unmask. If you select "Masked" for a field, then it cannot be "Primary Key" and "Unique Key". Also, default value of "Type" for a Masked field will be "VARCHAR" and it cannot be changed. ::Image[]{src="https://api.archbee.com/api/optimize/SK2urIgCC2ml99YyqWOSl/mv1zquRxrEQoCDTvH9570-20260729-060300.png" size="90" width="1006" height="202" position="center" caption="Figure: Sample Values to create a Table" showCaption="true"} ::::hint{type="info"} There may be some cases arise when you have to disable the mask data fields. In this case, run the following query to disable the Mask Data Field. :::BlockQuote update system\_configuration\_parameter set value='duplicatePreprocessor,numberRegexMatcherPreprocessor,standardNumberFormaterPreprocessor' where name='customerManagerPreprocessorsNames'; ::: :::: - **Unmaskable:**If selected, then the values of this field will not mask. - **Default value:** Enter the default value that will be displayed in all cells of this column. *You can add multiple columns using the same steps.* Following is a screenshot of a table containing different columns. ::Image[]{src="https://api.archbee.com/api/optimize/SK2urIgCC2ml99YyqWOSl/tOEj90u8S2HFv7zheOhZC-20260729-060259.png" size="90" width="1036" height="524" position="center" caption="Figure: Sample Values to create a Table" showCaption="true"} Click **"Save" **to create a table. Following screenshot shows a newly created table. ::Image[]{src="https://api.archbee.com/api/optimize/SK2urIgCC2ml99YyqWOSl/uUDDZFcHOjXyVZa7s6S-7-20260729-060301.png" size="90" width="1158" height="264" position="center" caption="Figure: Created a Table" showCaption="true"} ### Modify Table Definition Perform the following steps to edit the table. 1. Select a table and click "Edit". *** *** ::Image[]{src="https://api.archbee.com/api/optimize/SK2urIgCC2ml99YyqWOSl/tOEj90u8S2HFv7zheOhZC-20260729-060259.png" size="90" width="1036" height="524" position="center" caption="Figure: Modify a Table Definition" showCaption="true"} 2. You can change the following fields here.You cannot modify or delete the columns. Also, you cannot modify the column properties such as name, type, Nullable, unique key, primary key, or default value. - **Add new column:** You can add the new columns in the table definitions. Click "Add" button to add the new column. A blank row is added at the bottom of the table. Here you can define the properties of the table column. - **Table Definition Name:** Change the name of the table. - **Description:** Change the description. :::hint{type="info"} You cannot modify or delete the columns. Also, you cannot modify the column properties such as name, type, Nullable, unique key, primary key, or default value. ::: 3. Click "Save" to save and apply the changes.Click "Cancel" to cancel the changes. *** ### Delete Table Definition Perform the following steps to delete a table. 1. Select the table and click "Delete". It shows the following warning message. ::Image[]{src="https://api.archbee.com/api/optimize/SK2urIgCC2ml99YyqWOSl/EoNsXCgDbl5J2iPEj9_su-20260729-051309.png" size="88" width="745" height="108" position="center" caption="Figure: Asking to delete a table" showCaption="true"} 2. Click "Yes" to delete the selected table. You can click "No" to not delete the table.