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