Table Definition

in this tab, you can create, edit, and delete table definitions 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 click the create table button a pop up window will appear 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 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 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 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 execute the following query to verify whether the maskdatapreprocessor is available or not select from system configuration parameter where name = 'customermanagerpreprocessorsnames'; execute the following query to enable the maskdatapreprocessor if it is not available update system configuration parameter set value='duplicatepreprocessor,numberregexmatcherpreprocessor,standardnumberformaterpreprocessor,maskdatapreprocessor' where name='customermanagerpreprocessorsnames'; run the following query 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='\<column name to mask>'; 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 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 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 click "save" to create a table following screenshot shows a newly created table modify table definition perform the following steps to edit the table select a table and click "edit" 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 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 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 select the table and click "delete" it shows the following warning message click "yes" to delete the selected table you can click "no" to not delete the table