DDL语句中有外键约束不生效

Viewed 11

使用DDL生成关系图,oracle版DDL语句中有外键约束,但是物理模型读取不到,这是为什么?
输入:
CREATE TABLE NUSP.RT_CON_BAY
(
ID VARCHAR(20) NOT NULL,
NAME VARCHAR(64) NOT NULL,
SUBSTATION_ID VARCHAR(20),
VOLTAGE_TYPE NUMBER(10),
BAY_STATE NUMBER(10),
BAY_TYPE NUMBER(10),
LIGHT_VALUE_1 NUMBER(3),
LIGHT_QUAL_1 NUMBER(10),
LIGHT_VALUE_2 NUMBER(3),
LIGHT_QUAL_2 NUMBER(10),
RECORD_MODEL_MODE NUMBER(10) DEFAULT 56703,
MODELOWNER VARCHAR(16),
RESP_GROUP NUMBER(20),
RESP_VALUE NUMBER(20),
BAY_TYPE_ID NUMBER(10),
DEF_BAY_TEM_NAME VARCHAR(64),
DEF_PRESS_TEM_NAME VARCHAR(64),
REF_NAME VARCHAR(128),
UNCHANGE_PERCENT NUMBER(22, 6),
SCADA_SLICE_NO NUMBER(10) DEFAULT (-1),
DSCADA_SLICE_NO NUMBER(10) DEFAULT (-1),
CONSTRAINT PK_RT_CON_BAY PRIMARY KEY (ID),
CONSTRAINT FK_RT_CON_BAY_SUBSTATION_ID FOREIGN KEY (SUBSTATION_ID)
REFERENCES NUSP.RT_CON_COMMONSUBSTATION DEFERRABLE,
CONSTRAINT FK_RT_CON_BAY_VOLTAGE_TYPE FOREIGN KEY (VOLTAGE_TYPE)
REFERENCES NUSP.RT_DIC_VOLTAGETYPE DEFERRABLE
);

结果变成了
image.png
只有索引名称,其余内容全置空了

1 Answers

从数据库逆向解析的时候,暂不支持解析外键