说明

安装全局依赖

npm install -g @dbml/[email protected]
npm install -g @softwaretechnik/[email protected]
npm install -g dbdocs

使用

初始化

dbml2db init

生成

dbml2db generate-types main.dbml .env

翻译测试

dbml2db translate .env level en2zh

dbml2db translate .env 级别

输出文件

dbml2db output main.dbml -g "D:\Graphviz\bin"

Graphviz 下载

https://graphviz.org/download/

上传

dbml2db upload main.dbml momoca

类型表

CREATE TABLE `dict_types` (
    `id` INT NOT NULL AUTO_INCREMENT,
    `parent_id` INT NULL DEFAULT NULL COMMENT '父级id',
    `key` VARCHAR(64) NULL DEFAULT NULL COMMENT '键名,用于快速查询' COLLATE 'utf8mb4_general_ci',
    `name` VARCHAR(64) NULL DEFAULT NULL COMMENT '名称,用于说明用途' COLLATE 'utf8mb4_general_ci',
    `comment` VARCHAR(64) NULL DEFAULT NULL COMMENT '备注,用于后台查看' COLLATE 'utf8mb4_general_ci',
    `setting` JSON NULL DEFAULT NULL COMMENT '其它配置',
    `sort_order` INT NULL DEFAULT '0' COMMENT '排序用于输出时显示顺序',
    `delete_time` INT NULL DEFAULT NULL COMMENT '删除时间',
    `create_time` INT NOT NULL DEFAULT '0' COMMENT '创建时间',
    `update_time` INT NOT NULL DEFAULT '0' COMMENT ' 更新时间',
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE INDEX `key` (`key`) USING BTREE,
    INDEX `dict_types_index_0` (`key`) USING BTREE,
    INDEX `dict_types_index_2` (`sort_order`) USING BTREE,
    INDEX `dict_types_index_3` (`delete_time`) USING BTREE,
    INDEX `dict_types_index_4` (`create_time`) USING BTREE,
    INDEX `dict_types_index_5` (`update_time`) USING BTREE,
    INDEX `parent_id` (`parent_id`) USING BTREE,
    CONSTRAINT `dict_types_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `dict_types` (`id`) ON UPDATE NO ACTION ON DELETE NO ACTION
)
COMMENT='类型表'
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
;