   `UPDATE_USER_ID` VARCHAR(32) NOT NULL,
   `UPDATE_TS` DATETIME NOT NULL,
   PRIMARY KEY (`GRE_UID`),
-  CONSTRAINT `fk_GROUP_EMPLOYEE_ASSOC_EMPLOYEES1`
+  CONSTRAINT `fk_GROUP_PARTY_ASSOC_PARTY1`
     FOREIGN KEY (`PTY_UID_FK`)
     REFERENCES `calordersdb`.`PARTY` (`PTY_UID`)
     ON DELETE NO ACTION
     ON UPDATE NO ACTION,
-  CONSTRAINT `fk_GROUP_EMPLOYEE_ASSOC_GROUPS1`
+  CONSTRAINT `fk_GROUP_PARTY_ASSOC_GROUPS1`
     FOREIGN KEY (`GRP_UID_FK`)
-    REFERENCES `calordersdb`.`GROUP` (`GRP_UID`)
+    REFERENCES `calordersdb`.`GROUPS` (`GRP_UID`)
     ON DELETE NO ACTION
     ON UPDATE NO ACTION)
 ENGINE = InnoDB

  PRIMARY KEY (`PRV_UID`),
  CONSTRAINT `fk_PRIVILEGES_GROUPS`
    FOREIGN KEY (`GRP_UID_FK`)
    REFERENCES `calordersdb`.`GROUP` (`GRP_UID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;

ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;

CREATE UNIQUE INDEX `DEP_UID_UNIQUE` ON `calordersdb`.`DEPARTMENT` (`DEP_UID` ASC);


-- -----------------------------------------------------
