Open Flutter Project: E-commerce App Local Database
We are moving forward on implementation of the E-commerce App described in this articles. We already have UI/UX done. Our project team is spread all over the world in various time zones. That is why we need have exact same vision of the functionality we do.
We have a few variants to consider:
- Describe each feature on the UI/UX screens and add it to requirement document. Write a detailed backlog and break it down into smaller tasks.
- Make structure of the models we will be using that will explain the attributes of each entity that will be used.
The app design is common for E-commerce App and most of users are familiar with a process like Product Catalog -> Product Details -> Add to Cart -> Checkout. There is no need to describe it in details.
What we can do no is describe the structure of the local database used in the app. Let`s see what it looks like.
Products table
It is self-explanatory if you look at the screens on the screenshot below
Product Photos, Product Parameters and Parameter Variants
Product parameter variant can affect the price (additionalPrice field).
Product Categories
Product Reviews
Product and Category Hashtags
User and Shipping Addresses
Cart
Promo Codes
Delivery Methods
Order Details
As you can see the database structure provides enough details to build models and repositories for most of the features.
Whats next?
You can join our LinkedIn group “Open Flutter Project” to stay up to date on project updates.
If you have any questions or propositions feel free to get in touch with LinkedIn with me.
Regards,
Andrey