I'm wondering if there is any good convention for key attributes in relational datatables.ID or Id seems to be good. however it conflict with others ids when joining.MyTableNameId does not conflicts when joining, however your software must know the ID name for each table. There is any good practice?
What is a good convention for table key id name?
relational database;keys