ATG Multilingual Repository design

Here is the example of the multilingual image settings for category.

<item-descriptor name="category">
<table name="pjt_category_images" type="primary" id-column-name="image_id">
<!-- IMAGE TRANSLATION PROPETIES BEGINS -->
<property column-name="promotional_image"
display-name-resource="promotionalImage" data-type="string"
name="promotionalImageDefault">
<attribute name="resourceBundle"
value="atg.projects.store.InternationalStoreCatalogTemplateResources" />
<attribute name="propertySortPriority" value="-11" />
</property>
<property name="promotionalHeroImageDefault" column-name="promotional_hero_image"
data-type="string" readable="true" writable="true" queryable="true"
hidden="false" expert="false" cache-mode="inherit">
<attribute name="resourceBundle"
value="atg.projects.store.InternationalStoreCatalogTemplateResources" />
<attribute name="propertySortPriority" value="-11" />
</property>
<property name="smallImageDefault" column-name="small_image"
data-type="string" readable="true" writable="true" queryable="true"
hidden="false" expert="false" cache-mode="inherit">
<attribute name="resourceBundle"
value="atg.projects.store.InternationalStoreCatalogTemplateResources" />
<attribute name="propertySortPriority" value="-11" />
</property>
<!-- IMAGE TRANSLATION PROPETIES ENDS -->
</table>

<!-- IMAGE TRANSLATION PROPETIES EXPRESSION BEGINS -->
<property display-name-resource="promotionalImage" data-type="string"
hidden="true" writable="false" name="promotionalImage" queryable="true">
<derivation user-method="atg.repository.dp.LanguageTranslation">
<expression>promotionalImageDefault</expression>
</derivation>
<attribute name="defaultProperty" value="promotionalImageDefault" />
<attribute name="defaultLocale" value="" />
</property>
<property display-name-resource="promotionalHeroImage"
data-type="string" hidden="true" writable="false" name="promotionalHeroImage"
queryable="true">
<derivation user-method="atg.repository.dp.LanguageTranslation">
<expression>promotionalHeroImageDefault</expression>
</derivation>
<attribute name="defaultProperty" value="promotionalHeroImageDefault" />
<attribute name="defaultLocale" value="" />
</property>
<property display-name-resource="smallImage" data-type="string"
hidden="true" writable="false" name="smallImage" queryable="true">
<derivation user-method="atg.repository.dp.LanguageTranslation">
<expression>smallImageDefault</expression>
</derivation>
<attribute name="defaultProperty" value="smallImageDefault" />
<attribute name="defaultLocale" value="" />
</property>
<!-- IMAGE TRANSLATION PROPETIES EXPRESSION ENDS -->

<table name="pjt_category_images_xlate" id-column-names="image_id"
multi-column-name="locale" type="multi">
<property category-resource="categoryAppearance"
component-item-type="pjtCategoryImageTranslation" column-name="translation_id"
display-name="Translations" display-name-resource="translations"
data-type="map" name="translations">
<attribute name="resourceBundle"
value="atg.projects.store.InternationalStoreCatalogTemplateResources" />
<attribute name="propertySortPriority" value="-12" />
</property>
</table>
</item-descriptor>

<item-descriptor name="pjtCategoryImageTranslation">
<table name="pjt_image_xlate" id-column-name="id" type="primary">
<property name="promotionalImage" column-name="promotional_image"
data-type="string" readable="true" writable="true" queryable="true"
hidden="false" expert="false" cache-mode="inherit" />
<property name="promotionalHeroImage" column-name="promotional_hero_image"
data-type="string" readable="true" writable="true" queryable="true"
hidden="false" expert="false" cache-mode="inherit" />
<property name="smallImage" column-name="small_image"
data-type="string" readable="true" writable="true" queryable="true"
hidden="false" expert="false" cache-mode="inherit" />
</table>
</item-descriptor>