pears.ComplianceDomain

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

Description

Compliance template for scoring a candidate

Column	Type	Null	Comment
ComplianceDomainID	char(20)	NOT NULL
Name	char(100)	NOT NULL
DepartmentID	char(2)	NULL	null for non-departmental
ClientTempComplianceCode	char(12)	NULL	Allows client specific compliance domains

ComplianceDomainID

Constraint	Columns	References	Delete/update action
Department	DepartmentID	pears.Department (departmentid)	ON DELETE CASCADE

Table	Constraint	Columns	Referenced columns
pears.ComplianceDocumentType	ComplianceDomain	ComplianceDomainID	ComplianceDomainID
pears.ComplianceDomainTag	ComplianceDomain	ComplianceDomainID	ComplianceDomainID
pears.ComplianceLinkedDomain	ComplianceLinkedDomain1	ComplianceDomainID	ComplianceDomainID
pears.ComplianceLinkedDomain	ComplianceLinkedDomain2	ComplianceLinkedDomainID	ComplianceDomainID
pears.CompliancePersonDomain	ComplianceDomain	ComplianceDomainID	ComplianceDomainID
pears.ComplianceReferenceType	ComplianceDomain	ComplianceDomainID	ComplianceDomainID
pears.TempShiftTemplate	ComplianceDomain	ComplianceDomainID	ComplianceDomainID
pears.vacancy	ComplianceDomain	ComplianceDomainID	ComplianceDomainID

No indexes found.

No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."ComplianceDomain"
-- Table comment: Compliance template for scoring a candidate
-- Statement count: 5
 
CREATE TABLE "pears"."ComplianceDomain" (
    "ComplianceDomainID"             CHAR(20) NOT NULL
   ,"Name"                           CHAR(100) NOT NULL
   ,"DepartmentID"                   CHAR(2) NULL
   ,"ClientTempComplianceCode"       CHAR(12) NULL
   ,PRIMARY KEY ("ComplianceDomainID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."ComplianceDomain"."DepartmentID" IS 
	'null for non-departmental'
GO
 
 
COMMENT ON COLUMN "pears"."ComplianceDomain"."ClientTempComplianceCode" IS 
	'Allows client specific compliance domains'
GO
 
 
COMMENT ON TABLE "pears"."ComplianceDomain" IS 
	'Compliance template for scoring a candidate'
GO
 
 
ALTER TABLE "pears"."ComplianceDomain"
    ADD FOREIGN KEY "Department" ("DepartmentID" ASC)
    REFERENCES "pears"."Department" ("departmentid")
    ON DELETE CASCADE
GO

pears.ComplianceDomain

Description

Columns

Primary Key

Foreign Keys

Referenced By

Indexes

Triggers

Original SQL

iqx