| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677 |
- package com.its.op.model.entity.database;
- import com.its.op.model.dto.database.IfscDto;
- import lombok.AllArgsConstructor;
- import lombok.Getter;
- import lombok.NoArgsConstructor;
- import org.hibernate.annotations.ColumnDefault;
- import org.hibernate.annotations.DynamicInsert;
- import org.hibernate.annotations.DynamicUpdate;
- import javax.persistence.Column;
- import javax.persistence.Entity;
- import javax.persistence.Id;
- import javax.persistence.Table;
- @DynamicInsert
- @DynamicUpdate
- @Getter
- @NoArgsConstructor
- @AllArgsConstructor
- @Entity
- @Table(name = "TB_IFSC")
- public class Ifsc {
- @Id
- @Column(nullable = false, unique = true, length = 10)
- private Long IFSC_ID; // N NUMBER(10) N 정보제공구간 ID
- @Column(length = 100)
- private String IFSC_NM; // N VARCHAR2(100) Y 정보제공구간 명
- @Column(length = 7)
- private String DRCT_CD; // N VARCHAR2(7) Y 방향 코드
- @Column(length = 100)
- private String STRT_NM; // N VARCHAR2(100) Y 시점 명
- @Column(length = 100)
- private String END_NM; // N VARCHAR2(100) Y 종점 명
- @Column(nullable = false)
- private Integer SECT_LNGT; // N NUMBER(5) Y 0 구간 길이
- @Column(columnDefinition = "CHAR", length = 1)
- @ColumnDefault(value = "N")
- private String EXTR_CNCT_SECT_YN; // N CHAR(1) Y 'N' 외부 연계 구간 여부
- @Column(length = 600)
- private String RMRK; // N VARCHAR2(600) Y 비고
- @Column(nullable = false, length = 10)
- private Long F_NODE_ID; // N NUMBER(10) Y 시작 노드 ID
- @Column(nullable = false, length = 10)
- private Long T_NODE_ID; // N NUMBER(10) Y 종료 노드 ID
- @Column(nullable = false, length = 7)
- private String SECT_GRAD_CD; // N VARCHAR2(7) Y 구간 등급 코드
- @Column(nullable = false, length = 7)
- private String AREA_CD; // N VARCHAR2(7) Y 지역 코드
- @Column(columnDefinition = "CHAR", length = 1)
- @ColumnDefault(value = "N")
- private String DEL_YN; // N CHAR(1) Y 'N' 삭제 여부
- /*@OneToOne(mappedBy = "ifscInfo")
- @Fetch(FetchMode.JOIN)
- private IfscTraf ifscTraf = new IfscTraf();*/
- /* @OneToOne
- @JoinColumn(insertable=false, updatable=false, name="IFSC_ID", referencedColumnName = "IFSC_ID")
- private IfscTraf traf = new IfscTraf();
- @OneToOne
- @JoinColumn(insertable=false, updatable=false, name="F_NODE_ID", referencedColumnName = "NODE_ID")
- private Node from_node = new Node();
- @OneToOne
- @JoinColumn(insertable=false, updatable=false, name="T_NODE_ID", referencedColumnName = "NODE_ID")
- private Node to_node= new Node();*/
- public void updateName(IfscDto.IfscNameUpdateReq req) {
- this.IFSC_NM = req.getIFSC_NM();
- this.STRT_NM = req.getSTRT_NM();
- this.END_NM = req.getEND_NM();
- }
- }
|