SiteImages
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | int |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| Name | nvarchar(256) | yes | ||
| Category | nvarchar(256) | yes | ||
| FileName | nvarchar(256) | yes | ||
| UploadFileName | nvarchar(256) | yes | ||
| ImageType | nvarchar(50) | yes | ||
| ImageSize | int | yes | ||
| ImageContent | image | yes | ||
| Guid | uniqueidentifier | yes | Default = (newid()) | |
| OwnerID | int | yes | ||
| Deleted | bit | Default = 0 | ||
| Type | int | Default = 0 | ||
| FolderID | int | Default = 0 | ||
| Caption | nvarchar(255) | yes | ||
| Approved | bit | Default = 1 | ||
| Private | bit | Default = 0 | ||
| Photographer | nvarchar(255) | yes | ||
| PhotoDateTaken | nvarchar(100) | yes | ||
| CreateDate | datetime | yes | Default = getutcdate() | |
| CopySourceID | int | yes | ||
| CopyBatchGUID | uniqueidentifier | yes | ||
| InTrashBin | bit | Default = 0 | ||
| URL | nvarchar(255) | yes | ||
| ThumbX | int | yes | Default = 0 | |
| ThumbY | int | yes | Default = 0 | |
| ThumbLength | int | yes |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| ClientSitesID | int | ClientSites.ID |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_SiteImages_ClientSitesID | ClientSitesID | |||
| IX_SiteImages_GUID_OwnerID_Deleted | Guid, OwnerID, Deleted | |||
| IX_SiteImages_Type_OwnerID | OwnerID, Type | |||
| PK_Images | ID | yes | yes | |
| UC_CLIENTSITE_URL_SITEIMAGES | ClientSitesID, URL | yes | ||
| UC_SITEIMAGES_OWNERID_PROFILEIMAGE | OwnerID, Type | yes |
Referenced by
| Referenced by | Field |
|---|---|
| FAFPARTICIPANTGALLERYIMAGES | SITEIMAGESID |
| MICROSITECONTENT | IMAGEID |
| SiteImageFolders | SiteImageID |
| SITEIMAGESEXTENSION | SITEIMAGESID |
| SITEIMAGETAG | SITEIMAGEID |