source: src/main/java/com/example/skychasemk/model/TopMonthlyReport.java

package com.example.skychasemk.model;

import jakarta.persistence.*;
import lombok.Getter;
import lombok.Setter;
import org.hibernate.annotations.Immutable;

import java.time.LocalDate;
@Setter
@Getter
@Entity
@Table(name="topmonhtlyreport")
@IdClass(TopMonthlyReportId.class) // Define composite key

public class TopMonthlyReport {
    // Getters and Setters
    @Id
    @Column(name = "month")
    private LocalDate month;
    @Id
    @Column(name = "category")
    private String category;
    @Id
    @Column(name = "name")
    private String name;
    @Column(name = "count")
    private int count;

}