Table containing images/photos uploaded by the constituents/participants of a fundraising event.
Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
NAME
|
nvarchar(256)
|
false
|
|
Label/name of the image.
|
|
DESCRIPTION
|
nvarchar(256)
|
false
|
|
Description of the image.
|
|
FILENAME
|
nvarchar(256)
|
false
|
|
Name of file with extension
|
|
UPLOADFILENAME
|
nvarchar(256)
|
false
|
|
Path, filename and extension of the originally uploaded file.
|
|
IMAGETYPE
|
nvarchar(50)
|
false
|
|
Mime type of the image.
|
|
IMAGESIZE
|
int
|
false
|
|
Number of bytes in the image.
|
|
IMAGECONTENT
|
varbinary
|
true
|
|
The serialized image file.
|
|
CAPTION
|
nvarchar(256)
|
false
|
|
|
|
APPROVED
|
bit
|
false
|
|
Flag to be used for needed approval.
|
|
PRIVATE
|
bit
|
false
|
|
Flag images only viewable by the participant.
|
|
PHOTOGRAPHER
|
nvarchar(256)
|
false
|
|
Image creator.
|
|
PHOTODATETAKEN
|
datetime
|
true
|
|
Date the photo was taken.
|
|
TAGS
|
nvarchar(256)
|
false
|
|
Tags to assign photo, space separated.
|
|
EXTERNALFLAG
|
bit
|
false
|
|
Flags photos housed at external sources.
|
|
IMAGESOURCECODE
|
tinyint
|
false
|
|
Where the image was added from.
|
|
IMAGESOURCE
|
nvarchar(11) (Computed)
|
true
|
|
Provides a translation for the 'IMAGESOURCECODE' field.
|
|
EXTERNALURL
|
nvarchar(256)
|
false
|
|
URL to image if the image is not contained in the IMAGECONTENT.
|
|
DATEADDED
|
datetime
|
false
|
|
Indicates the date this record was added.
|
|
DATECHANGED
|
datetime
|
false
|
|
Indicates the date this record was last changed.
|
|
TS
|
timestamp
|
false
|
|
Timestamp.
|
|
TSLONG
|
bigint (Computed)
|
true
|
|
Numeric representation of the timestamp.
|
