iot

Tables (14)

tb_field_inspection_report (변형 테이블1)

  • report_id (보고서 id) — UUID — Primary key — NOT NULL
  • manufacturer_id (제조사 id) — UUID — Foreign key → tb_manufacturer.manufacturer_id — NOT NULL
  • report_type_id (현장점검 보고서 종류 id) — UUID — Foreign key → tb_field_inspection_report_type.report_type_id — NOT NULL
  • bridge_code (교량 코드) — VARCHAR(10)
  • writer_user_id (작성자 id) — VARCHAR(20)
  • inspection_result (점검 결과) — TEXT
  • report_date (보고서 날짜) — TIMESTAMP
  • write_date (작성 날짜) — TIMESTAMP
  • last_update_date (마지막 수정 날짜) — TIMESTAMP
  • last_update_user_id (마지막 수정자 id) — VARCHAR(20)
  • inspector (점검자) — VARCHAR(50)

tb_field_inspection_report_display (추가 테이블 3)

  • display_id (항목 id) — UUID — Primary key — NOT NULL
  • manufacturer_id (제조사 id) — UUID — Foreign key → tb_manufacturer.manufacturer_id — NOT NULL
  • display_name (항목 이름) — VARCHAR(50)
  • display_code (항목 코드) — VARCHAR(30)
  • display_order (항목 배열 순서) — int4
  • is_required (필수 여부) — BOOLEAN

tb_field_inspection_report_display_detail (추가 테이블 4)

  • detail_id (특이사항 id) — UUID — Primary key — NOT NULL
  • display_id (항목 id) — UUID — Foreign key → tb_field_inspection_report_display.display_id — NOT NULL
  • parent_id (상위 특이사항(1차, 2차 구분)) — UUID — Foreign key → tb_field_inspection_report_display_detail.detail_id — NOT NULL
  • detail_name (특이사항 내용) — VARCHAR(200)
  • detail_order (특이사항 배열 순서) — int4

tb_field_inspection_report_item (변형 테이블2)

  • item_id (아이템 id) — Primary key — NOT NULL
  • report_id (보고서 id)
  • display_code (항목 타입 코드)
  • comment (특이사항별 코멘트)
  • seq (항목에 대한 내부 순서)
  • item_code (센서 코드 (축을 제거한 순수 이름))
  • item_display_name (보고서 출력용 센서 이름 (축 존재))

tb_field_inspection_report_item_detail (추가 테이블 5)

  • item_detail_id (아이템 상세 id) — Primary key — NOT NULL
  • item_id (아이템 id) — Foreign key → tb_field_inspection_report_item.item_id — NOT NULL
  • etc1 (1차 특이사항)
  • etc2 (2차 특이사항)
  • item_detail_order (아이템 상세 순서)

tb_field_inspection_report_item_file_map (변형 테이블3)

  • map_id (매핑 id) — Primary key — NOT NULL
  • item_id (아이템 id) — Foreign key → tb_field_inspection_report_item.item_id — NOT NULL
  • file_id (파일 id) — Foreign key → tb_files.id — NOT NULL
  • file_order (파일 순서)

tb_field_inspection_report_item_old (기존 테이블 2)

  • item_id (Key) — Primary key — NOT NULL
  • report_id (Field)
  • sensor_type_code (Field2)
  • etc (Field3)
  • seq (Field4)
  • sensor_code (Field5)
  • sensor_display_name (Field6)

tb_field_inspection_report_old (기존 테이블1)

  • report_id (Key) — Primary key — NOT NULL
  • bridge_code (Field)
  • writer_user_id (Field2)
  • inspection_result (Field3)
  • report_date (Field4)
  • write_date (Field5)
  • last_update_date (Field6)
  • last_update_user_id (Field7)
  • image_id (Field8)
  • inspector (Field9)

tb_field_inspection_report_type (추가 테이블 1)

  • report_type_id (현장점검 보고서 종류 id) — UUID — Primary key — NOT NULL
  • report_type_name (현장점검 보고서 종류 이름) — VARCHAR(50)
  • report_type_code (현장점검 보고서 종류 코드) — VARCUAR(50)

tb_files (기존 테이블4)

  • id (Key) — Primary key — NOT NULL
  • code (Field)
  • bridge_code (Field2)
  • device_id (Field3)
  • sensor_id (Field4)
  • name (Field5)
  • hash_name (Field6)
  • remarks (Field7)
  • size (Field8)
  • extension (Field9)

tb_manufacturer (추가 테이블 2)

  • manufacturer_id (제조사 id) — UUID — Primary key — NOT NULL
  • manufacturer_name (제조사 이름) — VARCHAR(15)

tb_report_item_file_map_old (기존 테이블3)

  • report_id (Key) — Primary key — NOT NULL
  • report_item_id (Field)
  • file_id (Field2)
  • etc (Field3)

tb_special_check_request_device (특별점검요청 디바이스)

  • request_id (요청id) — Primary key — NOT NULL
  • item_id (아이템 id) — Foreign key → tb_field_inspection_report_item.item_id — NOT NULL
  • bridge_code (교량 코드)
  • group_id (그룹 id)
  • device_code (디바이스 코드)
  • is_solved (해결 여부)
  • request_reason (요청 사유)

tb_track_bridge (추적관리교량)

  • bridge_code (교량 코드)
  • group_id (그룹 id)
  • time (등록 시간)
  • user_id (등록자)
  • reason (등록 사유)