Не могу подключить модель созданную в Workbench 8 к базе данных. Выдает ошибку Error 3780

Executing SQL script in server ERROR: Error 3780: Referencing column 'TYPE_AUTHORSHIP' and referenced column 'TYPE_AUTHORSHIP' in foreign key constraint 'TYPE_AUTHORSHIP' are incompatible. SQL Code:

    -- -----------------------------------------------------
    -- Table `MUSIC_SYSTEM`.`AUTHORS_MUSIC_PIECE`
    -- -----------------------------------------------------
    CREATE TABLE IF NOT EXISTS `MUSIC_SYSTEM`.`AUTHORS_MUSIC_PIECE` (
      `NO_MUSIC_PIECE` SMALLINT(6) NOT NULL,
      `TYPE_AUTHORSHIP` VARCHAR(10) NOT NULL,
      `ID_PERSON` CHAR(6) NOT NULL,
      INDEX `NO_MUSIC_PIECE (FK)_idx` (`NO_MUSIC_PIECE` ASC) VISIBLE,
      INDEX `TYPE_AUTHORSHIP_idx` (`TYPE_AUTHORSHIP` ASC) VISIBLE,
      INDEX `ID_PERSON_idx` (`ID_PERSON` ASC) VISIBLE,
      CONSTRAINT `NO_MUSIC_PIECE`
        FOREIGN KEY (`NO_MUSIC_PIECE`)
        REFERENCES `MUSIC_SYSTEM`.`MUSIC_PIECE` (`NO_MUSIC_PIECE`)
        ON DELETE CASCADE
        ON UPDATE CASCADE,
      CONSTRAINT `TYPE_AUTHORSHIP`
        FOREIGN KEY (`TYPE_AUTHORSHIP`)
        REFERENCES `MUSIC_SYSTEM`.`AUTHORSHIP` (`TYPE_AUTHORSHIP`)
        ON DELETE CASCADE
        ON UPDATE CASCADE,
      CONSTRAINT `ID_PERSON`
        FOREIGN KEY (`ID_PERSON`)
        REFERENCES `MUSIC_SYSTEM`.`PERSON` (`ID_PERSON`)
        ON DELETE CASCADE
        ON UPDATE CASCADE)
    ENGINE = InnoDB

SQL script execution finished: statements: 10 succeeded, 1 failed

Fetching back view definitions in final form. Nothing to fetch