🐛 Bug Report: relation fields with names that include "id" should be created properly

### What happened?

When using Jovu, the AI model sometimes sends a request to create a field with the type "Lookup" (for relation), and the name of the field is sent with a suffix ID (which is not expected).
For example, the field name is "customerId" instead of "customer" - this causes the field to be created as a SingleLineText because the entity is not found

### What you expected to happen

Amplication should create the field as relation and use the property naming convention with out the suffix a

### How to reproduce

use Jovu and ask to create a relation called "customerId" from table x to table customer

### Amplication version

_No response_

### Environment

_No response_

### Are you willing to submit PR?

_No response_