observe.Common.reportsUrl

 observe.Common.root.list.message.none

 observe.Common.sampleQuality

 observe.Common.sampleSpeciesMeasure

 observe.Common.sampleType

 observe.Common.saveFile.overwrite

 # #L%

 ###

 #Generated by org.nuiton.i18n.plugin.GenerateI18nLabelsMojo

 observe.Business.createDate=observe.Common.createDate

 observe.Business.homeId=observe.Common.homeId

 observe.Business.id=observe.Common.id

 observe.data.ll.observation.Catch.predator=observe.Common.predator

 observe.data.ll.observation.Catch.predator.available=observe.Common.predator.available

 observe.data.ll.observation.Catch.predator.selected=observe.Common.predator.selected

 observe.data.ll.observation.Catch.section=observe.Common.section

 observe.data.ll.observation.Catch.section.short=observe.Common.section.short

 observe.data.ll.observation.Catch.sex=observe.Common.sex

                 "objectOperation", "observationsComment", "observationsDataEntryOperator", "observationsDataQuality", "observedSystem",

                 "observedSystem.available", "observedSystem.selected", "observedSystemDistance",

                 "observer", "ocean", "ocean.available", "ocean.selected",

                 "program", "proportion", "proportion.short", "proportionSum", "psSampler.available", "psSampler.selected", "quadrant", "quadrantOriginal", "reasonForNoFishing", "reasonForNullSet", "relatedObservedActivity", "reportsUrl", "root.list.message.none", "sampleQuality", "sampleSpeciesMeasure", "sampleType", "saveFile.overwrite",

                 "saveFile.overwrite.cancel", "saveFile.overwrite.ok", "saveFile.overwrite.title", "schoolType", "seaSurfaceTemperature", "second.buoy", "section", "section.short",

                 "sensorBrand", "sensorBrand.short", "sensorDataFormat", "sensorDataFormat.short", "sensorSerialNo", "sensorSerialNo.short", "sensorType", "sensorType.short", "serialNo", "serialNo.short", "settingEndLatitude", "settingEndLongitude", "settingEndQuadrant",

       "predator": [

         "check if referential predator is disabled (only if validation is strong)"

       ],

       "sex": [

         "check if referential sex is disabled (only if validation is strong)"

       ],

       "predator": [

         "check if referential predator is disabled (only if validation is strong)"

       ],

       "sex": [

         "check if referential sex is disabled (only if validation is strong)"

       ],

       "predator": [

         "check if referential predator is disabled (only if validation is strong)"

       ],

       "sex": [

         "check if referential sex is disabled (only if validation is strong)"

       ],

       "predator": [

         "check if referential predator is disabled (only if validation is strong)"

       ],

       "sex": [

         "check if referential sex is disabled (only if validation is strong)"

       ],

 observe.Common.relatedObservedActivity

 observe.Common.reportsUrl

 observe.Common.sampleQuality

 observe.Common.sampleSpeciesMeasure

 observe.Common.sampleType

 observe.Common.schoolType

       "comment": "check if referential predator is disabled (only if validation is strong)"

     }

   ],

   "sex": [

     {

       "validator": "fr.ird.observe.validation.validator.referential.CheckReferentialIsEnabledOnErrorScope",

     </field-validator>

   </field>

   <field name="sex">

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

     <field-validator type="checkDisabledReferentialOnErrorScope">

       "comment": "check if referential predator is disabled (only if validation is strong)"

     }

   ],

   "sex": [

     {

       "validator": "fr.ird.observe.validation.validator.referential.CheckReferentialIsEnabledOnErrorScope",

     </field-validator>

   </field>

   <field name="sex">

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

     <field-validator type="checkDisabledReferentialOnErrorScope">

       {

         "gav": "ll_observation.catch",

         "from": "INNER JOIN ll_observation.set set ON set.topiaId = catch.set INNER JOIN ll_observation.activity activity ON activity.topiaId = set.activity WHERE activity.trip %s",

         "extra-referentialShell": {

           "fr.ird.observe.entities.referential.ll.observation.StomachFullness": "stomachFullness",

           "fr.ird.observe.entities.referential.common.Species": "species",

     "fr.ird.observe.entities.data.ll.observation.Catch": {

       "table": {

         "gav": "fr.ird.observe.entities.data.ll.observation.Catch~ll_observation~catch",

         "selectors": [

           "ll_observation.catch catch~INNER JOIN ll_observation.set set ON set.topiaId = catch.set INNER JOIN ll_observation.activity activity ON activity.topiaId = set.activity~activity.trip"

         ],

           "lastUpdateDate": "java.sql.Timestamp",

           "number": "java.lang.Integer",

           "photoReferences": "java.lang.String",

           "tagNumber": "java.lang.String",

           "totalWeight": "java.lang.Float"

         },

         "gav": "ll_observation.catch",

         "from": "INNER JOIN ll_observation.set set ON set.topiaId = catch.set WHERE set.activity %s",

         "parentColumnName": "set",

         "columnsToReplace": "section,basket,branchline"

       },

       {

         "gav": "ll_observation.catch",

         "from": "WHERE catch.topiaId %s",

         "parentColumnName": "set",

         "columnsToDetach": "section~ll_observation.section,basket~ll_observation.basket,branchline~ll_observation.branchline",

         "entryPoint": true

       },

         "gav": "ll_observation.catch",

         "from": "WHERE catch.set %s",

         "parentColumnName": "set",

         "columnsToReplace": "section,basket,branchline"

       },

       {

             <column name="gonadeWeight" precision="6" scale="3" sql-type="numeric"/>

         </property>

         <property name="photoReferences" access="field" type="java.lang.String" column="photoReferences"/>

         <property name="number" access="field" type="java.lang.Integer" column="number"/>

         <property name="acquisitionMode" access="field" type="int" column="acquisitionMode"/>

         <property name="tagNumber" access="field" type="java.lang.String" column="tagNumber"/>

             issue2914(executor);

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

             executor.addScript("01", "issue-2931");

         }

     }

 create table ll_observation.basket (topiaId varchar(255) not null, topiaVersion bigint not null, topiaCreateDate timestamp not null, lastUpdateDate timestamp default CURRENT_TIMESTAMP not null, homeId varchar(255), settingIdentifier integer not null, haulingIdentifier integer, floatline1Length numeric, floatline2Length numeric, section varchar(255) not null, primary key (topiaId));

 create table ll_observation.branchline (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), settingIdentifier integer not null, haulingIdentifier integer, depthRecorder boolean default false not null, timer boolean default false not null, timeSinceContact integer, hookOffset integer, branchlineLength numeric, weightedSwivel boolean default false not null, timerTimeOnBoard timestamp, weightedSnap boolean default false not null, swivelWeight numeric, snapWeight numeric, tracelineLength numeric, hookLost boolean default false not null, traceCutOff boolean default false not null, hookType varchar(255), baitType varchar(255), topType varchar(255), tracelineType varchar(255), baitSettingStatus varchar(255), baitHaulingStatus varchar(255), hookSize varchar(255), basket varchar(255) not null, primary key (topiaId));

 create table ll_observation.branchlinesComposition (topiaId varchar(255) not null, topiaVersion bigint not null, topiaCreateDate timestamp not null, lastUpdateDate timestamp default CURRENT_TIMESTAMP not null, homeId varchar(255), length numeric not null, proportion integer not null, tracelineLength numeric, topType varchar(255) not null, tracelineType varchar(255) not null, set varchar(255) not null, primary key (topiaId));

 create table ll_observation.catch_predator (catch varchar(255) not null, species varchar(255) not null, primary key (catch, species));

 create table ll_observation.encounter (topiaId varchar(255) not null, topiaVersion bigint not null, topiaCreateDate timestamp not null, lastUpdateDate timestamp default CURRENT_TIMESTAMP not null, homeId varchar(255), distance numeric, count integer, encounterType varchar(255) not null, species varchar(255), activity varchar(255) not null, primary key (topiaId));

 create table ll_observation.encounterType (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 ll_observation.basket (topiaId varchar(255) not null, topiaVersion bigint not null, topiaCreateDate timestamp not null, lastUpdateDate timestamp default CURRENT_TIMESTAMP not null, homeId varchar(255), settingIdentifier integer not null, haulingIdentifier integer, floatline1Length numeric, floatline2Length numeric, section varchar(255) not null, primary key (topiaId));

 create table ll_observation.branchline (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), settingIdentifier integer not null, haulingIdentifier integer, depthRecorder boolean default false not null, timer boolean default false not null, timeSinceContact integer, hookOffset integer, branchlineLength numeric, weightedSwivel boolean default false not null, timerTimeOnBoard timestamp, weightedSnap boolean default false not null, swivelWeight numeric, snapWeight numeric, tracelineLength numeric, hookLost boolean default false not null, traceCutOff boolean default false not null, hookType varchar(255), baitType varchar(255), topType varchar(255), tracelineType varchar(255), baitSettingStatus varchar(255), baitHaulingStatus varchar(255), hookSize varchar(255), basket varchar(255) not null, primary key (topiaId));

 create table ll_observation.branchlinesComposition (topiaId varchar(255) not null, topiaVersion bigint not null, topiaCreateDate timestamp not null, lastUpdateDate timestamp default CURRENT_TIMESTAMP not null, homeId varchar(255), length numeric not null, proportion integer not null, tracelineLength numeric, topType varchar(255) not null, tracelineType varchar(255) not null, set varchar(255) not null, primary key (topiaId));

 create table ll_observation.catch_predator (catch varchar(255) not null, species varchar(255) not null, primary key (catch, species));

 create table ll_observation.encounter (topiaId varchar(255) not null, topiaVersion bigint not null, topiaCreateDate timestamp not null, lastUpdateDate timestamp default CURRENT_TIMESTAMP not null, homeId varchar(255), distance numeric, count integer, encounterType varchar(255) not null, species varchar(255), activity varchar(255) not null, primary key (topiaId));

 create table ll_observation.encounterType (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));

   "beatDiameter": "Float",

   "gonadeWeight": "Float",

   "photoReferences": "String",

   "number": "Integer",

   "acquisitionMode": "int",

   "tagNumber": "String",

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

     ]

   },

   "section": {

     "warnings": [

       "mandatory except if acquisitionMode != 0"

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

     ]

   },

   "section": {

     "warnings": [

       "mandatory except if acquisitionMode != 0"

 observe.Common.root.list.message.none=<html><body>No data of type <i>%s</i> for group by <i>%s</i> saved.</body></html>

 observe.Common.sample=Sample

 observe.Common.sampleQuality=Sample quality

 observe.Common.sampleSpeciesMeasure=Frequencies

 observe.Common.sampleSpeciesMeasure.validation.uniqueKey=Size class must be unique, value at index %s is duplicated.

 observe.Common.sampleType=Sample type

 observe.Common.root.list.message.none=<html><body>No data of type <i>%s</i> for group by <i>%s</i> saved.</body></html>

 observe.Common.sample=Sample \#TODO

 observe.Common.sampleQuality=Sample quality \#TODO

 observe.Common.sampleSpeciesMeasure=TODO

 observe.Common.sampleSpeciesMeasure.validation.uniqueKey=TODO

 observe.Common.sampleType=Sample type \#TODO

 observe.Common.root.list.message.none=<html><body>Aucune donnée du type <i>%s</i> pour le groupement <i>%s</i> enregistrée.</body></html>

 observe.Common.sample=Échantillon

 observe.Common.sampleQuality=Qualité de l'échantillon

 observe.Common.sampleSpeciesMeasure=Fréquences

 observe.Common.sampleSpeciesMeasure.validation.uniqueKey=La classe de taille doit être unique, la donnée de rang %s est invalide.

 observe.Common.sampleType=Type d'échantillon

 beatDiameter Float

 gonadeWeight Float

 photoReferences String

 number Integer

 acquisitionMode int

 tagNumber String

 data.ll.observation.Branchline.attribute.comment=true

 data.ll.observation.Catch.attribute.comment=true

 data.ll.observation.Catch.attribute.photoReferences=true

 data.ll.observation.Catch.attribute.tagNumber=true

 data.ll.observation.SectionTemplate.attribute.floatlineLengths=true

 data.ll.observation.SectionTemplate.attribute.id=true

 data.ll.observation.Activity.attribute.comment=8192

 data.ll.observation.Branchline.attribute.comment=8192

 data.ll.observation.Catch.attribute.comment=8192

 data.ps.common.GearUseFeatures.attribute.comment=8192

 data.ps.common.Trip.attribute.generalComment=8192

 data.ps.common.Trip.attribute.logbookComment=8192

 data.ll.observation.Basket=floatline1Length,floatline1Length.short,floatline2Length,floatline2Length.short,branchline,haulingIdentifier,settingIdentifier

 data.ll.observation.Branchline=branchlineLength.short,tracelineLength.short,depthRecorder,timer,timeSinceContact,hookOffset,branchlineLength,weightedSwivel,timerTimeOnBoard,weightedSnap,swivelWeight,snapWeight,tracelineLength,hookLost,traceCutOff,baitSettingStatus,hookSize,baitHaulingStatus,hookType,tracelineType,topType,baitType,comment,action.save,action.save.tip,haulingIdentifier,message.modified,message.modified.but.invalid,setDefaultTimerTimeOnBoard.tip,settingIdentifier

 data.ll.observation.BranchlinesComposition=length,topType,tracelineLength,tracelineType,branchlinesCompositionProportionSum

 data.ll.observation.Encounter=count,distance,encounterType,species

 data.ll.observation.FloatlinesComposition=length,lineType,floatlinesCompositionProportionSum

 data.ll.observation.HooksComposition=hookOffset,hookSize,hookType,hooksCompositionProportionSum

 beatDiameter Float

 gonadeWeight Float

 photoReferences String

 number Integer

 acquisitionMode int

 tagNumber String

 data.ll.observation.Activity.attribute.comment=8192

 data.ll.observation.Branchline.attribute.comment=8192

 data.ll.observation.Catch.attribute.comment=8192

 data.ll.observation.Set.attribute.comment=8192

 data.ps.common.GearUseFeatures.attribute.comment=8192

 data.ps.common.Trip.attribute.generalComment=8192