One-to-One Nested CDT Data Store Verification

Certified Lead Developer

I am currently having issues while working with a one-to-one nested cdt design (without reference data).  I have simplified this problem by creating the following 2 tables:

CREATE TABLE TEST_PARENT(
parentId INT PRIMARY KEY AUTO_INCREMENT,
parentName VARCHAR(50)
);

CREATE TABLE TEST_CHILD(
childId INT PRIMARY KEY AUTO_INCREMENT,
parentId INT,
childName VARCHAR(50)
);

ALTER TABLE TEST_CHILD ADD CONSTRAINT FOREIGN KEY(parentId) references TEST_PARENT(parentId);

While trying to publish the nested CDT TEST_PARENT with the following configurations:

I am receiving the following error:

The repeated column error does not make sense to me as the columnName defined in the second screenshot is the foreign key column on the child table which is pointing to the parent.  I am struggling to get this to map properly and get around this error and would appreciate any assistance.

  Discussion posts and replies are publicly visible