pears.ComplianceDomainTag

Tags used in Compliance Domains

• ComplianceDomainID, TagLocation, TagID, TagChoiceID

• No incoming foreign keys found.

• No indexes found.

• No triggers found.

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