hei_

Tables (6)

tb_hei_car

  • hei_car_id — VARCHAR(255) — HEI 발급 ID (예: rntjdrh308_50거5276)
  • safe_charge_car_id — BIGINT — NOT NULL — BIZ tb_safe_charge_car.id
  • user_id — BIGINT — NOT NULL — tb_member.id
  • car_no — VARCHAR(20) — 차량번호 (= plate)
  • owner_name — VARCHAR(100) — 차주명
  • brand — VARCHAR(100) — 차량 브랜드
  • model_name — VARCHAR(200) — 모델명
  • model_year — VARCHAR(10) — 차량년식
  • vin — VARCHAR(50) — VIN
  • car_type — VARCHAR(20) — 개인|법인
  • mileage — INT — 누적 주행거리 (km)
  • soc_max — INT — 목표 충전량 (0~100)
  • reg_dtm — DATETIME
  • upd_dtm — DATETIME

tb_hei_consent

  • id — BIGINT
  • user_id — BIGINT — NOT NULL — tb_member.id
  • consent_status — VARCHAR(20) — NOT NULL — AGREED|REVOKED
  • consented_at — DATETIME — NOT NULL — 최초 동의 일시
  • revoked_at — DATETIME — 철회 일시
  • reg_dtm — DATETIME
  • upd_dtm — DATETIME

tb_hei_diagnosis

  • id — BIGINT
  • hei_car_id — VARCHAR(255) — NOT NULL
  • battery_level — INT — 0=정상, 1=주의경미, 2=주의중간, 3=위험
  • battery_score — INT — 0~100
  • diagnosis_status — VARCHAR(20) — NORMAL|CAUTION|DANGER
  • diagnosed_at — DATETIME — NOT NULL
  • station_id — BIGINT
  • charger_id — BIGINT
  • charger_key — VARCHAR(20)
  • raw_response — TEXT
  • reg_dtm — DATETIME
  • upd_dtm — DATETIME
  • INDEX — idx_car_diagnosed
  • INDEX — idx_status_diagnosed

tb_hei_file

  • file_id — BIGINT — Primary key — NOT NULL
  • hei_car_id — VARCHAR(255) — Primary key — NOT NULL
  • file_type — VARCHAR(30) — CORPORATE_DOC|VEHICLE|OTHER
  • reg_dtm — DATETIME
  • upd_dtm — DATETIME

tb_safe_charge_alim_history

  • id — BIGINT
  • safe_charge_car_id — BIGINT — NOT NULL — tb_safe_charge_car.id
  • station_id — BIGINT — 발생 충전소 (선택)
  • send_method — VARCHAR(20) — DIRECT|AUTO
  • alim_type — VARCHAR(50) — 알림 유형
  • content — TEXT — 발송 내용
  • sent_at — DATETIME — 발송 일시
  • success_yn — CHAR(1) — Y/N
  • reg_dtm — DATETIME
  • upd_dtm — DATETIME

tb_safe_charge_car

  • id — BIGINT
  • car_no — VARCHAR(20) — NOT NULL — 차량번호
  • owner — VARCHAR(100) — NOT NULL — 소유주명/차주명
  • phone — VARCHAR(20) — NOT NULL — 연락처
  • email — VARCHAR(100) — NOT NULL — 메일 수신지
  • cc_email — VARCHAR(100) — 참조 이메일
  • car_type — VARCHAR(20) — NOT NULL — PERSONAL|CORPORATE|RENTAL
  • is_ev — TINYINT(1) — 0=비전기차, 1=전기차
  • business_license_url — VARCHAR(500) — 사업자등록증 URL
  • battery_status — VARCHAR(20) — NORMAL|CAUTION|RISK|UNDIAGNOSED|UNAVAILABLE
  • user_id — BIGINT — tb_member.id (논리 FK)
  • status — VARCHAR(20) — NOT NULL — REQUESTED|MAIL_SENT|MAIL_FAILED|LINKED|REVOKED|EXPIRED
  • mail_send_count — INT — 메일 발송 누적 횟수
  • registered_by — VARCHAR(100) — Cognito sub or email
  • deleted_yn — CHAR(1) — Y=거점 해제
  • deleted_at — DATETIME — 해제 일시
  • reg_dtm — DATETIME
  • upd_dtm — DATETIME