ClientUserImages

Primary Key

Primary Key	Field Type
ID	int

Fields

Field	Field Type	Null	Notes	Description
Name	nvarchar(256)	yes
Caption	nvarchar(256)	yes
Category	nvarchar(256)	yes
Sequence	int		Default = 1
Editable	bit		Default = 1
UploadFileName	nvarchar(256)	yes
ImageType	nvarchar(50)	yes
ImageSize	int	yes
ImageContent	image	yes
Approved	bit		Default = 1
Private	bit		Default = 0
Guid	uniqueidentifier	yes	Default = (newid())
OwnerID	int	yes
Deleted	bit		Default = 0

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
ClientUsersID	int		ClientUsers.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_ClientUserImages_ClientUsersID	ClientUsersID
IX_ClientUserImages_GUID_OwnerID_Deleted	Guid, OwnerID, Deleted
PK_ClientUserImages	ID	yes	yes