下載地址：EDB: Open-Source, Enterprise Postgres Database Management

安裝

注意：端口號默認是5432

配置dbeaver應用，創建數據庫和表

-- 創建模式（如果不存在）
CREATE SCHEMA IF NOT EXISTS bbbase;-- 創建序列（用于主鍵自增）
CREATE SEQUENCE IF NOT EXISTS bbbase.rp_config_id_seq2
START WITH 1
INCREMENT BY 1
MINVALUE 1
MAXVALUE 9223372036854775807
CACHE 1;-- 創建路由代理配置表
CREATE TABLE IF NOT EXISTS bbbase.rp_config2 (config_id bigint PRIMARY KEY DEFAULT nextval('bbbase.rp_config_id_seq2'),department_id varchar(64) NULL,request_url varchar(256) NULL,function_id varchar(64) NULL,redirect_url varchar(256) NULL,factorycode varchar(64) NULL,username varchar(64) NULL,password_hash varchar(128) NULL,password_salt varchar(64) NULL,create_by varchar(64) NULL DEFAULT NULL::varchar,create_time timestamptz DEFAULT CURRENT_TIMESTAMP,update_by varchar(64) NULL DEFAULT NULL::varchar,update_time timestamptz DEFAULT CURRENT_TIMESTAMP,remark varchar(500) NULL DEFAULT NULL::varchar,is_deleted boolean DEFAULT false
) WITH (fillfactor = 80);-- 為表添加注釋
COMMENT ON TABLE bbbase.rp_config2 IS '路由代理配置表';-- 為各個字段添加注釋
COMMENT ON COLUMN bbbase.rp_config2.config_id IS '配置ID（主鍵）';
COMMENT ON COLUMN bbbase.rp_config2.department_id IS '部門ID';
COMMENT ON COLUMN bbbase.rp_config2.request_url IS '原始請求URL';
COMMENT ON COLUMN bbbase.rp_config2.function_id IS '功能模塊ID';
COMMENT ON COLUMN bbbase.rp_config2.redirect_url IS '重定向目標URL';
COMMENT ON COLUMN bbbase.rp_config2.factorycode IS '工廠/系統編碼';
COMMENT ON COLUMN bbbase.rp_config2.username IS '認證用戶名';
COMMENT ON COLUMN bbbase.rp_config2.password_hash IS '密碼哈希值';
COMMENT ON COLUMN bbbase.rp_config2.password_salt IS '密碼加密鹽值';
COMMENT ON COLUMN bbbase.rp_config2.create_by IS '記錄創建人';
COMMENT ON COLUMN bbbase.rp_config2.create_time IS '記錄創建時間';
COMMENT ON COLUMN bbbase.rp_config2.update_by IS '記錄最后更新人';
COMMENT ON COLUMN bbbase.rp_config2.update_time IS '記錄最后更新時間';
COMMENT ON COLUMN bbbase.rp_config2.remark IS '備注信息';
COMMENT ON COLUMN bbbase.rp_config2.is_deleted IS '是否刪除（true-已刪除，false-未刪除）';-- 驗證表和注釋是否創建成功
SELECT * FROM bbbase.rp_config2 LIMIT 0;

csdn下載鏈接：https://download.csdn.net/download/ly1h1/91349558