
⚡ Energy & Utilities · Database ERD
The core tables of a utility billing system: customers, premises, meters, meter readings, tariffs and bills.
Opening a template is free and never counts toward your daily diagrams. Asking the AI to change it counts as one.
Drawing diagram…
Database schema for utility billing: customers own accounts; each account is for a premises; a premises has meters (with install and removal dates); meters have readings (actual or estimated); bills are generated per account per billing period using a tariff, with bill lines and payments.
erDiagram
CUSTOMER ||--o{ ACCOUNT : holds
PREMISES ||--o{ ACCOUNT : "billed for"
PREMISES ||--o{ METER : has
METER ||--o{ READING : records
ACCOUNT ||--o{ BILL : receives
TARIFF ||--o{ BILL : "priced by"
BILL ||--|{ BILL_LINE : contains
BILL ||--o{ PAYMENT : "paid by"
CUSTOMER {
int id PK
string name
string phone
}
ACCOUNT {
int id PK
int customer_id FK
int premises_id FK
string status
}
PREMISES {
int id PK
string address
string category
}
METER {
int id PK
int premises_id FK
string serial_no
date installed_on
date removed_on
}
READING {
int id PK
int meter_id FK
datetime read_at
decimal kwh
string read_type
}
TARIFF {
int id PK
string code
decimal rate_per_kwh
date effective_from
}
BILL {
int id PK
int account_id FK
int tariff_id FK
date period_end
decimal amount
}
BILL_LINE {
int id PK
int bill_id FK
string description
decimal amount
}
PAYMENT {
int id PK
int bill_id FK
decimal amount
string channel
}An entity relationship diagram with 9 tables, 37 columns and 8 relationships.
Describe your own system in plain English and the AI ER diagram generator draws it in seconds, in the same style as this template.
How readings from millions of smart electricity meters reach billing and customers: head-end system, meter data management and analytics.
What a power utility does from the moment an outage is detected to restoring supply and closing the incident.
The software behind a modern power grid: SCADA/EMS for transmission, ADMS for distribution, smart meters, DER management and the customer portal.
How an electricity or water bill is produced and paid: meter reads, validation, tariff calculation, bill delivery and payment posting.
Where monitoring runs for a renewable energy portfolio: inverters and turbines at each plant, a plant controller, and the central monitoring cloud.
How electricity flows from generation sources to the grid and on to consumer segments, including losses.