Table of Contents



pears.HTMLImage

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Description

Links to contactevent - 1 record per image.

Columns

Column Type Null Default Comment
HTMLImageID char(20) NOT NULL
DocType char(20) NOT NULL
DocID char(20) NOT NULL
FileName char(150) NOT NULL
FileHash char(32) NULL
BlobID char(20) NULL

Primary Key

Foreign Keys

Referenced By

Indexes

Name Type Columns Detail
HTMLImageFile Index DocType, DocID, FileName
HTMLImageBlob Index BlobID

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."HTMLImage"
-- Table comment: Links to contactevent - 1 record per image.
-- Statement count: 4
 
CREATE TABLE "pears"."HTMLImage" (
    "HTMLImageID"                    CHAR(20) NOT NULL
   ,"DocType"                        CHAR(20) NOT NULL
   ,"DocID"                          CHAR(20) NOT NULL
   ,"FileName"                       CHAR(150) NOT NULL
   ,"FileHash"                       CHAR(32) NULL
   ,"BlobID"                         CHAR(20) NULL
   ,PRIMARY KEY ("HTMLImageID" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."HTMLImage" IS 
	'Links to contactevent - 1 record per image.'
GO
 
 
CREATE INDEX "HTMLImageFile" ON "pears"."HTMLImage"
    ( "DocType","DocID","FileName" )
GO
 
 
CREATE INDEX "HTMLImageBlob" ON "pears"."HTMLImage"
    ( "BlobID" )
GO