Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
6 replies
Subscribers
4 subscribers
Views
1549 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Process
Hello, We are building a set of CDTs and we have the following case.
thanosm
over 9 years ago
Hello,
We are building a set of CDTs and we have the following case.
We have defined a CDT "xChild" that is a child of two different CDTs "xParent1" and "xParent2" which are all under a main CDT "xParentMain".
When we verify the Data Store in which these CDTs are placed, an SQL DDL is generated in which the table of "xChild" has one foreign key column for "xParent1" and TWO foreign key columns for "xParent2".
How does the Data Store generate the foreign key columns that show up in the database?
I ask this because in the Data Store we originally had all the above CDTs and that's how the above issue appeared.
We have even tried to only include "xParentMain" and "xParent2", which had the same result.
However, when we only had "xParentMain" in the Data Store OR "xParent1" and "xParentMain", then the generated SQL DDL did NOT have two foreign key columns for "xParent2".
We need to understand this behavior and what could cause this based on the defi...
OriginalPostID-150061
OriginalPostID-150061
Discussion posts and replies are publicly visible
Parents
0
rodgraham
Certified Lead Developer
over 9 years ago
Can you attach the xsd. Nesting beyond a single level is generally not recommended.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
rodgraham
Certified Lead Developer
over 9 years ago
Can you attach the xsd. Nesting beyond a single level is generally not recommended.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data