DB doc for fei.dbo.fileTypes

Table fileTypes

Last update on April 13, 1998
Send questions, comments and corrections to DBA

Database: fei Owner: dbo Object: fileTypes

Description

feiServers

files

The value of spaceReserved is not used by FEI servers. It must be supplied so system administrators know how much room to allocate for files of the specified type. Also, FEI servers do not update spaceUsed. This can be done manually from time to time using the information in the file system or in the files table.

Columns

Name Datatype Description
ftIdx numeric(6) not null A unique ID for each file type. Used when joining with other tables. Also used by the server.

name varchar(30) not null The file type name.

host varchar(30) not null The name of the machine where the file directory is located.

directory varchar(128) not null The directory where files of this type are placed.

spaceReserved int not null The number of megabytes reserved for files of this type in the file system.

spaceUsed smallint not null The number of megabytes used by files of this files of this type

fileFormat varchar(10) null The format of the file: i.e., text, tiff, VICAR, etc.

proprietaryTime datetime null When specified, files modified after this date and time are proprietary. You must have both get and proprietary capabilities to retrieve them.

compressionType varchar(20) null If files of this type are compressed, this denotes the compression alrorithm used.

feiServerIdx numeric(3) not null The ID of the server that manages this type of file. See the feiServers table.

mission tinyint not null The ID of the mission with which this file type is associated. Missions ID's are defined in dba.dbo.missions. If the file is associated with a mission, this value is 0.

DEFAULT 0

description varchar(255) null A description of the file type. People not familiar with the mission find this helpful.

crcFlag bit not null If CRC's are to be computed whenever a file of this type is transfered, the value is 1. Otherwise, it's 0.

encryptFlag bit not null If files of this type are to be encrypted when transfered, the value is 1. Otherwisse, it's 0.

modified datetime not null The date and time this record was created or last modified. On update, set automatically by a trigger.

DEFAULT getdate()

Name	Datatype	Description
ftIdx	numeric(6) not null	A unique ID for each file type. Used when joining with other tables. Also used by the server.
name	varchar(30) not null	The file type name.
host	varchar(30) not null	The name of the machine where the file directory is located.
directory	varchar(128) not null	The directory where files of this type are placed.
spaceReserved	int not null	The number of megabytes reserved for files of this type in the file system.
spaceUsed	smallint not null	The number of megabytes used by files of this files of this type
fileFormat	varchar(10) null	The format of the file: i.e., text, tiff, VICAR, etc.
proprietaryTime	datetime null	When specified, files modified after this date and time are proprietary. You must have both get and proprietary capabilities to retrieve them.
compressionType	varchar(20) null	If files of this type are compressed, this denotes the compression alrorithm used.
feiServerIdx	numeric(3) not null	The ID of the server that manages this type of file. See the feiServers table.
mission	tinyint not null	The ID of the mission with which this file type is associated. Missions ID's are defined in dba.dbo.missions. If the file is associated with a mission, this value is 0.
	DEFAULT 0
description	varchar(255) null	A description of the file type. People not familiar with the mission find this helpful.
crcFlag	bit not null	If CRC's are to be computed whenever a file of this type is transfered, the value is 1. Otherwise, it's 0.
encryptFlag	bit not null	If files of this type are to be encrypted when transfered, the value is 1. Otherwisse, it's 0.
modified	datetime not null	The date and time this record was created or last modified. On update, set automatically by a trigger.
	DEFAULT getdate()