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

senthilar over 10 years ago

#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!

Discussion posts and replies are publicly visible

Parents

0 senthilar over 10 years ago

We tried this, but it didn't create the foreign key constraint:
<xsd:element form="qualified" name="employeeId" type="xsd:int">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">@JoinTable(name="ADDRESS",
joinColumns=@JoinColumn(name="E_ID", referencedColumnName="EMPLOYEE_ID")
)</xsd:appinfo>
</xsd:annotation>
</xsd:element>
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 senthilar over 10 years ago

We tried this, but it didn't create the foreign key constraint:
<xsd:element form="qualified" name="employeeId" type="xsd:int">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">@JoinTable(name="ADDRESS",
joinColumns=@JoinColumn(name="E_ID", referencedColumnName="EMPLOYEE_ID")
)</xsd:appinfo>
</xsd:annotation>
</xsd:element>
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data