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