This question is locked. New answers and comments are not allowed.
In our object we are mapping an array of decimals to a join table. Here is the XML the wizard created:
<field name="_discount">
<extension key="field" value="_discounts">
<extension key="array">
<extension key="db-link-table">
<extension key="db-table-name" value="MS_RegistrationDiscounts" />
<extension key="db-owner-ref">
<extension key="db-ref" value="_id">
<extension key="db-column">
<extension key="db-column-name" value="RegistrationId" />
</extension>
</extension>
</extension>
<extension key="db-value">
<extension key="db-column">
<extension key="db-column-name" value="DiscountAmount" />
</extension>
</extension>
<extension key="db-sequence">
<extension key="db-column">
<extension key="db-column-name" value="OrderBy" />
</extension>
</extension>
</extension>
</extension>
</extension>
</field>
The problem is when we use the schema tool, the names of the tables and columns for this mapped field are not followed. Here is the output from the schema executable.
Table 'MS_Rgstrtns_dscount__discounts' : FAIL
Table 'MS_Rgstrtns_dscount__discounts' does not exist.
Constraint 'ref_MS_Rgstrtns_dscnt__dscnts_' does not exist.
Is this a bug in the schema generator since the XML is getting created or is there something else I have to do to make this work?
Thanks
<field name="_discount">
<extension key="field" value="_discounts">
<extension key="array">
<extension key="db-link-table">
<extension key="db-table-name" value="MS_RegistrationDiscounts" />
<extension key="db-owner-ref">
<extension key="db-ref" value="_id">
<extension key="db-column">
<extension key="db-column-name" value="RegistrationId" />
</extension>
</extension>
</extension>
<extension key="db-value">
<extension key="db-column">
<extension key="db-column-name" value="DiscountAmount" />
</extension>
</extension>
<extension key="db-sequence">
<extension key="db-column">
<extension key="db-column-name" value="OrderBy" />
</extension>
</extension>
</extension>
</extension>
</extension>
</field>
The problem is when we use the schema tool, the names of the tables and columns for this mapped field are not followed. Here is the output from the schema executable.
Table 'MS_Rgstrtns_dscount__discounts' : FAIL
Table 'MS_Rgstrtns_dscount__discounts' does not exist.
Constraint 'ref_MS_Rgstrtns_dscnt__dscnts_' does not exist.
Is this a bug in the schema generator since the XML is getting created or is there something else I have to do to make this work?
Thanks