ISSUE 4: Design the Database Schema

[emidombek]

As a developer,

I need to design the database schema for the e-commerce website, So that I can create efficient and organized data structures.

Acceptance Criteria

• [x] Define the structure of the database, including tables and relationships.
• [x] Identify the key entities such as products, users, and orders.
• [x] Determine the attributes (fields) for each entity and their data types.
• [x] Create an ER diagram or document illustrating the schema design.

[emidombek]

Starting the draft schema design.

[emidombek]

Finished DB design spreadsheet with models,fields and datatypes here: https://docs.google.com/spreadsheets/d/1yzLWMaacPBo0Enisx-ewH1tFGFetv429_kQoNCWtCQs/edit?usp=sharing

[emidombek]

ERD diagram:

[emidombek]

Added removed some schema's updated ERD diagram:

[emidombek]

Database fields and datatypes planning sheet: https://docs.google.com/spreadsheets/d/1yzLWMaacPBo0Enisx-ewH1tFGFetv429_kQoNCWtCQs/edit?usp=sharing