중량

테이블 (50)

common_event_metadata

  • event_id — VARCHAR(255) — 기본 키 — NOT NULL
  • event_type — VARCHAR(255) — NOT NULL
  • event_time — DATETIME — NOT NULL
  • collected_time — DATETIME — NOT NULL
  • timezone — VARCHAR(255)
  • source_event_id — VARCHAR(255)
  • source_system_id — VARCHAR(255)
  • source_org_name — VARCHAR(255)
  • ingestion_method — VARCHAR(255)
  • data_quality_code — VARCHAR(255)
  • data_quality_reason — VARCHAR(255)
  • created_time — DATETIME
  • last_updated_time — DATETIME

common_ingestion_evidence_metadata

  • payload_parse_status — VARCHAR(255)
  • duplicate_flag — TINYINT(1)
  • time_delay_ms — INT
  • raw_payload_uri — TEXT
  • raw_payload_hash — TEXT
  • raw_file_uri — TEXT
  • raw_file_hash — TEXT
  • blockchain_tx_hash — TEXT

common_station_device_metadata

  • station_id — VARCHAR(255) — 기본 키 — NOT NULL
  • station_type — VARCHAR(255)
  • station_name — VARCHAR(255)
  • device_id — VARCHAR(255) — 외래 키 → equipment_master.device_id
  • device_type — VARCHAR(255)
  • link_id — VARCHAR(255) — 외래 키 → road_link_master.link_id
  • lane_no — INT
  • direction — VARCHAR(255)
  • latitude — DECIMAL(18,3)
  • longitude — DECIMAL(18,3)

common_vehicle_identity_metadata

  • car_no — VARCHAR(255)
  • car_no_hash — TEXT
  • car_no_encrypted — VARCHAR(255)
  • car_no_normalized — VARCHAR(255)
  • tractor_car_no — VARCHAR(255)
  • trailer_car_no — VARCHAR(255)

container_vgm

  • vgm_id — VARCHAR(255) — 기본 키 — NOT NULL
  • container_no — VARCHAR(255) — NOT NULL
  • container_size_type — VARCHAR(255) — NOT NULL
  • container_tare_weight_kg — DECIMAL(18,3) — NOT NULL
  • seal_no — VARCHAR(255)
  • verified_gross_mass_kg — DECIMAL(18,3) — NOT NULL
  • vgm_method — VARCHAR(255) — NOT NULL
  • vgm_measurement_time — DATETIME — NOT NULL
  • vgm_submission_time — DATETIME — NOT NULL
  • vgm_submitter_org_id — VARCHAR(255) — NOT NULL
  • vgm_signatory_name_hash — TEXT
  • vgm_status — VARCHAR(255) — NOT NULL
  • booking_no — VARCHAR(255) — NOT NULL
  • bl_no — VARCHAR(255)
  • shipping_instruction_no — VARCHAR(255)
  • port_code — VARCHAR(255) — NOT NULL
  • terminal_code — VARCHAR(255) — NOT NULL
  • gate_in_time — DATETIME — NOT NULL
  • gate_out_time — DATETIME
  • truck_appointment_no — VARCHAR(255)
  • vessel_name — VARCHAR(255)
  • voyage_no — VARCHAR(255)
  • export_import_type — VARCHAR(255) — NOT NULL
  • vgm_vs_pws_diff_kg — DECIMAL(18,3)
  • vgm_vs_wim_diff_kg — DECIMAL(18,3)

credential_evidence_result

  • event_id — VARCHAR(255) — 외래 키 → common_event_metadata.event_id — NOT NULL
  • event_type — VARCHAR(255) — NOT NULL
  • verification_id — VARCHAR(255) — 외래 키 → weight_verification_result.verification_id
  • screening_result_id — VARCHAR(255)
  • legal_match_id — VARCHAR(255)
  • transport_order_id — VARCHAR(255) — 외래 키 → transport_order_common.platform_order_id
  • trip_id — VARCHAR(255)
  • car_no — VARCHAR(255) — NOT NULL
  • credential_action_type — VARCHAR(255) — NOT NULL
  • did_subject — VARCHAR(255)
  • vc_id — VARCHAR(255)
  • vc_type — VARCHAR(255)
  • vc_issuer_id — VARCHAR(255)
  • vc_issued_time — DATETIME
  • vc_valid_from — DATETIME
  • vc_valid_until — DATETIME
  • vc_status — VARCHAR(255)
  • vc_status_reason — VARCHAR(255)
  • issue_basis_rule_version_id — VARCHAR(255)
  • issue_basis_verification_id — VARCHAR(255)
  • issue_basis_screening_result_id — VARCHAR(255)
  • issue_basis_history_start_time — DATETIME
  • issue_basis_history_end_time — DATETIME
  • last_impact_analysis_id — VARCHAR(255)
  • impact_status — VARCHAR(255)
  • vp_id — VARCHAR(255)
  • vp_submitted_time — DATETIME
  • vp_verifier_id — VARCHAR(255)
  • vp_verification_status — VARCHAR(255)
  • blockchain_tx_hash — TEXT
  • evidence_hash — TEXT
  • evidence_uri — TEXT
  • created_time — DATETIME
  • last_updated_time — DATETIME
  • evidence_bundle_id — VARCHAR(255) — 외래 키 → evidence_bundle_master.evidence_bundle_id
  • issuer_did — VARCHAR(255)
  • subject_did — VARCHAR(255)
  • anchor_evidence_id — VARCHAR(255) — 외래 키
  • last_verification_log_id — VARCHAR(255) — 외래 키
  • last_vp_submission_id — VARCHAR(255) — 외래 키
  • credential_payload_hash — TEXT
  • credential_integrity_status — VARCHAR(255)

device_link_map

  • device_id — VARCHAR(255) — 외래 키 → equipment_master.device_id — NOT NULL
  • device_type — VARCHAR(255) — NOT NULL
  • link_id — VARCHAR(255) — 외래 키 → road_link_master.link_id — NOT NULL
  • link_match_method — VARCHAR(255) — NOT NULL
  • device_lat — DECIMAL(18,3) — NOT NULL
  • device_lon — DECIMAL(18,3) — NOT NULL
  • device_direction — VARCHAR(255)
  • valid_from — DATETIME — NOT NULL
  • valid_to — DATETIME
  • mapping_confidence — DECIMAL(18,3)

equipment_calibration_master

  • calibration_id — VARCHAR(255) — 기본 키 — NOT NULL
  • device_id — VARCHAR(255) — 외래 키 → equipment_master.device_id — NOT NULL
  • calibration_date — DATE — NOT NULL
  • calibration_due_date — DATE — NOT NULL
  • calibration_org_id — VARCHAR(255)
  • calibration_certificate_no — VARCHAR(255)
  • certificate_file_hash — TEXT
  • allowable_error_kg — DECIMAL(18,3)
  • calibration_result — VARCHAR(255) — NOT NULL
  • registered_time — DATETIME — NOT NULL
  • kolas_accredited_yn — TINYINT(1)
  • kolas_lab_id — VARCHAR(255)
  • traceability_statement — VARCHAR(255)
  • calibration_standard_version — VARCHAR(255)
  • certificate_hash_algorithm — VARCHAR(255)
  • calibration_validity_status — VARCHAR(255)

