i18nProperty:comment;

 }

       {

         "name": "objectOperation",

         "comments": [

         ]

       },

       {

       {

         "name": "objectOperation",

         "comments": [

         ]

       },

       {

       {

         "name": "objectOperation",

         "comments": [

         ]

       },

       {

       {

         "name": "objectOperation",

         "comments": [

         ]

       },

       {

   </field>

   <field name="objectOperation">

     <!-- check if referential objectOperation is disabled (only if validation is strong) -->

     <field-validator type="checkDisabledReferentialOnErrorScope">

       <message/>

   </field>

   <field name="objectOperation">

     <!-- check if referential objectOperation is disabled (only if validation is strong) -->

     <field-validator type="checkDisabledReferentialOnErrorScope">

       <message/>

   </field>

   <field name="objectOperation">

     <!-- check if referential objectOperation is disabled (only if validation is strong) -->

     <field-validator type="checkDisabledReferentialOnErrorScope">

       <message/>

   </field>

   <field name="objectOperation">

     <!-- check if referential objectOperation is disabled (only if validation is strong) -->

     <field-validator type="checkDisabledReferentialOnErrorScope">

       <message/>

 import fr.ird.observe.entities.data.ps.landing.Landing;

 import fr.ird.observe.entities.data.ps.logbook.Activity;

 import fr.ird.observe.entities.data.ps.logbook.Route;

 import fr.ird.observe.entities.referential.common.Ocean;

 import fr.ird.observe.entities.referential.common.Species;

 import fr.ird.observe.entities.referential.common.SpeciesList;

         }

         AcquisitionStatus acquisitionStatus = AcquisitionStatus.loadEntity(context, ProtectedIdsPs.PS_COMMON_DEFAULT_ACQUISITION_STATUS_ID);

         AcquisitionStatus acquisitionStatusDone = AcquisitionStatus.loadEntity(context, ProtectedIdsPs.PS_COMMON_DONE_ACQUISITION_STATUS_ID);

             //FIXME Should we add some default values?

             preCreated.setObservationsAcquisitionStatus(acquisitionStatusDone);

         }

             preCreated.setLogbookAcquisitionStatus(acquisitionStatus);

         }

         preCreated.setTargetWellsSamplingAcquisitionStatus(acquisitionStatus);

         preCreated.setLandingAcquisitionStatus(acquisitionStatus);

         preCreated.setLocalMarketWellsSamplingAcquisitionStatus(acquisitionStatus);

         preCreated.setLocalMarketSurveySamplingAcquisitionStatus(acquisitionStatus);

         preCreated.setAdvancedSamplingAcquisitionStatus(acquisitionStatus);

         preCreated.setActivitiesAcquisitionMode(ActivitiesAcquisitionMode.BY_TIME);

         return super.preCreate(context, preCreated);

     }

       ]

     },

     "fr.ird.observe.entities.referential.ps.common.ObjectOperation": {

         "fr.ird.observe.entities.data.ps.observation.FloatingObject~objectOperation",

         "fr.ird.observe.entities.data.ps.logbook.FloatingObject~objectOperation"

       ]

         <property name="comment" access="field" type="java.lang.String" length="8192">

             <column length="8192" name="comment"/>

         </property>

         <property name="supportVesselName" access="field" type="java.lang.String" length="32">

             <column length="32" name="supportVesselName"/>

         </property>

             <key column="floatingObject" foreign-key="fk_ps_observation_floatingobject_objectobservedspecies" not-null="true" />

             <one-to-many class="fr.ird.observe.entities.data.ps.observation.ObjectObservedSpeciesImpl"/>

         </set>

         <property name="supportVesselName" access="field" type="java.lang.String" length="32">

             <column length="32" name="supportVesselName"/>

         </property>

     public DataSourceMigrationForVersion_9_3() {

         super(Version.valueOf("9.3"), false);

     }

     @Override

             executor.addScript("02", "issue-2857");

             // See https://gitlab.com/ultreiaio/ird-observe/-/issues/2869

             executor.addScript("03", "issue-2869");

         }

     }

 create table ps_logbook.activity (topiaId varchar(255) not null, topiaVersion bigint not null, topiaCreateDate timestamp not null, lastUpdateDate timestamp default CURRENT_TIMESTAMP not null, homeId varchar(255), comment varchar(8192), time time, latitude numeric, longitude numeric, latitudeOriginal numeric, longitudeOriginal numeric, originalDataModified boolean default false not null, vmsDivergent boolean default false not null, positionCorrected boolean default false not null, number integer not null, setCount integer, seaSurfaceTemperature numeric, windDirection integer, vesselActivity varchar(255) not null, wind varchar(255), totalWeight numeric, currentSpeed numeric, currentDirection integer, schoolType varchar(255), relatedObservedActivity varchar(255), currentFpaZone varchar(255), previousFpaZone varchar(255), nextFpaZone varchar(255), dataQuality varchar(255), informationSource varchar(255), reasonForNoFishing varchar(255), setSuccessStatus varchar(255), reasonForNullSet varchar(255), route varchar(255) not null, primary key (topiaId));

 create table ps_logbook.activity_observedSystem (activity varchar(255) not null, observedSystem varchar(255) not null, primary key (activity, observedSystem));

 create table ps_logbook.catch (topiaId varchar(255) not null, topiaVersion bigint not null, topiaCreateDate timestamp not null, lastUpdateDate timestamp default CURRENT_TIMESTAMP not null, homeId varchar(255), comment varchar(8192), species varchar(255) not null, weightCategory varchar(255), speciesFate varchar(255) not null, weight numeric, count integer, weightMeasureMethod varchar(255), well varchar(255), activity varchar(255) not null, activity_idx integer, primary key (topiaId));

 create table ps_logbook.floatingObjectPart (topiaId varchar(255) not null, topiaVersion bigint not null, topiaCreateDate timestamp not null, lastUpdateDate timestamp default CURRENT_TIMESTAMP not null, homeId varchar(255), whenArriving varchar(255), whenLeaving varchar(255), objectMaterial varchar(255) not null, floatingObject varchar(255) not null, primary key (topiaId));

 create table ps_logbook.informationSource (topiaId varchar(255) not null, topiaVersion bigint not null, topiaCreateDate timestamp not null, lastUpdateDate timestamp default CURRENT_TIMESTAMP not null, code varchar(255) not null, uri varchar(255), homeId varchar(255), needComment boolean default false not null, status integer not null, label1 varchar(255) not null, label2 varchar(255) not null, label3 varchar(255) not null, label4 varchar(255), label5 varchar(255), label6 varchar(255), label7 varchar(255), label8 varchar(255), primary key (topiaId));

 create table ps_logbook.route (topiaId varchar(255) not null, topiaVersion bigint not null, topiaCreateDate timestamp not null, lastUpdateDate timestamp default CURRENT_TIMESTAMP not null, homeId varchar(255), comment varchar(8192), date date not null, timeAtSea integer, fishingTime integer, trip varchar(255) not null, primary key (topiaId));

 create table ps_observation.activity_observedSystem (activity varchar(255) not null, observedSystem varchar(255) not null, primary key (activity, observedSystem));

 create table ps_observation.catch (topiaId varchar(255) not null, topiaVersion bigint not null, topiaCreateDate timestamp not null, lastUpdateDate timestamp default CURRENT_TIMESTAMP not null, homeId varchar(255), comment varchar(8192), catchWeight numeric, catchWeightComputedSource integer, minWeight numeric, meanWeight numeric, maxWeight numeric, meanWeightComputedSource integer, meanLength numeric, meanLengthComputedSource integer, totalCount integer, totalCountComputedSource integer, well varchar(255), reasonForDiscard varchar(255), informationSource varchar(255) not null, species varchar(255) not null, weightMeasureMethod varchar(255), sizeMeasureMethod varchar(255), speciesFate varchar(255) not null, set varchar(255) not null, set_idx integer, primary key (topiaId));

 create table ps_observation.detectionMode (topiaId varchar(255) not null, topiaVersion bigint not null, topiaCreateDate timestamp not null, lastUpdateDate timestamp default CURRENT_TIMESTAMP not null, code varchar(255) not null, uri varchar(255), homeId varchar(255), needComment boolean default false not null, status integer not null, label1 varchar(255) not null, label2 varchar(255) not null, label3 varchar(255) not null, label4 varchar(255), label5 varchar(255), label6 varchar(255), label7 varchar(255), label8 varchar(255), primary key (topiaId));

 create table ps_observation.floatingObjectPart (topiaId varchar(255) not null, topiaVersion bigint not null, topiaCreateDate timestamp not null, lastUpdateDate timestamp default CURRENT_TIMESTAMP not null, homeId varchar(255), whenArriving varchar(255), whenLeaving varchar(255), objectMaterial varchar(255) not null, floatingObject varchar(255) not null, primary key (topiaId));

 create table ps_observation.informationSource (topiaId varchar(255) not null, topiaVersion bigint not null, topiaCreateDate timestamp not null, lastUpdateDate timestamp default CURRENT_TIMESTAMP not null, code varchar(255) not null, uri varchar(255), homeId varchar(255), needComment boolean default false not null, status integer not null, label1 varchar(255) not null, label2 varchar(255) not null, label3 varchar(255) not null, label4 varchar(255), label5 varchar(255), label6 varchar(255), label7 varchar(255), label8 varchar(255), primary key (topiaId));

 create table ps_observation.nonTargetCatchRelease (topiaId varchar(255) not null, topiaVersion bigint not null, topiaCreateDate timestamp not null, lastUpdateDate timestamp default CURRENT_TIMESTAMP not null, homeId varchar(255), comment varchar(8192), length numeric, count integer not null, brailNumber integer, acquisitionMode integer, species varchar(255) not null, status varchar(255) not null, sex varchar(255) not null, speciesGroupReleaseMode varchar(255) not null, conformity varchar(255), handlingPlace varchar(255), releasingTime varchar(255), sizeMeasureMethod varchar(255), set varchar(255) not null, set_idx integer, primary key (topiaId));

 create table ps_logbook.activity (topiaId varchar(255) not null, topiaVersion bigint not null, topiaCreateDate timestamp not null, lastUpdateDate timestamp default CURRENT_TIMESTAMP not null, homeId varchar(255), comment varchar(8192), time time, latitude numeric, longitude numeric, latitudeOriginal numeric, longitudeOriginal numeric, originalDataModified boolean default false not null, vmsDivergent boolean default false not null, positionCorrected boolean default false not null, number integer not null, setCount integer, seaSurfaceTemperature numeric, windDirection integer, vesselActivity varchar(255) not null, wind varchar(255), totalWeight numeric, currentSpeed numeric, currentDirection integer, schoolType varchar(255), relatedObservedActivity varchar(255), currentFpaZone varchar(255), previousFpaZone varchar(255), nextFpaZone varchar(255), dataQuality varchar(255), informationSource varchar(255), reasonForNoFishing varchar(255), setSuccessStatus varchar(255), reasonForNullSet varchar(255), route varchar(255) not null, primary key (topiaId));

 create table ps_logbook.activity_observedSystem (activity varchar(255) not null, observedSystem varchar(255) not null, primary key (activity, observedSystem));

 create table ps_logbook.catch (topiaId varchar(255) not null, topiaVersion bigint not null, topiaCreateDate timestamp not null, lastUpdateDate timestamp default CURRENT_TIMESTAMP not null, homeId varchar(255), comment varchar(8192), species varchar(255) not null, weightCategory varchar(255), speciesFate varchar(255) not null, weight numeric, count integer, weightMeasureMethod varchar(255), well varchar(255), activity varchar(255) not null, activity_idx integer, primary key (topiaId));

 create table ps_logbook.floatingObjectPart (topiaId varchar(255) not null, topiaVersion bigint not null, topiaCreateDate timestamp not null, lastUpdateDate timestamp default CURRENT_TIMESTAMP not null, homeId varchar(255), whenArriving varchar(255), whenLeaving varchar(255), objectMaterial varchar(255) not null, floatingObject varchar(255) not null, primary key (topiaId));

 create table ps_logbook.informationSource (topiaId varchar(255) not null, topiaVersion bigint not null, topiaCreateDate timestamp not null, lastUpdateDate timestamp default CURRENT_TIMESTAMP not null, code varchar(255) not null, uri varchar(255), homeId varchar(255), needComment boolean default false not null, status integer not null, label1 varchar(255) not null, label2 varchar(255) not null, label3 varchar(255) not null, label4 varchar(255), label5 varchar(255), label6 varchar(255), label7 varchar(255), label8 varchar(255), primary key (topiaId));

 create table ps_logbook.route (topiaId varchar(255) not null, topiaVersion bigint not null, topiaCreateDate timestamp not null, lastUpdateDate timestamp default CURRENT_TIMESTAMP not null, homeId varchar(255), comment varchar(8192), date date not null, timeAtSea integer, fishingTime integer, trip varchar(255) not null, primary key (topiaId));

 create table ps_observation.activity_observedSystem (activity varchar(255) not null, observedSystem varchar(255) not null, primary key (activity, observedSystem));

 create table ps_observation.catch (topiaId varchar(255) not null, topiaVersion bigint not null, topiaCreateDate timestamp not null, lastUpdateDate timestamp default CURRENT_TIMESTAMP not null, homeId varchar(255), comment varchar(8192), catchWeight numeric, catchWeightComputedSource integer, minWeight numeric, meanWeight numeric, maxWeight numeric, meanWeightComputedSource integer, meanLength numeric, meanLengthComputedSource integer, totalCount integer, totalCountComputedSource integer, well varchar(255), reasonForDiscard varchar(255), informationSource varchar(255) not null, species varchar(255) not null, weightMeasureMethod varchar(255), sizeMeasureMethod varchar(255), speciesFate varchar(255) not null, set varchar(255) not null, set_idx integer, primary key (topiaId));

 create table ps_observation.detectionMode (topiaId varchar(255) not null, topiaVersion bigint not null, topiaCreateDate timestamp not null, lastUpdateDate timestamp default CURRENT_TIMESTAMP not null, code varchar(255) not null, uri varchar(255), homeId varchar(255), needComment boolean default false not null, status integer not null, label1 varchar(255) not null, label2 varchar(255) not null, label3 varchar(255) not null, label4 varchar(255), label5 varchar(255), label6 varchar(255), label7 varchar(255), label8 varchar(255), primary key (topiaId));

 create table ps_observation.floatingObjectPart (topiaId varchar(255) not null, topiaVersion bigint not null, topiaCreateDate timestamp not null, lastUpdateDate timestamp default CURRENT_TIMESTAMP not null, homeId varchar(255), whenArriving varchar(255), whenLeaving varchar(255), objectMaterial varchar(255) not null, floatingObject varchar(255) not null, primary key (topiaId));

 create table ps_observation.informationSource (topiaId varchar(255) not null, topiaVersion bigint not null, topiaCreateDate timestamp not null, lastUpdateDate timestamp default CURRENT_TIMESTAMP not null, code varchar(255) not null, uri varchar(255), homeId varchar(255), needComment boolean default false not null, status integer not null, label1 varchar(255) not null, label2 varchar(255) not null, label3 varchar(255) not null, label4 varchar(255), label5 varchar(255), label6 varchar(255), label7 varchar(255), label8 varchar(255), primary key (topiaId));

 create table ps_observation.nonTargetCatchRelease (topiaId varchar(255) not null, topiaVersion bigint not null, topiaCreateDate timestamp not null, lastUpdateDate timestamp default CURRENT_TIMESTAMP not null, homeId varchar(255), comment varchar(8192), length numeric, count integer not null, brailNumber integer, acquisitionMode integer, species varchar(255) not null, status varchar(255) not null, sex varchar(255) not null, speciesGroupReleaseMode varchar(255) not null, conformity varchar(255), handlingPlace varchar(255), releasingTime varchar(255), sizeMeasureMethod varchar(255), set varchar(255) not null, set_idx integer, primary key (topiaId));

   },

   "objectOperation": {

     "errors": [

     ],

     "warnings": [

       "check if referential objectOperation is disabled (only if validation is not strong)"

   },

   "objectOperation": {

     "errors": [

     ],

     "warnings": [

       "check if referential objectOperation is disabled (only if validation is not strong)"

   },

   "objectOperation": {

     "errors": [

     ],

     "warnings": [

       "check if referential objectOperation is disabled (only if validation is not strong)"

   },

   "objectOperation": {

     "errors": [

     ],

     "warnings": [

       "check if referential objectOperation is disabled (only if validation is not strong)"

 data.ps.logbook.Activity.attribute.vesselActivity=true

 data.ps.logbook.Catch.attribute.species=true

 data.ps.logbook.Catch.attribute.speciesFate=true

 data.ps.logbook.FloatingObjectPart.attribute.objectMaterial=true

 data.ps.logbook.Route.attribute.date=true

 data.ps.logbook.Sample.attribute.number=true

 data.ps.observation.Catch.attribute.informationSource=true

 data.ps.observation.Catch.attribute.species=true

 data.ps.observation.Catch.attribute.speciesFate=true

 data.ps.observation.FloatingObjectPart.attribute.objectMaterial=true

 data.ps.observation.NonTargetCatchRelease.attribute.count=true

 data.ps.observation.NonTargetCatchRelease.attribute.sex=true

 data.ps.logbook.Activity.attribute.vmsDivergent=true

 data.ps.logbook.Catch.attribute.species=true

 data.ps.logbook.Catch.attribute.speciesFate=true

 data.ps.logbook.FloatingObjectPart.attribute.objectMaterial=true

 data.ps.logbook.Route.attribute.date=true

 data.ps.logbook.Sample.attribute.number=true

 data.ps.observation.Catch.attribute.informationSource=true

 data.ps.observation.Catch.attribute.species=true

 data.ps.observation.Catch.attribute.speciesFate=true

 data.ps.observation.FloatingObjectPart.attribute.objectMaterial=true

 data.ps.observation.NonTargetCatchRelease.attribute.count=true

 data.ps.observation.NonTargetCatchRelease.attribute.sex=true

   </field>

   <field name="objectOperation">

     <!-- check if referential objectOperation is disabled (only if validation is strong) -->

     <field-validator type="checkDisabledReferentialOnErrorScope">

       <message/>

   },

   "objectOperation": {

     "errors": [

     ],

     "warnings": [

       "check if referential objectOperation is disabled (only if validation is not strong)"

   </field>

   <field name="objectOperation">

     <!-- check if referential objectOperation is disabled (only if validation is strong) -->

     <field-validator type="checkDisabledReferentialOnErrorScope">

       <message/>

   },

   "objectOperation": {

     "errors": [

     ],

     "warnings": [

       "check if referential objectOperation is disabled (only if validation is not strong)"

   </field>

   <field name="objectOperation">

     <!-- check if referential objectOperation is disabled (only if validation is strong) -->

     <field-validator type="checkDisabledReferentialOnErrorScope">

       <message/>

   },

   "objectOperation": {

     "errors": [

     ],

     "warnings": [

       "check if referential objectOperation is disabled (only if validation is not strong)"

   </field>

   <field name="objectOperation">

     <!-- check if referential objectOperation is disabled (only if validation is strong) -->

     <field-validator type="checkDisabledReferentialOnErrorScope">

       <message/>

   },

   "objectOperation": {

     "errors": [

     ],

     "warnings": [

       "check if referential objectOperation is disabled (only if validation is not strong)"