To reference to another table, the id referenced must be primary key, and in mysql or mariadb don't use serial but instead use AUTO_INCREMENT if you want the id to be generated