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
7 replies
Subscribers
8 subscribers
Views
6361 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
CDT Mapping Primary Key and Foreign Key
Ravi Roshan
over 7 years ago
I have a main table say ABC which has ID column as primary and identity. I have another table DEF where I have another column say CASE_ID which is both primary and foreign key but not the identity. In the second table DEF I have provide the reference as ABC.ID.
I have mapped the second table CDT DEF in CDT ABC, however while verifying the Data Store, I am getting the error "The data source schema does not match the type mappings: Missing column: CASE_ID in dbo.ABC (APNX-2-4056-000)"
My Requirement is to map the second table as @OneToOne Relationship with first table. Please find some screenshots for reference in attachment.
Please provide any solution for this. Thanks
OriginalPostID-261496
Discussion posts and replies are publicly visible
Parents
0
Ravi Roshan
over 7 years ago
Same configuration is working fine when I use oneToMany configuration, however it is failing for OneToOne.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Ravi Roshan
over 7 years ago
Same configuration is working fine when I use oneToMany configuration, however it is failing for OneToOne.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data