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 — 변경