Fri, 17 Apr 2015 03:22:35 GMT
I got a exception said not referenced table for foreign key 'ROD' while generate repository. I checked the table and figure out the 'ROD' key was a self-referenced key. my question is it's my bad or this tool not support self-reference key?
DEPTNO CHARACTER(3) NOT NULL,
DEPTNAME VARCHAR(36) NOT NULL,
ADMRDEPT CHARACTER(3) NOT NULL,
CONSTRAINT PK_DEPARTMENT PRIMARY KEY (DEPTNO),
CONSTRAINT RDE FOREIGN KEY (MGRNO) REFERENCES EMPLOYEE (EMPNO) ON
CONSTRAINT ROD FOREIGN KEY (ADMRDEPT) REFERENCES DEPARTMENT (DEPTNO)