Api Reference

Our APIs are organized around core domains such as Experimentation, User Management, Comments, Core Entities, Catalogs (Germplasm, Product/Bio Product), Growing Area, and Attachments. Each domain encapsulates a set of related entities and operations designed to provide a modular and efficient interaction experience.

mindmap
  root((APIs))
    {{**Experiment**}}
      MET
      Trial
          Plot            
          Notation
          Notebook
          Task
          ExperimentalDesign
          Factor
              Modality
                  Treatment
          Conclusion
      Label
      Partner
    {{**User**}}
      User
      Role
      Permission
    {{**Comment**}}
      Comment
          Topic
    {{**Core**}}
      BlommeoTag
      Hierarchy
      PickList
      TemplateObs
      Variable
    {{**Germplasm**}}
      Genotype
      Lot
      Product
    {{**GrowingArea**}}
      GrowingArea
      MarketSegment
    {{**Attachment**}}
      Attachment
    %%   {{**Ingestion**}}
    %%     IngestionJob
    %%     IngestionRunner

API Domains

Core: Shared entities like templates and variables.
Experiment: Elements to plan and feed experiments.
Germplasm: Genetic and product-related data management.
Growing Area: Location and market segmentation management.
Attachment: Manage file attachments.
Comment: Discussion and annotation features.
User: Manage users, roles, and permissions.

Entity Relationship diagram

Preview

This is a preview of the entity relationship diagram. It is a work in progress and may not be complete.

Zoom and Pan

You can use zoom and pan to navigate the diagram.

Overall view

erDiagram

Detailed views

Core

