package com.its.op.model.entity;

import lombok.AllArgsConstructor;
import lombok.Getter;
import lombok.NoArgsConstructor;
import org.hibernate.annotations.DynamicInsert;
import org.hibernate.annotations.DynamicUpdate;
import org.hibernate.annotations.NotFound;
import org.hibernate.annotations.NotFoundAction;

import javax.persistence.*;

@DynamicInsert
@DynamicUpdate
@Getter
@NoArgsConstructor
@AllArgsConstructor
@Entity
@Table(name = "TB_LINK_TRAF")
public class LinkTraf {

    @Id
    @Column(nullable = false, unique = true, length = 10)
    private Long    LINK_ID;         //	N	NUMBER(10)	    N			링크ID
    @Column(nullable = false, length = 14)
    private String  PRCN_DT;         //	N	VARCHAR2(14)	Y			가공 일시
    @Column(length = 6)
    private Integer TFVL;            //	N	NUMBER(6)	    Y	0		교통량
    @Column(length = 3)
    private Integer SPED;            //	N	NUMBER(3)	    Y	0		속도
    @Column(columnDefinition = "NUMBER", length = 5, precision = 2)
    private Double  OCPY_RATE;       //	N	NUMBER(5,2)	    Y	0		점유 율
    @Column(length = 6)
    private Integer TRVL_HH;         //	N	NUMBER(6)	    Y	0		통행 시간
    @Column(length = 7)
    private String  CMTR_GRAD_CD;    //	N	VARCHAR2(7)	    Y			소통 등급 코드
    @Column(columnDefinition = "CHAR", length = 1)
    private String  MISS_YN;         //	N	CHAR(1)	        Y	'N'		결측 여부
    @Column(length = 3)
    private Integer PRCN_SPED;       //	N	NUMBER(3)	    Y	0		가공 속도
    @Column(length = 3)
    private Integer SMTH_SPED;       //	N	NUMBER(3)	    Y	0		평활화 속도
    @Column(length = 3)
    private Integer ADJS_SPED;       //	N	NUMBER(3)	    Y	0		보정 속도
    @Column(length = 3)
    private Integer PTRN_SPED;       //	N	NUMBER(3)	    Y	0		패턴 속도
    @Column(length = 7)
    private String  PRCN_SORC;       //	N	VARCHAR2(7)	    Y			가공 소스
    @Column(length = 7)
    private String  ADJS_SORC;       //	N	VARCHAR2(7)	    Y			보정 소스
    @Column(length = 3)
    private Integer DATA_NUM;        //	N	NUMBER(3)	    Y	0		데이터 개수

    @OneToOne
    @JoinColumn(insertable=false, updatable=false, name="LINK_ID", referencedColumnName = "LINK_ID")
    @NotFound(action = NotFoundAction.IGNORE)
    private Link link = new Link();
/*
    @OneToOne
    @JoinColumn(insertable=false, updatable=false, name="LINK_ID", referencedColumnName = "LINK_ID")
    private Node from_node = new Node();

    @OneToOne
    @JoinColumn(insertable=false, updatable=false, name="LINK_ID", referencedColumnName = "LINK_ID")
    private Node to_node = new Node();*/
}