Table that stores printers related to a device
Data model

Fields
Field |
Type |
Description |
description |
NVARCHAR (500) |
Brief description of the printer (if registered in the printer settings) |
device_id* |
INT |
Associated device ID, reference to AAM_DEVICE.id table |
driver_id* |
INT |
Identifier in the peripheral driver database |
krun_status |
CHAR (1) |
Inventory Registration Status |
modification_date* |
DATETIME |
Date of edition |
name* |
NVARCHAR (240) |
Printer name (as listed in the Printers folder on the Windows Start menu). In the case of a network printer, the name with which it was shared |
port |
NVARCHAR (512) |
Communications port to which the printer is connected |
Primary Key
References
Column |
Referenced Table |
Referenced column |
Name |
device_id* |
dbo.AAM_DEVICE |
id |
FK02_AAM_DEVICE_PRINTER |
driver_id* |
Bod. AAM_PRINTERDRIVER |
id |
FK01_AAM_DEVICE_PRINTER |