pears.DeletedTag

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

• DeletedID

• No outgoing foreign keys found.

• No incoming foreign keys found.

• No indexes found.

• No triggers found.

-- 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