equipment_master

  • device_id — VARCHAR(255) — 기본 키 — NOT NULL
  • device_type — VARCHAR(255) — NOT NULL
  • manufacturer — VARCHAR(255)
  • model_name — VARCHAR(255)
  • serial_no_hash — TEXT
  • station_id — VARCHAR(255) — 외래 키 → common_station_device_metadata.station_id — NOT NULL
  • lane_no — VARCHAR(255)
  • calibration_id — VARCHAR(255) — 외래 키 → equipment_calibration_master.calibration_id — NOT NULL
  • operator_org_id — VARCHAR(255) — NOT NULL
  • install_date — DATE
  • use_yn — TINYINT(1) — NOT NULL
  • qualification_summary_status — VARCHAR(255)
  • latest_qualification_evidence_id — VARCHAR(255)
  • type_approval_valid_yn — TINYINT(1)
  • performance_evaluation_valid_yn — TINYINT(1)
  • kolas_report_valid_yn — TINYINT(1)
  • installation_operation_evidence_id — VARCHAR(255) — 외래 키 → installation_operation_evidence.install_operation_evidence_id

equipment_qualification_evidence

  • qualification_evidence_id — VARCHAR(255) — 기본 키 — NOT NULL
  • device_id — VARCHAR(255) — 외래 키 → equipment_master.device_id — NOT NULL
  • station_id — VARCHAR(255) — 외래 키 → common_station_device_metadata.station_id
  • qualification_type — VARCHAR(255) — NOT NULL
  • qualification_status — VARCHAR(255) — NOT NULL
  • certificate_no — VARCHAR(255)
  • certificate_name — VARCHAR(255)
  • approval_org_id — VARCHAR(255)
  • approval_org_name — VARCHAR(255)
  • standard_name — VARCHAR(255)
  • standard_version — VARCHAR(255)
  • issue_date — DATE
  • valid_from_date — DATE
  • valid_until_date — DATE
  • approved_accuracy_class — VARCHAR(255)
  • approved_speed_range_kph — VARCHAR(255)
  • approved_weight_range_kg — VARCHAR(255)
  • kolas_accredited_yn — TINYINT(1)
  • kolas_lab_id — VARCHAR(255)
  • traceability_statement — VARCHAR(255)
  • certificate_file_uri — TEXT
  • certificate_file_hash — TEXT
  • hash_algorithm — VARCHAR(255)
  • review_status — VARCHAR(255) — NOT NULL
  • reviewer_id — VARCHAR(255)
  • reviewed_time — DATETIME
  • registered_time — DATETIME — NOT NULL

equipment_status_event

  • event_id — VARCHAR(255) — 외래 키 → common_event_metadata.event_id — NOT NULL
  • event_type — VARCHAR(255) — NOT NULL
  • device_id — VARCHAR(255) — 외래 키 → equipment_master.device_id — NOT NULL
  • equipment_status — VARCHAR(255) — NOT NULL
  • device_status_time — DATETIME
  • server_collected_time — DATETIME — NOT NULL
  • heartbeat_interval_sec — INT
  • communication_status — VARCHAR(255)
  • error_code — VARCHAR(255)
  • error_level — VARCHAR(255)
  • status_message — TEXT

event_weather_context

  • event_weather_context_id — VARCHAR(255) — 기본 키 — NOT NULL
  • event_id — VARCHAR(255) — 외래 키 → common_event_metadata.event_id — NOT NULL
  • event_type — VARCHAR(255) — NOT NULL
  • device_id — VARCHAR(255) — 외래 키 → equipment_master.device_id — NOT NULL
  • device_type — VARCHAR(255) — NOT NULL
  • link_id — VARCHAR(255) — 외래 키 → road_link_master.link_id — NOT NULL
  • event_time — DATETIME — NOT NULL
  • time_bucket — DATETIME — NOT NULL
  • weather_observation_id — VARCHAR(255) — 외래 키 → weather_observation.weather_observation_id — NOT NULL
  • temperature_c — DECIMAL(18,3)
  • humidity_percent — DECIMAL(18,3)
  • precipitation_mm — DECIMAL(18,3)
  • precipitation_type — VARCHAR(255)
  • wind_speed_mps — DECIMAL(18,3)
  • visibility_m — DECIMAL(18,3)
  • road_surface_temp_c — DECIMAL(18,3)
  • road_surface_status — VARCHAR(255)
  • weather_match_grade — VARCHAR(255) — NOT NULL
  • weather_risk_level — VARCHAR(255)
  • analysis_available_yn — TINYINT(1) — NOT NULL

evidence_bundle_master

  • evidence_bundle_id — VARCHAR(255) — 기본 키 — NOT NULL
  • event_id — VARCHAR(255) — 외래 키 → common_event_metadata.event_id — NOT NULL
  • event_type — VARCHAR(255) — NOT NULL
  • station_id — VARCHAR(255) — 외래 키 → common_station_device_metadata.station_id
  • device_id — VARCHAR(255) — 외래 키 → equipment_master.device_id — NOT NULL
  • car_no — VARCHAR(255)
  • car_no_hash — TEXT
  • bundle_status — VARCHAR(255) — NOT NULL
  • bundle_version — VARCHAR(255) — NOT NULL
  • bundle_created_time — DATETIME — NOT NULL
  • bundle_closed_time — DATETIME
  • bundle_payload_hash — TEXT — NOT NULL
  • hash_algorithm — VARCHAR(255) — NOT NULL
  • vc_id — VARCHAR(255)
  • vp_id — VARCHAR(255)
  • latest_blockchain_tx_hash — TEXT
  • created_by — VARCHAR(255)
  • created_time — DATETIME — NOT NULL
  • updated_time — DATETIME

installation_operation_evidence

  • install_operation_evidence_id — VARCHAR(255) — 기본 키 — NOT NULL
  • station_id — VARCHAR(255) — 외래 키 → common_station_device_metadata.station_id — NOT NULL
  • device_id — VARCHAR(255) — 외래 키 → equipment_master.device_id — NOT NULL
  • latitude — DECIMAL(18,3) — NOT NULL
  • longitude — DECIMAL(18,3) — NOT NULL
  • coordinate_system — VARCHAR(255) — NOT NULL
  • road_name — VARCHAR(255)
  • link_id — VARCHAR(255) — 외래 키 → road_link_master.link_id
  • lane_no — INT
  • installation_date — DATE
  • installation_org_id — VARCHAR(255)
  • site_acceptance_result — VARCHAR(255) — NOT NULL
  • site_acceptance_report_uri — TEXT
  • site_acceptance_report_hash — TEXT
  • approach_straight_length_m — DECIMAL(18,3)
  • exit_straight_length_m — DECIMAL(18,3)
  • road_grade_pct — DECIMAL(18,3)
  • cross_slope_pct — DECIMAL(18,3)
  • surface_flatness_mm — DECIMAL(18,3)
  • lane_width_m — DECIMAL(18,3)
  • drainage_condition — VARCHAR(255)
  • obstacle_monitoring_yn — TINYINT(1) — NOT NULL
  • operation_start_date — DATE
  • last_site_inspection_time — DATETIME
  • next_site_inspection_due_date — DATE
  • operation_status — VARCHAR(255) — NOT NULL
  • registered_time — DATETIME — NOT NULL

