[DBDiagram] ERD 자동생성 사이트 - free

 

 

 

#1. DBDiagram 이란?

 

DBDiagram은 코드를 작성하고 ERD( Entity Relationship Diagram )으로 렌더링 해준다.

 

 

그런다음 PDF나 PNG 파일로 내보내거나 그것을 SQL 코드로 생성하는것도 가능하다.

 

 

 

 

#2. DBDiagram 을 이용하여 ERD 그리기 - CREATE Query문 사용

 

 

URL : https://dbdiagram.io/

dbdiagram.io - Database Relationship Diagrams Design Tool

 

 

 

 

 

 

 

 

CREATE SCHEMA `ecommerce`;

CREATE TABLE `ecommerce`.`orders` (
  `id` int PRIMARY KEY,
  `user_id` int UNIQUE NOT NULL,
  `status` varchar(255),
  `created_at` varchar(255) COMMENT 'When order created'
);

CREATE TABLE `ecommerce`.`order_items` (
  `order_id` int,
  `product_id` int,
  `quantity` int
);

CREATE TABLE `ecommerce`.`products` (
  `id` int PRIMARY KEY,
  `name` varchar(255),
  `merchant_id` int NOT NULL,
  `price` int,
  `status` varchar(255),
  `created_at` varchar(255)
);

CREATE TABLE `ecommerce`.`merchants` (
  `id` int PRIMARY KEY,
  `merchant_name` varchar(255),
  `country_code` int,
  `created_at` varchar(255),
  `admin_id` int
);

CREATE TABLE `users` (
  `id` int PRIMARY KEY,
  `full_name` varchar(255),
  `created_at` varchar(255),
  `country_code` int
);

CREATE TABLE `countries` (
  `code` int PRIMARY KEY,
  `name` varchar(255),
  `continent_name` varchar(255)
);

ALTER TABLE `ecommerce`.`order_items` ADD FOREIGN KEY (`order_id`) REFERENCES `ecommerce`.`orders` (`id`);

ALTER TABLE `ecommerce`.`order_items` ADD FOREIGN KEY (`product_id`) REFERENCES `ecommerce`.`products` (`id`);

ALTER TABLE `ecommerce`.`merchants` ADD FOREIGN KEY (`country_code`) REFERENCES `countries` (`code`);

ALTER TABLE `ecommerce`.`products` ADD FOREIGN KEY (`merchant_id`) REFERENCES `ecommerce`.`merchants` (`id`);

ALTER TABLE `ecommerce`.`merchants` ADD FOREIGN KEY (`admin_id`) REFERENCES `users` (`id`);

ALTER TABLE `users` ADD FOREIGN KEY (`country_code`) REFERENCES `countries` (`code`);