test

Tables (4)

report_templates

  • template_id — TEXT
  • description — TEXT
  • template_config — JSONB
  • updated_at — TIMESTAMP

rf_configurations

  • config_id — UUID
  • session_id — UUID — Foreign key → rf_test_sessions.session_id
  • path_name — TEXT
  • path_index — INT
  • air_tech — TEXT — 무선
  • tx_freq_mhz — NUMERIC — 송신(Tx)
  • rx_freq_mhz — NUMERIC
  • tx_bw_mhz — NUMERIC
  • rx_bw_mhz — NUMERIC
  • frequency_band — TEXT — 주파수
  • carrier_info — TEXT
  • config_details — JSONB

rf_test_results

  • result_id — UUID
  • config_id — UUID — Foreign key → rf_configurations.config_id
  • standard_item — TEXT
  • raw_item_name — TEXT — 원본
  • measurement_condition — TEXT
  • test_model — TEXT — 측정
  • measured_value — NUMERIC — 실제
  • spec_min — NUMERIC
  • spec_max — NUMERIC
  • spec_operator — TEXT
  • judgement — TEXT — 단위
  • extra_attributes — JSONB — spec_max
  • mapping_source — TEXT
  • confidence_score — NUMERIC
  • is_reviewed — BOOLEAN
  • created_at — TIMESTAMP

rf_test_sessions

  • session_id — UUID
  • project_name — TEXT
  • du_pkg — TEXT — 측정에
  • ru_model — TEXT — 측정에
  • ru_serial — TEXT — 측정에
  • ru_fw — TEXT — 측정에
  • du_ru_info — JSONB
  • test_date — TIMESTAMP
  • raw_metadata — JSONB
  • unparsed_data — JSONB
  • file_name — TEXT
  • source_department — TEXT
  • basic_code — TEXT — 한
  • created_at — TIMESTAMP