Design schema for Handle Meter Payment Transactions

[Mzeey]

Task Description

Design the database schema for handling meter payment transactions, ensuring a robust and scalable structure to support secure and efficient transaction processing.

Acceptance Criteria

• [ ] Create a "Transactions" table to store payment transactions with fields for transaction ID, user ID, meter ID, amount, timestamp, and transaction status.
• [ ] Implement appropriate data types and constraints for each field.
• [ ] Include a field to indicate the payment method used for each transaction (e.g., credit card, mobile wallet).
• [ ] Design any additional tables necessary for logging or tracking transaction-related information.

User Story

• 28

• 41 (core)

• 29

Milestone (Epic)

• 21

Task Dependencies

• [ ] #51
• [ ] #62
• [ ] #63

Additional Context

Consider the security measures for handling financial transactions, and implement mechanisms to track and audit payment transactions for transparency and accountability.

[Mzeey]

Do also consider users which are on monthly payments (users not using meters)