erDiagram
  IVarLimitedChoiceDto {
    string(0-64) label "(ie. #quot;Fully resistant#quot;)"
  }
  MarketSegmentSelectionDto {
    string marketSegmentId "(ie. #quot;640333d44a4fef871c1fa44d#quot;)"
    string[] microMarketSegmentIds "(ie. [#quot;8ad37abd14a0cce5756abf37e#quot;])"
  }
  MarketSegmentSelectionDto }o--|| MarketSegmentDto : "references through marketSegmentId"
  MarketSegmentSelectionDto ||--o{ MicroMarketSegmentDto : "references through microMarketSegmentIds"
  ScopedVariableDto {
    string variableId "(ie. #quot;61662aaf7f3dc3a4d3ad645f#quot;)"
    number scope "(0, 1, 2)(ie. 2)"
  }
  ScopedVariableDto }o--|| VariableCoreDto : "references through variableId"
  DateConstraintDto {
    date type "(ie. #quot;date#quot;)"
    string minDate "(ie. #quot;2023-03-23#quot;)"
    string maxDate "(ie. #quot;2023-03-23#quot;)"
  }
  DecConstraintDto {
    dec type "(ie. #quot;dec#quot;)"
    number min ""
    number max "(ie. 42)"
    number nbDigits "(ie. 2)"
  }
  IntConstraintDto {
    int type "(ie. #quot;int#quot;)"
    number min ""
    number max "(ie. 42)"
  }
  StringConstraintDto {
    string type "(ie. #quot;string#quot;)"
    number min ""
    number max "(ie. 42)"
  }
  FormulaConstraintDto {
    string[] formulaVariables "(ie. [#quot;x#quot;,#quot;y#quot;])"
    string(0-512) formula "(ie. #quot;x*y+500#quot;)"
    formula type "(ie. #quot;formula#quot;)"
    number nbDigits "(ie. 2)"
  }
  VariableCoreDto {
    string _id "(ie. #quot;640333d44a4fef871c1fa44d#quot;)"
    string(1-64) identifier "(ie. #quot;C0001#quot;)"
    object name "(ie. {#quot;fr#quot;:#quot;exemple#quot;,#quot;en#quot;:#quot;example#quot;})"
    string(1-8) shortName "(ie. #quot;com#quot;)"
    string(0-256) description "(ie. #quot;a description of the variable#quot;)"
    string(0-1024) comments "(ie. #quot;Comments of the variable#quot;)"
    string inputType "(limited choice, free)"
    string(0-64) unit "(ie. #quot;cm#quot;)"
    string[] tags ""
    number scope "(0, 1, 2)(ie. 2)"
    DateConstraintDto_DecConstraintDto_IntConstraintDto_StringConstraintDto_FormulaConstraintDto constraint ""
    string type "(boolean, date, string, int, dec, picture, formula)(ie. #quot;date#quot;)"
    IVarLimitedChoiceDto[] limitedChoices ""
    MarketSegmentSelectionDto[] marketSegmentSelection ""
    array[] speciesV2 "(ie. [[#quot;Vegetable#quot;,#quot;Tomato#quot;]])"
    boolean usedForPermission "(ie. true)"
    boolean deactivated ""
    string notationPicklistId "(ie. #quot;640333d44a4fef871c1fa44d#quot;)"
    string defaultNotaPicklistValId "(ie. #quot;640333d44a4fef871c1fa44d#quot;)"
    string method "(ie. #quot;Method description#quot;)"
  }
  VariableCoreDto }o--|| DateConstraintDto : "has"
  VariableCoreDto }o--|| DecConstraintDto : "has"
  VariableCoreDto }o--|| IntConstraintDto : "has"
  VariableCoreDto }o--|| StringConstraintDto : "has"
  VariableCoreDto }o--|| FormulaConstraintDto : "has"
  VariableCoreDto }o--|| IVarLimitedChoiceDto : "has"
  VariableCoreDto }o--|| MarketSegmentSelectionDto : "has"
  VariableCoreDto }o--|| NotationPicklistDto : "references through notationPicklistId"
  VariableCoreDto }o--|| DefaultNotaPicklistValDto : "references through defaultNotaPicklistValId"
  IVarMultiInputDto {
    number expectedNotationNb ""
    string expectationType "(fixed, minimum, free)(ie. #quot;minimum#quot;)"
    string computeMethod "(count, sum, minimum, maximum, average, median, standard deviation)(ie. #quot;average#quot;)"
  }
  FormulaVarConfigItemDto {
    string placeholder "(ie. #quot;MOISTURE#quot;)"
    string levelToFetch "(trial, material, plot, subPlot)(ie. #quot;trial#quot;)"
    string linkedVariableId "(ie. #quot;61662aaf7f3dc3a4d3ad645f#quot;)"
  }
  FormulaVarConfigItemDto }o--|| VariableCoreDto : "references through linkedVariableId"
  TemplateObservationVariableDto {
    string variableId "(ie. #quot;61662aaf7f3dc3a4d3ad645f#quot;)"
    number scope "(0, 1, 2)(ie. 2)"
    string priority "(HIGH, MEDIUM, LOW)(ie. #quot;MEDIUM#quot;)"
    IVarMultiInputDto multiInput ""
    FormulaVarConfigItemDto[] formulaConfiguration ""
  }
  TemplateObservationVariableDto }o--|| VariableCoreDto : "references through variableId"
  TemplateObservationVariableDto }o--|| IVarMultiInputDto : "has"
  TemplateObservationVariableDto }o--|| FormulaVarConfigItemDto : "has"
  TemplateObservationUnitDto {
    ScopedVariableDto[] trial ""
    ScopedVariableDto[] material ""
    ScopedVariableDto[] plot ""
    ScopedVariableDto[] subPlot ""
    string observationRoundId "(ie. #quot;648846cd7869046fc0676fbf#quot;)"
  }
  TemplateObservationUnitDto }o--|| ScopedVariableDto : "has"
  TemplateObservationUnitDto }o--|| ScopedVariableDto : "has"
  TemplateObservationUnitDto }o--|| ScopedVariableDto : "has"
  TemplateObservationUnitDto }o--|| ScopedVariableDto : "has"
  TemplateObservationUnitDto }o--|| ObservationRoundDto : "references through observationRoundId"
  TemplateObservationDto {
    string _id "(ie. #quot;640333d44a4fef871c1fa44d#quot;)"
    string(0-64) identifier "(ie. #quot;comments#quot;)"
    object name "(ie. {#quot;fr#quot;:#quot;commentaires#quot;,#quot;en#quot;:#quot;comments#quot;})"
    string(0-8) shortName "(ie. #quot;com#quot;)"
    string(0-256) description ""
    string(0-1024) comments "(ie. #quot;A simple comment for this observation template#quot;)"
    array[] speciesV2 "(ie. [[#quot;Vegetable#quot;,#quot;Tomato#quot;]])"
    array[] geography "(ie. [[#quot;FR#quot;,#quot;NICE#quot;]])"
    array[] organization "(ie. [[#quot;Organization1#quot;,#quot;VMK#quot;],[#quot;Organization2#quot;]])"
    TemplateObservationVariableDto[] variablesPool ""
    TemplateObservationUnitDto templateObsUnits ""
    MarketSegmentSelectionDto[] marketSegmentSelection ""
  }
  TemplateObservationDto }o--|| TemplateObservationVariableDto : "has"
  TemplateObservationDto }o--|| TemplateObservationUnitDto : "has"
  TemplateObservationDto }o--|| MarketSegmentSelectionDto : "has"
  VariableTagDto {
    string _id "(ie. #quot;640333d44a4fef871c1fa44d#quot;)"
    string(1-64) value "(ie. #quot;variableTag#quot;)"
    string type "(VARIABLE, CONCLUSION, EXPERIMENT, OTHER_FACTOR, COMMENT)(ie. #quot;VARIABLE#quot;)"
    string context "(other, agronomic, pheno, operation, marketSegment, geno, species, geo, organization)(ie. #quot;agronomic#quot;)"
  }
  ConclusionTagDto {
    string _id "(ie. #quot;640333d44a4fef871c1fa44d#quot;)"
    string(1-64) value "(ie. #quot;variableTag#quot;)"
    string type "(VARIABLE, CONCLUSION, EXPERIMENT, OTHER_FACTOR, COMMENT)(ie. #quot;VARIABLE#quot;)"
    string context "(advantage, drawback, warning)(ie. #quot;advantage#quot;)"
  }
  OtherFactorTagDto {
    string _id "(ie. #quot;640333d44a4fef871c1fa44d#quot;)"
    string(1-64) value "(ie. #quot;variableTag#quot;)"
    string type "(VARIABLE, CONCLUSION, EXPERIMENT, OTHER_FACTOR, COMMENT)(ie. #quot;VARIABLE#quot;)"
    string context "(other, agronomic, pheno, operation, marketSegment, geno, species, geo, organization)(ie. #quot;other#quot;)"
  }
  CommentTagDto {
    string _id "(ie. #quot;640333d44a4fef871c1fa44d#quot;)"
    string(1-64) value "(ie. #quot;variableTag#quot;)"
    string type "(VARIABLE, CONCLUSION, EXPERIMENT, OTHER_FACTOR, COMMENT)(ie. #quot;VARIABLE#quot;)"
    string context "(other, agronomic, pheno, operation, marketSegment, geno, species, geo, organization)(ie. #quot;other#quot;)"
  }
  HierarchyLevelDefinitionDto {
    string name ""
    string description ""
  }
  HierarchyNodeDto {
    string value ""
    string code ""
    HierarchyNodeDto[] children ""
  }
  HierarchyNodeDto }o--|| HierarchyNodeDto : "has"
  FlattenedHierarchyItemDto {
    string path ""
    string code ""
  }
  PickListItemDto {
    string(1-64) value "(ie. #quot;a choice of the pick list#quot;)"
  }
  PickListDto {
    string _id "(ie. #quot;640333d44a4fef871c1fa44d#quot;)"
    string type "(cultivation_method, local_stage, company_name, agronomic_stage, partner_type, application_method, application_placement, lot_location, lot_packaging, location_type, storage_condition, fertility_class, genotype_lot_stage, registration_orga_name, holder, endophyte, genetic_group, genetic_group_2, material_type, modality_unit, season, cut, lab_project, lab_analysis_profile, program_type, program_category, experiment_category, crop_management_description, trial_analytic_method, irrigation_type, pollination_type, method, genotype_main_usage, holder_location, discard_reason, vintage, climate, soil_type)(ie. #quot;local_stage#quot;)"
    PickListItemDto[] items ""
  }
  PickListDto }o--|| PickListItemDto : "has"
  AuditDto {
    string _id "(ie. #quot;640333d44a4fef871c1fa44d#quot;)"
    string action ""
    object tenantId ""
    object entityId ""
    object entityLabel ""
    object entityType ""
    object traceId ""
    object data ""
  }
  AuditDto }o--|| EntityDto : "references through entityId"
  AuditDto }o--|| TraceDto : "references through traceId"
  ExperimentTagDto {
    string _id "(ie. #quot;640333d44a4fef871c1fa44d#quot;)"
    string(1-64) value "(ie. #quot;variableTag#quot;)"
    string type "(VARIABLE, CONCLUSION, EXPERIMENT, OTHER_FACTOR, COMMENT)(ie. #quot;VARIABLE#quot;)"
    string context "(other, agronomic, pheno, operation, marketSegment, geno, species, geo, organization)(ie. #quot;agronomic#quot;)"
  }

