Table that stores gateway configuration.
Data model
Fields
| Field | Type | Description |
|---|---|---|
| address* | NVARCHAR (160) | IP address or DNS of the gateway |
| creation_date* | DATETIME | Date the gateway is created |
| creator_user_id* | INT | User who creates the reference gateway with afw_users.id |
| id* | INT | Unique Table Identifier |
| is_active* | BIT | Field indicating whether it is active or not |
| is_default* | BIT | Field indicating if it is the default gateway |
| is_ssl* | BIT | Connection with or without ssl |
| name* | NVARCHAR (510) | Gateway Configuration Name |
| port* | INT | Gateway connection port |
| update_date | DATETIME | Date on which the gateway modification is made |
| updater_user_id | INT | User making the modification of the reference record with afw_users.id |
Primary Key
| PK_ADM_CONFIGURATION_GATEWAY |
|---|
| id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| creator_user_id* | dbo.AFW_USERS | user_id | FK01_ADM_CONFIGURATION_GATEWAY |
| updater_user_id | dbo.AFW_USERS | user_id | FK02_ADM_CONFIGURATION_GATEWAY |