Implement core database schema and migrations #2
Description
- Create database tables for User, Shop, Tenant, Lease, and Payment entities
- Set up foreign key relationships and constraints for data integrity
- Create indexes for optimized query performance on payment and dashboard operations
- Implement database migration system for schema version control
- Add audit trail tables for tracking all data changes