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