Table of Contents



pears.DAXTRAParams

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

Description

Used for Daxtra Document Imports. Populated from Daxtra Web Service.

Columns

Column Type Null Default Comment
DAXTRAParamsID char(20) NOT NULL
id char(20) NULL
dname long varchar NULL
dvalue long varchar NULL

Primary Key

Foreign Keys

Referenced By

Indexes

Name Type Columns Detail
paramsid Index id

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."DAXTRAParams"
-- Table comment: Used for Daxtra Document Imports. Populated from Daxtra Web Service.
-- Statement count: 3
 
CREATE GLOBAL TEMPORARY TABLE "pears"."DAXTRAParams" (
    "DAXTRAParamsID"                 CHAR(20) NOT NULL
   ,"id"                             CHAR(20) NULL
   ,"dname"                          long VARCHAR NULL
   ,"dvalue"                         long VARCHAR NULL
   ,PRIMARY KEY ("DAXTRAParamsID" ASC) 
) ON COMMIT PRESERVE ROWS
GO
 
 
COMMENT ON TABLE "pears"."DAXTRAParams" IS 
	'Used for Daxtra Document Imports. Populated from Daxtra Web Service.'
GO
 
 
CREATE INDEX "paramsid" ON "pears"."DAXTRAParams"
    ( "id" )
GO