#Establishing constraints via xsd Hi, We have addressCDT and emp

#Establishing constraints via xsd

Hi,
We have addressCDT and employeeCDT separately. But in the DB, we want address table to have a foreign key pointing to the employee table. We have added employeeId as a member in addressCDT (to hold the primary key from associated employee row). After publishing the CDTs in Appian, we are manually adding the foreign key constraint on this employeeId member using DDL script. But is there a way we can achieve the same in XSD itself? We want to maintain the CDTs separately only and do not want to add addressCDT into employeeCDT. Thanks!

OriginalPostID-148033

OriginalPostID-148033