pears.SecureDocumentLink

• SecureDocumentLinkID

• 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"."SecureDocumentLink"
-- Table comment: 
-- Statement count: 5
 
CREATE TABLE "pears"."SecureDocumentLink" (
    "SecureDocumentLinkID"           CHAR(20) NOT NULL
   ,"EmailAddress"                   CHAR(100) NOT NULL
   ,"Title"                          CHAR(100) NOT NULL
   ,"DownloadsAllowed"               SMALLINT NULL DEFAULT 1
   ,"SuccessfulDownloads"            SMALLINT NULL DEFAULT 0
   ,"ExpiryDate"                     DATE NULL
   ,"Password"                       CHAR(100) NULL
   ,"PasswordFails"                  SMALLINT NULL DEFAULT 0
   ,"DownloadRecord"                 long VARCHAR NULL
   ,PRIMARY KEY ("SecureDocumentLinkID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."SecureDocumentLink"."SecureDocumentLinkID" IS 
	'Points to blob of class S'
GO
 
 
COMMENT ON COLUMN "pears"."SecureDocumentLink"."Password" IS 
	'For both download attempt AND zip file'
GO
 
 
CREATE INDEX "SDExpiry" ON "pears"."SecureDocumentLink"
    ( "ExpiryDate" )
GO
 
 
CREATE INDEX "SDEmail" ON "pears"."SecureDocumentLink"
    ( "EmailAddress" )
GO