Scout Database Model (LTSR)
Table: Printer
Entry is a printer definition and refers to an entry in the Setup table.
| ColumnName | DataType | Key | Not Null | Default Value | Comment |
|---|---|---|---|---|---|
| PrinterID | INTEGER | PK | NN | Unique ID of printer definition | |
| SetupID | INTEGER | FK | NN | Setup ID (foreign key refers to table Setup.SetupID) | |
| Baud | INTEGER | Baud rate | |||
| 1200 / 2400 / 4800 / 9600 / 19200 / 38400 / 57600 / 115200 | |||||
| Name | NVARCHAR(255) | NN | lp | Local Printer name | |
| Type | NVARCHAR(255) | NN | par | Printer type | |
| par - Printer on parallel port | |||||
| ser - Printer on serial port | |||||
| usb - Printer on USB port | |||||
| net - Network printer | |||||
| TextFilter | SMALLINT(6) | NN | 0 | Text filter is active | |
| 0 / 1 | |||||
| PclFilter | NVARCHAR(255) | false | PCL filter is active | ||
| true / false | |||||
| Address | NVARCHAR(255) | Printer network name (or IP address) | |||
| Queue | NVARCHAR(255) | Queue name | |||
| Com | SMALLINT(6) | -1 | COM port ID | ||
| 1 - Printer on serial port 1 | |||||
| UseAsDefault | SMALLINT(6) | 0 | Default printer | ||
| 0 or 1 | |||||
| DriverName | NVARCHAR(255) | Driver name on server side used for auto-connected printer | |||
| TpConnect | SMALLINT(6) | 0 | Use as ThinPrint printer | ||
| 0 or 1 | |||||
| TpClass | NVARCHAR(255) | ThinPrint class name | |||
| ReservedString1 | NVARCHAR(255) | ||||
| ReservedString2 | NVARCHAR(255) | ||||
| ReservedInt1 | INTEGER | ||||
| ReservedInt2 | INTEGER |
| IndexName | IndexType | Columns |
|---|---|---|
| PRIMARY | PRIMARY | PrinterID |
How to create
CREATE TABLE Printer(
PrinterID INTEGER NOT NULL,
SetupID INTEGER NOT NULL,
Baud INTEGER,
Name NVARCHAR(255) NOT NULL,
Type NVARCHAR(255) NOT NULL,
TextFilter SMALLINT NOT NULL,
PclFilter NVARCHAR(255),
Address NVARCHAR(255),
Queue NVARCHAR(255),
Com SMALLINT,
UseAsDefault SMALLINT,
DriverName NVARCHAR(255),
TpConnect SMALLINT,
TpClass NVARCHAR(255),
ReservedString1 NVARCHAR(255),
ReservedString2 NVARCHAR(255),
ReservedInt1 INTEGER,
ReservedInt2 INTEGER,
PRIMARY KEY (PrinterID),
CONSTRAINT FK_Printer_SetupID_Setup_SetupID FOREIGN KEY (SetupID) REFERENCES Setup(SetupID));
Table: Printer
In this article
Copied!
Failed!