PRINTER_SUPPLIES
This table represents supplies in printers. There is a row in this table for each supply in a given printer, all pointing to the same PRINTER_ID. Depending on the type, not all columns apply.
|
Field Name |
Data Type |
Description |
|---|---|---|
|
SUPPLY_ID |
BIGINT |
The primary key. |
|
CAPACITY |
BIGINT |
The maximum sheet capacity of the supply. |
|
COLOR |
VARCHAR(255) |
The color of the supply (for example, Black, Cyan, or NULL). |
|
NAME |
VARCHAR(255) |
The name of the supply (for example, Black Toner, Fuser, and Waste Bottle). |
|
SMART_CARTRIDGE_PREBATE |
SMALLINT/ TINYINT* |
The flag indicating whether this supply is a smart cartridge prebate. |
|
SMART_CARTRIDGE_REFILLED |
SMALLINT/ TINYINT* |
The flag indicating whether this supply is a smart cartridge refill. |
|
SMART_CARTRIDGE_SERIAL_NUM BER |
VARCHAR(255) |
The smart cartridge serial number. |
|
TYPE |
VARCHAR(255) |
The type of supply (for example, Toner, Transfer Belt, Fuser, Container, or Imaging Unit). |
|
PRINTER_ID |
BIGINT |
The foreign key to NETWORK_PRINTER.PRINTER_ID. |
|
PERCENT_FULL |
BIGINT |
The calculated remaining percentage of the supply. |
*This data type is required for Microsoft SQL Server.