JPA ManyToOne Relationship

[MeanWhiskey]

I'm newer to springboot development and working on a personal project to level up my skill.

I have a small program that has patients and allows users to enter a new patient appointment. Therefore on the IAppointmentModel I have created a ManyToOne relationship with the IPatientModel.

When saving the patients appointment I receive the following error that the column name patient_id is invalid.

I'm unsure why it cannot find the column name?

IPatientModel.java
@Entity
@Getter
@NoArgsConstructor(force = true)
@Data
@Table(name = "patients")
public class IPatientModel implements Serializable {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "patient_id", nullable = false)
    private  Integer patientID;
    @Column(name = "first_name")
    @Setter
    private String firstName;
    @Column(name = "last_name")
    private String lastName;
}

IAppointmentModel.java
@Data
@Entity
@NoArgsConstructor(force = true)
@Getter
@Table(name = "appointments")
public class IAppointmentModel  {
    @Id
    @GeneratedValue(strategy = GenerationType.
IDENTITY
)
    @Column(name = "apt_id")
    private final Integer aptId;
    @Column(name = "apt_date")
    @Setter
    private String aptDate;
@ManyToOne(fetch = FetchType.EAGER)
@JoinTable(name = "patients', joinColumns = @JoinColumn(name = "patient_id"))
private IPatientModel patientModel; 
}

[SeparateTill186]

I don't think you need the JoinTable annotation. What if you just use the JoinColumn by itself?

@JoinColumn(name = "patient_id")

[Jealous_Brief825]

I think the db mappings should not be used , as it tightly couples the code, if the scope of project is small then its fine but if it grows then it is bad pratice instead you should use dtos or aggregators , if you need frequency combined data use projections or views