Table of Contents



pears.ComplianceDomainTag

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

Description

Tags used in Compliance Domains

Columns

Column Type Null Default Comment
ComplianceDomainID char(20) NOT NULL
TagLocation char(2) NOT NULL P for Person questionnaire, A% for Departmental
TagID char(3) NOT NULL
TagChoiceID char(4) NOT NULL 'N/A' N/A signifies any or not applicable. Cannot be null because of pk.
Behaviour tinyint NOT NULL 1 1=required 2=warning 3=score only
Score smallint NOT NULL 1
MinValue double NOT NULL 1 For numerics, scored and graded choices
SortOrder smallint NULL

Primary Key

Foreign Keys

Constraint Columns References Delete/update action
ComplianceDomain ComplianceDomainID pears.ComplianceDomain (ComplianceDomainID) NOT NULL; ON DELETE CASCADE

Referenced By

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."ComplianceDomainTag"
-- Table comment: Tags used in Compliance Domains
-- Statement count: 7
 
CREATE TABLE "pears"."ComplianceDomainTag" (
    "ComplianceDomainID"             CHAR(20) NOT NULL
   ,"TagLocation"                    CHAR(2) NOT NULL
   ,"TagID"                          CHAR(3) NOT NULL
   ,"TagChoiceID"                    CHAR(4) NOT NULL DEFAULT 'N/A'
   ,"Behaviour"                      tinyint NOT NULL DEFAULT 1
   ,"Score"                          SMALLINT NOT NULL DEFAULT 1
   ,"MinValue"                       DOUBLE NOT NULL DEFAULT 1
   ,"SortOrder"                      SMALLINT NULL
   ,PRIMARY KEY ("ComplianceDomainID" ASC,"TagLocation" ASC,"TagID" ASC,"TagChoiceID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."ComplianceDomainTag"."TagLocation" IS 
	'P for Person questionnaire, A% for Departmental'
GO
 
 
COMMENT ON COLUMN "pears"."ComplianceDomainTag"."TagChoiceID" IS 
	'N/A signifies any or not applicable. Cannot be null because of pk.'
GO
 
 
COMMENT ON COLUMN "pears"."ComplianceDomainTag"."Behaviour" IS 
	'1=required 2=warning 3=score only'
GO
 
 
COMMENT ON COLUMN "pears"."ComplianceDomainTag"."MinValue" IS 
	'For numerics, scored and graded choices'
GO
 
 
COMMENT ON TABLE "pears"."ComplianceDomainTag" IS 
	'Tags used in Compliance Domains'
GO
 
 
ALTER TABLE "pears"."ComplianceDomainTag"
    ADD NOT NULL FOREIGN KEY "ComplianceDomain" ("ComplianceDomainID" ASC)
    REFERENCES "pears"."ComplianceDomain" ("ComplianceDomainID")
    ON DELETE CASCADE
GO