🔒 Closed Mysql foreign key, can't create table (errno: 150)

[Chainsaw-Man]

Pahelp po kasi hindi ko malaman kung bakit nag eerror code na to

MariaDB [2a_mdr]> create table Emp_Group_Info
   -> (
   -> Philhealth_No bigint,
   -> Name_Of_Emp varchar(50),
   -> Business_Add varchar(80),
   -> Tel_No varchar(50),
   -> TIN varchar(50),
   -> foreign key(TIN) references Member_Information (Philhealth_IN)
   -> );

Ano po kaya ang mali? Pls. Help
Maraming salamat po sa makakatulong

 

[Chance-]

Up natin to, sana may tumulong.

 

[Futility]

pareho po ng datatype yung foreign key tsaka referencing key?

 

[Chainsaw-Man]

pareho po ng datatype yung foreign key tsaka referencing key?

Pano po dapat gawin?

 

[Futility]

check niyo po kung pareho ng datatype ang foreign key niyo sa referencing key, baka kasi yung isa varchar tapos isa int dapat pareho silang either varchar o int...

 

[Romeo-14]

Up! Pakipansin naman to mga pro's

 

[Chainsaw-Man]

pareho po ng datatype yung foreign key tsaka referencing key?

Pano po dapat gawin?

check niyo po kung pareho ng datatype ang foreign key niyo sa referencing key, baka kasi yung isa varchar tapos isa int dapat pareho silang either varchar o int...

Ok na po..maraming maraming salamat

 

[Futility]

welcome po...