legal_judgement_evidence

  • legal_judgement_evidence_id — VARCHAR(255) — 기본 키 — NOT NULL
  • event_id — VARCHAR(255) — 외래 키 → common_event_metadata.event_id — NOT NULL
  • evidence_bundle_id — VARCHAR(255) — 외래 키 → evidence_bundle_master.evidence_bundle_id — NOT NULL
  • vehicle_id — VARCHAR(255)
  • car_no — VARCHAR(255)
  • rule_version_id — VARCHAR(255) — 외래 키 → rule_version.rule_version_id — NOT NULL
  • rule_category — VARCHAR(255) — NOT NULL
  • law_name — VARCHAR(255)
  • law_article — VARCHAR(255)
  • rule_effective_time — DATETIME — NOT NULL
  • link_id — VARCHAR(255) — 외래 키 → road_link_master.link_id
  • gross_weight_limit_kg — DECIMAL(18,3)
  • axle_weight_limit_kg — DECIMAL(18,3)
  • vehicle_gross_weight_limit_kg — DECIMAL(18,3)
  • payload_limit_kg — DECIMAL(18,3)
  • measured_gross_weight_kg — DECIMAL(18,3) — NOT NULL
  • max_measured_axle_weight_kg — DECIMAL(18,3)
  • axle_weights_kg — JSON
  • legal_judgement_status — VARCHAR(255) — NOT NULL
  • non_overweight_yn — TINYINT(1) — NOT NULL
  • overweight_basis — VARCHAR(255)
  • judgement_reason_code — VARCHAR(255)
  • judgement_reason_text — TEXT
  • reweigh_required_yn — TINYINT(1) — NOT NULL
  • reweigh_reason_code — VARCHAR(255)
  • decision_algorithm_id — VARCHAR(255)
  • decision_algorithm_version — VARCHAR(255)
  • decision_input_hash — TEXT
  • decision_output_hash — TEXT
  • judgement_time — DATETIME — NOT NULL

link_weather_context

  • link_weather_id — VARCHAR(255) — 기본 키 — NOT NULL
  • link_id — VARCHAR(255) — 외래 키 → road_link_master.link_id — NOT NULL
  • weather_observation_id — VARCHAR(255) — 외래 키 → weather_observation.weather_observation_id — NOT NULL
  • weather_source_type — VARCHAR(255) — NOT NULL
  • time_bucket — DATETIME — NOT NULL
  • match_time_diff_sec — INT — NOT NULL
  • match_distance_m — DECIMAL(18,3)
  • spatial_match_method — VARCHAR(255) — NOT NULL
  • weather_match_grade — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL

maintenance_history

  • maintenance_history_id — VARCHAR(255) — 기본 키 — NOT NULL
  • device_id — VARCHAR(255) — 외래 키 → equipment_master.device_id — NOT NULL
  • maintenance_type — VARCHAR(255) — NOT NULL
  • maintenance_started_time — DATETIME
  • maintenance_ended_time — DATETIME
  • action_detail — VARCHAR(255)
  • operator_id — VARCHAR(255)
  • maintenance_result — VARCHAR(255) — NOT NULL

measurement_media_evidence

  • media_evidence_id — VARCHAR(255) — 기본 키 — NOT NULL
  • event_id — VARCHAR(255) — 외래 키 → common_event_metadata.event_id — NOT NULL
  • evidence_bundle_id — VARCHAR(255) — 외래 키 → evidence_bundle_master.evidence_bundle_id — NOT NULL
  • camera_device_id — VARCHAR(255) — 외래 키 → equipment_master.device_id
  • media_type — VARCHAR(255) — NOT NULL
  • media_uri — TEXT — NOT NULL
  • media_hash — TEXT — NOT NULL
  • hash_algorithm — VARCHAR(255) — NOT NULL
  • media_start_time — DATETIME
  • media_end_time — DATETIME
  • captured_time — DATETIME
  • car_no_recognized — VARCHAR(255)
  • car_no_recognition_confidence — DECIMAL(18,3)
  • vehicle_overview_yn — TINYINT(1)
  • front_rear_clearance_visible_yn — TINYINT(1)
  • lane_position_valid_yn — TINYINT(1)
  • media_validation_status — VARCHAR(255) — NOT NULL
  • media_quality_note — TEXT
  • created_time — DATETIME — NOT NULL

measurement_operation_snapshot

  • operation_snapshot_id — VARCHAR(255) — 기본 키 — NOT NULL
  • event_id — VARCHAR(255) — 외래 키 → common_event_metadata.event_id — NOT NULL
  • evidence_bundle_id — VARCHAR(255) — 외래 키 → evidence_bundle_master.evidence_bundle_id — NOT NULL
  • device_id — VARCHAR(255) — 외래 키 → equipment_master.device_id — NOT NULL
  • calibration_id — VARCHAR(255) — 외래 키 → equipment_calibration_master.calibration_id
  • calibration_valid_at_measurement_yn — TINYINT(1) — NOT NULL
  • equipment_status_at_measurement — VARCHAR(255) — NOT NULL
  • sensor_health_status_at_measurement — VARCHAR(255) — NOT NULL
  • communication_status_at_measurement — VARCHAR(255) — NOT NULL
  • driving_pattern_status — VARCHAR(255)
  • front_obstacle_free_yn — TINYINT(1)
  • rear_obstacle_free_yn — TINYINT(1)
  • front_vehicle_gap_m — DECIMAL(18,3)
  • rear_vehicle_gap_m — DECIMAL(18,3)
  • obstacle_detection_method — VARCHAR(255)
  • obstacle_proof_media_id — VARCHAR(255)
  • weather_context_id — VARCHAR(255) — 외래 키 → event_weather_context.event_weather_context_id
  • road_surface_status — VARCHAR(255)
  • operation_validity — VARCHAR(255) — NOT NULL
  • operation_invalid_reason — VARCHAR(255)
  • snapshot_created_time — DATETIME — NOT NULL

measurement_time_chain

  • time_chain_id — VARCHAR(255) — 기본 키 — NOT NULL
  • event_id — VARCHAR(255) — 외래 키 → common_event_metadata.event_id — NOT NULL
  • evidence_bundle_id — VARCHAR(255) — 외래 키 → evidence_bundle_master.evidence_bundle_id — NOT NULL
  • time_role — VARCHAR(255) — NOT NULL
  • event_time_value — DATETIME — NOT NULL
  • time_source — VARCHAR(255) — NOT NULL
  • time_precision_ms — INT
  • clock_sync_method — VARCHAR(255)
  • clock_offset_ms — INT
  • time_sequence_no — INT — NOT NULL
  • time_sequence_valid_yn — TINYINT(1) — NOT NULL
  • time_anomaly_reason — VARCHAR(255)
  • time_record_hash — TEXT
  • created_time — DATETIME — NOT NULL

