pears.dictionary

Data dictionary defining search criteria. Tag / Questionaire criteria are not included as these are automatically added to criteria lists.

• dictionaryid, dictionarylocation

• No outgoing foreign keys found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."dictionary"
-- Table comment: Data dictionary defining search criteria. Tag / Questionaire criteria are not included as these are automatically added to criteria lists.
-- Statement count: 7
 
CREATE TABLE "pears"."dictionary" (
    "minstep"                        DOUBLE NULL
   ,"dictionaryid"                   CHAR(20) NOT NULL
   ,"dictionarylocation"             CHAR(3) NOT NULL
   ,"itemtype"                       CHAR(1) NOT NULL
   ,"databaseitem"                   long VARCHAR NOT NULL
   ,"comboselections"                long VARCHAR NULL
   ,"description"                    CHAR(25) NOT NULL
   ,"sortorder"                      SMALLINT NULL
   ,"units"                          CHAR(10) NULL
   ,"complexexpression"              long VARCHAR NULL
   ,"displaygroup"                   SMALLINT NULL DEFAULT 0
   ,PRIMARY KEY ("dictionaryid" ASC,"dictionarylocation" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."dictionary"."itemtype" IS 
	'S String,L Long,C Combo,B Boolean,D Date,N Numeric'
GO
 
 
COMMENT ON COLUMN "pears"."dictionary"."databaseitem" IS 
	'booking.description OR bookingtotal(booking.bookingid)'
GO
 
 
COMMENT ON COLUMN "pears"."dictionary"."comboselections" IS 
	'select desc,id from table OR Male:M;Female:F'
GO
 
 
COMMENT ON COLUMN "pears"."dictionary"."complexexpression" IS 
	'Use if databaseitem is to be part of a subquery. Use <EXPRESSION> for the insertion point of the expression'
GO
 
 
COMMENT ON TABLE "pears"."dictionary" IS 
	'Data dictionary defining search criteria. Tag / Questionaire criteria are not included as these are automatically added to criteria lists.'
GO
 
 
CREATE INDEX "DictionaryLocationSortOrder" ON "pears"."dictionary"
    ( "dictionarylocation","sortorder" )
GO