Creating my migrations in Laravel I had the following doubt:
I have these two tables:
Used
TRADEMARKS
migration to save the tag ID I would do so:
$table->integer('marca_id')->unsigned();
$table->foreign('marca_id')->references('id')->on('marcas');
All information is stored through a form. And if I want to save USADOS to column NOME_MARCA_ID Nome and not ID would be possible?
This practice, in addition to Mysql does not allow, does not make much sense. First, in order to relate two tables, the reference field must necessarily have identical properties. Second, you can generate an integrity error if in Marcas the NOME field can be repeated with the same data in another record.
The best way to do this is by the key, which in this case is id , so that you can retrieve all other data from the relationship, including Nome , which is the field in question.
I hope I have helped
A query with 'Inner Join' already helps get the 'Brand' name.
Any questions, we're there.