maria

Tables (7)

charger

  • charger_id — INT(11) — Primary key — NOT NULL
  • charger_src_id — VARCHAR(100)
  • station_id — INT(11) — Foreign key → station.station_id — NOT NULL
  • charger_type_id — INT(11) — Foreign key → dim_charger_type.charger_type_id
  • capacity_kw — DECIMAL(10,2)
  • status_id — INT(11) — Foreign key → dim_status.status_id
  • mgmt_src_id — VARCHAR(100)

dim_address

  • address_id — INT(11) — Primary key — NOT NULL
  • road_addr — VARCHAR(300) — NOT NULL
  • lat — DECIMAL(10,6)
  • lng — DECIMAL(10,6)
  • district_id — INT(11) — Foreign key → dim_district.district_id — NOT NULL

dim_charger_type

  • charger_type_id — INT(11) — Primary key — NOT NULL
  • charger_type_name — VARCHAR(50) — NOT NULL

dim_district

  • district_id — INT(11) — Primary key — NOT NULL
  • district_name — VARCHAR(50) — NOT NULL

dim_operator

  • operator_id — INT(11) — Primary key — NOT NULL
  • operator_name — VARCHAR(200) — NOT NULL

dim_status

  • status_id — INT(11) — Primary key — NOT NULL
  • status_name — VARCHAR(50) — NOT NULL

station

  • station_id — INT(11) — Primary key — NOT NULL
  • station_name — VARCHAR(300) — NOT NULL
  • address_id — INT(11) — Foreign key → dim_address.address_id — NOT NULL
  • operator_id — INT(11) — Foreign key → dim_operator.operator_id — NOT NULL