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));