One can establish a relation between two tables with the foreign key. Add foreign key in a column and establish the relation of that table with another table.
Check the solution to add foreign key in database table in Magento 2 at https://meetanshi.co...e-in-magento-2/