non_inspection_vehicle_candidate_result

  • screening_result_id — VARCHAR(255) — 기본 키 — NOT NULL
  • car_no — VARCHAR(255) — NOT NULL
  • verification_id — VARCHAR(255) — 외래 키 → weight_verification_result.verification_id
  • legal_match_id — VARCHAR(255)
  • basis_rule_version_id — VARCHAR(255) — NOT NULL
  • history_start_time — DATETIME — NOT NULL
  • history_end_time — DATETIME — NOT NULL
  • basis_weight_event_count — INT — NOT NULL
  • basis_legal_match_count — INT — NOT NULL
  • normal_judgement_count — INT — NOT NULL
  • over_limit_judgement_count — INT — NOT NULL
  • anomaly_detected_count — INT — NOT NULL
  • event_id — VARCHAR(255) — 외래 키 → common_event_metadata.event_id
  • event_type — VARCHAR(255) — NOT NULL
  • last_normal_judgement_time — DATETIME
  • weight_trust_score — DECIMAL(18,3)
  • vehicle_identity_score — DECIMAL(18,3)
  • equipment_trust_score — DECIMAL(18,3)
  • screening_status — VARCHAR(255) — NOT NULL
  • non_inspection_candidate_yn — TINYINT(1) — NOT NULL
  • screening_reason — VARCHAR(255)
  • vc_issue_eligible_yn — TINYINT(1) — NOT NULL
  • vc_issue_reject_reason — VARCHAR(255)
  • created_time — DATETIME
  • last_updated_time — DATETIME

obm_device_mount

  • device_id — VARCHAR(255) — 외래 키 → equipment_master.device_id — NOT NULL
  • event_type — VARCHAR(255) — NOT NULL
  • device_type — VARCHAR(255) — NOT NULL
  • sensor_type — VARCHAR(255)
  • communication_device_id — VARCHAR(255)
  • device_vendor — VARCHAR(255)
  • device_model — VARCHAR(255)
  • firmware_version — VARCHAR(255)
  • mass_reading_method — VARCHAR(255) — NOT NULL
  • car_no — VARCHAR(255) — NOT NULL
  • vin — VARCHAR(255)
  • tractor_car_no — VARCHAR(255)
  • trailer_car_no — VARCHAR(255)
  • combination_type — VARCHAR(255)
  • mount_status — VARCHAR(255) — NOT NULL
  • use_yn — TINYINT(1) — NOT NULL
  • last_updated_time — DATETIME — NOT NULL

obm_enrichment_result

  • event_id — VARCHAR(255) — 외래 키 → common_event_metadata.event_id — NOT NULL
  • device_master_match_status — VARCHAR(255)
  • device_calibration_valid_yn — TINYINT(1)
  • device_equipment_status — VARCHAR(255)
  • calibration_id — VARCHAR(255) — 외래 키 → equipment_calibration_master.calibration_id
  • last_calibration_date — DATE
  • calibration_due_date — DATE
  • link_id — VARCHAR(255) — 외래 키 → road_link_master.link_id
  • location_match_status — VARCHAR(255)
  • location_name — VARCHAR(255)
  • car_no_normalized — VARCHAR(255)
  • vehicle_master_match_status — VARCHAR(255)
  • vehicle_category — VARCHAR(255)
  • vehicle_use_type — VARCHAR(255)
  • registered_gvwr_kg — DECIMAL(18,3)
  • registered_max_payload_kg — DECIMAL(18,3)
  • registered_curb_weight_kg — DECIMAL(18,3)
  • registered_axle_count — INT
  • vehicle_class_6 — VARCHAR(255)
  • vehicle_class_12 — VARCHAR(255)
  • combination_required_yn — TINYINT(1)
  • combination_match_status — VARCHAR(255)
  • mount_start_time — DATETIME
  • mount_end_time — DATETIME
  • calculated_payload_weight_kg — DECIMAL(18,3)
  • gross_vs_registered_gvwr_diff_kg — DECIMAL(18,3)
  • payload_vs_registered_payload_diff_kg — DECIMAL(18,3)
  • weight_change_rate_kg_per_min — DECIMAL(18,3)
  • left_right_imbalance_ratio — DECIMAL(18,3)
  • overweight_final_flag — TINYINT(1)
  • overweight_basis — VARCHAR(255)
  • legal_judgement_available_yn — TINYINT(1)
  • reweigh_required_yn — TINYINT(1)
  • wim_match_status — VARCHAR(255)
  • wim_vs_obm_diff_kg — DECIMAL(18,3)
  • pws_match_status — VARCHAR(255)
  • pws_vs_obm_diff_kg — DECIMAL(18,3)
  • data_quality_code — VARCHAR(255)
  • obm_trust_score — DECIMAL(18,3)
  • transport_order_id — VARCHAR(255) — 외래 키 → transport_order_common.platform_order_id
  • match_confidence_score — DECIMAL(18,3)
  • vc_issue_eligible_yn — TINYINT(1)
  • vc_reject_reason — VARCHAR(255)
  • raw_data_hash — TEXT
  • blockchain_tx_hash — TEXT
  • weigh_certificate_no — VARCHAR(255) — NOT NULL
  • certificate_issue_time — DATETIME — NOT NULL
  • certificate_scope — VARCHAR(255)
  • certificate_valid_until — DATETIME
  • certificate_file_uri — TEXT
  • container_tare_weight_kg — DECIMAL(18,3)

obm_ingestion_evidence

  • event_id — VARCHAR(255) — 외래 키 → common_event_metadata.event_id — NOT NULL
  • event_type — VARCHAR(255) — NOT NULL
  • device_id — VARCHAR(255) — 외래 키 → equipment_master.device_id — NOT NULL
  • car_no — VARCHAR(255) — NOT NULL
  • collected_time — DATETIME — NOT NULL
  • ingestion_method — VARCHAR(255)
  • collection_batch_id — VARCHAR(255)
  • batch_sequence_no — INT
  • payload_parse_status — VARCHAR(255) — NOT NULL
  • duplicate_flag — TINYINT(1)
  • time_delay_ms — INT
  • raw_payload_uri — TEXT
  • raw_payload_hash — TEXT
  • raw_payload_format — VARCHAR(255)
  • data_quality_code — VARCHAR(255)

obm_measurement_event

  • device_id — VARCHAR(255) — 외래 키 → equipment_master.device_id — NOT NULL
  • event_type — VARCHAR(255) — NOT NULL
  • car_no — VARCHAR(255) — NOT NULL
  • measured_time — DATETIME — NOT NULL
  • sequence_no — INT
  • sampling_interval_ms — INT
  • gross_weight_kg — DECIMAL(18,3) — NOT NULL
  • axle_group_weights_kg — JSON
  • payload_weight_kg — DECIMAL(18,3)
  • weight_unit — VARCHAR(255)
  • weight_validity — VARCHAR(255)
  • gps_latitude — DECIMAL(18,3) — NOT NULL
  • gps_longitude — DECIMAL(18,3) — NOT NULL
  • gps_accuracy_m — DECIMAL(18,3)
  • vehicle_speed_kph — DECIMAL(18,3)
  • heading_deg — INT
  • ignition_status — TINYINT(1)
  • trip_id — VARCHAR(255)
  • sensor_health_status — VARCHAR(255)
  • communication_status — VARCHAR(255)
  • tamper_flag — TINYINT(1)
  • tamper_reason — VARCHAR(255)
  • battery_voltage_v — DECIMAL(18,3)
  • raw_payload_uri — TEXT

