EN
Español
English
Português
    AAM_NETWORKADAPTER_ADDRES

    Table that stores network addresses

    Data model

    Fields

    Field Type Description
    default* INT Field that tells me which of the IP addresses of a workstation is the default
    device_adapter_id* INT Network adapter ID associated with the device, reference to AAM_DEVICE_NETWORKADAPTER.id table
    ipaddress* NVARCHAR (80) IP address
    krun_status CHAR (1) Inventory Registration Status
    mask* NVARCHAR (80) Network Mask
    modification_date* DATETIME Date of edition

    Primary Key

    PK_AAM_NETWORKADAPTER_ADDRES
    device_adapter_id, ipaddress, mask

    References

    Column Referenced Table Referenced column Name
    device_adapter_id* dbo.AAM_DEVICE_NETWORKADAPTER id FK01_AAM_NETWORKADAPTER_ADDRES