Road.java 2.0 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859
  1. package com.its.op.model.entity.database;
  2. import com.its.op.model.dto.database.RoadDto;
  3. import lombok.AllArgsConstructor;
  4. import lombok.Getter;
  5. import lombok.NoArgsConstructor;
  6. import lombok.Setter;
  7. import org.hibernate.annotations.ColumnDefault;
  8. import org.hibernate.annotations.DynamicInsert;
  9. import org.hibernate.annotations.DynamicUpdate;
  10. import javax.persistence.Column;
  11. import javax.persistence.Entity;
  12. import javax.persistence.Id;
  13. import javax.persistence.Table;
  14. @DynamicInsert
  15. @DynamicUpdate
  16. @Getter
  17. @Setter
  18. @NoArgsConstructor
  19. @AllArgsConstructor
  20. @Entity
  21. @Table(name = "TB_ROAD")
  22. public class Road {
  23. @Id
  24. @Column(nullable = false, unique = true, length = 10)
  25. private Long ROAD_ID; // N NUMBER(10) N 도로 ID
  26. @Column(length = 100)
  27. private String ROAD_NAME; // N VARCHAR2(100) Y 도로 명
  28. @Column(length = 7)
  29. private String DRCT_CD; // N VARCHAR2(7) Y 방향 코드
  30. @Column(length = 100)
  31. private String STRT_NM; // N VARCHAR2(100) Y 시점 명
  32. @Column(length = 100)
  33. private String END_NM; // N VARCHAR2(100) Y 종점 명
  34. @Column(nullable = false)
  35. private Integer SECT_LNGT; // N NUMBER(5) Y 구간 길이
  36. @Column(nullable = false, length = 10)
  37. private Long F_NODE_ID; // N NUMBER(10) Y 시작 노드 ID
  38. @Column(nullable = false, length = 10)
  39. private Long T_NODE_ID; // N NUMBER(10) Y 종료 노드 ID
  40. @Column(nullable = false, length = 7)
  41. private String SECT_GRAD_CD; // N VARCHAR2(7) Y 구간 등급 코드
  42. @Column(nullable = false, length = 7)
  43. private String AREA_CD; // N VARCHAR2(7) Y 지역 코드
  44. @Column(columnDefinition = "CHAR", length = 1)
  45. @ColumnDefault(value = "N")
  46. private String DEL_YN; // N CHAR(1) Y 'N' 삭제 여부
  47. public void updateName(RoadDto.RoadNameUpdateReq req) {
  48. this.ROAD_NAME = req.getROAD_NAME();
  49. this.STRT_NM = req.getSTRT_NM();
  50. this.END_NM = req.getEND_NM();
  51. }
  52. }