pws_enrichment_result

  • event_id — VARCHAR(255) — 외래 키 → common_event_metadata.event_id — NOT NULL
  • station_master_match_status — VARCHAR(255)
  • station_name — VARCHAR(255)
  • device_master_match_status — VARCHAR(255)
  • device_calibration_valid_yn — TINYINT(1)
  • device_equipment_status — VARCHAR(255)
  • scale_capacity_kg — DECIMAL(18,3)
  • link_id — VARCHAR(255) — 외래 키 → road_link_master.link_id
  • calibration_id — VARCHAR(255) — 외래 키 → equipment_calibration_master.calibration_id
  • station_link_match_status — VARCHAR(255)
  • location_name — VARCHAR(255)
  • direction — VARCHAR(255)
  • car_no_normalized — VARCHAR(255)
  • vehicle_master_match_status — VARCHAR(255)
  • vehicle_category — VARCHAR(255)
  • vehicle_use_type — VARCHAR(255)
  • registered_gvwr_kg — DECIMAL(18,3)
  • registered_max_payload_kg — DECIMAL(18,3)
  • registered_curb_weight_kg — DECIMAL(18,3)
  • registered_axle_count — INT
  • vehicle_class_6 — VARCHAR(255)
  • vehicle_class_12 — VARCHAR(255)
  • combination_required_yn — TINYINT(1)
  • combination_match_status — VARCHAR(255)
  • calculated_net_cargo_weight_kg — DECIMAL(18,3)
  • gross_vs_registered_gvwr_diff_kg — DECIMAL(18,3)
  • payload_vs_registered_payload_diff_kg — DECIMAL(18,3)
  • axle_group_weights_derived_kg — JSON
  • left_right_imbalance_ratio — DECIMAL(18,3)
  • overweight_final_flag — TINYINT(1)
  • overweight_final_basis — VARCHAR(255)
  • legal_judgement_available_yn — TINYINT(1)
  • reweigh_required_yn — TINYINT(1)
  • vgm_match_status — VARCHAR(255)
  • vgm_weight_kg — DECIMAL(18,3)
  • vgm_vs_pws_diff_kg — DECIMAL(18,3)
  • data_quality_code — VARCHAR(255)
  • pws_trust_score — DECIMAL(18,3)
  • transport_order_id — VARCHAR(255) — 외래 키 → transport_order_common.platform_order_id
  • match_confidence_score — DECIMAL(18,3)
  • vc_issue_eligible_yn — TINYINT(1)
  • vc_reject_reason — VARCHAR(255)
  • blockchain_tx_hash — TEXT
  • weigh_certificate_no — VARCHAR(255) — NOT NULL
  • certificate_issue_time — DATETIME — NOT NULL
  • certificate_scope — VARCHAR(255)
  • certificate_valid_until — DATETIME
  • certificate_file_uri — TEXT
  • container_tare_weight_kg — DECIMAL(18,3)

pws_ingestion_evidence

  • event_id — VARCHAR(255) — 외래 키 → common_event_metadata.event_id — NOT NULL
  • event_type — VARCHAR(255) — NOT NULL
  • collected_time — DATETIME — NOT NULL
  • ingestion_method — VARCHAR(255)
  • payload_parse_status — VARCHAR(255)
  • duplicate_flag — TINYINT(1)
  • time_delay_ms — INT
  • raw_payload_uri — TEXT
  • raw_payload_hash — TEXT
  • raw_signal_uri — TEXT
  • raw_signal_hash — TEXT
  • raw_car_no_image_uri — TEXT
  • raw_vehicle_image_uri — TEXT
  • raw_front_image_uri — TEXT
  • raw_side_image_uri — TEXT
  • data_quality_code — VARCHAR(255)

pws_measurement_event

  • station_id — VARCHAR(255) — 외래 키 → common_station_device_metadata.station_id — NOT NULL
  • station_type — VARCHAR(255) — NOT NULL
  • device_id — VARCHAR(255) — 외래 키 → equipment_master.device_id
  • device_type — VARCHAR(255)
  • sensor_type — VARCHAR(255)
  • lane_no — INT — NOT NULL
  • car_no — VARCHAR(255) — NOT NULL
  • car_no_recognition_status — VARCHAR(255)
  • car_no_recognition_confidence — DECIMAL(18,3)
  • vehicle_type_declared — VARCHAR(255)
  • tractor_car_no — VARCHAR(255)
  • trailer_car_no — VARCHAR(255)
  • cargo_item_name — VARCHAR(255)
  • container_no — VARCHAR(255)
  • seal_no — VARCHAR(255)
  • vehicle_class_raw — VARCHAR(255)
  • cargo_category — VARCHAR(255)
  • shipper_name — VARCHAR(255)
  • carrier_name — VARCHAR(255)
  • passage_time — DATETIME — NOT NULL
  • speed_kph — DECIMAL(18,3) — NOT NULL
  • vehicle_length_m — DECIMAL(18,3)
  • headway_sec — DECIMAL(18,3)
  • driving_pattern_status — VARCHAR(255)
  • weighing_time — DATETIME — NOT NULL
  • weighing_method — VARCHAR(255)
  • gross_weight_kg — DECIMAL(18,3) — NOT NULL
  • tare_weight_kg — DECIMAL(18,3)
  • net_cargo_weight_kg — DECIMAL(18,3)
  • weight_unit — VARCHAR(255)
  • loaded_weighing_time — DATETIME
  • empty_weighing_time — DATETIME
  • axle_count — INT — NOT NULL
  • axle_weights_kg — JSON — NOT NULL
  • axle_spacings_m — JSON
  • axle_group_weights_kg — JSON
  • wheel_weights_kg — JSON
  • manual_correction_flag — TINYINT(1)
  • manual_correction_reason — VARCHAR(255)
  • operator_name — VARCHAR(255)
  • signal_uri — TEXT
  • car_no_image_uri — TEXT
  • vehicle_image_uri — TEXT
  • front_image_uri — TEXT
  • side_image_uri — TEXT

raw_measurement_evidence

  • raw_measurement_evidence_id — VARCHAR(255) — 기본 키 — NOT NULL
  • event_id — VARCHAR(255) — 외래 키 → common_event_metadata.event_id — NOT NULL
  • evidence_bundle_id — VARCHAR(255) — 외래 키 → evidence_bundle_master.evidence_bundle_id — NOT NULL
  • source_system_id — VARCHAR(255) — NOT NULL
  • source_event_id — VARCHAR(255)
  • source_device_serial_no — VARCHAR(255)
  • raw_payload_uri — TEXT — NOT NULL
  • raw_payload_format — VARCHAR(255) — NOT NULL
  • raw_payload_size_bytes — INT
  • raw_payload_hash — TEXT — NOT NULL
  • raw_hash_algorithm — VARCHAR(255) — NOT NULL
  • canonical_payload_uri — TEXT
  • canonical_payload_hash — TEXT
  • normalized_event_hash — TEXT
  • raw_center_value_separation_yn — TINYINT(1) — NOT NULL
  • raw_gross_weight_value — DECIMAL(18,3)
  • raw_weight_unit — VARCHAR(255)
  • center_gross_weight_kg — DECIMAL(18,3)
  • raw_axle_weights_text — TEXT
  • center_axle_weights_kg — JSON
  • measured_latitude — DECIMAL(18,3)
  • measured_longitude — DECIMAL(18,3)
  • temperature_c — DECIMAL(18,3)
  • humidity_pct — DECIMAL(18,3)
  • road_surface_status — VARCHAR(255)
  • parse_status — VARCHAR(255) — NOT NULL
  • validation_status — VARCHAR(255) — NOT NULL
  • validation_error_code — VARCHAR(255)
  • created_time — DATETIME — NOT NULL

