I am trying to make a junction table, but I getting a ERROR 1005 errno 150
CREATE TABLE 61furiousFistPokemon(
cardNumber int NOT NULL PRIMARY KEY,
pokemonName VARCHAR(12),
type VARCHAR(10),
stage VARCHAR(10),
evolvesFrom VARCHAR(12),
HP INT,
retreatCost INT,
weakness VARCHAR(10),
weaknessAmount VARCHAR(5),
resistance VARCHAR(5),
resistanceAmount VARCHAR(5)
);
CREATE TABLE cardTags (
tagId int NOT NULL AUTO_INCREMENT PRIMARY KEY,
tagName VARCHAR(60) NOT NULL
);
CREATE TABLE 61furiousFistPokemonTags (
tagId int NOT NULL AUTO_INCREMENT PRIMARY KEY,
pokemonCardNumber int,
tagName VARCHAR(60),
FOREIGN KEY (pokemonCardNumber) REFERENCES 61furiousFistPokemon(cardNumber),
FOREIGN KEY (tagName) REFERENCES cardTags(tagName)
);
Any help would be greatly appreciated.
Best Answer
tagName column in table cardTags is not defined as primary key and you are declaring foreign key FOREIGN KEY (tagName) REFERENCES cardTags(tagName).