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