How to resolve Database naming convention issues ?

Question

Hi Community, 
 I am using Microsoft SQL Server for my Application Application. In my CDT (Say Employee) I have an array field (Say Skills) to store checkbox values but the problem is that when i go to data store to verify it and publish. It asks for Employee_Skills table. if i define it as EmployeeSkills then it throws an error saying table not found. Also by default it generates weird column names in the new table. How can i control naming convention of my foreign key table and choose friendly column name ? 
 I checked everywhere in CDT's XSD file also but i couldn't find any way to change table/column name.

Carlos Santander · Answer

Take a look at the supported JPA annotations (link below.) In particular, you'll want to look at @Table and @Column. 
 
 docs.appian.com/.../Supported_XSD_Elements_and_JPA_Annotations.html

Mike Schmitt · Answer

I'm not really an expert at creating DB tables straight from XSD... but by looking at your XSD and the "tables" you're being asked for when you try to publish, its because you haven't pointed NodesAffected or ToolsAffected at any DB table column. You need to use the XSD syntax already pointed out by i'm guessing.