DocUploadFiles

Primary Key

Primary Key	Field Type
ID	int

Fields

Field	Field Type	Null	Notes	Description
CID	int	yes
Name	nvarchar(100)
FileName	nvarchar(100)
Description	nvarchar(1024)	yes
ContentType	nvarchar(255)
OwnerID	int
UploadDate	datetime		Default = getutcdate()
Approved	bit	yes
Size	int	yes
Contents	image	yes
Guid	uniqueidentifier		Default = (newid())
CLIENTSITESID	int	yes
INTRASHBIN	bit		Default = 0
URL	nvarchar(255)	yes
DISCOVERABLE	bit		Default = 0
DISCOVERABLETITLE	nvarchar(255)	yes
DISCOVERABLESUMMARY	nvarchar(4000)	yes

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
FOLDERID	int	yes	SiteFolders.FolderID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_DocUploadFiles_CID	CID
PK_DocUploadFiles	ID	yes	yes	yes
UC_CLIENTSITE_URL_DOCUPLOADFILES	CLIENTSITESID, URL	yes

Referenced by

Referenced by	Field
CUSTOMFORMENTRYDOCUMENT	DOCUPLOADFILEID
EA7_AssignmentDocuments	DocID
SITEFILETAG	FILEID