중량
테이블 (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