• State Suggested Answer
  • Replies 5 replies
  • Answers 1 answer
  • Subscribers 9 subscribers
  • Views 4097 views
  • Users 0 members are here
Related Discussions
Home » Discussions » General

Which is better- To create a new CDT or update existing one while restructuring the tables?

diptis2174
Certified Senior Developer

We have created few UI's and process models of our application. And now, we got to know that we are restructuring our table structure. 

Old tables does not have foreign key relationships. However, in new table structure there is foreign key mapping. What should I do now? Should I update my CDTs or create new ones for new table structure.

If table structure has only field name changes or type changes then it would be easy to update CDT. But now as the new tables has foreign key relationship what should be better to do?

  Discussion posts and replies are publicly visible

Parents
  • 0
    Hi diptis0001,
    you can create a CDT from a DB table or view.Once you select a data source and entity the FK mappings will be automatically verified by Appian.
    But if the columns are reshuffled among the tables, I guess this would be a better option.
    If only FK constraints are defined then updating existing CDT's would be better as there would not be any impact where CDT's are called.

    Thanks,
Reply
  • 0
    Hi diptis0001,
    you can create a CDT from a DB table or view.Once you select a data source and entity the FK mappings will be automatically verified by Appian.
    But if the columns are reshuffled among the tables, I guess this would be a better option.
    If only FK constraints are defined then updating existing CDT's would be better as there would not be any impact where CDT's are called.

    Thanks,
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.