Table: Report_Image
Columns
NameTypeConstraintsDescription
report_image_KEYintNOT NULL
report_imagevarbinary (-1)NOT NULL
byte_countintNOT NULL
file_pathnvarchar (260)NOT NULL
create_date_utcdatetimeNOT NULL
hash_codevarchar (40)NOT NULL40-character hexadecimal-formatted string from the SHA-1 hash of the image for faster look-up.
Primary key
NameColumnsDescription
PK_Report_Image$report_image_KEYreport_image_KEYCLUSTERED
Indexes
NameColumnsDescription
IX_Report_Image$byte_count$hash_codebyte_count, hash_code

Schema diagram