Table that stores the network adapters related to a device
Data model
Fields
| Field |
Type |
Description |
| adapter_id* |
INT |
Network adapter ID, reference to AAM_NETWORKADAPTER.id table |
| device_id* |
INT |
Associated device ID, reference to AAM_DEVICE.id table |
| dhcp_address |
NVARCHAR (90) |
DHCP server IP address |
| dhcp_enabled |
INT |
Dhcp Enabled Indicator |
| dhcp_expired |
DATETIME |
Date on which the IP address assigned by the DHCP server expires |
| dhcp_obtained |
DATETIME |
Date on which the IP address obtained by the DHCP server was assigned |
| krun_status |
CHAR (1) |
Inventory Registration Status |
| lmhosts_enabled |
INT |
lmhosts indicator enabled |
| mac |
NVARCHAR (510) |
MAC ID number associated with the station’s network card |
| modification_date* |
DATETIME |
Date of edition |
| speed |
BIGINT |
Network Card Speed |
Primary Key
| PK_AAM_DEVICE_NETWORKADAPTER |
| id |
References