road_incident_event

  • incident_id — VARCHAR(255) — 기본 키 — NOT NULL
  • link_id — VARCHAR(255) — 외래 키 → road_link_master.link_id
  • road_section_id — VARCHAR(255)
  • incident_type — VARCHAR(255) — NOT NULL
  • incident_level — VARCHAR(255)
  • incident_message — TEXT
  • incident_started_time — DATETIME
  • incident_ended_time — DATETIME
  • collected_time — DATETIME — NOT NULL
  • source_system_id — VARCHAR(255) — NOT NULL

road_link_limit_rule_map

  • link_id — VARCHAR(255) — 외래 키 → road_link_master.link_id — NOT NULL
  • road_section_id — VARCHAR(255)
  • facility_id — VARCHAR(255)
  • facility_name — VARCHAR(255)
  • rule_version_id — VARCHAR(255) — 외래 키 → rule_version.rule_version_id — NOT NULL
  • road_manager_org_name — VARCHAR(255)
  • valid_from_time — DATETIME
  • valid_until_time — DATETIME
  • map_status — VARCHAR(255) — NOT NULL
  • map_revision_reason — VARCHAR(255)
  • created_time — DATETIME
  • last_updated_time — DATETIME

road_link_master

  • link_id — VARCHAR(255) — 기본 키 — NOT NULL
  • road_section_id — VARCHAR(255)
  • from_node_id — VARCHAR(255)
  • to_node_id — VARCHAR(255)
  • route_no — VARCHAR(255)
  • route_name — VARCHAR(255)
  • road_class — VARCHAR(255)
  • direction_code — VARCHAR(255)
  • link_length_m — DECIMAL(18,3)
  • geometry_hash — TEXT
  • source_system_id — VARCHAR(255) — NOT NULL
  • last_updated_time — DATETIME — NOT NULL

road_restriction_master

  • restriction_id — VARCHAR(255) — 기본 키 — NOT NULL
  • link_id — VARCHAR(255) — 외래 키 → road_link_master.link_id
  • road_section_id — VARCHAR(255)
  • bridge_id — VARCHAR(255)
  • facility_name — VARCHAR(255)
  • restriction_type — VARCHAR(255) — NOT NULL
  • load_limit_kg — DECIMAL(18,3)
  • height_limit_m — DECIMAL(18,3)
  • width_limit_m — DECIMAL(18,3)
  • length_limit_m — DECIMAL(18,3)
  • restriction_reason — VARCHAR(255)
  • valid_from_time — DATETIME
  • valid_until_time — DATETIME
  • source_system_id — VARCHAR(255) — NOT NULL
  • last_updated_time — DATETIME — NOT NULL

rule_change_impact_result

  • impact_analysis_id — VARCHAR(255) — 기본 키 — NOT NULL
  • rule_version_id — VARCHAR(255) — 외래 키 → rule_version.rule_version_id — NOT NULL
  • old_rule_version_id — VARCHAR(255)
  • impact_status — VARCHAR(255) — NOT NULL
  • affected_car_count — INT
  • affected_vc_count — INT
  • review_required_yn — TINYINT(1) — NOT NULL
  • reissue_required_yn — TINYINT(1) — NOT NULL
  • suspend_required_yn — TINYINT(1)
  • revoke_required_yn — TINYINT(1)
  • impact_reason — VARCHAR(255)
  • action_completed_yn — TINYINT(1)
  • analysis_time — DATETIME — NOT NULL
  • created_time — DATETIME

rule_version

  • rule_version_id — VARCHAR(255) — 기본 키 — NOT NULL
  • rule_name — VARCHAR(255) — NOT NULL
  • rule_version — VARCHAR(255) — NOT NULL
  • rule_category — VARCHAR(255)
  • rule_status — VARCHAR(255) — NOT NULL
  • law_name — VARCHAR(255)
  • law_article — VARCHAR(255)
  • law_change_type — VARCHAR(255)
  • valid_from_date — DATE — NOT NULL
  • valid_until_date — DATE
  • source_org_name — VARCHAR(255)
  • source_document_uri — TEXT
  • change_detected_time — DATETIME — NOT NULL
  • change_effective_date — DATETIME
  • impact_analysis_required_yn — TINYINT(1) — NOT NULL
  • created_time — DATETIME

traffic_link_observation

  • link_id — VARCHAR(255) — 외래 키 → road_link_master.link_id — NOT NULL
  • road_section_id — VARCHAR(255)
  • observed_time — DATETIME — NOT NULL
  • collected_time — DATETIME — NOT NULL
  • average_speed_kph — DECIMAL(18,3)
  • occupancy_rate — DECIMAL(18,3)
  • travel_time_sec — INT
  • traffic_volume_count — INT
  • congestion_level — VARCHAR(255)
  • aggregation_interval_sec — INT
  • data_quality_code — VARCHAR(255)
  • source_system_id — VARCHAR(255) — NOT NULL

transport_container_detail

  • platform_order_id — VARCHAR(255) — 기본 키 — NOT NULL
  • container_no — VARCHAR(255) — NOT NULL
  • container_size_type — VARCHAR(255)
  • full_empty_code — VARCHAR(255)
  • port_code — VARCHAR(255)
  • terminal_id — VARCHAR(255)
  • gate_inout_type — VARCHAR(255)
  • vessel_voyage — VARCHAR(255)
  • shipping_line_code — VARCHAR(255)
  • discharge_port_code — VARCHAR(255)
  • declared_vgm_weight_kg — DECIMAL(18,3)
  • dangerous_goods_code — VARCHAR(255)
  • reefer_temperature — DECIMAL(18,3)
  • oog_flag — TINYINT(1)
  • source_message_type — VARCHAR(255)
  • source_message_time — DATETIME

transport_domestic_cargo_detail

  • platform_order_id — VARCHAR(255) — 기본 키 — NOT NULL
  • cargo_name — VARCHAR(255)
  • cargo_category — VARCHAR(255)
  • cargo_subcategory — VARCHAR(255)
  • declared_cargo_weight_kg — DECIMAL(18,3)
  • cargo_volume_cbm — DECIMAL(18,3)
  • package_type — VARCHAR(255)
  • regulated_cargo_flag — TINYINT(1)
  • manifest_no_hash — TEXT
  • hazardous_material_flag — TINYINT(1)
  • hazardous_material_code — VARCHAR(255)
  • loading_location_type — VARCHAR(255)
  • unloading_location_type — VARCHAR(255)
  • route_pattern_type — VARCHAR(255)
  • planned_route_id — VARCHAR(255)
  • contract_no_hash — TEXT

transport_order_common

  • platform_order_id — VARCHAR(255) — 기본 키 — NOT NULL
  • source_system_id — VARCHAR(255) — NOT NULL
  • source_order_id — VARCHAR(255)
  • transport_type — VARCHAR(255) — NOT NULL
  • order_status — VARCHAR(255) — NOT NULL
  • order_created_time — DATETIME
  • order_collected_time — DATETIME — NOT NULL
  • carrier_org_id — VARCHAR(255)
  • carrier_org_name — VARCHAR(255)
  • shipper_org_id — VARCHAR(255)
  • shipper_org_name — VARCHAR(255)
  • car_no — VARCHAR(255) — NOT NULL
  • driver_hash — TEXT
  • origin_name — VARCHAR(255)
  • origin_address — VARCHAR(255)
  • destination_name — VARCHAR(255)
  • destination_address — VARCHAR(255)
  • planned_departure_time — DATETIME
  • planned_arrival_time — DATETIME
  • last_updated_time — DATETIME — NOT NULL

