عرض عملي: تقسيم قاعدة بيانات Shop المشتركة

خطوة بخطوة

1. Map every table to an owner and list queries that cross owners (for example a join of orders and products).
2. Create separate schemas and database users: orders, inventory, payments.
3. Replace the cross-owner join with a snapshot in order_lines and a call to inventory's API for stock.
4. Migrate data and move Flyway migrations into each service.
5. Planned mistake: give orders read access "just for reporting" on inventory's table. Show how a column rename in inventory breaks it, then revoke and use an event feed instead.
6. Document the context map and data ownership table in the repo.