Table: dbo.Report_Image
Columns
NameTypeConstraintsDescription
report_image_KEYint (4)NOT NULL
report_imageimage (16)NOT NULL
byte_countint (4)NOT NULL
hash_codevarchar (40)NOT NULL40-character hexadecimal-formatted string from the SHA-1 hash of the image for faster look-up.
report_image_guiduniqueidentifier (16)NOT NULLA unique identifer for each report image row.
Primary key
NameColumnsDescription
PK_Report_Imagereport_image_KEY
Unique constraints
NameColumnsDescription
UK_Report_Image$report_image_guidreport_image_guid
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Tickmark__Report_Image__report_image_KEYreport_image_KEYTickmark
FK_Firm__Report_Image__logo__report_image_KEYlogo__report_image_KEYFirm
FK_Firm__Report_Image__signature_1__report_image_KEYsignature_1__report_image_KEYFirm
FK_Firm__Report_Image__signature_2__report_image_KEYsignature_2__report_image_KEYFirm
FK_Firm__Report_Image__signature_3__report_image_KEYsignature_3__report_image_KEYFirm
FK_Employer_Jurisdiction_Payroll_Tax_Information__Report_Image__taxpayer_signature__report_image_KEYtaxpayer_signature__report_image_KEYEmployer_Jurisdiction_Payroll_Tax_Information
FK_Checkbook__Report_Image__logo__report_image_KEYlogo__report_image_KEYCheckbook
FK_Checkbook__Report_Image__signature_1__report_image_KEYsignature_1__report_image_KEYCheckbook
FK_Checkbook__Report_Image__signature_2__report_image_KEYsignature_2__report_image_KEYCheckbook
FK_Client_AR_Setup__Report_Image__report_image_KEYreport_image_KEYClient_AR_Setup

Schema diagram