package io.delphiplatform.api.v3.rdb.entity.video;

import javax.persistence.Column;
import javax.persistence.EmbeddedId;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.Table;

import io.delphiplatform.api.v3.rdb.entity.RegionEntity;
import io.delphiplatform.api.v3.rdb.entity.shazam.ShazamChartEntity;
import io.delphiplatform.api.v3.rdb.entity.shazam.ShazamTrackEntity;
import lombok.EqualsAndHashCode;
import lombok.Getter;
import lombok.Setter;

@Entity
@Table(name = "shazam_chart_track_summary_report")
@Getter
@Setter
@EqualsAndHashCode(of = "id")
public class ShazamChartTrackSummaryReportEntity extends AbstractChartSummaryReportEntity {

    @EmbeddedId
    private ShazamChartTrackSummaryReportId id;

    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn(name = "track_id", insertable = false, updatable = false)
    private ShazamTrackEntity track;

    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn(name = "chart_id", insertable = false, updatable = false)
    private ShazamChartEntity chart;

    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn(name = "country_code", insertable = false, updatable = false)
    private RegionEntity region;

    @Column(name = "isrc")
    private String isrc;

    @Column(name = "total_shazams")
    private Integer totalShazams;

    @Column(name = "total_positions")
    private Integer totalPositions;

}