Design Schema for Handling credit orders

[Mzeey]

Task Description

Design the database schema for handling credit orders, ensuring a structured and organized representation of credit order-related information.

Acceptance Criteria

• [ ] Create a "CreditOrders" table to store credit order details with fields for credit_order_id, user_id, meter_id, amount, order_timestamp, and status.
• [ ] Implement appropriate data types and constraints for each field.
• [ ] Document the purpose and relationships of each field in the schema.

User Story

• 41

Milestone (Epic)

• 21

Task Dependencies

• [ ] #51
• [ ] #62

Additional Context

Consider future scalability and potential enhancements related to credit orders when designing the schema. Document the schema design thoroughly for reference during implementation.

[Mzeey]

Oh this will also contain price per credit, and number of credits