I'm working with a table in database that references to a column in another table. Such as:
Product Table ------------ Id Description Currencies_Code Currencies ------------ Id Code Description
We have the convention:
"Foreign key fields should be a combination of the name of the referenced table and the name of the referenced fields."
Until there, everything is fine. Now, a second column should be added referencing to Currencies table "Code" column for a second scenario where another currency should be used.
My initial idea was using these columns:
However, the suffix Internal/External breaks the convention.
Which way of naming would be the most appropiate in this case to change the convention?