Hi. I’m looking for input on best practices in regards to entity attributes. Should the entity attribute and database table column name always match? Here are two situations where I think a difference may be appropriate.
- Company Name. We would want Company.name to be the attribute but “name” is a reserved word in the database. So perhaps the COMPANY table column should be COMPANY_NAME.
- Important Flag. We would want Company.important to be the attribute but maybe IS_IMPORTANT or IMPORTANT_F is a more appropriate column name.