Ifsc.java 2.9 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677
  1. package com.its.op.model.entity.database;
  2. import com.its.op.model.dto.database.IfscDto;
  3. import lombok.AllArgsConstructor;
  4. import lombok.Getter;
  5. import lombok.NoArgsConstructor;
  6. import org.hibernate.annotations.ColumnDefault;
  7. import org.hibernate.annotations.DynamicInsert;
  8. import org.hibernate.annotations.DynamicUpdate;
  9. import javax.persistence.Column;
  10. import javax.persistence.Entity;
  11. import javax.persistence.Id;
  12. import javax.persistence.Table;
  13. @DynamicInsert
  14. @DynamicUpdate
  15. @Getter
  16. @NoArgsConstructor
  17. @AllArgsConstructor
  18. @Entity
  19. @Table(name = "TB_IFSC")
  20. public class Ifsc {
  21. @Id
  22. @Column(nullable = false, unique = true, length = 10)
  23. private Long IFSC_ID; // N NUMBER(10) N 정보제공구간 ID
  24. @Column(length = 100)
  25. private String IFSC_NM; // N VARCHAR2(100) Y 정보제공구간 명
  26. @Column(length = 7)
  27. private String DRCT_CD; // N VARCHAR2(7) Y 방향 코드
  28. @Column(length = 100)
  29. private String STRT_NM; // N VARCHAR2(100) Y 시점 명
  30. @Column(length = 100)
  31. private String END_NM; // N VARCHAR2(100) Y 종점 명
  32. @Column(nullable = false)
  33. private Integer SECT_LNGT; // N NUMBER(5) Y 0 구간 길이
  34. @Column(columnDefinition = "CHAR", length = 1)
  35. @ColumnDefault(value = "N")
  36. private String EXTR_CNCT_SECT_YN; // N CHAR(1) Y 'N' 외부 연계 구간 여부
  37. @Column(length = 600)
  38. private String RMRK; // N VARCHAR2(600) Y 비고
  39. @Column(nullable = false, length = 10)
  40. private Long F_NODE_ID; // N NUMBER(10) Y 시작 노드 ID
  41. @Column(nullable = false, length = 10)
  42. private Long T_NODE_ID; // N NUMBER(10) Y 종료 노드 ID
  43. @Column(nullable = false, length = 7)
  44. private String SECT_GRAD_CD; // N VARCHAR2(7) Y 구간 등급 코드
  45. @Column(nullable = false, length = 7)
  46. private String AREA_CD; // N VARCHAR2(7) Y 지역 코드
  47. @Column(columnDefinition = "CHAR", length = 1)
  48. @ColumnDefault(value = "N")
  49. private String DEL_YN; // N CHAR(1) Y 'N' 삭제 여부
  50. /*@OneToOne(mappedBy = "ifscInfo")
  51. @Fetch(FetchMode.JOIN)
  52. private IfscTraf ifscTraf = new IfscTraf();*/
  53. /* @OneToOne
  54. @JoinColumn(insertable=false, updatable=false, name="IFSC_ID", referencedColumnName = "IFSC_ID")
  55. private IfscTraf traf = new IfscTraf();
  56. @OneToOne
  57. @JoinColumn(insertable=false, updatable=false, name="F_NODE_ID", referencedColumnName = "NODE_ID")
  58. private Node from_node = new Node();
  59. @OneToOne
  60. @JoinColumn(insertable=false, updatable=false, name="T_NODE_ID", referencedColumnName = "NODE_ID")
  61. private Node to_node= new Node();*/
  62. public void updateName(IfscDto.IfscNameUpdateReq req) {
  63. this.IFSC_NM = req.getIFSC_NM();
  64. this.STRT_NM = req.getSTRT_NM();
  65. this.END_NM = req.getEND_NM();
  66. }
  67. }