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."
MyColumn: ExternalTableName_ColumnName
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:
Currencies_Code_Internal
Currencies_Code_External
However, the suffix Internal/External breaks the convention.
Which way of naming would be the most appropiate in this case to change the convention?