scc

Tables (6)

SC_CHARGER

  • charger_id (Key) — NUMBER(10) — Primary key — NOT NULL
  • station_id — NUMBER(10) — 충전소
  • id_cp — VARCHAR2(50) — CSMS에
  • cp_p_max — NUMBER(10) — 충전

SC_CONNECTOR

  • connector_id — NUMBER(10)
  • charger_id — NUMBER(10) — 충전기
  • id_con — NUMBER(5) — 커넥터
  • con_p_max — NUMBER(10) — 커넥터
  • con_p_min — NUMBER(10) — 커넥터
  • t_charging — NUMBER(1) — 스마트

SC_STATION

  • station_id (Key) — NUMBER(10) — Primary key — NOT NULL
  • station_name — VARCHAR2(100) — 충전소
  • p_grid_max — NUMBER(10) — 전력망
  • efficiency — NUMBER(5,2) — 충전
  • alo_span — NUMBER(5) — 시간확장
  • alo_iter_max — NUMBER(10) — 계산
  • price_limit — NUMBER(10) — 최대

SC_VEHICLE

  • vehicle_id (Key) — NUMBER(10) — Primary key — NOT NULL
  • vehicle_name — VARCHAR2(50) — 차량
  • battery_capacity — NUMBER(10) — 차량
  • soc — NUMBER(5,2) — 차량

electricity_bill

  • id — NUMBER
  • customer_number — VARCHAR2(50) — NOT NULL — 고객
  • applied_power — NUMBER(10,2) — NOT NULL — 요금
  • created_at — DATE — NOT NULL — 레코드
  • updated_at — DATE — NOT NULL — 레코드
  • created_by — VARCHAR2(50) — 레코드
  • updated_by — VARCHAR2(50) — 레코드

electricity_bill_history

  • history_id — NUMBER — Primary key — NOT NULL
  • bill_id — NUMBER — NOT NULL — 원본
  • customer_number — VARCHAR2(50) — NOT NULL — 고객
  • applied_power — NUMBER(10,2) — NOT NULL — 요금
  • change_date — DATE — NOT NULL — 변경
  • changed_by — VARCHAR2(50) — 변경한
  • change_type — VARCHAR2(10) — NOT NULL — 변경