<BeanCheckBox id='lightsticksUsed'/>

                       </cell>

                     </row>

                     <!-- total lightsticks count -->

                     <row>

                       <cell anchor='west'>

 totalSectionsCount + {*:1} Integer | notNull positiveNumber

 totalBasketsCount + {*:1} Integer | positiveNumber

 totalHooksCount + {*:1} Integer | positiveNumber

 totalLightsticksCount + {*:1} Integer | positiveNumber

 weightedSnap + {*:1} Boolean

 snapWeight + {*:1} Float | positiveNumber

 totalSectionsCount + {*:1} Integer

 totalBasketsCount + {*:1} Integer

 totalHooksCount + {*:1} Integer

 totalLightsticksCount + {*:1} Integer

 weightedSnap + {*:1} Boolean

 snapWeight + {*:1} Float | sqlType=numeric

 CREATE SCHEMA ll_logbook;

 CREATE TABLE ll_logbook.baitscomposition(topiaId VARCHAR(255) NOT NULL, topiaVersion BIGINT NOT NULL, topiaCreateDate TIMESTAMP NOT NULL, lastUpdateDate TIMESTAMP NOT NULL, proportion INTEGER, individualsize INTEGER, individualweight NUMERIC, baitsettingstatus VARCHAR(255), baittype VARCHAR(255), set VARCHAR(255), homeId VARCHAR(255), CONSTRAINT pk_ll_logbook_baitscomposition primary key(topiaId));

 CREATE TABLE ll_logbook.branchlinescomposition(topiaId VARCHAR(255) NOT NULL, topiaVersion BIGINT NOT NULL, topiaCreateDate TIMESTAMP NOT NULL, lastUpdateDate TIMESTAMP NOT NULL, length NUMERIC, proportion INTEGER, tracelinelength NUMERIC, toptype VARCHAR(255), tracelinetype VARCHAR(255), set VARCHAR(255), homeId VARCHAR(255), CONSTRAINT pk_ll_logbook_branchlinescomposition primary key(topiaId));

 CREATE TABLE ll_logbook.catch(topiaId VARCHAR(255) NOT NULL, topiaVersion BIGINT NOT NULL, topiaCreateDate TIMESTAMP NOT NULL, lastUpdateDate TIMESTAMP NOT NULL, comment VARCHAR(1025), count INTEGER, totalweight NUMERIC, hookwhendiscarded BOOLEAN, depredated BOOLEAN, beatdiameter NUMERIC, countdepredated INTEGER, depredatedproportion INTEGER, photoreferences VARCHAR(255), number INTEGER, acquisitionmode INTEGER, tagnumber VARCHAR(255), onboardprocessing VARCHAR(255), catchfate VARCHAR(255), discardhealthStatus VARCHAR(255), speciescatch VARCHAR(255), catchhealthStatus VARCHAR(255), weightmeasuremethod VARCHAR(255), set VARCHAR(255), set_idx INTEGER, homeId VARCHAR(255), CONSTRAINT pk_ll_logbook_catch primary key(topiaId));

 boolean.false=No

 boolean.true=Yes

 observe.Id.comment=Comment

 boolean.false=No

 boolean.true=Si

 observe.Id.comment=Commentario

 observe.Id.ocean=Ocean

 observe.Id.quadrant=Quadrant

 observe.Id.sex=Sexe

 observe.Id.sizeMeasureType=Type de mensuration

 observe.Id.validation.comment.needed.for.multiple=Un commentaire est requis pour l'un des référentiels %s sélectionné.

 observe.Id.validation.comment.needed.for.single=Un commentaire est requis pour le référentiel %s sélectionné.

 observe.data.ll.logbook.Set.haulingStartTimeStamp

 observe.data.ll.logbook.Set.lengthBetweenBranchlines

 observe.data.ll.logbook.Set.lightsticksColor

 observe.data.ll.logbook.Set.lightsticksType

 observe.data.ll.logbook.Set.lineType

 observe.data.ll.logbook.Set.maxDepthTargeted