Entity Relationship Diagram

E-commerce ER Diagram

E-commerce ER Diagram - Free database diagram for E-commerce

Open the diagram in full screen Open image in browser SQL DDL scripts

You can create the ER Diagram below by importing the E-commerce SQL scripts into any database design tool that can generate ER Diagrams and database schemas from SQL DDL (Data Definition Language) files. The Demo edition shows the diagram with an evaluation watermark; licensed editions include the complete ER Diagram in PDF, SVG, JPG, PNG format.

E-commerce entity relationship diagram with all entities, attributes and relationships — E-commerce Entity Relationship Diagram (74 entities) Click to zoom

E-commerce database schema design

Entities and attributes

Navigate to each subject area of the E-commerce database diagram to get powerful insights into entities and attributes (tables and columns).

Customer7 entities Store10 entities Item8 entities Inventory and Stock4 entities Price and Discount5 entities Order13 entities Document16 entities Payment and Invoice4 entities Employee and Role7 entities

At a glance

entities (tables)

subject areas

database systems

E-commerce Data Model Help Docs SQL DDL scripts All ER Diagrams

Purchase

Accelerate every database schema design with powerful data models

We have already created the database diagram and prepared the SQL DDL scripts to deploy your database schema. Download a free Demo edition and evaluate it in your own database.

Try Data Model Pack free View pricing