Skip to content

lgustavopuga/DIO_Ecommerce_DB

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 

Repository files navigation

MySQL E-commerce Database

This repository contains the SQL script for creating a comprehensive E-commerce database using MySQL.

Table of Contents

  1. Introduction
  2. Database Structure
  3. Usage
  4. Contributing
  5. License

Introduction

This database is designed to support an E-commerce system, including tables for clients, payment methods, deliveries, sellers, products, suppliers, stock, orders, and their relationships.


Database Structure

The database structure is organized into the following tables:

  1. Client
  2. PaymentMethod
  3. ClientPayment
  4. Delivery
  5. DeliveryOrder
  6. Seller
  7. ProductSeller
  8. Product
  9. ProductSupplier
  10. Supplier
  11. Stock
  12. ProductStock
  13. Order
  14. ProductOrder

Each table has its own set of columns and relationships, providing a comprehensive schema for an E-commerce system.


Usage

To use this script:

  1. Execute the SQL script in your MySQL environment.
  2. Adjust the database name and configuration to match your requirements.

Contributing

Feel free to contribute by forking this repository, making changes, and submitting a pull request. Your contributions are highly appreciated.


License

This MySQL E-commerce Database is open-sourced under the MIT License.


Feel free to customize the content according to your specific needs. The sections include an introduction, information about the database structure, usage instructions, a call for contributions, and licensing details.

About

DIO Ecommerce DB Project

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published