MySQL foreign key error?

Just remove NOT NULL from "REC_LAB_CODE INT(7) PRIMARY KEY NOT NULL,". A Primary Key is never NULL. So there's no need to specifically mention NOT NULL there.