使用pgAdmin创建ERD
基本功能介绍
打开工具
详细使用介绍
新建表
设置表关系
1M表示一对多关系
MM表示多对多关系
一对多关系的设置
生成sql
-- This script was generated by the ERD tool in pgAdmin 4.
-- Please log an issue at https://redmine.postgresql.org/projects/pgadmin4/issues/new if you find any bugs, including reproduction steps.
BEGIN;
CREATE TABLE IF NOT EXISTS public.test
(
id bigint NOT NULL,
name character varying(100),
PRIMARY KEY (id, name)
);
COMMENT ON TABLE public.test
IS '测试表';
CREATE TABLE IF NOT EXISTS public.t2
(
id bigint NOT NULL,
fid bigint,
PRIMARY KEY (id)
);
COMMENT ON TABLE public.t2
IS '测试表2';
ALTER TABLE IF EXISTS public.t2
ADD FOREIGN KEY (fid)
REFERENCES public.test (id) MATCH SIMPLE
ON UPDATE NO ACTION
ON DELETE NO ACTION
NOT VALID;
END;
抽取指定的数据库的ERD