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