Astro企业应用 AstroPro-通过导入DDL文件实现业务设计:DDL文件设计

时间：2025-02-12 15:02:26

Astro企业应用 AstroPro 导入DDL

DDL文件设计

根据业务模型，完成DDL文件设计，DDL标签使用可参考DDL标签使用指南。

示例：

CREATE TABLE `t_value_object` (    `workspace1_id` varchar(200) NOT NULL COMMENT 'relation("t_workspace1","id","AGGREGATE")',    `number` int NOT NULL COMMENT 'valueObject',    `new_name3` varchar(200) NOT NULL COMMENT 'searchable',    `new_name4` varchar(200) NOT NULL COMMENT 'searchable',    CONSTRAINT pk_t_value_object PRIMARY KEY (`workspace1_id`, `number`)) COMMENT = 'primaryKeyType("NONE")';CREATE TABLE `renameWorkspace` (    `key1` varchar(200) NOT NULL COMMENT 'alias("newName2")',    `key2` varchar(200) NOT NULL COMMENT 'alias("newName3")',    `renameField` boolean NOT NULL COMMENT 'alias("newName4")',    `new_name5` int NOT NULL,    `new_name6` bigint(40) NOT NULL,    `new_name7` decimal(40, 0) NOT NULL,    `new_name8` float(40, 0) NOT NULL,    `new_name9` double(40, 0) NOT NULL,    `new_name10` date NOT NULL,    `new_name11` timestamp NOT NULL,    CONSTRAINT pk_renameworkspace PRIMARY KEY (`key1`, `key2`)) COMMENT = 'alias("renameWeaweae");primaryKeyType("COMPOSITE")';CREATE TABLE `t_workspace6` (    `parent_id` bigint(40) NULL COMMENT 'parent_id;relation("t_workspace6","id","RECURSIVE")',    `id` bigint(40) NOT NULL,    `new_name4` varchar(200) NOT NULL,    `new_name5` varchar(200) NOT NULL,    PRIMARY KEY (`id`)) COMMENT = 'primaryKeyType("SNOWFLAKE")';