Wiki Article · Cinematic

E-commerce Data Model

E-commerce data model ek online store ka complete database blueprint hai jo define karta hai ke…

Overview

E-commerce Data Model — Quick Facts

📌

Property: Detail

🎯

Full Name: E-commerce Data Model

⚡

Category: Database Design / Data…

🔑

Also Known As: E-commerce Schema, Online Store…

Topic 1

Kya Hai E-commerce Data Model

💡

Entities kya hain (Products,…

🔑

Har entity ke attributes kya hain…

⚡

Entities ke beech relationships…

🎯

Constraints kya hain (price…

Topic 2

Analogy — Library Catalog System

💾 E-commerce data model ko library system se samjho: | Library System | E-commerce Data…

Topic 3

Core Entities Overview

🗄️ | # | Entity | Key Attributes | Primary Key | Purpose | |---|---|---|---|---| | 1 | Users…

Topic 4

User / Account Entity

💡

user_id (PK) — unique identifier…

🔑

email — unique, login ke liye…

⚡

password_hash — bcrypt/argon2…

🎯

first_name, last_name — display…

Topic 5

Product Entity

💡

product_id (PK) — unique identifier

🔑

name — product title

⚡

slug — URL-friendly name (e.g.,…

🎯

description — detailed description…

Topic 6

Category Entity

💡

category_id (PK)

🔑

name — category display name

⚡

slug — URL-friendly

🎯

parent_id (FK → self) — parent…

Topic 7

Cart Entity

💡

cart_id (PK)

🔑

user_id (FK, nullable — guest…

⚡

session_id — guest identification

🎯

status — active, converted (order…

Topic 8

Order Entity

💡

order_id (PK) — unique order number

🔑

user_id (FK)

⚡

status — pending, confirmed,…

🎯

subtotal — items total before…

Topic 9

Payment Entity

💡

payment_id (PK)

🔑

order_id (FK)

⚡

method — credit_card, debit_card,…

🎯

gateway — stripe, razorpay, paypal

Topic 10

Inventory Entity

💡

inventory_id (PK)

🔑

variant_id (FK) — stock variant…

⚡

warehouse_id (FK) —…

🎯

quantity_available — actual…

Topic 11

Shipping Entity

💡

shipment_id (PK)

🔑

order_id (FK)

⚡

carrier — fedex, dhl, delhivery,…

🎯

tracking_number — carrier ka…

Topic 12

Review / Rating Entity

💡

review_id (PK)

🔑

product_id (FK)

⚡

user_id (FK)

🎯

order_item_id (FK, nullable) —…

Topic 13

Entity Relationships

🔍 | Relationship | Type | Cardinality | Description | |---|---|---|---| | User → Addresses…

Topic 14

ER Diagram

📉 `mermaid erDiagram USERS ||--o{ ADDRESSES : "has many" USERS ||--o{ ORDERS : "places"…

Topic 15

Design Patterns

💡

Order items me product data ka…

🔑

Reason: product change hone ke…

⚡

Records actually delete nahi…

🎯

Reason: audit trail, data…

Topic 16

Normalization vs Denormalization

💡

3NF (Third Normal Form) tak…

🔑

Separate tables for users,…

⚡

Foreign keys se relationships…

🎯

Benefits: data consistency, less…

Diagram

Visual Flow

📊 Diagram visualization — details in narration

Quiz — Question 1

E-commerce Data Model ka sabse sahi definition kya hai?

Quick Quiz

Quiz — Question 2

E-commerce Data Model ka 'Full Name' kya hai?

Complete! 🎉

E-commerce Data Model Complete!

Aliens Wiki · HIEN · Cinematic Knowledge

✅