Is your feature request related to a problem?
The database for v1.0 may not be optimized for performance and consistency. This could lead to inefficiencies and complications as we scale.
Describe the solution you'd like
- Audit indexes: add missing ones and remove unused
- Standardize on ID vs UUID usage across tables
- Standardize the timezone followed
- Log slow queries
- Adding ENUMS
Is your feature request related to a problem?
The database for v1.0 may not be optimized for performance and consistency. This could lead to inefficiencies and complications as we scale.
Describe the solution you'd like