1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| CREATE TABLE IF NOT EXISTS `ACC_COMP_PROFILE` (
`ACCESS_COMP_PROF_ID` INT NOT NULL AUTO_INCREMENT ,
`ACCESS_PROFILE_ID` INT NOT NULL ,
`COMPONENT_ID` INT NOT NULL ,
`COMPANY_ID` INT NOT NULL ,
`ACCESS_TYPE` CHAR(2) NOT NULL ,
PRIMARY KEY (`ACCESS_COMP_PROF_ID`) ,
UNIQUE INDEX `IX_ACC_COMP_PROFILE` (`ACCESS_PROFILE_ID` ASC, `COMPONENT_ID` ASC, `ACCESS_TYPE` ASC) ,
CONSTRAINT `FK_ACCESS_COMPONENT_PROFILE_SEC_COMPONENT`
FOREIGN KEY (`COMPANY_ID` , `COMPONENT_ID` )
REFERENCES `ezWorkYinosoft`.`SEC_COMPONENT` (`COMPANY_ID` , `SEC_COMPONENT_ID` )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `FK_ACCESS_COMPONENT_PROFILE_PROFILE`
FOREIGN KEY (`COMPANY_ID` , `ACCESS_PROFILE_ID` )
REFERENCES `ACCESS_PROFILE` (`COMPANY_ID` , `ACCESS_PROFILE_ID` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
COLLATE = utf8_general_ci; |
Partager