bma 진단기

테이블 (9)

analysis_result

  • analysis_id — BIGINT — 기본 키 — NOT NULL
  • meas_id — BIGINT — 외래 키 → measurement.meas_id — NOT NULL
  • analysis_type — VARCHAR(30) — NOT NULL
  • rs_ohm — DECIMAL(20,8)
  • rct_ohm — DECIMAL(20,8)
  • tau_peak_s — DECIMAL(20,8)
  • soh_percent — DECIMAL(5,2)
  • fit_error — DECIMAL(20,8)
  • drt_file_path — VARCHAR(500)
  • created_at — DATETIME — NOT NULL

bma_module

  • bma_id — BIGINT — 기본 키 — NOT NULL
  • bma_serial — VARCHAR(100) — NOT NULL
  • vehicle_model — VARCHAR(100)
  • config_code — VARCHAR(50)
  • nominal_capacity_ah — DECIMAL(10,3)
  • manufacture_date — DATE
  • note — VARCHAR(500)

cell_info

  • cell_id — BIGINT — 기본 키 — NOT NULL
  • bma_id — BIGINT — 외래 키 → bma_module.bma_id — NOT NULL
  • position_index — INT — NOT NULL
  • cell_vendor — VARCHAR(100)
  • cell_model — VARCHAR(100)
  • nominal_ir_mohm — DECIMAL(10,3)
  • nominal_capacity_ah — DECIMAL(10,3)

cycle_log

  • cycle_id — BIGINT — 기본 키 — NOT NULL
  • meas_id — BIGINT — 외래 키 → measurement.meas_id — NOT NULL
  • step_index — INT — NOT NULL
  • time_s — DECIMAL(15,3)
  • current_a — DECIMAL(15,6)
  • voltage_v — DECIMAL(15,6)
  • temperature_c — DECIMAL(10,4)
  • status — VARCHAR(30)

eis_raw

  • eis_id — BIGINT — 기본 키 — NOT NULL
  • meas_id — BIGINT — 외래 키 → measurement.meas_id — NOT NULL
  • freq_hz — DECIMAL(20,8) — NOT NULL
  • re_z_ohm — DECIMAL(20,8) — NOT NULL
  • im_z_ohm — DECIMAL(20,8) — NOT NULL
  • phase_deg — DECIMAL(10,4)
  • ts — DATETIME

instrument

  • instrument_id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • manufacturer — VARCHAR(100)
  • model — VARCHAR(100)
  • fw_version — VARCHAR(50)

measurement

  • meas_id — BIGINT — 기본 키 — NOT NULL
  • bma_id — BIGINT — 외래 키 → bma_module.bma_id — NOT NULL
  • cell_id — BIGINT
  • instrument_id — BIGINT — NOT NULL
  • user_id — BIGINT
  • meas_type — VARCHAR(30) — NOT NULL
  • start_time — DATETIME — NOT NULL
  • end_time — DATETIME
  • soc_percent — DECIMAL(5,2)
  • temperature_env — DECIMAL(5,2)
  • comment — VARCHAR(500) — ARCHAR(500

temp_log

  • temp_id — BIGINT — 기본 키 — NOT NULL
  • meas_id — BIGINT — 외래 키 → measurement.meas_id — NOT NULL
  • sensor_index — INT — NOT NULL
  • time_s — DECIMAL(15,3)
  • temperature_c — DECIMAL(10,4) — NOT NULL

user_account

  • user_id — BIGINT — 기본 키 — NOT NULL
  • user_name — VARCHAR(100) — NOT NULL
  • department — VARCHAR(100)
  • role — VARCHAR(50)