Description Maxim Martynov 2018-07-19 08:10:09 EDT

CDO has nice feature to generate table names for db. At the different instance of DB, cdo will generate different names for binding table. Different table names complicate the writing scripts when working directly with the database. To set the table names, CDO allows you to use the annotation
org.eclipse.emf.cdo.server.internal.db.DBAnnotation.TABLE_NAME. In this case, the binding table is still generated. 
It is necessary to be able to set the name of the binding table.
In our project we use DBAnnotation which start from "REF:" and with feature name.

For example Deployment class has many Artefacts:

  <eClassifiers xsi:type="ecore:EClass" name="Deployment">
    <eAnnotations source="http://www.eclipse.org/CDO/DBStore">
      <details key="tableName" value="DEPLOY_DEPLOYMENT"/>
      <details key="ref:artefacts" value="DEPLOY_DEPLOYMENT_ARTE_FLS1968"/>
    </eAnnotations>
    <eStructuralFeatures xsi:type="ecore:EAttribute" name="id" eType="ecore:EDataType http://www.eclipse.org/emf/2002/Ecore#//EString"/>
    <eStructuralFeatures xsi:type="ecore:EReference" name="artefacts" upperBound="-1"
        eType="#//Artefact" containment="true"/>
  </eClassifiers>