pears.HTMLImage

Links to contactevent - 1 record per image.

• HTMLImageID

• No outgoing foreign keys found.

• No incoming foreign keys found.

• No triggers found.

-- 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