Configuration table for each of the Field Service fields. It works to identify the type of configuration field on the frontend.
Data model
Fields
| Field | Type | Description |
|---|---|---|
| sett_datatype* | VARCHAR (100) | Identifying the Configuration Field Type |
| sett_group* | VARCHAR (100) | Identifying the configuration group to which the field belongs |
| sett_id* | INT | Unique identifier of the table |
| sett_is_active* | BIT | Field marking to identify active/inactive status |
| sett_key* | NVARCHAR (110) | Configuration Field Name |
| sett_label* | VARCHAR (100) | Field label for identification on the frontend |
| sett_length | INT | Column where the maximum configuration field size is assigned |
| sett_options | VARCHAR (MAX) | Column to assign default values to the corresponding field |
| sett_order | INT | Field Display Order |
| sett_placeholder | VARCHAR (100) | Text label message located within the settings field |
Primary Key
| PK_AFLS_SETTINGS |
|---|
| sett_id |