pears.CompanyDeptDocType

Used to set standard Document Types to attach when sending CVs.

• CDDTid

• No incoming foreign keys found.

• No indexes found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."CompanyDeptDocType"
-- Table comment: Used to set standard Document Types to attach when sending CVs.
-- Statement count: 5
 
CREATE TABLE "pears"."CompanyDeptDocType" (
    "CDDTid"                         CHAR(20) NOT NULL
   ,"documenttypeid"                 CHAR(20) NULL
   ,"departmentid"                   CHAR(2) NULL
   ,"companyid"                      CHAR(20) NULL
   ,PRIMARY KEY ("CDDTid" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."CompanyDeptDocType" IS 
	'Used to set standard Document Types to attach when sending CVs.'
GO
 
 
ALTER TABLE "pears"."CompanyDeptDocType"
    ADD FOREIGN KEY "documenttype" ("documenttypeid" ASC)
    REFERENCES "pears"."DocumentType" ("DocumentTypeID")
    ON DELETE CASCADE
GO
 
 
ALTER TABLE "pears"."CompanyDeptDocType"
    ADD FOREIGN KEY "department" ("departmentid" ASC)
    REFERENCES "pears"."Department" ("departmentid")
    ON DELETE CASCADE
GO
 
 
ALTER TABLE "pears"."CompanyDeptDocType"
    ADD FOREIGN KEY "company" ("companyid" ASC)
    REFERENCES "pears"."Company" ("companyid")
    ON DELETE CASCADE
GO