
Hello !
I am currently trying to develop a mobile shop application using flutter and appwrite, and have come across a problem when trying to adapt my data model (image 1) to appwrite's database system.
To do so, I have tried using appwrite's relationship system (image 2). In this case, I have a one to many relation from sale to product, and from product to sale.
However, this solution leaves no room for historisation of the data when the sale is made. Say I add a new stock to a product in the sale with a different buy_price , it doesn't look like I can know which stock was involved when the sale was created?
Would anyone be able to offer a solution to my problem, or clarify the situation if I am misunderstanding how relationships work? Thanks a lot! :terraLike:
Recommended threads
- Database update issue
When updating value of any attribute from appwrite Dashboard then this issue facing
- Unable to migrate the project to self ho...
The Continue button is disabled in the migration modal. Unable to migrate the project. In both local and cloud appwrite 1.7.4
- Why is it taking up so much bandwidth?
Why is it taking up so much bandwidth, Because I am not even using storage, neither for images nor for PDF, then how did I get so much GB bandwidth
