Primary Key Field Type
 ID int

Field Field Type Null Notes Description
 Name nvarchar(256)
 Category nvarchar(256)
 FileName nvarchar(256)
 UploadFileName nvarchar(256)
 ImageType nvarchar(50)
 ImageSize int
 ImageContent image
 Guid uniqueidentifier Default = (newid())
 OwnerID int
 Deleted bit   Default = 0
 Type int   Default = 0
 FolderID int   Default = 0
 Caption nvarchar(255)
 Approved bit   Default = 1
 Private bit   Default = 0
 Photographer nvarchar(255)
 PhotoDateTaken nvarchar(100)
 CreateDate datetime Default = getutcdate()
 CopySourceID int
 CopyBatchGUID uniqueidentifier
 InTrashBin bit   Default = 0
 URL nvarchar(255)

Foreign Key Field Type Null Notes Description
 ClientSitesID int   ClientSites.ID

Index Name Field(s) Unique Primary Clustered
 IX_SiteImages_ClientSitesID ClientSitesID      
 IX_SiteImages_GUID_OwnerID_Deleted Guid, OwnerID, Deleted      
 PK_Images ID  
 UC_CLIENTSITE_URL_SITEIMAGES ClientSitesID, URL    

Referenced by Field
 FAFPARTICIPANTGALLERYIMAGES SITEIMAGESID
 MICROSITECONTENT IMAGEID
 SiteImageFolders SiteImageID
 SITEIMAGESEXTENSION SITEIMAGESID
 SITEIMAGETAG SITEIMAGEID

Entity-Relationship diagram of this table