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|1
DriverName	NVARCHAR(255)				Driver name on server side used for auto-connected printer
TpConnect	SMALLINT(6)			0	Use as ThinPrint printer 0|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));