Naming foreign keys

1. Use the format ${other_table}_id to name foreign keys.
2. If you have multiple foreign keys in a table pointing to the same table, try to identify the role of each foreign key and use this name.