pears.templatestore

Word document template details. Actual templates are in the BlobStore with Class 'T'.

• templateid

• No indexes found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."templatestore"
-- Table comment: Word document template details. Actual templates are in the BlobStore with Class 'T'.
-- Statement count: 4
 
CREATE TABLE "pears"."templatestore" (
    "templateid"                     CHAR(20) NOT NULL
   ,"description"                    CHAR(50) NULL
   ,"templatetype"                   CHAR(1) NULL
   ,"agencyid"                       CHAR(20) NULL
   ,"sortorder"                      SMALLINT NULL
   ,"esign"                          tinyint NULL DEFAULT 0
   ,"FormFields"                     tinyint NULL DEFAULT 0
   ,"Defunct"                        tinyint NULL DEFAULT 0
   ,PRIMARY KEY ("templateid" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."templatestore"."FormFields" IS 
	'Uses form fields, not document variables'
GO
 
 
COMMENT ON TABLE "pears"."templatestore" IS 
	'Word document template details. Actual templates are in the BlobStore with Class ''T''.'
GO
 
 
ALTER TABLE "pears"."templatestore"
    ADD FOREIGN KEY "agencydetails" ("agencyid" ASC)
    REFERENCES "pears"."agencydetails" ("agencyid")
    ON DELETE SET NULL
GO