MyWind is a MySQL version of the Microsoft Access 2010 Northwind sample database.
The Northwind sample database provided with Microsoft Access is an excellent tutorial schema for a small business to manage customers, orders, inventory, purchasing, suppliers, shipping, and employees, using single-entry accounting. However, I wanted to experiment with the Northwind schema using MySQL.
WARNING
- northwind-02 (northwind-02.mwb and northwind-02-sales-orders-and-shipping.png) are a work in process and presumably related to improving the ERD model where it relates to sales orders and shipping, but the specifics have now been lost in time. If anyone sorts this out, I would sincerely appreciate a pull request (creating an issue would be just as appreciated). Thanks.
Files
- Model:
- northwind.mwb (MySQL Workbench v6.2)
- EER Diagram:
- northwind-erd.pdf
- northwind-erd.png
- Structure:
- northwind.sql
- northwind-default-current-timestamp.sql (uses DEFAULT CURRENT TIMESTAMP, requires MySQL 5.6.5+)
- Data:
- northwind-data.sql
如何使用？
- 1.进入会员主界面；
- 2.在【应用与数据】模块中，找到数据并另存到自己的空间；
- 3.创建相关应用的实例，并将数据另存的目录挂载上；
- 4.在应用中使用数据；
文件清单
LICENSE (1 KB)
README.md (2 KB)
northwind-02-sales-orders-and-shipping.png (118 KB)
northwind-02.mwb (41 KB)
northwind-data.sql (146 KB)
northwind-default-current-timestamp.sql (20 KB)
northwind-erd.pdf (49 KB)
northwind-erd.png (203 KB)
northwind.mwb (38 KB)
northwind.sql (20 KB)
README.md (2 KB)
northwind-02-sales-orders-and-shipping.png (118 KB)
northwind-02.mwb (41 KB)
northwind-data.sql (146 KB)
northwind-default-current-timestamp.sql (20 KB)
northwind-erd.pdf (49 KB)
northwind-erd.png (203 KB)
northwind.mwb (38 KB)
northwind.sql (20 KB)
相关应用
MySQL数据库，内置phpMyAdmin管理程序。