I'm using SpiceDB to store all relationships and metadata is being stored in app relational DB. The flow is as follows :-
1. Create Organisation in App Relational DB (This is Metadata)
2. Check -
2a. If failed, EXIT WITH FAILURE
2b. If passed, MOVE AHEAD
3. Write Relationship in SpiceDB
4. Check -
4a. If passed, EXIT WITH SUCCESS
4b. If failed, Delete Organisation in App Relational DB (This is Metadata)
4c. Check -
4cA. If passed, EXIT WITH FAILURE
4cB. If failed, ??????????