Table: FileEntry
For file transfer purposes, an entry in this table specifies the file which is transferred from the Scout 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
|
||||||||||||
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));