5 Database

When designing a database for an OCPP 1.6J implementation, key entities include the following:

• Charge points to store identifiers, locations, statuses and configurations.
• Transactions to track transaction IDs, charge point IDs, start/end times, energy delivered and user IDs.
• Users to maintain user IDs, names and payment methods.
• Events to log event IDs, charge point references, timestamps and event types (such as faults or status changes).
• Firmware updates to monitor charge point firmware versions and update statuses.