Table: FileEntry

For file transfer purposes, an entry in this table specifies the file which is transferred from the Scout Enterprise server to the thin client. The file transfer can be assigned to a single device, an organization unit, or at enterprise level (Advanced options).

ColumnName	DataType	Key	Not Null	Default Value	Comment
FileEntryID	INTEGER	PK	NN		Unique file entry ID
MemberType	INTEGER				Member type −1 Enterprise  MemberID must be -1 1 TYPE_GROUP  MemberID refers to Groups 4 TYPE_DEVICE_ENTRY  MemberID refers to Device
MemberID	INTEGER	(FK)	NN		Member ID (depending on MemberType, this refers to table Groups or Device)
FileSource	NVARCHAR(255)				Source file to be transferred to the client
FileDestination	NVARCHAR(255)				Target file on the client
Description	NVARCHAR(255)				Contains the description if the file entry is a destination file template on the client
UCFTID	INTEGER				This field refers to an entry in the UCFT table (for files that have been imported to the database).
ReservedString1	NVARCHAR(255)
ReservedString2	NVARCHAR(255)
ReservedInt1	INTEGER
ReservedInt2	INTEGER

IndexName	IndexType	Columns
PRIMARY	PRIMARY	FileEntryID MemberID

 

How to create

CREATE TABLE FileEntry(
FileEntryID INTEGER NOT NULL,
MemberType INTEGER,
MemberID INTEGER,
FileSource NVARCHAR(255),
FileDestination NVARCHAR(255),
ReservedString1 NVARCHAR(255),
ReservedString2 NVARCHAR(255),
ReservedInt1 INTEGER,
ReservedInt2 INTEGER,
PRIMARY KEY (FileEntryID));