Tables
In this article we will see the tables used (database schema) for Nearby Shops
Prerequisite Knowledge
To understand this guide having some basic knowledge of SQL Databases will help you.
Tables for User login Information
1. User 2. StaffPermissions 3. ShopStaffPermissions 4. EmailVerificationCodes 5. PhoneVerificationCodes
Tables for Storing Core app Data
1. Order 2. OrderItem 3. Cart 4. CartItem 5. DeliveryAddress 6. Shop 7. ShopItem 8. Item 9. ItemCategory
Tables for Storing Image Links
1. ItemImages 2. ShopImages
Tables for Storing Item Reviews
1. FavouriteItems 2. ItemReview 3. ItemReviewThanks
Tables for Storing Shop Reviews
1. FavouriteShops 2. ShopReview 3. ShopReviewThanks
For storing billing data
1. Transactions