Experiment

erDiagram

Germplasm

erDiagram
  LotDivideAllocationDto {
    string lotId ""
    number numberOfLotsToGenerate ""
  }
  LotDivideAllocationDto }o--|| LotDto : "references through lotId"
  ExecuteLotDivideDto {
    LotDivideAllocationDto[] allocations ""
    string codification "(parent_with_counter)"
    string experimentId ""
    string divideTaskId ""
    array[] organization ""
    array[] sharedWithOrganization ""
  }
  ExecuteLotDivideDto }o--|| LotDivideAllocationDto : "has"
  ExecuteLotDivideDto }o--|| ExperimentDto : "references through experimentId"
  ExecuteLotDivideDto }o--|| DivideTaskDto : "references through divideTaskId"
  LotGenotypeDto {
    string _id "(ie. #quot;62a2196d0894b83b87cd202f#quot;)"
    string(0-64) name "(ie. #quot;CO05HY0001#quot;)"
    array[] speciesV2 "(ie. [[#quot;Vegetable#quot;,#quot;Tomato#quot;]])"
    array[] organization "(ie. [[#quot;Organization1#quot;,#quot;VMK#quot;],[#quot;Organization2#quot;]])"
    string status "(in creation, active)(ie. #quot;in creation#quot;)"
  }
  LotGenotypeDto }o--|| GenotypeDto : "references through _id"
  LotGenealogyDto {
    string _id "(ie. #quot;f47ac10b-58cc-4372-a567-0e02b2c3d479#quot;)"
    string parentId "(ie. #quot;64a33b87eac98ad254854f98#quot;)"
    string name "(ie. #quot;Custom name#quot;)"
    string type "(directFParent, directMParent)(ie. #quot;directFParent#quot;)"
  }
  LotGenealogyDto }o--|| ParentDto : "references through parentId"
  LotDto {
    string _id "(ie. #quot;5fc7abd14a0cce5298abf37e#quot;)"
    LotGenotypeDto genotype ""
    string(0-64) lotCode "(ie. #quot;87140989813#quot;)"
    string(0-64) lotName "(ie. #quot;LOT-NB1#quot;)"
    string harvestDate "(ie. #quot;2023-02-15#quot;)"
    string(0-1024) notes "(ie. #quot;A note of the lot#quot;)"
    string(0-1024) comments "(ie. #quot;A comments of the lot#quot;)"
    string lotNature "(planted material, seeds, cutting, plants)(ie. #quot;planted material#quot;)"
    string materialScope "(Organizational Material, Experiment Material)(ie. #quot;Organizational Material#quot;)"
    array[] sharedWithOrganization "(ie. [[#quot;Organization1#quot;,#quot;North#quot;],[#quot;Organization2#quot;]])"
    array[] organization "(ie. [[#quot;Organization1#quot;,#quot;SubOrg#quot;]])"
    array[] geography "(ie. [[#quot;France#quot;,#quot;Nice#quot;],[#quot;Italy#quot;]])"
    string(0-64) lotAlternateName "(ie. #quot;LOT-NB2#quot;)"
    string(0-256) description "(ie. #quot;the is a description#quot;)"
    string(0-64) lotLocation "(ie. #quot;france#quot;)"
    string(0-64) linkingIdentifier "(ie. #quot;france#quot;)"
    string(0-64) lotPackaging "(ie. #quot;france#quot;)"
    number lotGeneration "(ie. 1)"
    string(0-64) linkingIdentifier1 "(ie. #quot;LINK12345#quot;)"
    string(0-64) linkingIdentifier2 "(ie. #quot;LINK12346#quot;)"
    string(0-64) linkingIdentifier3 "(ie. #quot;LINK12347#quot;)"
    string(0-64) linkingIdentifier4 "(ie. #quot;LINK12348#quot;)"
    string(0-64) linkingIdentifier5 "(ie. #quot;LINK12349#quot;)"
    string crossId "(ie. #quot;6668e7fae9f2a5c45c8f4b3d#quot;)"
    string experimentId "(ie. #quot;6668e7fae9f2a5c45c8f4b3d#quot;)"
    string[] sourceLotIds ""
    string lotSource "(mix, divide)"
    LotGenealogyDto[] genealogies ""
    string(0-64) registrationCode "(ie. #quot;REG12345#quot;)"
    string stage "(ie. #quot;seedling#quot;)"
    string(0-64) lotQuality "(ie. #quot;high#quot;)"
    string locationType "(ie. #quot;greenhouse#quot;)"
    string storageCondition "(ie. #quot;dry#quot;)"
    string lotResponsible "(ie. #quot;12351166-ef12-1234-abcd-456ffac55452#quot;)"
    string endophyte "(ie. #quot;E+#quot;)"
    string status "(in creation, active)(ie. #quot;in creation#quot;)"
    string quantityType "(weight, quantity)(ie. #quot;weight#quot;)"
    string quantityUnit "(t, kg, hg, dag, g, dg, cg, mg, µg, ng, q, ct, tn, lt, lb, oz, st, dr, gr)(ie. #quot;kg#quot;)"
    number qtyToSet "(ie. 1.5)"
    object extraRawData "(ie. {#quot;customField1#quot;:#quot;value1#quot;,#quot;customField2#quot;:#quot;value2#quot;})"
    string(0-64) ownership "(ie. #quot;Company A#quot;)"
    string companyName "(ie. #quot;Company A#quot;)"
  }
  LotDto }o--|| LotGenotypeDto : "has"
  LotDto }o--|| CrossDto : "references through crossId"
  LotDto }o--|| ExperimentDto : "references through experimentId"
  LotDto ||--o{ SourceLotDto : "references through sourceLotIds"
  LotDto }o--|| LotGenealogyDto : "has"
  MarketSegmentSelectionDto {
    string marketSegmentId "(ie. #quot;640333d44a4fef871c1fa44d#quot;)"
    string[] microMarketSegmentIds "(ie. [#quot;8ad37abd14a0cce5756abf37e#quot;])"
  }
  MarketSegmentSelectionDto }o--|| MarketSegmentDto : "references through marketSegmentId"
  MarketSegmentSelectionDto ||--o{ MicroMarketSegmentDto : "references through microMarketSegmentIds"
  MaterialExperimentScopeDto {
    string id "(ie. #quot;5fc7abd14a0cce5298abf37e#quot;)"
    string type "(Trial, MET)(ie. #quot;Trial#quot;)"
  }
  IBulkFunctionResponseDTO {
  }
  GenotypeGenealogyDto {
    string _id "(ie. #quot;f47ac10b-58cc-4372-a567-0e02b2c3d479#quot;)"
    string parentId "(ie. #quot;64a33b87eac98ad254854f98#quot;)"
    string name "(ie. #quot;Custom name#quot;)"
    string type "(directFParent, directMParent, originFParent, originMParent)(ie. #quot;directFParent#quot;)"
  }
  GenotypeGenealogyDto }o--|| ParentDto : "references through parentId"
  GenotypeDto {
    string _id "(ie. #quot;5fc7abd14a0cce5298abf37e#quot;)"
    string(0-64) name "(ie. #quot;CO05HY0001#quot;)"
    array[] speciesV2 "(ie. [[#quot;Vegetable#quot;,#quot;Tomato#quot;]])"
    string(0-64) label "(ie. #quot;ARGO29843#quot;)"
    string crossType "(synthetic, simple cross, back cross, double haploid, self cross, half sib, individualization, clone, none)(ie. #quot;simple cross#quot;)"
    string germplasmMaterialType "(ie. #quot;SC#quot;)"
    string materialCreationProfile "(ie. #quot;SIMPLE#quot;)"
    string mcpId "(ie. #quot;5fc7abd14a0cce5298abf37e#quot;)"
    string(0-64) variety "(ie. #quot;ARGO29843#quot;)"
    number generation "(ie. 1)"
    string(0-256) directParentage "(ie. #quot;(ADDENDUM)x(YOSEMITE)#quot;)"
    string fullParentage "(ie. #quot;(ADDENDUM)x(YOSEMITE)#quot;)"
    string(0-1024) notes "(ie. #quot;A note of the genotype#quot;)"
    string(0-1024) comments "(ie. #quot;A comments of the genotype#quot;)"
    MarketSegmentSelectionDto[] marketSegmentSelection ""
    string(0-64) alternateName "(ie. #quot;Alternate name#quot;)"
    array[] organization "(ie. [[#quot;Organization1#quot;,#quot;VMK#quot;],[#quot;Organization2#quot;]])"
    array[] sharedWithOrganizations "(ie. [[#quot;Organization1#quot;,#quot;VMK#quot;],[#quot;Organization2#quot;]])"
    boolean control "(ie. true)"
    string(0-64) ownership "(ie. #quot;External#quot;)"
    string companyName "(ie. #quot;Doriane#quot;)"
    string materialScope "(Organizational Material, Experiment Material)(ie. #quot;Organizational Material#quot;)"
    MaterialExperimentScopeDto[] experimentScopes ""
    boolean isRequestedToOrga ""
    boolean isRequestedToOrgaNotif ""
    string requestedToOrgaBy "(ie. #quot;doriane@doriane.com#quot;)"
    string requestToOrgaDate "(ie. #quot;2023-03-23T11:29:31.077Z#quot;)"
    string(0-64) externalId "(ie. #quot;ARGO29843#quot;)"
    string(0-64) linkingIdentifier1 "(ie. #quot;LINK12345#quot;)"
    string(0-64) linkingIdentifier2 "(ie. #quot;LINK12346#quot;)"
    string(0-64) linkingIdentifier3 "(ie. #quot;LINK12347#quot;)"
    string(0-64) linkingIdentifier4 "(ie. #quot;LINK12348#quot;)"
    string(0-64) linkingIdentifier5 "(ie. #quot;LINK12349#quot;)"
    string harvestDate "(ie. #quot;2023-02-15#quot;)"
    string crossObjective "(ie. #quot;Improvement of disease resistance#quot;)"
    boolean fixity ""
    string startingCrossGenotypeName ""
    string harvestLevel "(treatment, sub plot, plot)(ie. #quot;treatment#quot;)"
    string crossId "(ie. #quot;6668e7fae9f2a5c45c8f4b3d#quot;)"
    string experimentId "(ie. #quot;6668e7fae9f2a5c45c8f4b3d#quot;)"
    GenotypeGenealogyDto[] genealogies ""
    string programId "(ie. #quot;6668e7fae9f2a5c45c8f4b3d#quot;)"
    string(0-64) researchCode "(ie. #quot;RC2023-001#quot;)"
    string(0-64) registrationCode "(ie. #quot;REG2023-001#quot;)"
    string(0-64) cultivarCode "(ie. #quot;CULT2023-001#quot;)"
    string(0-64) familyCode "(ie. #quot;FAM2023-001#quot;)"
    string(0-64) otherGroupingColumn "(ie. #quot;GROUP-001#quot;)"
    string(0-512) pedigree "(ie. #quot;Parent1 x Parent2#quot;)"
    string(0-64) geneticGroup1 "(ie. #quot;GG1-001#quot;)"
    string(0-64) geneticGroup2 "(ie. #quot;GG2-001#quot;)"
    string fertilityClass "(ie. #quot;High#quot;)"
    number consecutiveSelf "(ie. 3)"
    string stage "(ie. #quot;Advanced#quot;)"
    string registrationOrgaName "(ie. #quot;ACME Registration Corp#quot;)"
    boolean isRegistered ""
    number ploidy "(ie. 2)"
    string endophyte "(ie. #quot;E+#quot;)"
    string genotypeResponsible "(ie. #quot;user@example.com#quot;)"
    string holder "(ie. #quot;Research Institute#quot;)"
    string status "(in creation, active)(ie. #quot;in creation#quot;)"
    object extraRawData "(ie. {#quot;customField1#quot;:#quot;value1#quot;,#quot;customField2#quot;:#quot;value2#quot;})"
    string mainUsage "(ie. #quot;Research#quot;)"
    string holderLocation "(ie. #quot;Location A#quot;)"
    string(0-64) brandName "(ie. #quot;BrandX#quot;)"
    string(0-64) oldName "(ie. #quot;OldName#quot;)"
    string(0-64) holderCode "(ie. #quot;HOLDER123#quot;)"
    string(0-64) varietyManager "(ie. #quot;VarietyManager#quot;)"
  }
  GenotypeDto }o--|| McpDto : "references through mcpId"
  GenotypeDto }o--|| MarketSegmentSelectionDto : "has"
  GenotypeDto }o--|| MaterialExperimentScopeDto : "has"
  GenotypeDto }o--|| ExternalDto : "references through externalId"
  GenotypeDto }o--|| CrossDto : "references through crossId"
  GenotypeDto }o--|| ExperimentDto : "references through experimentId"
  GenotypeDto }o--|| GenotypeGenealogyDto : "has"
  GenotypeDto }o--|| ProgramDto : "references through programId"
  AllowEditionDto {
    boolean allow ""
  }
  LotQuantityStateDto {
    string lotId "(ie. #quot;5fc7abd14a0cce5298abf37f#quot;)"
    number inStock "(ie. 1000)"
    number reserved "(ie. 200)"
    number used "(ie. 50)"
    number available "(ie. 800)"
    string[] reservedExperimentIds ""
    string experimentId "(ie. #quot;5fc7abd14a0cce5298abf380#quot;)"
    string taskId "(ie. #quot;5fc7abd14a0cce5298abf381#quot;)"
  }
  LotQuantityStateDto }o--|| LotDto : "references through lotId"
  LotQuantityStateDto ||--o{ ReservedExperimentDto : "references through reservedExperimentIds"
  LotQuantityStateDto }o--|| ExperimentDto : "references through experimentId"
  LotQuantityStateDto }o--|| TaskDto : "references through taskId"
  BatchLotQuantityStateDto {
    string[] lotIds ""
    string experimentId "(ie. #quot;5fc7abd14a0cce5298abf381#quot;)"
    string taskId "(ie. #quot;5fc7abd14a0cce5298abf382#quot;)"
  }
  BatchLotQuantityStateDto ||--o{ LotDto : "references through lotIds"
  BatchLotQuantityStateDto }o--|| ExperimentDto : "references through experimentId"
  BatchLotQuantityStateDto }o--|| TaskDto : "references through taskId"
  LotQuantityTransactionResponseDto {
    string _id "(ie. #quot;5fc7abd14a0cce5298abf37e#quot;)"
    string lotId "(ie. #quot;5fc7abd14a0cce5298abf37f#quot;)"
    string type "(UPDATE_IN_STOCK, RESERVATION, CANCEL_RESERVATION, USAGE, CANCEL_USAGE)(ie. #quot;RESERVATION#quot;)"
    number quantity "(ie. 100.5)"
    string experimentId "(ie. #quot;5fc7abd14a0cce5298abf380#quot;)"
    string taskId "(ie. #quot;5fc7abd14a0cce5298abf381#quot;)"
    string lotCode "(ie. #quot;LOT-001#quot;)"
    string experimentName "(ie. #quot;Trial Spring 2025#quot;)"
    string quantityType "(weight, quantity)"
    string quantityUnit "(t, kg, hg, dag, g, dg, cg, mg, µg, ng, q, ct, tn, lt, lb, oz, st, dr, gr)"
  }
  LotQuantityTransactionResponseDto }o--|| LotDto : "references through lotId"
  LotQuantityTransactionResponseDto }o--|| ExperimentDto : "references through experimentId"
  LotQuantityTransactionResponseDto }o--|| TaskDto : "references through taskId"
  GenotypeGroupDetailsDto {
    string _id "(ie. #quot;640333d44a4fef871c1fa44d#quot;)"
    string(0-128) name "(ie. #quot;Agro Testing#quot;)"
    string startDate "(ie. #quot;2023-03-23T11:29:31.077Z#quot;)"
    integer year "(ie. 2023)"
    string(0-256) description ""
    string status "(IN_CONFIGURATION, PLANNED, USED)(ie. #quot;IN_CONFIGURATION#quot;)"
    string[] organization "(ie. [[#quot;Organization1#quot;,#quot;VMK#quot;],[#quot;Organization2#quot;]])"
    string[] species "(ie. [[#quot;Vegetable#quot;,#quot;Tomato#quot;]])"
    string[] geography "(ie. [[#quot;FR#quot;,#quot;NICE#quot;],[#quot;ES#quot;]])"
    string experimentSourceId "(ie. #quot;640333d44a4fef871c1fa44d#quot;)"
    string taskSourceId "(ie. #quot;640333d44a4fef871c1fa44d#quot;)"
    string originMCPId "(ie. #quot;640333d44a4fef871c1fa44d#quot;)"
    number elementsCount "(ie. 10)"
  }
  GenotypeGroupDetailsDto }o--|| ExperimentSourceDto : "references through experimentSourceId"
  GenotypeGroupDetailsDto }o--|| TaskSourceDto : "references through taskSourceId"
  GenotypeGroupDetailsDto }o--|| OriginMCPDto : "references through originMCPId"
  GenotypeGroupDto {
    string _id "(ie. #quot;640333d44a4fef871c1fa44d#quot;)"
    string(0-128) name "(ie. #quot;Agro Testing#quot;)"
    string startDate "(ie. #quot;2023-03-23T11:29:31.077Z#quot;)"
    integer year "(ie. 2023)"
    string(0-256) description ""
    string status "(IN_CONFIGURATION, PLANNED, USED)(ie. #quot;IN_CONFIGURATION#quot;)"
    string[] organization "(ie. [[#quot;Organization1#quot;,#quot;VMK#quot;],[#quot;Organization2#quot;]])"
    string[] species "(ie. [[#quot;Vegetable#quot;,#quot;Tomato#quot;]])"
    string[] geography "(ie. [[#quot;FR#quot;,#quot;NICE#quot;],[#quot;ES#quot;]])"
    string experimentSourceId "(ie. #quot;640333d44a4fef871c1fa44d#quot;)"
    string taskSourceId "(ie. #quot;640333d44a4fef871c1fa44d#quot;)"
    string originMCPId "(ie. #quot;640333d44a4fef871c1fa44d#quot;)"
  }
  GenotypeGroupDto }o--|| ExperimentSourceDto : "references through experimentSourceId"
  GenotypeGroupDto }o--|| TaskSourceDto : "references through taskSourceId"
  GenotypeGroupDto }o--|| OriginMCPDto : "references through originMCPId"
  GenotypeGroupElementDto {
    string _id "(ie. #quot;640333d44a4fef871c1fa44d#quot;)"
    string genotypeGroupId "(ie. #quot;65d2f7c12a4a3c0012e3b456#quot;)"
    string genotypeId "(ie. #quot;65d2f7c12a4a3c0012e3b789#quot;)"
    string[] lotIds "(ie. [#quot;lotId1#quot;,#quot;lotId2#quot;,#quot;lotId3#quot;])"
  }
  GenotypeGroupElementDto }o--|| GenotypeGroupDto : "references through genotypeGroupId"
  GenotypeGroupElementDto }o--|| GenotypeDto : "references through genotypeId"
  GenotypeGroupElementDto ||--o{ LotDto : "references through lotIds"
  MCPDto {
    string _id "(ie. #quot;640333d44a4fef871c1fa44d#quot;)"
    string mcpId "(ie. #quot;507f1f77bcf86cd799439011#quot;)"
    string name "(ie. #quot;MCP Alpha#quot;)"
    string description "(ie. #quot;MCP used for early generation codification#quot;)"
    string materialType ""
    string crossType "(synthetic, simple cross, back cross, double haploid, self cross, half sib, individualization, clone, none)"
    string harvestLevel "(treatment, sub plot, plot)"
    string genotypeCodification "(genotypeUniversal1, doNotGenerate)"
    string materialGenotypeCreationRule "(create, skip)"
    string materialResearchCodeRule "(empty, same_as_female)"
    string materialVarietyNameRule "(empty, same_as_female)"
    string materialCultivarCodeRule "(empty, same_as_female)"
    string materialAlternateNameRule "(empty, same_as_female)"
    string materialFamilyCodeRule "(empty, same_as_female)"
    string materialOtherGroupingColumnRule "(empty, same_as_female)"
    string materialLinkingIdentifierRule "(use_genotype_name, same_as_female, do_not_generate)"
    string materialLinkingIdentifier1Rule "(empty, same_as_female)"
    string materialLinkingIdentifier2Rule "(empty, same_as_female)"
    string materialLinkingIdentifier3Rule "(empty, same_as_female)"
    string materialLinkingIdentifier4Rule "(empty, same_as_female)"
    string materialLinkingIdentifier5Rule "(empty, same_as_female)"
    string materialSourceRule "(internal, same_as_female)"
    string materialGenerationRule "(one, female_plus_one, same_as_female, do_not_generate)"
    string materialConsecutiveSelfRule "(zero, female_plus_one, do_not_generate)"
    string materialFixityRule "(fixed, not_fixed, same_as_female, do_not_generate)"
    string materialPedigreeRule "(empty, same_as_female)"
    string materialDirectParentageRule "(empty, same_as_female)"
    string materialGeneticGroup1Rule "(empty, same_as_female)"
    string materialGeneticGroup2Rule "(empty, same_as_female)"
    string materialStageRule "(same_as_female, first_value_of_associated_picklists)"
    string materialStagePickListTarget ""
    string materialCountryOfRegistrationRule "(empty, same_as_female)"
    string materialYearOfRegistrationRule "(empty, same_as_female)"
    string materialEndophyteNameRule "(empty, same_as_female)"
    string materialProgramRule "(from_experiment, same_as_female, empty)"
    string materialStartingCrossGenotypeNameRule "(use_genotype_name, same_as_female, empty)"
    string lotCodification "(lotUniversal1, lotUniversal2, lotUniversal3)"
    string lotNatureRule "(planted material, seeds, cutting, plants, same_as_female)"
    string lotNameRule "(empty, same_as_female)"
    string lotAlternateNameRule "(empty, same_as_female)"
    string lotDescriptionRule "(empty, same_as_female)"
    string lotLocationRule "(empty, same_as_female)"
    string lotLinkingIdentifierRule "(empty, same_as_female)"
    string lotLinkingIdentifier1Rule "(empty, same_as_female)"
    string lotLinkingIdentifier2Rule "(empty, same_as_female)"
    string lotLinkingIdentifier3Rule "(empty, same_as_female)"
    string lotLinkingIdentifier4Rule "(empty, same_as_female)"
    string lotLinkingIdentifier5Rule "(empty, same_as_female)"
    string lotPackagingRule "(empty, same_as_female)"
    string lotSourceRule "(internal, external, same_as_female)"
    string lotGenerationRule "(one, female_plus_one, same_as_female)"
    string lotStageRule "(empty, same_as_female, one, first_value_of_associated_picklists)"
    string lotStagePickListTarget ""
    string lotGerminativeFacultyRule "(empty)"
    string lotQualityRule "(empty)"
    string lotLocationTypeRule "(empty)"
    string lotStorageConditionRule "(empty)"
    string lotEndophyteRule "(empty, same_as_female)"
  }
  MCPDto }o--|| McpDto : "references through mcpId"
  ProductDTO {
    string _id "(ie. #quot;5fc7abd14a0cce5298abf37e#quot;)"
    string(0-64) name "(ie. #quot;CO05HY0001#quot;)"
    string(0-64) officialName "(ie. #quot;CO05HY0001#quot;)"
    string(0-64) alternateName "(ie. #quot;CO05#quot;)"
    array[] organization "(ie. [[#quot;Organization1#quot;,#quot;VMK#quot;],[#quot;Organization2#quot;]])"
    array[] species "(ie. [[#quot;Vege#quot;,#quot;Tomato#quot;]])"
    MarketSegmentSelectionDto[] marketSegmentSelection ""
    boolean isControl "(ie. true)"
    string(0-64) ownership "(ie. #quot;wiki#quot;)"
    string companyName "(ie. #quot;Doriane#quot;)"
    string(0-64) externalId "(ie. #quot;C0001#quot;)"
    string(0-2048) comments "(ie. #quot;A comment#quot;)"
    string(0-64) label "(ie. #quot;Nh3#quot;)"
    string(0-64) formulation "(ie. #quot;O2#quot;)"
    string(0-32) formulationUnit "(ie. #quot;ml#quot;)"
    array[] sharedWith "(ie. [[#quot;Organization1#quot;,#quot;VMK#quot;],[#quot;Organization2#quot;]])"
    boolean homologation "(ie. true)"
  }
  ProductDTO }o--|| MarketSegmentSelectionDto : "has"
  ProductDTO }o--|| ExternalDto : "references through externalId"
  OtherFactorModalityDto {
    string _id "(ie. #quot;5fc7abd14a0cce5298abf37e#quot;)"
    string(0-64) name "(ie. #quot;Irrigation#quot;)"
    string(0-256) externalId "(ie. #quot;C0001#quot;)"
    string(0-256) description "(ie. #quot;Modality irrigation#quot;)"
    boolean isControl "(ie. true)"
  }
  OtherFactorModalityDto }o--|| ExternalDto : "references through externalId"
  OtherFactorDto {
    string _id "(ie. #quot;5fc7abd14a0cce5298abf37e#quot;)"
    string(0-64) name "(ie. #quot;Irrigation#quot;)"
    string(0-3) code "(ie. #quot;IRR#quot;)"
    string(0-256) description "(ie. #quot;Irrigation.#quot;)"
    string[] tagIds "(ie. [#quot;agro#quot;,#quot;field#quot;])"
    OtherFactorModalityDto[] modalities ""
  }
  OtherFactorDto }o--|| OtherFactorModalityDto : "has"
  PortfolioPaginatedDto {
    string _id "(ie. #quot;640333d44a4fef871c1fa44d#quot;)"
    string name "(ie. #quot;Agro Portfolio 2025#quot;)"
    string(0-256) description ""
    string startDate "(ie. #quot;2025-01-01T00:00:00.000Z#quot;)"
    string endDate "(ie. #quot;2025-12-31T00:00:00.000Z#quot;)"
    string[] organization "(ie. [[#quot;Organization1#quot;,#quot;VMK#quot;],[#quot;Organization2#quot;]])"
    string[] species "(ie. [[#quot;Vegetable#quot;,#quot;Tomato#quot;]])"
    string[] geography "(ie. [[#quot;FR#quot;,#quot;NICE#quot;],[#quot;ES#quot;]])"
    number variablesCount "(ie. 10)"
    number genotypesCount "(ie. 10)"
  }
  PortfolioVariableDto {
    string _id "(ie. #quot;640333d44a4fef871c1fa44d#quot;)"
    string portfolioId "(ie. #quot;65d2f7c12a4a3c0012e3b456#quot;)"
    string variableId "(ie. #quot;65d2f7c12a4a3c0012e3b789#quot;)"
  }
  PortfolioVariableDto }o--|| PortfolioDto : "references through portfolioId"
  PortfolioVariableDto }o--|| VariableCoreDto : "references through variableId"
  PortfolioGenotypeDto {
    string _id "(ie. #quot;640333d44a4fef871c1fa44d#quot;)"
    string portfolioId "(ie. #quot;65d2f7c12a4a3c0012e3b456#quot;)"
    string genotypeId "(ie. #quot;65d2f7c12a4a3c0012e3b789#quot;)"
  }
  PortfolioGenotypeDto }o--|| PortfolioDto : "references through portfolioId"
  PortfolioGenotypeDto }o--|| GenotypeDto : "references through genotypeId"
  PortfolioDto {
    string _id "(ie. #quot;640333d44a4fef871c1fa44d#quot;)"
    string name "(ie. #quot;Agro Portfolio 2025#quot;)"
    string(0-256) description ""
    string startDate "(ie. #quot;2025-01-01T00:00:00.000Z#quot;)"
    string endDate "(ie. #quot;2025-12-31T00:00:00.000Z#quot;)"
    string[] organization "(ie. [[#quot;Organization1#quot;,#quot;VMK#quot;],[#quot;Organization2#quot;]])"
    string[] species "(ie. [[#quot;Vegetable#quot;,#quot;Tomato#quot;]])"
    string[] geography "(ie. [[#quot;FR#quot;,#quot;NICE#quot;],[#quot;ES#quot;]])"
    PortfolioVariableDto[] variables ""
    PortfolioGenotypeDto[] genotypes ""
  }
  PortfolioDto }o--|| PortfolioVariableDto : "has"
  PortfolioDto }o--|| PortfolioGenotypeDto : "has"
  PortfolioNotationDto {
    string _id "(ie. #quot;640333d44a4fef871c1fa44d#quot;)"
    string portfolioId "(ie. #quot;65d2f7c12a4a3c0012e3b111#quot;)"
    string genotypeId "(ie. #quot;65d2f7c12a4a3c0012e3b456#quot;)"
    string variableId "(ie. #quot;65d2f7c12a4a3c0012e3b789#quot;)"
    string notationDate "(ie. #quot;2023-03-23T11:29:31.077Z#quot;)"
    object value "(ie. 2)"
  }
  PortfolioNotationDto }o--|| PortfolioDto : "references through portfolioId"
  PortfolioNotationDto }o--|| GenotypeDto : "references through genotypeId"
  PortfolioNotationDto }o--|| VariableCoreDto : "references through variableId"
  PortfolioNotationUsageDto {
    string[] genotypeIds "(ie. [#quot;65d2f7c12a4a3c0012e3b111#quot;])"
    string[] variableIds "(ie. [#quot;65d2f7c12a4a3c0012e3b222#quot;])"
  }
  PortfolioNotationUsageDto ||--o{ GenotypeDto : "references through genotypeIds"
  PortfolioNotationUsageDto ||--o{ VariableCoreDto : "references through variableIds"

Growing Area

erDiagram

Attachment

erDiagram
  ResourceDto {
    string _id "(ie. #quot;640333d44a4fef871c1fa44d#quot;)"
    string assetId "(ie. #quot;5fc7abd14a0cce5298abf37e#quot;)"
    string publicId "(ie. #quot;sample_image#quot;)"
    string resourceType "(AUTO, IMAGE, VIDEO, RAW)(ie. #quot;IMAGE#quot;)"
    string resourceSrc "(NOTATION, ATTACHMENT, COMMENT)(ie. #quot;NOTATION#quot;)"
    string[] tags "(ie. [#quot;tomato#quot;])"
    boolean like "(ie. true)"
    string commentary "(ie. #quot;this is a commentary....#quot;)"
    array[] species "(ie. [[#quot;Vegetable#quot;,#quot;Tomato#quot;]])"
    array[] geography "(ie. [[#quot;FR#quot;,#quot;NICE#quot;],[#quot;ES#quot;]])"
    array[] organization "(ie. [[#quot;Organization1#quot;,#quot;VMK#quot;],[#quot;Organization2#quot;]])"
    string fileName "(ie. #quot;sample_image.jpg#quot;)"
    string fileType "(ie. #quot;image/jpeg#quot;)"
    string base64Thumbnail ""
    string localUrl ""
    string url ""
  }
  ResourceDto }o--|| ExternalAssetSystem : "references through assetId"
  ResourceTagDto {
    string _id "(ie. #quot;640333d44a4fef871c1fa44d#quot;)"
    string sourceId "(ie. #quot;5fc7abd14a0cce5298abf37e#quot;)"
    string type "(DEFAULT, TRIAL, MET, MATERIAL, VARIABLE)(ie. #quot;TRIAL#quot;)"
    string[] resourceIds "(ie. #quot;[5fc7abd14a0cce5298abf37e]#quot;)"
    string value "(ie. #quot;templateTagName#quot;)"
  }
  ResourceTagDto }o--|| TrialDto_MetDto_GenotypeDto_ProductDto_variable_Dto : "references through sourceId"
  ResourceTagDto ||--o{ ResourceDto : "references through resourceIds"

User

erDiagram
  PermissionProfileDTO {
    string roleId "(ie. #quot;633bdc8b2fc27dab54f80108#quot;)"
    object abac ""
  }
  PermissionProfileDTO }o--|| RoleDto : "references through roleId"
  UserDto {
    string id "(ie. #quot;12351166-ef12-1234-abcd-456ffac55452#quot;)"
    string(1-64) firstName "(ie. #quot;John#quot;)"
    string(1-64) lastName "(ie. #quot;Snow#quot;)"
    string(1-128) mail "(ie. #quot;contact@doriane.com#quot;)"
    string color "(ie. #quot;#666fff#quot;)"
    string tenantId "(ie. #quot;633bdc8b2fc27dab54f80108#quot;)"
    PermissionProfileDTO permissionProfile ""
    boolean ssoUser ""
    boolean deactivated ""
    string userType "(human, machine)(ie. #quot;human#quot;)"
  }
  UserDto }o--|| PermissionProfileDTO : "has"
  RoleDto {
    string _id "(ie. #quot;640333d44a4fef871c1fa44d#quot;)"
    string name ""
    string[] permissions ""
    boolean isCustom ""
    string baseRoleId "(ie. #quot;000000000000000000000001#quot;)"
  }
  DeactivateUserStatusDto {
    boolean deactivated "(ie. true)"
  }
  ServiceAccountDto {
    string serviceAccountId ""
    string tenantId ""
    string name ""
    string description ""
    string clientId ""
    string userId ""
    object permissionProfile ""
    object systemMetadata ""
  }
  ServiceAccountDto }o--|| ServiceAccountDto : "references through serviceAccountId"
  ServiceAccountDto }o--|| ClientDto : "references through clientId"
  ServiceAccountDto }o--|| UserDto : "references through userId"