Table that stores logical disks related to a device
Data model
Fields
| Field | Type | Description |
|---|---|---|
| device_diskid* | INT | Key related to physical disk related to device, reference to AAM_DEVICE_DISK.id table |
| file_system | NVARCHAR (510) | File System |
| free | BIGINT | Logical Unit Free Space |
| krun_status | CHAR (1) | Inventory Registration Status |
| modification_date* | DATETIME | Date of edition |
| name | NVARCHAR (510) | Volume Name |
| serial | NVARCHAR (510) | Logical Disk Serial |
| size | BIGINT | Logical Drive Size |
| type | NVARCHAR (510) | Logical Unit Type |
| unit* | NVARCHAR (510) | Key that identifies the disk drive |
Primary Key
| PK_AAM_LOGICAL_DISK |
|---|
| device_diskid, unit |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| device_diskid* | dbo.AAM_DEVICE_DISK | id | FK01_AAM_LOGICAL_DISK |