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

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

import io.delphiplatform.api.v3.constant.ChartmetricPartner;
import io.delphiplatform.api.v3.rdb.entity.RegionEntity;
import lombok.Getter;
import lombok.Setter;

@Entity
@Table(name = "dim_amazon_chart", schema = ChartmetricPartner.AMAZON)
@Getter
@Setter
public class AmazonChartEntity {

    @Id
    @Column(name = "chart_id")
    private String chartId;

    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn(name = "genre_id", insertable = false, updatable = false)
    private AmazonGenreEntity genre;

    @Column(name = "genre_id")
    private Long genreId;

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

    @Column(name = "country_code")
    private String countryCode;

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