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

时间:2024-11-13 15:18:50

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")';
support.huaweicloud.com/usermanual-astropro/astropro_05_0142.html