Table of Contents



pears.DeletedTag

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

Description

Record of deleted tag data. Purpose to save time recovering data if tag deleted by mistake. Cleared after 6 months

Columns

Column Type Null Default Comment
DeletedID integer NOT NULL autoincrement
InstanceID char(20) NULL Group all deletes together
WhenDeleted date NULL Used by cleanup and if multiple deletes
taglocation char(3) NULL
tagid char(3) NULL
tagtype char(1) NOT NULL
description char(60) NOT NULL
sortorder smallint NULL
minstep double NULL
units char(10) NULL
required smallint NULL
readonly smallint NULL
displaygroup smallint NULL 0
wizarddisplaygroup smallint NULL 0
fixed smallint NULL 0
AuditFlag smallint NULL 0
PublishToWeb smallint NULL 0
PublicOnWeb smallint NULL 0 Viewable, but not editable, by 3rd parties on web
NonSearchable smallint NULL 0
HeadingExpanded smallint NULL 0
HeadingAnswers smallint NULL 0
Expiry smallint NULL
ExpiryBehaviour smallint NULL
LongDescription long varchar NULL
Archived tinyint NULL
BackgroundColour integer NULL 16777215
FontColour integer NULL 0
IncludeInKeyWordSearch tinyint NOT NULL 0
DependsOnTagid char(3) NULL Ask if this tag is filled (in same taglocation), and DependsOnTagchoiceid is selected or null
DependsOnTagchoiceid char(4) NULL Ask if this DependsOnTagid choice is selected or null
WebDescription long varchar NULL
MinValue double NULL 0
MaxValue double NULL 0

Primary Key

Foreign Keys

Referenced By

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."DeletedTag"
-- Table comment: Record of deleted tag data. Purpose to save time recovering data if tag deleted by mistake. Cleared after 6 months
-- Statement count: 7
 
CREATE TABLE "pears"."DeletedTag" (
    "DeletedID"                      INTEGER NOT NULL DEFAULT autoincrement
   ,"InstanceID"                     CHAR(20) NULL
   ,"WhenDeleted"                    DATE NULL
   ,"taglocation"                    CHAR(3) NULL
   ,"tagid"                          CHAR(3) NULL
   ,"tagtype"                        CHAR(1) NOT NULL
   ,"description"                    CHAR(60) NOT NULL
   ,"sortorder"                      SMALLINT NULL
   ,"minstep"                        DOUBLE NULL
   ,"units"                          CHAR(10) NULL
   ,"required"                       SMALLINT NULL
   ,"readonly"                       SMALLINT NULL
   ,"displaygroup"                   SMALLINT NULL DEFAULT 0
   ,"wizarddisplaygroup"             SMALLINT NULL DEFAULT 0
   ,"fixed"                          SMALLINT NULL DEFAULT 0
   ,"AuditFlag"                      SMALLINT NULL DEFAULT 0
   ,"PublishToWeb"                   SMALLINT NULL DEFAULT 0
   ,"PublicOnWeb"                    SMALLINT NULL DEFAULT 0
   ,"NonSearchable"                  SMALLINT NULL DEFAULT 0
   ,"HeadingExpanded"                SMALLINT NULL DEFAULT 0
   ,"HeadingAnswers"                 SMALLINT NULL DEFAULT 0
   ,"Expiry"                         SMALLINT NULL
   ,"ExpiryBehaviour"                SMALLINT NULL
   ,"LongDescription"                long VARCHAR NULL
   ,"Archived"                       tinyint NULL
   ,"BackgroundColour"               INTEGER NULL DEFAULT 16777215
   ,"FontColour"                     INTEGER NULL DEFAULT 0
   ,"IncludeInKeyWordSearch"         tinyint NOT NULL DEFAULT 0
   ,"DependsOnTagid"                 CHAR(3) NULL
   ,"DependsOnTagchoiceid"           CHAR(4) NULL
   ,"WebDescription"                 long VARCHAR NULL
   ,"MinValue"                       DOUBLE NULL DEFAULT 0
   ,"MaxValue"                       DOUBLE NULL DEFAULT 0
   ,PRIMARY KEY ("DeletedID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."DeletedTag"."InstanceID" IS 
	'Group all deletes together'
GO
 
 
COMMENT ON COLUMN "pears"."DeletedTag"."WhenDeleted" IS 
	'Used by cleanup and if multiple deletes '
GO
 
 
COMMENT ON COLUMN "pears"."DeletedTag"."PublicOnWeb" IS 
	'Viewable, but not editable, by 3rd parties on web'
GO
 
 
COMMENT ON COLUMN "pears"."DeletedTag"."DependsOnTagid" IS 
	'Ask if this tag is filled (in same taglocation), and DependsOnTagchoiceid is selected or null'
GO
 
 
COMMENT ON COLUMN "pears"."DeletedTag"."DependsOnTagchoiceid" IS 
	'Ask if this DependsOnTagid choice is selected or null'
GO
 
 
COMMENT ON TABLE "pears"."DeletedTag" IS 
	'Record of deleted tag data. Purpose to save time recovering data if tag deleted by mistake. Cleared after 6 months'
GO