transport_order_event

  • event_id — VARCHAR(255) — 외래 키 → common_event_metadata.event_id — NOT NULL
  • event_type — VARCHAR(255) — NOT NULL
  • platform_order_id — VARCHAR(255) — NOT NULL
  • order_action_type — VARCHAR(255) — NOT NULL
  • event_time — DATETIME
  • collected_time — DATETIME — NOT NULL
  • car_no — VARCHAR(255)
  • car_no_hash — TEXT
  • location_name — VARCHAR(255)
  • source_system_id — VARCHAR(255) — NOT NULL
  • event_payload_hash — TEXT

transport_order_weight_match

  • match_id — VARCHAR(255) — 기본 키 — NOT NULL
  • platform_order_id — VARCHAR(255) — NOT NULL
  • event_id — VARCHAR(255) — 외래 키 → common_event_metadata.event_id — NOT NULL
  • event_type — VARCHAR(255) — NOT NULL
  • car_no — VARCHAR(255)
  • car_no_hash — TEXT — NOT NULL
  • transport_type — VARCHAR(255) — NOT NULL
  • match_method — VARCHAR(255) — NOT NULL
  • match_score — DECIMAL(18,3)
  • matched_time — DATETIME — NOT NULL
  • match_status — VARCHAR(255) — NOT NULL

vehicle_combination

  • tractor_car_no — VARCHAR(255) — NOT NULL
  • trailer_car_no — VARCHAR(255)
  • combination_type — VARCHAR(255) — NOT NULL
  • observed_time — DATETIME — NOT NULL
  • combination_source — VARCHAR(255)
  • combination_confidence — DECIMAL(18,3)
  • combined_length_mm — INT
  • combined_width_mm — INT
  • combined_height_mm — INT
  • combined_curb_weight_kg — INT
  • combined_gvwr_kg — INT
  • combined_max_payload_kg — INT
  • combined_axle_count — INT

vehicle_limit_rule_master

  • rule_version_id — VARCHAR(255) — 외래 키 → rule_version.rule_version_id — NOT NULL
  • gross_weight_limit_kg — INT
  • axle_weight_limit_kg — INT
  • axle_group_weight_limit_json — JSON
  • width_limit_m — DECIMAL(18,3)
  • height_limit_m — DECIMAL(18,3)
  • length_limit_m — DECIMAL(18,3)
  • measurement_tolerance_rate — DECIMAL(18,3)
  • permit_required_yn — TINYINT(1) — NOT NULL
  • valid_from_date — DATE — NOT NULL
  • valid_until_date — DATE
  • revision_reason — VARCHAR(255)
  • old_rule_version_id — VARCHAR(255)
  • source_org_name — VARCHAR(255)
  • source_document_uri — TEXT
  • created_time — DATETIME
  • last_updated_time — DATETIME

vehicle_master

  • car_no — VARCHAR(255) — NOT NULL
  • vin — VARCHAR(255)
  • vehicle_info_source — VARCHAR(255)
  • vehicle_info_collected_time — DATETIME
  • vehicle_name — VARCHAR(255)
  • vehicle_model_type — VARCHAR(255)
  • manufacturer_name — VARCHAR(255)
  • manufacture_year_month — DATE
  • vehicle_category — VARCHAR(255) — NOT NULL
  • vehicle_use_type — VARCHAR(255) — NOT NULL
  • body_type — VARCHAR(255)
  • vehicle_role_type — VARCHAR(255) — NOT NULL
  • towed_vehicle_yn — TINYINT(1)
  • combination_required_yn — TINYINT(1)
  • length_mm — INT
  • width_mm — INT
  • height_mm — INT
  • curb_weight_kg — INT
  • gross_vehicle_weight_rating_kg — INT
  • max_payload_kg — INT
  • axle_count_registered — INT
  • axle_configuration — VARCHAR(255)
  • fuel_type — VARCHAR(255)
  • registration_date — DATE
  • registration_status — VARCHAR(255)
  • inspection_valid_until — DATE
  • tuning_history_flag — TINYINT(1)
  • tuning_last_date — DATE
  • tuning_item_summary — VARCHAR(255)
  • business_vehicle_yn — TINYINT(1)
  • carrier_name — VARCHAR(255)
  • data_quality_code — VARCHAR(255)
  • last_updated_time — DATETIME

vehicle_road_link_match

  • match_id — VARCHAR(255) — 기본 키 — NOT NULL
  • car_no — VARCHAR(255)
  • car_no_hash — TEXT
  • event_id — VARCHAR(255) — 외래 키 → common_event_metadata.event_id — NOT NULL
  • event_type — VARCHAR(255) — NOT NULL
  • ingestion_method — VARCHAR(255) — NOT NULL
  • event_time — DATETIME — NOT NULL
  • lat — DECIMAL(18,3)
  • lon — DECIMAL(18,3)
  • matched_link_id — VARCHAR(255) — NOT NULL
  • matched_road_section_id — VARCHAR(255)
  • matched_node_id — VARCHAR(255)
  • matched_ic_id — VARCHAR(255)
  • match_method — VARCHAR(255) — NOT NULL
  • match_score — DECIMAL(18,3)
  • matched_time — DATETIME — NOT NULL

verification_source_event

  • verification_id — VARCHAR(255) — 외래 키 → weight_verification_result.verification_id — NOT NULL
  • car_no — VARCHAR(255) — NOT NULL
  • event_id — VARCHAR(255) — 외래 키 → common_event_metadata.event_id — NOT NULL
  • event_type — VARCHAR(255) — NOT NULL
  • event_time — DATETIME — NOT NULL
  • transport_order_id — VARCHAR(255) — 외래 키 → transport_order_common.platform_order_id
  • trip_id — VARCHAR(255)
  • station_id — VARCHAR(255) — 외래 키 → common_station_device_metadata.station_id
  • station_type — VARCHAR(255)
  • station_owner_type — VARCHAR(255)
  • device_id — VARCHAR(255) — 외래 키 → equipment_master.device_id
  • device_type — VARCHAR(255)
  • gross_weight_kg — DECIMAL(18,3)
  • source_event_role — VARCHAR(255)
  • event_match_score — DECIMAL(18,3)
  • match_reason — VARCHAR(255)

weather_observation

  • weather_observation_id — VARCHAR(255) — 기본 키 — NOT NULL
  • weather_source_id — VARCHAR(255) — NOT NULL
  • weather_source_type — VARCHAR(255) — NOT NULL
  • weather_observed_time — DATETIME — NOT NULL
  • weather_lat — DECIMAL(18,3)
  • weather_lon — DECIMAL(18,3)
  • weather_grid_x — INT
  • weather_grid_y — INT
  • temperature_c — DECIMAL(18,3)
  • humidity_percent — DECIMAL(18,3)
  • precipitation_mm — DECIMAL(18,3)
  • precipitation_type — VARCHAR(255)
  • wind_speed_mps — DECIMAL(18,3)
  • wind_direction_deg — INT
  • visibility_m — DECIMAL(18,3)
  • road_surface_temp_c — DECIMAL(18,3)
  • road_surface_status — VARCHAR(255)
  • data_quality_code — VARCHAR(255) — NOT NULL

