EN
Español
English
Português
    AAM_DEVICE_DISK

    Table that stores physical disks related to a device

    Data model

    Fields

    Field Type Description
    bus_type NVARCHAR (510) Data Bus Type
    device_id* INT Associated device ID, reference to AAM_DEVICE.id table
    disk_id* INT Identifier of the associated physical disk, reference to the AAM_DISK.id table
    features NVARCHAR (1000) Disc Feature
    id* INT Integer Type Primary Key
    krun_status CHAR (1) Inventory Registration Status
    media_type* NVARCHAR (510) Media Type
    modification_date* DATETIME Date of edition
    pnp_device_id* NVARCHAR (510) Unique key that identifies the device’s hard drive
    serial NVARCHAR (510) Serial of the disc
    size* BIGINT Total disk space

    Primary Key

    PK_AAM_DEVICE_DISK
    id

    References

    Column Referenced Table Referenced column Name
    device_id* dbo.AAM_DEVICE id FK01_AAM_DEVICE_DISK
    disk_id* Bod. AAM_DISK id FK02_AAM_DEVICE_DISK