1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
6 <class>Translation
</class>
7 <name>civicrm_translation
</name>
8 <title>Translated String
</title>
9 <titlePlural>Translated Strings
</titlePlural>
10 <comment>Each string record is an alternate translation of some displayable string in the database.
</comment>
16 <title>Translated String ID
</title>
17 <type>int unsigned
</type>
18 <required>true
</required>
19 <comment>Unique String ID
</comment>
23 <autoincrement>true
</autoincrement>
28 <name>entity_table
</name>
29 <title>Translated Entity
</title>
32 <required>true
</required>
34 <callback>CRM_Core_BAO_Translation::getEntityTables
</callback>
36 <comment>Table where referenced item is stored
</comment>
41 <name>entity_field
</name>
42 <title>Translated Field
</title>
45 <required>true
</required>
47 <callback>CRM_Core_BAO_Translation::getEntityFields
</callback>
49 <comment>Field where referenced item is stored
</comment>
54 <name>entity_id
</name>
55 <title>Translated Entity ID
</title>
58 <required>true
</required>
59 <comment>ID of the relevant entity.
</comment>
65 <title>Language
</title>
68 <required>true
</required>
69 <comment>Relevant language
</comment>
74 <optionGroupName>languages
</optionGroupName>
75 <keyColumn>name
</keyColumn>
76 <optionEditPath>civicrm/admin/options/languages
</optionEditPath>
82 <name>status_id
</name>
87 <required>true
</required>
89 <callback>CRM_Core_BAO_Translation::getStatuses
</callback>
91 <comment>Specify whether the string is active, draft, etc
</comment>
96 <title>Translated String
</title>
99 <required>true
</required>
100 <comment>Translated string
</comment>
105 <idColumn>entity_id
</idColumn>
106 <typeColumn>entity_table
</typeColumn>
111 <!-- Expected queries:
112 "Admin UI: I'm editing a record. Show me all relevant translations."
113 "Public UI: I'm browsing a list of records. Show this page-worth of records in my preferred language."
115 <name>index_entity_lang
</name>
116 <!-- Prediction: In a large DB with many events/contribution-pages/groups/mailings/etc, entity ID will have best selectivity. -->
117 <!-- Prediction: Over diverse set of deployments, the selectivity of 'table' and 'language' will be similar. -->
118 <fieldName>entity_id
</fieldName>
119 <fieldName>entity_table
</fieldName>
120 <fieldName>language
</fieldName>