maria
Tables (6)
charger (충전기)
- charger_id (충전기 id) — INT — Primary key — NOT NULL
- capacity_kw (정격 출력) — DECIMAL(10,2)
- station_id (충전소 id) — INT — Foreign key → station.station_id — NOT NULL
dim_address (주소)
- address_id (주소 id) — INT — Primary key — NOT NULL
- road_addr (도로명 주소) — VARCHAR(300) — NOT NULL
- lat (위도) — DECIMAL(10,6)
- lng (경도) — DECIMAL(10,6)
- district_id (행정구역 id) — INT — Foreign key → dim_district.district_id — NOT NULL
dim_district (행정구역)
- district_id (행정구역 id) — INT — Primary key — NOT NULL
- district_name (행정구역 이름) — VARCHAR(50) — NOT NULL
dim_operator (운영기관)
- operator_id (운영기관 id) — INT — Primary key — NOT NULL
- operator_name (운영기관 이름) — VARCHAR(200) — NOT NULL
fee (요금)
- tariff_id (요금제 id) — VARCHAR(20) — Primary key — NOT NULL
- operator_id (운영기관 id) — INT — Foreign key → dim_operator.operator_id — NOT NULL
- charger_type (요금 구분 타입) — VARCHAR(20) — NOT NULL
- day_price_kwh (주간 요금) — DECIMAL(10,2)
- night_price_kwh (야간 요금) — DECIMAL(10,2)
- membership (회원 요금) — VARCHAR(120)
- roaming (로밍 정책 요약) — VARCHAR(120)
station (충전소)
- station_id (충전소 id) — INT — Primary key — NOT NULL
- station_name (충전소 이름) — VARCHAR(300) — NOT NULL
- address_id (주소 id) — INT — Foreign key → dim_address.address_id — NOT NULL
- operator_id (운영기관 id) — INT — Foreign key → dim_operator.operator_id — NOT NULL