Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| AutomatedJobSettingId | int identity | 4 | √ | null |
|
|
Data field - AutomatedJobSettingId information for AutomatedJobSetting business operations |
|
| CompanyID | int | 4 | √ | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
|
| fkJobID | Unknown | 0 | null |
|
|
Job reference - Reference to the automated job (foreign key to AutomatedJob.JobID) |
||
| ParameterType | nvarchar | 100 | √ | null |
|
|
Type classification - Category or classification type for AutomatedJobSetting records |
|
| ParameterValue | int | 4 | √ | null |
|
|
Numeric value - Quantity, count, or numeric measurement for AutomatedJobSetting records |
|
| ParameterDateValue | datetime | 16,3 | √ | null |
|
|
Date/time field - Date and time when parametervalue occurred or was recorded |
|
| SettingID | Unknown | 0 | null |
|
|
Primary key - AutomatedJobSetting unique identifier for each job setting |
||
| SettingName | Unknown | 0 | null |
|
|
Setting name - Name of the configuration parameter |
||
| SettingType | Unknown | 0 | null |
|
|
Setting type - Data type of the setting (String, Integer, Boolean, etc.) |
||
| SettingValue | Unknown | 0 | null |
|
|
Setting value - Value of the configuration parameter |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__Automate__0187E5B2B1C11667 | Primary key | Asc | AutomatedJobSettingId |