README.en-us.md · 雾水/ERD-ONLINE - Gitee.com

forked from martin88 / ERD-ONLINE

加入 Gitee

与超过 1200万开发者一起发现、参与优秀开源项目，私有仓库也完全免费：）

克隆/下载

README.en-us.md 4.30 KB

![Logo](/img/logo.png)

[简体中文](/README.md) | English

<p align="center"><strong>🌍 ERD Online: The World's First Open Source, Free Online Data Modeling and Metadata Management Platform 🚀</strong></p>
<p align="center"><strong>Featuring user-friendly metadata design, relationship diagram creation, SQL querying, and more. Enhanced with versioning, import/export, data sources, SQL parsing, auditing, and team collaboration tools for fast and secure metadata management in databases 🛠️</strong></p>

<p align="center">
<a href="https://github.com/www-zerocode-net-cn/ERD-Online"><img alt="ERD%20Online" src="https://img.shields.io/badge/zerocode-ERD%20Online-brightgreen"></a>
<a href="https://github.com/www-zerocode-net-cn/ERD-Online/actions/workflows/ci.yml"><img alt="build" src="https://img.shields.io/github/actions/workflow/status/www-zerocode-net-cn/ERD-Online/ci.yml?branch=main&style=flat-square"></a>
<a href="https://mvnrepository.com/artifact/com.java2e/martin-extension-ncnb"><img alt="Maven Package" src="https://img.shields.io/maven-metadata/v?metadataUrl=https%3A%2F%2Frepo1.maven.org%2Fmaven2%2Fcom%2Fjava2e%2Fmartin-extension-ncnb%2Fmaven-metadata.xml"></a>
</p>

<p align="center">
<a href="https://github.com/www-zerocode-net-cn/ERD-Online/blob/master/LICENSE"><img src="https://img.shields.io/github/license/www-zerocode-net-cn/ERD-Online?style=flat-square" alt="AGPL-V3 License"></a>
<a href="https://www.typescriptlang.org"><img alt="Language" src="https://img.shields.io/badge/language-TypeScript-blue.svg?style=flat-square"></a>
<a href="https://github.com/www-zerocode-net-cn/ERD-Online/pulls"><img alt="PRs Welcome" src="https://img.shields.io/badge/PRs-Welcome-brightgreen.svg?style=flat-square"></a>
<a href="https://www.erdonline.com"><img alt="website" src="https://img.shields.io/static/v1?label=&labelColor=505050&message=website&color=0076D6&style=flat-square&logo=google-chrome&logoColor=0076D6"></a>
</p>

## Features 🌟

📦 **Ready to Use**: Focus on data structure design right out of the box.

🌱 **Team Collaboration**: Three-tier permissions (Owner, Admin, Regular Role) with element-level access control.

📋 **Metadata Design**: Quick replication of existing table structures, table defaults, and case settings via JSON.

🏷 **Metadata Management**: Online management of table structures, with support for executing directly to the database.

🎨 **Metadata Parsing**: Manage existing database structures within the software.

📱 **Multiple Data Sources**: Supports various database connections for online management (MySQL, Oracle, DB2, SQL Server, PostgreSQL), and synchronizes metadata structures across different sources.

📡 **Version Control**: Generate versions for each requirement and change; compare differences between versions.

🎉 **Documentation Generation**: Auto-generate Word, HTML, and MD documents of all table structures for offline use.

💯 **Online SQL**: Online SQL querying, execution plans, and historical query tracking.

🧲 **Never Lose Data**: Keep track of the last 9 metadata operation versions, with the ability to restore to any historical version.

🌏 **Data Dictionary**: Global data dictionary design to standardize metadata design.

## Development Milestones 🛤️

![milepost](/img/milepost.png)

## Product Atlas 🗺️
![ERD Online Function Tree](https://user-images.githubusercontent.com/26294919/230535866-1936a1aa-099b-4b75-80ba-442c2c22cf55.png)

## About Us 🤝

ERD Online Official website: [https://www.erdonline.com/](https://www.erdonline.com/)

ERD Online Experience: [https://app.erdonline.com/](https://app.erdonline.com/)

ERD Online Documentation: [https://doc.erdonline.com/](https://doc.erdonline.com/)

Forum: [https://github.com/www-zerocode-net-cn/ERD-Online/discussions](https://github.com/www-zerocode-net-cn/ERD-Online/discussions)

Backend Source Code:
- [Cluster Version](https://github.com/www-zerocode-net-cn/martin-framework)
- [Single Node Version](https://gitee.com/MARTIN-88/erd-apis)

## Function Atlas

### Diagram Design
![Diagram](/img/relation.png)

### Metadata Design
![Metadata](/img/table.png)

### Version Management
![Version](/img/version.png)

### Import
![Import](/img/import.png)

### Export
![Export DDL](/img/export.png)

### Online SQL
![Online SQL](/img/query.png)

### SQL Explain
![SQL Explain](/img/explain.png)

一键复制编辑原始数据按行查看历史

提交于 2024-01-28 12:04 . add(erd-onloine): 后端源码全开源，MIT协议

简体中文 | English

🌍 ERD Online: The World's First Open Source, Free Online Data Modeling and Metadata Management Platform 🚀

Featuring user-friendly metadata design, relationship diagram creation, SQL querying, and more. Enhanced with versioning, import/export, data sources, SQL parsing, auditing, and team collaboration tools for fast and secure metadata management in databases 🛠️

Features 🌟

📦 Ready to Use: Focus on data structure design right out of the box.

🌱 Team Collaboration: Three-tier permissions (Owner, Admin, Regular Role) with element-level access control.

📋 Metadata Design: Quick replication of existing table structures, table defaults, and case settings via JSON.

🏷 Metadata Management: Online management of table structures, with support for executing directly to the database.

🎨 Metadata Parsing: Manage existing database structures within the software.

📱 Multiple Data Sources: Supports various database connections for online management (MySQL, Oracle, DB2, SQL Server, PostgreSQL), and synchronizes metadata structures across different sources.

📡 Version Control: Generate versions for each requirement and change; compare differences between versions.

🎉 Documentation Generation: Auto-generate Word, HTML, and MD documents of all table structures for offline use.

💯 Online SQL: Online SQL querying, execution plans, and historical query tracking.

🧲 Never Lose Data: Keep track of the last 9 metadata operation versions, with the ability to restore to any historical version.

🌏 Data Dictionary: Global data dictionary design to standardize metadata design.

Development Milestones 🛤️

milepost

Product Atlas 🗺️

ERD Online Function Tree

About Us 🤝

ERD Online Official website: https://www.erdonline.com/

ERD Online Experience: https://app.erdonline.com/

ERD Online Documentation: https://doc.erdonline.com/

Forum: https://github.com/www-zerocode-net-cn/ERD-Online/discussions

Backend Source Code:

Function Atlas

Diagram Design

Diagram

Metadata Design

Metadata

Version Management

Version

Import

Import

Export

Export DDL

Online SQL

Online SQL

SQL Explain

SQL Explain

JavaScript

1

https://gitee.com/yuyoq/erd-online.git

git@gitee.com:yuyoq/erd-online.git

yuyoq

erd-online

ERD-ONLINE

master