Design Schema for Storing Meter Details

Mzeey commented 7 months ago

Task Description

Design the database schema for storing meter details, ensuring a well-organized structure to support efficient retrieval and management of meter-related information.

Acceptance Criteria

[ ] Create a "Meters" table to store meter details with fields for meter ID, meter number, location, installation date, and other relevant information.
[ ] Implement appropriate data types and constraints for each field.
[ ] Consider any additional attributes needed for comprehensive meter details (e.g., meter type, manufacturer, firmware version).
[ ] Establish primary and unique keys as needed for data integrity.
[ ] Ensure fields to track the current status of each meter (e.g., active, inactive, under maintenance).

User Story

42 (core)
40
34
35

Milestone (Epic)

21

Additional Context

Ensure that the schema accommodates the expected volume of meters, and consider future scalability for potential enhancements or additional meter-related features.

Mzeey commented 7 months ago

We need to find a way to get the live meter units, possible this will not be stored in the database, but rather gotten from a service whose work is to get the live units from the meter. We will just handle allocating the purchased meter units to the system.

Mzeey commented 7 months ago

Also, because of the management of electricity is done by regions, this means that each regions will have it's own pricing. we most likely will be categorising meters based off regions

Mzeey commented 7 months ago

There are actually various meter types, there will be a table for storing meter types which will be referenced in the meter table as meterTypeId

mzeey-tutorials / NepaApp