weight_vehicle_legal_match

  • legal_match_id — VARCHAR(255) — 기본 키 — NOT NULL
  • event_id — VARCHAR(255) — 외래 키 → common_event_metadata.event_id — NOT NULL
  • event_type — VARCHAR(255) — NOT NULL
  • car_no — VARCHAR(255) — NOT NULL
  • tractor_car_no — VARCHAR(255)
  • trailer_car_no — VARCHAR(255)
  • link_id — VARCHAR(255) — 외래 키 → road_link_master.link_id
  • rule_version_id — VARCHAR(255) — 외래 키 → rule_version.rule_version_id — NOT NULL
  • applied_rule_valid_from_date — DATE
  • applied_rule_valid_until_date — DATE
  • measured_gross_weight_kg — DECIMAL(18,3) — NOT NULL
  • measured_max_axle_weight_kg — DECIMAL(18,3)
  • measured_axle_weights_kg — JSON
  • detected_axle_count — INT
  • registered_axle_count — INT
  • registered_max_payload_kg — INT
  • registered_gvwr_kg — INT
  • calculated_curb_weight_kg — INT
  • calculated_payload_kg — INT
  • gross_weight_over_limit_yn — TINYINT(1) — NOT NULL
  • axle_weight_over_limit_yn — TINYINT(1) — NOT NULL
  • payload_over_registered_yn — TINYINT(1)
  • axle_count_mismatch_yn — TINYINT(1)
  • permit_required_yn — TINYINT(1) — NOT NULL
  • permit_valid_yn — TINYINT(1)
  • violation_type — VARCHAR(255)
  • legal_judgement_status — VARCHAR(255) — NOT NULL
  • legal_judgement_reason — VARCHAR(255)
  • reweigh_required_yn — TINYINT(1) — NOT NULL
  • vc_issue_eligible_yn — TINYINT(1) — NOT NULL
  • vc_reject_reason — VARCHAR(255)
  • match_status — VARCHAR(255) — NOT NULL
  • judged_time — DATETIME — NOT NULL
  • created_time — DATETIME
  • last_updated_time — DATETIME
  • legal_judgement_evidence_id — VARCHAR(255) — 외래 키 → legal_judgement_evidence.legal_judgement_evidence_id
  • tolerance_evidence_id — VARCHAR(255) — 외래 키
  • applied_rule_snapshot_hash — TEXT
  • gross_margin_to_limit_kg — DECIMAL(18,3)
  • min_axle_margin_to_limit_kg — DECIMAL(18,3)
  • freepass_decision_evidence_id — VARCHAR(255) — 외래 키

weight_verification_result

  • verification_id — VARCHAR(255) — 기본 키 — NOT NULL
  • transport_order_id — VARCHAR(255) — 외래 키 → transport_order_common.platform_order_id
  • trip_id — VARCHAR(255)
  • car_no — VARCHAR(255) — NOT NULL
  • verification_time — DATETIME — NOT NULL
  • event_id — VARCHAR(255) — 외래 키 → common_event_metadata.event_id
  • event_type — VARCHAR(255) — NOT NULL
  • legal_match_id — VARCHAR(255)
  • basis_rule_version_id — VARCHAR(255)
  • source_event_count — INT — NOT NULL
  • basis_legal_match_count — INT
  • normal_judgement_count — INT
  • last_normal_judgement_time — DATETIME
  • match_confidence_score — DECIMAL(18,3)
  • weight_trust_score — DECIMAL(18,3) — NOT NULL
  • weight_consistency_score — DECIMAL(18,3)
  • vehicle_identity_score — DECIMAL(18,3)
  • equipment_trust_score — DECIMAL(18,3)
  • environment_reliability_score — DECIMAL(18,3)
  • anomaly_detected_yn — TINYINT(1) — NOT NULL
  • anomaly_type — VARCHAR(255)
  • anomaly_reason — VARCHAR(255)
  • verification_status — VARCHAR(255) — NOT NULL
  • verification_reason — VARCHAR(255)
  • vc_issue_eligible_yn — TINYINT(1) — NOT NULL
  • vc_issue_reject_reason — VARCHAR(255)
  • created_time — DATETIME
  • last_updated_time — DATETIME

wim_measurement_event

  • event_id — VARCHAR(255) — 외래 키 → common_event_metadata.event_id — NOT NULL
  • station_id — VARCHAR(255) — 외래 키 → common_station_device_metadata.station_id — NOT NULL
  • station_type — VARCHAR(255) — NOT NULL
  • device_id — VARCHAR(255) — 외래 키 → equipment_master.device_id — NOT NULL
  • device_type — VARCHAR(255) — NOT NULL
  • sensor_type — VARCHAR(255)
  • lane_no — INT — NOT NULL
  • car_no — VARCHAR(255) — NOT NULL
  • car_no_recognition_status — VARCHAR(255)
  • car_no_recognition_confidence — DECIMAL(18,3)
  • passage_time — DATETIME — NOT NULL
  • speed_kph — DECIMAL(18,3) — NOT NULL
  • vehicle_length_m — DECIMAL(18,3)
  • headway_sec — DECIMAL(18,3)
  • driving_pattern_status — VARCHAR(255)
  • gross_weight_kg — DECIMAL(18,3) — NOT NULL
  • axle_count — INT — NOT NULL
  • axle_weights_kg — JSON — NOT NULL
  • axle_spacings_m — JSON
  • axle_group_weights_kg — JSON
  • wheel_weights_kg — JSON
  • vehicle_class_raw — VARCHAR(255)
  • overweight_suspect_flag — TINYINT(1)
  • overweight_suspect_basis — VARCHAR(255)
  • weight_validity — VARCHAR(255) — NOT NULL
  • weight_invalid_reason — VARCHAR(255)
  • sensor_temperature_c — DECIMAL(18,3)
  • road_surface_status — VARCHAR(255)
  • signal_uri — TEXT
  • car_no_image_uri — TEXT
  • front_image_uri — TEXT
  • side_image_uri — TEXT
  • event_type — VARCHAR(255) — NOT NULL
  • collected_time — DATETIME — NOT NULL
  • ingestion_method — VARCHAR(255)
  • payload_parse_status — VARCHAR(255)
  • duplicate_flag — TINYINT(1)
  • time_delay_ms — INT
  • raw_payload_uri — TEXT
  • raw_payload_hash — TEXT
  • raw_signal_uri — TEXT
  • raw_signal_hash — TEXT
  • raw_car_no_image_uri — TEXT
  • raw_front_image_uri — TEXT
  • raw_side_image_uri — TEXT
  • data_quality_code — VARCHAR(255)
  • station_master_match_status — VARCHAR(255)
  • station_name — VARCHAR(255)
  • device_master_match_status — VARCHAR(255)
  • device_calibration_valid_yn — TINYINT(1)
  • device_equipment_status — VARCHAR(255)
  • scale_capacity_kg — DECIMAL(18,3)
  • link_id — VARCHAR(255) — 외래 키 → road_link_master.link_id
  • calibration_id — VARCHAR(255) — 외래 키 → equipment_calibration_master.calibration_id
  • station_link_match_status — VARCHAR(255)
  • location_name — VARCHAR(255)
  • direction — VARCHAR(255)
  • car_no_normalized — VARCHAR(255)
  • vehicle_master_match_status — VARCHAR(255)
  • vehicle_category — VARCHAR(255)
  • … +33