Represents integrations with external systems
Data model
Fields
| Field |
Type |
Description |
| active* |
BIT |
Determine whether the integration is active or not |
| default_path_url |
NVARCHAR (510) |
Define the default URL Path for the integration GUI |
| description |
NVARCHAR (500) |
Integration Description |
| gui_password |
NVARCHAR (500) |
Represents the password for GUI credentials |
| gui_url |
NVARCHAR (MAX) |
Represents the URL of the integration’s GUI |
| gui_user |
NVARCHAR (500) |
Represents the user of the GUI credentials |
| id* |
INT |
Unique identifier of the integration |
| item_type_id* |
INT |
Unique identifier of the integration type |
| name* |
NVARCHAR (100) |
Integration name |
| project_id |
INT |
Determine the integration project |
| responsible_id |
INT |
Determine the person responsible for the integration |
| user_id* |
INT |
Unique user identifier |
| webservice_password |
NVARCHAR (500) |
Represents the password for the web service credentials |
| webservice_url |
NVARCHAR (MAX) |
Represents the URL of the integration’s web service |
| webservice_user |
NVARCHAR (500) |
Represents the user of the web service credentials |
Primary Key
References
| Column |
Referenced Table |
Referenced column |
Name |
| item_type_id* |
dbo.ASMS_TYPES |
id |
FK01_AASMS_INTEGRATIONS |
| user_id* |
dbo.AFW_USERS |
user_id |
FK02_AASMS_INTEGRATIONS |
