注册

索引自动创建?

申献 2025/03/28 279 5

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:
【CPU】:
【问题描述】*:
CREATE TABLE PROPERTIES (
VALUE VARCHAR2(4000),
PROPERTY_DEFINITION_ID VARCHAR2(36) NOT NULL,
ITEM_ID VARCHAR2(36) NOT NULL,
WORKING_CONDITION_ID VARCHAR2(36) NOT NULL,
UNIT_ID VARCHAR2(36)
);
CREATE INDEX PROPERTIES_ITEM_ID ON PROPERTIES (ITEM_ID);
CREATE INDEX PROPERTIES_P_D_ID ON PROPERTIES (PROPERTY_DEFINITION_ID);
CREATE INDEX PROPERTIES_VALUE ON PROPERTIES (VALUE);

ALTER TABLE PROPERTIES ADD CONSTRAINT "fk_PROPERTIES_ITEMS_1" FOREIGN KEY (ITEM_ID) REFERENCES ITEMS(ID) ON DELETE CASCADE;
ALTER TABLE PROPERTIES ADD CONSTRAINT "fk_PROPERTIES_P_D_1" FOREIGN KEY (PROPERTY_DEFINITION_ID) REFERENCES PROPERTY_DEFINITIONS(ID) ON DELETE CASCADE;
ALTER TABLE PROPERTIES ADD CONSTRAINT "fk_PROPERTIES_UNIT_ID_1" FOREIGN KEY (UNIT_ID) REFERENCES UNITS(ID);
ALTER TABLE PROPERTIES ADD CONSTRAINT "fk_PROPERTIES_W_C_1" FOREIGN KEY (WORKING_CONDITION_ID) REFERENCES WORKING_CONDITIONS(ID) ON DELETE CASCADE;
这是建表相关语句 但是创建完发现索引重复了
image.png

回答 0
暂无回答
扫一扫
联系客服