Scout Database Model (CR)

Table: Printer

March 26, 2025

Contributed by:

S C

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 rate1200/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 active0/1
PclFilter	NVARCHAR(255)			false	PCL filter is activetrue/false
Address	NVARCHAR(255)				Printer network name (or IP address)
Queue	NVARCHAR(255)				Queue name
Com	SMALLINT(6)			-1	COM port ID
Com	SMALLINT(6)			-1	1 / Printer on serial port 1
UseAsDefault	SMALLINT(6)			0	Default printer0/1
DriverName	NVARCHAR(255)				Driver name on server side used for auto-connected printer
TpConnect	SMALLINT(6)			0	Use as ThinPrint printer0/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));
  

The official version of this content is in English. Some of the Cloud Software Group documentation content is machine translated for your convenience only. Cloud Software Group has no control over machine-translated content, which may contain errors, inaccuracies or unsuitable language. No warranty of any kind, either expressed or implied, is made as to the accuracy, reliability, suitability, or correctness of any translations made from the English original into any other language, or that your Cloud Software Group product or service conforms to any machine translated content, and any warranty provided under the applicable end user license agreement or terms of service, or any other agreement with Cloud Software Group, that the product or service conforms with any documentation shall not apply to the extent that such documentation has been machine translated. Cloud Software Group will not be held responsible for any damage or issues that may arise from using machine-translated content.

Was this helpful

Table: Printer

March 26, 2025

Contributed by:

S C

Table: Printer

How to create

In this article