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)