tgu

테이블 (4)

굴착기 작업(덤프 매칭) (tbl_tgu_dump_work)

  • tgu_work_id — BIGINT — 기본 키 — NOT NULL
  • tms_sn — VARCHAR(30) — NOT NULL
  • matched_dump_equipment_id — VARCHAR(30) — 외래 키 → 덤프작업.equipment_id
  • receipt_time — DATETIME(3) — NOT NULL
  • work_mode — VARCHAR(30)
  • power_mode — VARCHAR(30)
  • send_flag — VARCHAR(10)
  • valid_working_type — VARCHAR(80) — NOT NULL
  • start_time — DATETIME(3) — NOT NULL
  • end_time — DATETIME(3)
  • receipt_case — VARCHAR(30)
  • end_flag — TINYINT

덤프 raw (tbl_tbd_dump_raw)

  • dump_raw_id — BIGINT — 기본 키 — NOT NULL
  • equipment_id — VARCHAR(30) — NOT NULL
  • device_id — VARCHAR(30) — NOT NULL
  • sleep_mode — TINYINT
  • data_mode — TINYINT
  • gsm_signal — TINYINT
  • timestamp — BIGINT — NOT NULL
  • latitude_deg — DECIMAL(10,7)
  • longitude_deg — DECIMAL(10,7)
  • altitude_m — DECIMAL(10,2)
  • gnss_status — TINYINT
  • satellites — SMALLINT
  • engine_speed_rpm — INT
  • vehicle_speed_kmh — DECIMAL(6,2)
  • fuel_rate_lh — DECIMAL(7,2)

덤프 raw(정제 /표준화) (tbl_tbd_dump_raw_std)

  • dump_raw_id — BIGINT — 외래 키 → 덤프 raw.dump_raw_id — NOT NULL
  • equipment_id — VARCHAR(30) — NOT NULL
  • device_id — VARCHAR(30) — NOT NULL
  • ignition — TINYINT
  • datetime — DATETIME(3) — NOT NULL
  • latitude_deg_corrected — DECIMAL(10,7)
  • longitude_deg_corrected — DECIMAL(10,7)
  • altitude_m_corrected — DECIMAL(10,2)
  • engine_speed_rpm — INT
  • vehicle_speed_kmh — DECIMAL(6,2)
  • fuel_rate_lh — DECIMAL(7,2)
  • fault_code — VARCHAR(64)
  • dispatched_target — VARCHAR(64)

덤프작업 (tbl_tbd_dump_work)

  • equipment_id — VARCHAR(30) — 기본 키 — NOT NULL
  • datetime — DATETIME(3) — NOT NULL
  • latitude_deg_corrected — DECIMAL(10,7)
  • longitude_deg_corrected — DECIMAL(10,7)
  • altitude_m_corrected — DECIMAL(10,2)
  • engine_speed_rpm — INT
  • vehicle_speed_kmh — DECIMAL(6,2)
  • fuel_rate_lh — DECIMAL(7,2)
  • fault_code — VARCHAR(64)
  • dispatched_target — VARCHAR(64)
  • truck_task — VARCHAR(20)
  • cycle_count — INT