CREATE TABLE entity (id BIGINT AUTO_INCREMENT, columnx VARCHAR(255), type VARCHAR(255), PRIMARY KEY(id)) ENGINE = INNODB;
CREATE TABLE entity (id BIGINT AUTO_INCREMENT, columnx VARCHAR(255), type VARCHAR(255), INDEX other_id_idx (other_id), PRIMARY KEY(id)) ENGINE = INNODB;
CREATE TABLE entity (id BIGINT AUTO_INCREMENT, columnx VARCHAR(255), type VARCHAR(255), INDEX entity_type_idx (type), PRIMARY KEY(id)) ENGINE = INNODB;
CREATE TABLE other (id BIGINT AUTO_INCREMENT, columny VARCHAR(255), PRIMARY KEY(id)) ENGINE = INNODB;
ALTER TABLE entity ADD CONSTRAINT entity_other_id_other_id FOREIGN KEY (other_id) REFERENCES other(id);