tables.yml

---
account_balances:
  account_id:
    type: integer
    references: account
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  currency:
    type: string
    required: true
  financial_year_id:
    type: integer
    references: financial_year
    required: true
  global_balance:
    type: decimal
    precision: 19
    scale: 4
    required: true
  global_count:
    type: integer
    required: true
  global_credit:
    type: decimal
    precision: 19
    scale: 4
    required: true
  global_debit:
    type: decimal
    precision: 19
    scale: 4
    required: true
  id:
    type: integer
    required: true
  local_balance:
    type: decimal
    precision: 19
    scale: 4
    required: true
  local_count:
    type: integer
    required: true
  local_credit:
    type: decimal
    precision: 19
    scale: 4
    required: true
  local_debit:
    type: decimal
    precision: 19
    scale: 4
    required: true
  lock_version:
    type: integer
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
accounts:
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  custom_fields:
    type: jsonb
  debtor:
    type: boolean
    required: true
    default: false
  description:
    type: text
  id:
    type: integer
    required: true
  label:
    type: string
    required: true
  last_letter:
    type: string
  lock_version:
    type: integer
    required: true
  name:
    type: string
    required: true
  number:
    type: string
    required: true
  reconcilable:
    type: boolean
    required: true
    default: false
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
  usages:
    type: text
activities:
  codes:
    type: jsonb
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  cultivation_variety:
    type: string
  custom_fields:
    type: jsonb
  description:
    type: text
  family:
    type: string
    required: true
  grading_net_mass_unit_name:
    type: string
  grading_sizes_indicator_name:
    type: string
  grading_sizes_unit_name:
    type: string
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  measure_grading_items_count:
    type: boolean
    required: true
    default: false
  measure_grading_net_mass:
    type: boolean
    required: true
    default: false
  measure_grading_sizes:
    type: boolean
    required: true
    default: false
  name:
    type: string
    required: true
  nature:
    type: string
    required: true
  production_campaign:
    type: string
  production_cycle:
    type: string
    required: true
  production_system_name:
    type: string
  size_indicator_name:
    type: string
  size_unit_name:
    type: string
  support_variety:
    type: string
  suspended:
    type: boolean
    required: true
    default: false
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
  use_countings:
    type: boolean
    required: true
    default: false
  use_gradings:
    type: boolean
    required: true
    default: false
  use_seasons:
    type: boolean
    default: false
  use_tactics:
    type: boolean
    default: false
  with_cultivation:
    type: boolean
    required: true
  with_supports:
    type: boolean
    required: true
activity_budget_items:
  activity_budget_id:
    type: integer
    references: activity_budget
    required: true
  amount:
    type: decimal
    precision: 19
    scale: 4
  computation_method:
    type: string
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  currency:
    type: string
    required: true
  direction:
    type: string
    required: true
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  quantity:
    type: decimal
    precision: 19
    scale: 4
  unit_amount:
    type: decimal
    precision: 19
    scale: 4
  unit_currency:
    type: string
    required: true
  unit_population:
    type: decimal
    precision: 19
    scale: 4
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
  variant_id:
    type: integer
    references: product_nature_variant
  variant_indicator:
    type: string
  variant_unit:
    type: string
activity_budgets:
  activity_id:
    type: integer
    references: activity
    required: true
  campaign_id:
    type: integer
    references: campaign
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  currency:
    type: string
    required: true
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
activity_distributions:
  activity_id:
    type: integer
    references: activity
    required: true
  affectation_percentage:
    type: decimal
    precision: 19
    scale: 4
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  main_activity_id:
    type: integer
    references: activity
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
activity_inspection_calibration_natures:
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  marketable:
    type: boolean
    required: true
    default: false
  maximal_value:
    type: decimal
    precision: 19
    scale: 4
    required: true
  minimal_value:
    type: decimal
    precision: 19
    scale: 4
    required: true
  scale_id:
    type: integer
    references: activity_inspection_calibration_scale
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
activity_inspection_calibration_scales:
  activity_id:
    type: integer
    references: activity
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  size_indicator_name:
    type: string
    required: true
  size_unit_name:
    type: string
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
activity_inspection_point_natures:
  activity_id:
    type: integer
    references: activity
    required: true
  category:
    type: string
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  name:
    type: string
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
activity_productions:
  activity_id:
    type: integer
    references: activity
    required: true
  campaign_id:
    type: integer
    references: campaign
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  cultivable_zone_id:
    type: integer
    references: cultivable_zone
  custom_fields:
    type: jsonb
  id:
    type: integer
    required: true
  irrigated:
    type: boolean
    required: true
    default: false
  lock_version:
    type: integer
    required: true
  nitrate_fixing:
    type: boolean
    required: true
    default: false
  rank_number:
    type: integer
    required: true
  season_id:
    type: integer
    references: activity_season
  size_indicator_name:
    type: string
    required: true
  size_unit_name:
    type: string
  size_value:
    type: decimal
    precision: 19
    scale: 4
    required: true
  started_on:
    type: date
  state:
    type: string
  stopped_on:
    type: date
  support_id:
    type: integer
    references: product
    required: true
  support_nature:
    type: string
  support_shape:
    type: geometry
    limit:
      srid: 4326
      type: multi_polygon
  tactic_id:
    type: integer
    references: activity_tactic
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
  usage:
    type: string
    required: true
activity_seasons:
  activity_id:
    type: integer
    references: activity
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  name:
    type: string
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
activity_tactics:
  activity_id:
    type: integer
    references: activity
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  mode:
    type: string
  mode_delta:
    type: integer
  name:
    type: string
    required: true
  planned_on:
    type: date
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
affairs:
  accounted_at:
    type: datetime
  cash_session_id:
    type: integer
    references: cash_session
  closed:
    type: boolean
    required: true
    default: false
  closed_at:
    type: datetime
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  credit:
    type: decimal
    precision: 19
    scale: 4
    required: true
  currency:
    type: string
    required: true
  dead_line_at:
    type: datetime
  deals_count:
    type: integer
    required: true
  debit:
    type: decimal
    precision: 19
    scale: 4
    required: true
  description:
    type: text
  id:
    type: integer
    required: true
  journal_entry_id:
    type: integer
    references: journal_entry
  letter:
    type: string
  lock_version:
    type: integer
    required: true
  name:
    type: string
  number:
    type: string
  origin:
    type: string
  pretax_amount:
    type: decimal
    precision: 19
    scale: 4
  probability_percentage:
    type: decimal
    precision: 19
    scale: 4
  responsible_id:
    type: integer
    references: entity
  state:
    type: string
  third_id:
    type: integer
    references: entity
    required: true
  type:
    type: string
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
alert_phases:
  alert_id:
    type: integer
    references: alert
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  id:
    type: integer
    required: true
  level:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  started_at:
    type: datetime
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
alerts:
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  nature:
    type: string
    required: true
  sensor_id:
    type: integer
    references: sensor
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
analyses:
  analysed_at:
    type: datetime
  analyser_id:
    type: integer
    references: entity
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  custom_fields:
    type: jsonb
  description:
    type: text
  geolocation:
    type: geometry
    limit:
      srid: 4326
      type: st_point
  host_id:
    type: integer
    references: product
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  nature:
    type: string
    required: true
  number:
    type: string
    required: true
  product_id:
    type: integer
    references: product
  reference_number:
    type: string
  retrieval_message:
    type: string
  retrieval_status:
    type: string
    required: true
    default: ok
  sampled_at:
    type: datetime
    required: true
  sampler_id:
    type: integer
    references: entity
  sampling_temporal_mode:
    type: string
    required: true
    default: instant
  sensor_id:
    type: integer
    references: sensor
  stopped_at:
    type: datetime
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
analysis_items:
  absolute_measure_value_unit:
    type: string
  absolute_measure_value_value:
    type: decimal
    precision: 19
    scale: 4
  analysis_id:
    type: integer
    references: analysis
    required: true
  annotation:
    type: text
  boolean_value:
    type: boolean
    required: true
    default: false
  choice_value:
    type: string
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  decimal_value:
    type: decimal
    precision: 19
    scale: 4
  geometry_value:
    type: geometry
    limit:
      srid: 4326
      type: geometry
  id:
    type: integer
    required: true
  indicator_datatype:
    type: string
    required: true
  indicator_name:
    type: string
    required: true
  integer_value:
    type: integer
  lock_version:
    type: integer
    required: true
  measure_value_unit:
    type: string
  measure_value_value:
    type: decimal
    precision: 19
    scale: 4
  multi_polygon_value:
    type: geometry
    limit:
      srid: 4326
      type: multi_polygon
  point_value:
    type: geometry
    limit:
      srid: 4326
      type: st_point
  product_reading_id:
    type: integer
    references: product_reading
  string_value:
    type: text
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
attachments:
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  document_id:
    type: integer
    references: document
    required: true
  expired_at:
    type: datetime
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  nature:
    type: string
  resource_id:
    type: integer
    references: "~resource_type"
    required: true
  resource_type:
    type: string
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
bank_statement_items:
  bank_statement_id:
    type: integer
    references: bank_statement
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  credit:
    type: decimal
    precision: 19
    scale: 4
    required: true
  currency:
    type: string
    required: true
  debit:
    type: decimal
    precision: 19
    scale: 4
    required: true
  id:
    type: integer
    required: true
  initiated_on:
    type: date
  letter:
    type: string
  lock_version:
    type: integer
    required: true
  memo:
    type: string
  name:
    type: string
    required: true
  transaction_number:
    type: string
  transfered_on:
    type: date
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
bank_statements:
  accounted_at:
    type: datetime
  cash_id:
    type: integer
    references: cash
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  credit:
    type: decimal
    precision: 19
    scale: 4
    required: true
  currency:
    type: string
    required: true
  custom_fields:
    type: jsonb
  debit:
    type: decimal
    precision: 19
    scale: 4
    required: true
  id:
    type: integer
    required: true
  initial_balance_credit:
    type: decimal
    precision: 19
    scale: 4
    required: true
  initial_balance_debit:
    type: decimal
    precision: 19
    scale: 4
    required: true
  journal_entry_id:
    type: integer
    references: journal_entry
  lock_version:
    type: integer
    required: true
  number:
    type: string
    required: true
  started_on:
    type: date
    required: true
  stopped_on:
    type: date
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
call_messages:
  body:
    type: text
  call_id:
    type: integer
    references: call
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  format:
    type: string
  headers:
    type: text
  id:
    type: integer
    required: true
  ip_address:
    type: string
  lock_version:
    type: integer
    required: true
  nature:
    type: string
    required: true
  request_id:
    type: integer
    references: call_request
  ssl:
    type: string
  status:
    type: string
  type:
    type: string
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
  url:
    type: string
  verb:
    type: string
calls:
  arguments:
    type: jsonb
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  id:
    type: integer
    required: true
  integration_name:
    type: string
  lock_version:
    type: integer
    required: true
  name:
    type: string
  source_id:
    type: integer
    references: "~source_type"
  source_type:
    type: string
  state:
    type: string
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
campaigns:
  closed:
    type: boolean
    required: true
    default: false
  closed_at:
    type: datetime
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  description:
    type: text
  harvest_year:
    type: integer
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  name:
    type: string
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
cap_islets:
  cap_statement_id:
    type: integer
    references: cap_statement
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  id:
    type: integer
    required: true
  islet_number:
    type: string
    required: true
  lock_version:
    type: integer
    required: true
  shape:
    type: geometry
    limit:
      srid: 4326
      type: multi_polygon
    required: true
  town_number:
    type: string
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
cap_land_parcels:
  cap_islet_id:
    type: integer
    references: cap_islet
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  id:
    type: integer
    required: true
  land_parcel_number:
    type: string
    required: true
  lock_version:
    type: integer
    required: true
  main_crop_code:
    type: string
    required: true
  main_crop_commercialisation:
    type: boolean
    required: true
    default: false
  main_crop_precision:
    type: string
  main_crop_seed_production:
    type: boolean
    required: true
    default: false
  shape:
    type: geometry
    limit:
      srid: 4326
      type: multi_polygon
    required: true
  support_id:
    type: integer
    references: activity_production
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
cap_statements:
  campaign_id:
    type: integer
    references: campaign
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  declarant_id:
    type: integer
    references: entity
  farm_name:
    type: string
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  pacage_number:
    type: string
  siret_number:
    type: string
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
cash_sessions:
  cash_id:
    type: integer
    references: cash
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  currency:
    type: string
  expected_stop_amount:
    type: decimal
    precision: 19
    scale: 4
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  noticed_start_amount:
    type: decimal
    precision: 19
    scale: 4
  noticed_stop_amount:
    type: decimal
    precision: 19
    scale: 4
  number:
    type: string
  started_at:
    type: datetime
    required: true
  stopped_at:
    type: datetime
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
cash_transfers:
  accounted_at:
    type: datetime
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  currency_rate:
    type: decimal
    precision: 19
    scale: 10
    required: true
  custom_fields:
    type: jsonb
  description:
    type: text
  emission_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  emission_cash_id:
    type: integer
    references: cash
    required: true
  emission_currency:
    type: string
    required: true
  emission_journal_entry_id:
    type: integer
    references: journal_entry
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  number:
    type: string
    required: true
  reception_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  reception_cash_id:
    type: integer
    references: cash
    required: true
  reception_currency:
    type: string
    required: true
  reception_journal_entry_id:
    type: integer
    references: journal_entry
  transfered_at:
    type: datetime
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
cashes:
  bank_account_holder_name:
    type: string
  bank_account_key:
    type: string
  bank_account_number:
    type: string
  bank_agency_address:
    type: text
  bank_agency_code:
    type: string
  bank_code:
    type: string
  bank_identifier_code:
    type: string
  bank_name:
    type: string
  container_id:
    type: integer
    references: product
  country:
    type: string
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  currency:
    type: string
    required: true
  custom_fields:
    type: jsonb
  iban:
    type: string
  id:
    type: integer
    required: true
  journal_id:
    type: integer
    references: journal
    required: true
  last_number:
    type: integer
  lock_version:
    type: integer
    required: true
  main_account_id:
    type: integer
    references: account
    required: true
  mode:
    type: string
    required: true
    default: iban
  name:
    type: string
    required: true
  nature:
    type: string
    required: true
    default: bank_account
  owner_id:
    type: integer
    references: entity
  spaced_iban:
    type: string
  suspend_until_reconciliation:
    type: boolean
    required: true
    default: false
  suspense_account_id:
    type: integer
    references: account
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
catalog_items:
  all_taxes_included:
    type: boolean
    required: true
    default: false
  amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  catalog_id:
    type: integer
    references: catalog
    required: true
  commercial_description:
    type: text
  commercial_name:
    type: string
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  currency:
    type: string
    required: true
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  name:
    type: string
    required: true
  reference_tax_id:
    type: integer
    references: tax
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
  variant_id:
    type: integer
    references: product_nature_variant
    required: true
catalogs:
  all_taxes_included:
    type: boolean
    required: true
    default: false
  by_default:
    type: boolean
    required: true
    default: false
  code:
    type: string
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  currency:
    type: string
    required: true
  description:
    type: text
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  name:
    type: string
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
  usage:
    type: string
    required: true
contract_items:
  contract_id:
    type: integer
    references: contract
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  pretax_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  quantity:
    type: decimal
    precision: 19
    scale: 4
    required: true
  unit_pretax_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
  variant_id:
    type: integer
    references: product_nature_variant
    required: true
contracts:
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  currency:
    type: string
    required: true
  custom_fields:
    type: jsonb
  description:
    type: string
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  number:
    type: string
  pretax_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  reference_number:
    type: string
  responsible_id:
    type: integer
    references: user
    required: true
  started_on:
    type: date
  state:
    type: string
  stopped_on:
    type: date
  supplier_id:
    type: integer
    references: entity
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
crumbs:
  accuracy:
    type: decimal
    precision: 19
    scale: 4
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  device_uid:
    type: string
    required: true
  geolocation:
    type: geometry
    limit:
      srid: 4326
      type: st_point
    required: true
  id:
    type: integer
    required: true
  intervention_parameter_id:
    type: integer
    references: intervention_parameter
  intervention_participation_id:
    type: integer
    references: intervention_participation
  lock_version:
    type: integer
    required: true
  metadata:
    type: text
  nature:
    type: string
    required: true
  read_at:
    type: datetime
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
  user_id:
    type: integer
    references: user
cultivable_zones:
  codes:
    type: jsonb
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  custom_fields:
    type: jsonb
  description:
    type: text
  farmer_id:
    type: integer
    references: entity
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  name:
    type: string
    required: true
  owner_id:
    type: integer
    references: entity
  production_system_name:
    type: string
  shape:
    type: geometry
    limit:
      srid: 4326
      type: multi_polygon
    required: true
  soil_nature:
    type: string
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
  uuid:
    type: uuid
  work_number:
    type: string
    required: true
custom_field_choices:
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  custom_field_id:
    type: integer
    references: custom_field
    required: true
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  name:
    type: string
    required: true
  position:
    type: integer
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
  value:
    type: string
custom_fields:
  active:
    type: boolean
    required: true
    default: true
  column_name:
    type: string
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  customized_type:
    type: string
    required: true
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  maximal_length:
    type: integer
  maximal_value:
    type: decimal
    precision: 19
    scale: 4
  minimal_length:
    type: integer
  minimal_value:
    type: decimal
    precision: 19
    scale: 4
  name:
    type: string
    required: true
  nature:
    type: string
    required: true
  position:
    type: integer
  required:
    type: boolean
    required: true
    default: false
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
dashboards:
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  description:
    type: text
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  name:
    type: string
    required: true
  owner_id:
    type: integer
    references: user
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
debt_transfers:
  accounted_at:
    type: datetime
  affair_id:
    type: integer
    references: affair
    required: true
  amount:
    type: decimal
    precision: 19
    scale: 4
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  currency:
    type: string
    required: true
  debt_transfer_affair_id:
    type: integer
    references: affair
    required: true
  id:
    type: integer
    required: true
  journal_entry_id:
    type: integer
    references: journal_entry
  lock_version:
    type: integer
    required: true
  nature:
    type: string
    required: true
  number:
    type: string
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
deliveries:
  annotation:
    type: text
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  custom_fields:
    type: jsonb
  driver_id:
    type: integer
    references: entity
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  mode:
    type: string
  number:
    type: string
  reference_number:
    type: string
  responsible_id:
    type: integer
    references: entity
  started_at:
    type: datetime
  state:
    type: string
    required: true
  stopped_at:
    type: datetime
  transporter_id:
    type: integer
    references: entity
  transporter_purchase_id:
    type: integer
    references: purchase
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
delivery_tools:
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  delivery_id:
    type: integer
    references: delivery
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  tool_id:
    type: integer
    references: product
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
deposits:
  accounted_at:
    type: datetime
  amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  cash_id:
    type: integer
    references: cash
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  custom_fields:
    type: jsonb
  description:
    type: text
  id:
    type: integer
    required: true
  journal_entry_id:
    type: integer
    references: journal_entry
  lock_version:
    type: integer
    required: true
  locked:
    type: boolean
    required: true
    default: false
  mode_id:
    type: integer
    references: incoming_payment_mode
    required: true
  number:
    type: string
    required: true
  payments_count:
    type: integer
    required: true
  responsible_id:
    type: integer
    references: entity
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
districts:
  code:
    type: string
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  name:
    type: string
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
document_templates:
  active:
    type: boolean
    required: true
    default: false
  archiving:
    type: string
    required: true
  by_default:
    type: boolean
    required: true
    default: false
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  formats:
    type: string
  id:
    type: integer
    required: true
  language:
    type: string
    required: true
  lock_version:
    type: integer
    required: true
  managed:
    type: boolean
    required: true
    default: false
  name:
    type: string
    required: true
  nature:
    type: string
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
documents:
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  custom_fields:
    type: jsonb
  file_content_text:
    type: text
  file_content_type:
    type: string
  file_file_name:
    type: string
  file_file_size:
    type: integer
  file_fingerprint:
    type: string
  file_pages_count:
    type: integer
  file_updated_at:
    type: datetime
  id:
    type: integer
    required: true
  key:
    type: string
    required: true
  lock_version:
    type: integer
    required: true
  name:
    type: string
    required: true
  nature:
    type: string
  number:
    type: string
    required: true
  template_id:
    type: integer
    references: document_template
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
  uploaded:
    type: boolean
    required: true
    default: false
entities:
  active:
    type: boolean
    required: true
    default: true
  activity_code:
    type: string
  authorized_payments_count:
    type: integer
  bank_account_holder_name:
    type: string
  bank_identifier_code:
    type: string
  born_at:
    type: datetime
  client:
    type: boolean
    required: true
    default: false
  client_account_id:
    type: integer
    references: account
  codes:
    type: jsonb
  country:
    type: string
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  currency:
    type: string
    required: true
  custom_fields:
    type: jsonb
  dead_at:
    type: datetime
  deliveries_conditions:
    type: string
  description:
    type: text
  employee:
    type: boolean
    required: true
    default: false
  employee_account_id:
    type: integer
    references: account
  first_met_at:
    type: datetime
  first_name:
    type: string
  full_name:
    type: string
    required: true
  iban:
    type: string
  id:
    type: integer
    required: true
  language:
    type: string
    required: true
  last_name:
    type: string
    required: true
  lock_version:
    type: integer
    required: true
  locked:
    type: boolean
    required: true
    default: false
  meeting_origin:
    type: string
  nature:
    type: string
    required: true
  number:
    type: string
  of_company:
    type: boolean
    required: true
    default: false
  picture_content_type:
    type: string
  picture_file_name:
    type: string
  picture_file_size:
    type: integer
  picture_updated_at:
    type: datetime
  proposer_id:
    type: integer
    references: entity
  prospect:
    type: boolean
    required: true
    default: false
  reminder_submissive:
    type: boolean
    required: true
    default: false
  responsible_id:
    type: integer
    references: user
  siret_number:
    type: string
  supplier:
    type: boolean
    required: true
    default: false
  supplier_account_id:
    type: integer
    references: account
  supplier_payment_delay:
    type: string
  supplier_payment_mode_id:
    type: integer
    references: outgoing_payment_mode
  title:
    type: string
  transporter:
    type: boolean
    required: true
    default: false
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
  vat_number:
    type: string
  vat_subjected:
    type: boolean
    required: true
    default: true
entity_addresses:
  by_default:
    type: boolean
    required: true
    default: false
  canal:
    type: string
    required: true
  coordinate:
    type: string
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  deleted_at:
    type: datetime
  entity_id:
    type: integer
    references: entity
    required: true
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  mail_auto_update:
    type: boolean
    required: true
    default: false
  mail_country:
    type: string
  mail_geolocation:
    type: geometry
    limit:
      srid: 4326
      type: st_point
  mail_line_1:
    type: string
  mail_line_2:
    type: string
  mail_line_3:
    type: string
  mail_line_4:
    type: string
  mail_line_5:
    type: string
  mail_line_6:
    type: string
  mail_postal_zone_id:
    type: integer
    references: postal_zone
  name:
    type: string
  thread:
    type: string
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
entity_links:
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  description:
    type: text
  entity_id:
    type: integer
    references: entity
    required: true
  entity_role:
    type: string
    required: true
  id:
    type: integer
    required: true
  linked_id:
    type: integer
    references: entity
    required: true
  linked_role:
    type: string
    required: true
  lock_version:
    type: integer
    required: true
  main:
    type: boolean
    required: true
    default: false
  nature:
    type: string
    required: true
  post:
    type: string
  started_at:
    type: datetime
  stopped_at:
    type: datetime
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
event_participations:
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  event_id:
    type: integer
    references: event
    required: true
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  participant_id:
    type: integer
    references: entity
    required: true
  state:
    type: string
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
events:
  affair_id:
    type: integer
    references: affair
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  custom_fields:
    type: jsonb
  description:
    type: text
  duration:
    type: integer
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  name:
    type: string
    required: true
  nature:
    type: string
    required: true
  place:
    type: string
  restricted:
    type: boolean
    required: true
    default: false
  started_at:
    type: datetime
    required: true
  stopped_at:
    type: datetime
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
financial_year_exchanges:
  closed_at:
    type: datetime
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  financial_year_id:
    type: integer
    references: financial_year
    required: true
  id:
    type: integer
    required: true
  import_file_content_type:
    type: string
  import_file_file_name:
    type: string
  import_file_file_size:
    type: integer
  import_file_updated_at:
    type: datetime
  lock_version:
    type: integer
    required: true
  public_token:
    type: string
  public_token_expired_at:
    type: datetime
  started_on:
    type: date
    required: true
  stopped_on:
    type: date
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
financial_years:
  accountant_id:
    type: integer
    references: entity
  closed:
    type: boolean
    required: true
    default: false
  code:
    type: string
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  currency:
    type: string
    required: true
  currency_precision:
    type: integer
  custom_fields:
    type: jsonb
  id:
    type: integer
    required: true
  last_journal_entry_id:
    type: integer
    references: journal_entry
  lock_version:
    type: integer
    required: true
  started_on:
    type: date
    required: true
  stopped_on:
    type: date
    required: true
  tax_declaration_frequency:
    type: string
  tax_declaration_mode:
    type: string
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
fixed_asset_depreciations:
  accountable:
    type: boolean
    required: true
    default: false
  accounted_at:
    type: datetime
  amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  depreciable_amount:
    type: decimal
    precision: 19
    scale: 4
  depreciated_amount:
    type: decimal
    precision: 19
    scale: 4
  financial_year_id:
    type: integer
    references: financial_year
  fixed_asset_id:
    type: integer
    references: fixed_asset
    required: true
  id:
    type: integer
    required: true
  journal_entry_id:
    type: integer
    references: journal_entry
  lock_version:
    type: integer
    required: true
  locked:
    type: boolean
    required: true
    default: false
  position:
    type: integer
  started_on:
    type: date
    required: true
  stopped_on:
    type: date
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
fixed_assets:
  accounted_at:
    type: datetime
  allocation_account_id:
    type: integer
    references: account
    required: true
  asset_account_id:
    type: integer
    references: account
  ceded:
    type: boolean
  ceded_on:
    type: date
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  currency:
    type: string
    required: true
  current_amount:
    type: decimal
    precision: 19
    scale: 4
  custom_fields:
    type: jsonb
  depreciable_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  depreciated_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  depreciation_method:
    type: string
    required: true
  depreciation_percentage:
    type: decimal
    precision: 19
    scale: 4
  depreciation_period:
    type: string
  description:
    type: text
  expenses_account_id:
    type: integer
    references: account
  id:
    type: integer
    required: true
  journal_entry_id:
    type: integer
    references: journal_entry
  journal_id:
    type: integer
    references: journal
    required: true
  lock_version:
    type: integer
    required: true
  name:
    type: string
    required: true
  number:
    type: string
    required: true
  product_id:
    type: integer
    references: product
  purchase_amount:
    type: decimal
    precision: 19
    scale: 4
  purchase_id:
    type: integer
    references: purchase
  purchase_item_id:
    type: integer
    references: purchase_item
  purchased_on:
    type: date
  sale_id:
    type: integer
    references: sale
  sale_item_id:
    type: integer
    references: sale_item
  scrapped_journal_entry_id:
    type: integer
    references: journal_entry
  scrapped_on:
    type: date
  sold_journal_entry_id:
    type: integer
    references: journal_entry
  sold_on:
    type: date
  started_on:
    type: date
    required: true
  state:
    type: string
  stopped_on:
    type: date
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
gap_items:
  amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  currency:
    type: string
    required: true
  gap_id:
    type: integer
    references: gap
    required: true
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  pretax_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  tax_id:
    type: integer
    references: tax
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
gaps:
  accounted_at:
    type: datetime
  affair_id:
    type: integer
    references: affair
  amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  currency:
    type: string
    required: true
  direction:
    type: string
    required: true
  entity_id:
    type: integer
    references: entity
    required: true
  id:
    type: integer
    required: true
  journal_entry_id:
    type: integer
    references: journal_entry
  lock_version:
    type: integer
    required: true
  number:
    type: string
    required: true
  pretax_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  printed_at:
    type: datetime
    required: true
  type:
    type: string
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
georeadings:
  content:
    type: geometry
    limit:
      srid: 4326
      type: geometry
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  description:
    type: text
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  name:
    type: string
    required: true
  nature:
    type: string
    required: true
  number:
    type: string
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
guide_analyses:
  acceptance_status:
    type: string
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  execution_number:
    type: integer
    required: true
  guide_id:
    type: integer
    references: guide
    required: true
  id:
    type: integer
    required: true
  latest:
    type: boolean
    required: true
    default: false
  lock_version:
    type: integer
    required: true
  started_at:
    type: datetime
    required: true
  stopped_at:
    type: datetime
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
guide_analysis_points:
  acceptance_status:
    type: string
    required: true
  advice_reference_name:
    type: string
  analysis_id:
    type: integer
    references: analysis
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  reference_name:
    type: string
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
guides:
  active:
    type: boolean
    required: true
    default: false
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  external:
    type: boolean
    required: true
    default: false
  frequency:
    type: string
    required: true
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  name:
    type: string
    required: true
  nature:
    type: string
    required: true
  reference_name:
    type: string
  reference_source_content_type:
    type: string
  reference_source_file_name:
    type: string
  reference_source_file_size:
    type: integer
  reference_source_updated_at:
    type: datetime
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
identifiers:
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  nature:
    type: string
    required: true
  net_service_id:
    type: integer
    references: net_service
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
  value:
    type: string
    required: true
imports:
  archive_content_type:
    type: string
  archive_file_name:
    type: string
  archive_file_size:
    type: integer
  archive_updated_at:
    type: datetime
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  id:
    type: integer
    required: true
  imported_at:
    type: datetime
  importer_id:
    type: integer
    references: user
  lock_version:
    type: integer
    required: true
  nature:
    type: string
    required: true
  progression_percentage:
    type: decimal
    precision: 19
    scale: 4
  state:
    type: string
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
incoming_payment_modes:
  active:
    type: boolean
    default: false
  cash_id:
    type: integer
    references: cash
  commission_account_id:
    type: integer
    references: account
  commission_base_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  commission_percentage:
    type: decimal
    precision: 19
    scale: 4
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  depositables_account_id:
    type: integer
    references: account
  depositables_journal_id:
    type: integer
    references: journal
  detail_payments:
    type: boolean
    required: true
    default: false
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  name:
    type: string
    required: true
  position:
    type: integer
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
  with_accounting:
    type: boolean
    required: true
    default: false
  with_commission:
    type: boolean
    required: true
    default: false
  with_deposit:
    type: boolean
    required: true
    default: false
incoming_payments:
  accounted_at:
    type: datetime
  affair_id:
    type: integer
    references: affair
  amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  bank_account_number:
    type: string
  bank_check_number:
    type: string
  bank_name:
    type: string
  codes:
    type: jsonb
  commission_account_id:
    type: integer
    references: account
  commission_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  currency:
    type: string
    required: true
  custom_fields:
    type: jsonb
  deposit_id:
    type: integer
    references: deposit
  downpayment:
    type: boolean
    required: true
    default: true
  id:
    type: integer
    required: true
  journal_entry_id:
    type: integer
    references: journal_entry
  lock_version:
    type: integer
    required: true
  mode_id:
    type: integer
    references: incoming_payment_mode
    required: true
  number:
    type: string
  paid_at:
    type: datetime
  payer_id:
    type: integer
    references: entity
  receipt:
    type: text
  received:
    type: boolean
    required: true
    default: true
  responsible_id:
    type: integer
    references: user
  scheduled:
    type: boolean
    required: true
    default: false
  to_bank_at:
    type: datetime
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
inspection_calibrations:
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  id:
    type: integer
    required: true
  inspection_id:
    type: integer
    references: inspection
    required: true
  items_count_value:
    type: integer
  lock_version:
    type: integer
    required: true
  maximal_size_value:
    type: decimal
    precision: 19
    scale: 4
  minimal_size_value:
    type: decimal
    precision: 19
    scale: 4
  nature_id:
    type: integer
    references: activity_inspection_calibration_nature
    required: true
  net_mass_value:
    type: decimal
    precision: 19
    scale: 4
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
inspection_points:
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  id:
    type: integer
    required: true
  inspection_id:
    type: integer
    references: inspection
    required: true
  items_count_value:
    type: integer
  lock_version:
    type: integer
    required: true
  maximal_size_value:
    type: decimal
    precision: 19
    scale: 4
  minimal_size_value:
    type: decimal
    precision: 19
    scale: 4
  nature_id:
    type: integer
    references: activity_inspection_point_nature
    required: true
  net_mass_value:
    type: decimal
    precision: 19
    scale: 4
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
inspections:
  activity_id:
    type: integer
    references: activity
    required: true
  comment:
    type: text
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  id:
    type: integer
    required: true
  implanter_application_width:
    type: decimal
    precision: 19
    scale: 4
  implanter_rows_number:
    type: integer
  implanter_working_width:
    type: decimal
    precision: 19
    scale: 4
  lock_version:
    type: integer
    required: true
  number:
    type: string
    required: true
  product_id:
    type: integer
    references: product
    required: true
  product_net_surface_area_unit:
    type: string
  product_net_surface_area_value:
    type: decimal
    precision: 19
    scale: 4
  sampled_at:
    type: datetime
    required: true
  sampling_distance:
    type: decimal
    precision: 19
    scale: 4
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
integrations:
  ciphered_parameters:
    type: jsonb
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  data:
    type: jsonb
  id:
    type: integer
    required: true
  initialization_vectors:
    type: jsonb
  lock_version:
    type: integer
    required: true
  nature:
    type: string
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
intervention_labellings:
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  id:
    type: integer
    required: true
  intervention_id:
    type: integer
    references: intervention
    required: true
  label_id:
    type: integer
    references: label
    required: true
  lock_version:
    type: integer
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
intervention_parameter_readings:
  absolute_measure_value_unit:
    type: string
  absolute_measure_value_value:
    type: decimal
    precision: 19
    scale: 4
  boolean_value:
    type: boolean
    required: true
    default: false
  choice_value:
    type: string
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  decimal_value:
    type: decimal
    precision: 19
    scale: 4
  geometry_value:
    type: geometry
    limit:
      srid: 4326
      type: geometry
  id:
    type: integer
    required: true
  indicator_datatype:
    type: string
    required: true
  indicator_name:
    type: string
    required: true
  integer_value:
    type: integer
  lock_version:
    type: integer
    required: true
  measure_value_unit:
    type: string
  measure_value_value:
    type: decimal
    precision: 19
    scale: 4
  multi_polygon_value:
    type: geometry
    limit:
      srid: 4326
      type: multi_polygon
  parameter_id:
    type: integer
    references: intervention_product_parameter
    required: true
  point_value:
    type: geometry
    limit:
      srid: 4326
      type: st_point
  string_value:
    type: text
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
intervention_parameters:
  assembly_id:
    type: integer
    references: product
  component_id:
    type: integer
    references: product_nature_variant_component
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  currency:
    type: string
  dead:
    type: boolean
    required: true
    default: false
  event_participation_id:
    type: integer
    references: event_participation
  group_id:
    type: integer
    references: intervention_group_parameter
  id:
    type: integer
    required: true
  identification_number:
    type: string
  intervention_id:
    type: integer
    references: intervention
    required: true
  lock_version:
    type: integer
    required: true
  new_container_id:
    type: integer
    references: product
  new_group_id:
    type: integer
    references: product_group
  new_name:
    type: string
  new_variant_id:
    type: integer
    references: product_nature_variant
  outcoming_product_id:
    type: integer
    references: product
  position:
    type: integer
    required: true
  product_id:
    type: integer
    references: product
  quantity_handler:
    type: string
  quantity_indicator_name:
    type: string
  quantity_population:
    type: decimal
    precision: 19
    scale: 4
  quantity_unit_name:
    type: string
  quantity_value:
    type: decimal
    precision: 19
    scale: 4
  reference_name:
    type: string
    required: true
  type:
    type: string
  unit_pretax_stock_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
  variant_id:
    type: integer
    references: product_nature_variant
  working_zone:
    type: geometry
    limit:
      srid: 4326
      type: multi_polygon
intervention_participations:
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  id:
    type: integer
    required: true
  intervention_id:
    type: integer
    references: intervention
  lock_version:
    type: integer
    required: true
  procedure_name:
    type: string
  product_id:
    type: integer
    references: product
  request_compliant:
    type: boolean
    required: true
    default: false
  state:
    type: string
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
intervention_working_periods:
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  duration:
    type: integer
    required: true
  id:
    type: integer
    required: true
  intervention_id:
    type: integer
    references: intervention
  intervention_participation_id:
    type: integer
    references: intervention_participation
  lock_version:
    type: integer
    required: true
  nature:
    type: string
  started_at:
    type: datetime
    required: true
  stopped_at:
    type: datetime
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
interventions:
  accounted_at:
    type: datetime
  actions:
    type: string
  auto_calculate_working_periods:
    type: boolean
    default: false
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  currency:
    type: string
  custom_fields:
    type: jsonb
  description:
    type: text
  event_id:
    type: integer
    references: event
  id:
    type: integer
    required: true
  issue_id:
    type: integer
    references: issue
  journal_entry_id:
    type: integer
    references: journal_entry
  lock_version:
    type: integer
    required: true
  nature:
    type: string
    required: true
  number:
    type: string
  prescription_id:
    type: integer
    references: prescription
  procedure_name:
    type: string
    required: true
  request_compliant:
    type: boolean
  request_intervention_id:
    type: integer
    references: intervention
  started_at:
    type: datetime
    required: true
  state:
    type: string
    required: true
  stopped_at:
    type: datetime
    required: true
  trouble_description:
    type: text
  trouble_encountered:
    type: boolean
    required: true
    default: false
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
  whole_duration:
    type: integer
    required: true
  working_duration:
    type: integer
    required: true
inventories:
  accounted_at:
    type: datetime
  achieved_at:
    type: datetime
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  currency:
    type: string
  custom_fields:
    type: jsonb
  financial_year_id:
    type: integer
    references: financial_year
  id:
    type: integer
    required: true
  journal_entry_id:
    type: integer
    references: journal_entry
  lock_version:
    type: integer
    required: true
  name:
    type: string
    required: true
  number:
    type: string
    required: true
  reflected:
    type: boolean
    required: true
    default: false
  reflected_at:
    type: datetime
  responsible_id:
    type: integer
    references: entity
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
inventory_items:
  actual_population:
    type: decimal
    precision: 19
    scale: 4
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  currency:
    type: string
  expected_population:
    type: decimal
    precision: 19
    scale: 4
    required: true
  id:
    type: integer
    required: true
  inventory_id:
    type: integer
    references: inventory
    required: true
  lock_version:
    type: integer
    required: true
  product_id:
    type: integer
    references: product
    required: true
  product_movement_id:
    type: integer
    references: product_movement
  unit_pretax_stock_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
issues:
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  custom_fields:
    type: jsonb
  dead:
    type: boolean
    default: false
  description:
    type: text
  geolocation:
    type: geometry
    limit:
      srid: 4326
      type: st_point
  gravity:
    type: integer
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  name:
    type: string
    required: true
  nature:
    type: string
    required: true
  observed_at:
    type: datetime
    required: true
  picture_content_type:
    type: string
  picture_file_name:
    type: string
  picture_file_size:
    type: integer
  picture_updated_at:
    type: datetime
  priority:
    type: integer
  state:
    type: string
  target_id:
    type: integer
    references: "~target_type"
  target_type:
    type: string
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
journal_entries:
  absolute_credit:
    type: decimal
    precision: 19
    scale: 4
    required: true
  absolute_currency:
    type: string
    required: true
  absolute_debit:
    type: decimal
    precision: 19
    scale: 4
    required: true
  balance:
    type: decimal
    precision: 19
    scale: 4
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  credit:
    type: decimal
    precision: 19
    scale: 4
    required: true
  currency:
    type: string
    required: true
  debit:
    type: decimal
    precision: 19
    scale: 4
    required: true
  financial_year_exchange_id:
    type: integer
    references: financial_year_exchange
  financial_year_id:
    type: integer
    references: financial_year
  id:
    type: integer
    required: true
  journal_id:
    type: integer
    references: journal
    required: true
  lock_version:
    type: integer
    required: true
  number:
    type: string
    required: true
  printed_on:
    type: date
    required: true
  real_balance:
    type: decimal
    precision: 19
    scale: 4
    required: true
  real_credit:
    type: decimal
    precision: 19
    scale: 4
    required: true
  real_currency:
    type: string
    required: true
  real_currency_rate:
    type: decimal
    precision: 19
    scale: 10
    required: true
  real_debit:
    type: decimal
    precision: 19
    scale: 4
    required: true
  resource_id:
    type: integer
    references: "~resource_type"
  resource_prism:
    type: string
  resource_type:
    type: string
  state:
    type: string
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
journal_entry_items:
  absolute_credit:
    type: decimal
    precision: 19
    scale: 4
    required: true
  absolute_currency:
    type: string
    required: true
  absolute_debit:
    type: decimal
    precision: 19
    scale: 4
    required: true
  absolute_pretax_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  account_id:
    type: integer
    references: account
    required: true
  activity_budget_id:
    type: integer
    references: activity_budget
  balance:
    type: decimal
    precision: 19
    scale: 4
    required: true
  bank_statement_id:
    type: integer
    references: bank_statement
  bank_statement_letter:
    type: string
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  credit:
    type: decimal
    precision: 19
    scale: 4
    required: true
  cumulated_absolute_credit:
    type: decimal
    precision: 19
    scale: 4
    required: true
  cumulated_absolute_debit:
    type: decimal
    precision: 19
    scale: 4
    required: true
  currency:
    type: string
    required: true
  debit:
    type: decimal
    precision: 19
    scale: 4
    required: true
  description:
    type: text
  entry_id:
    type: integer
    references: journal_entry
    required: true
  entry_number:
    type: string
    required: true
  financial_year_id:
    type: integer
    references: financial_year
    required: true
  id:
    type: integer
    required: true
  journal_id:
    type: integer
    references: journal
    required: true
  letter:
    type: string
  lock_version:
    type: integer
    required: true
  name:
    type: string
    required: true
  position:
    type: integer
  pretax_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  printed_on:
    type: date
    required: true
  real_balance:
    type: decimal
    precision: 19
    scale: 4
    required: true
  real_credit:
    type: decimal
    precision: 19
    scale: 4
    required: true
  real_currency:
    type: string
    required: true
  real_currency_rate:
    type: decimal
    precision: 19
    scale: 10
    required: true
  real_debit:
    type: decimal
    precision: 19
    scale: 4
    required: true
  real_pretax_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  resource_id:
    type: integer
    references: "~resource_type"
  resource_prism:
    type: string
  resource_type:
    type: string
  state:
    type: string
    required: true
  tax_declaration_item_id:
    type: integer
    references: tax_declaration_item
  tax_declaration_mode:
    type: string
  tax_id:
    type: integer
    references: tax
  team_id:
    type: integer
    references: team
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
  variant_id:
    type: integer
    references: product_nature_variant
journals:
  accountant_id:
    type: integer
    references: entity
  closed_on:
    type: date
    required: true
  code:
    type: string
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  currency:
    type: string
    required: true
  custom_fields:
    type: jsonb
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  name:
    type: string
    required: true
  nature:
    type: string
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
  used_for_affairs:
    type: boolean
    required: true
    default: false
  used_for_gaps:
    type: boolean
    required: true
    default: false
  used_for_permanent_stock_inventory:
    type: boolean
    required: true
    default: false
  used_for_tax_declarations:
    type: boolean
    required: true
    default: false
  used_for_unbilled_payables:
    type: boolean
    required: true
    default: false
labels:
  color:
    type: string
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  name:
    type: string
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
listing_node_items:
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  nature:
    type: string
    required: true
  node_id:
    type: integer
    references: listing_node
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
  value:
    type: text
listing_nodes:
  attribute_name:
    type: string
  condition_operator:
    type: string
  condition_value:
    type: string
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  depth:
    type: integer
    required: true
  exportable:
    type: boolean
    required: true
    default: true
  id:
    type: integer
    required: true
  item_listing_id:
    type: integer
    references: listing
  item_listing_node_id:
    type: integer
    references: listing_node
  item_nature:
    type: string
  item_value:
    type: text
  key:
    type: string
  label:
    type: string
    required: true
  lft:
    type: integer
  listing_id:
    type: integer
    references: listing
    required: true
  lock_version:
    type: integer
    required: true
  name:
    type: string
    required: true
  nature:
    type: string
    required: true
  parent_id:
    type: integer
    references: listing_node
  position:
    type: integer
  rgt:
    type: integer
  sql_type:
    type: string
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
listings:
  conditions:
    type: text
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  description:
    type: text
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  mail:
    type: text
  name:
    type: string
    required: true
  query:
    type: text
  root_model:
    type: string
    required: true
  source:
    type: text
  story:
    type: text
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
loan_repayments:
  accountable:
    type: boolean
    required: true
    default: false
  accounted_at:
    type: datetime
  amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  base_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  due_on:
    type: date
    required: true
  id:
    type: integer
    required: true
  insurance_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  interest_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  journal_entry_id:
    type: integer
    references: journal_entry
  loan_id:
    type: integer
    references: loan
    required: true
  lock_version:
    type: integer
    required: true
  locked:
    type: boolean
    required: true
    default: false
  position:
    type: integer
    required: true
  remaining_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
loans:
  accountable_repayments_started_on:
    type: date
  accounted_at:
    type: datetime
  amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  bank_guarantee_account_id:
    type: integer
    references: account
  bank_guarantee_amount:
    type: integer
  cash_id:
    type: integer
    references: cash
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  currency:
    type: string
    required: true
  custom_fields:
    type: jsonb
  id:
    type: integer
    required: true
  initial_releasing_amount:
    type: boolean
    required: true
    default: false
  insurance_account_id:
    type: integer
    references: account
  insurance_percentage:
    type: decimal
    precision: 19
    scale: 4
    required: true
  insurance_repayment_method:
    type: string
  interest_account_id:
    type: integer
    references: account
  interest_percentage:
    type: decimal
    precision: 19
    scale: 4
    required: true
  journal_entry_id:
    type: integer
    references: journal_entry
  lender_id:
    type: integer
    references: entity
    required: true
  loan_account_id:
    type: integer
    references: account
  lock_version:
    type: integer
    required: true
  name:
    type: string
    required: true
  ongoing_at:
    type: datetime
  repaid_at:
    type: datetime
  repayment_duration:
    type: integer
    required: true
  repayment_method:
    type: string
    required: true
  repayment_period:
    type: string
    required: true
  shift_duration:
    type: integer
    required: true
  shift_method:
    type: string
  started_on:
    type: date
    required: true
  state:
    type: string
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
  use_bank_guarantee:
    type: boolean
manure_management_plan_zones:
  absorbed_nitrogen_at_opening:
    type: decimal
    precision: 19
    scale: 4
  activity_production_id:
    type: integer
    references: activity_production
    required: true
  administrative_area:
    type: string
  computation_method:
    type: string
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  cultivation_variety:
    type: string
  expected_yield:
    type: decimal
    precision: 19
    scale: 4
  humus_mineralization:
    type: decimal
    precision: 19
    scale: 4
  id:
    type: integer
    required: true
  intermediate_cultivation_residue_mineralization:
    type: decimal
    precision: 19
    scale: 4
  irrigation_water_nitrogen:
    type: decimal
    precision: 19
    scale: 4
  lock_version:
    type: integer
    required: true
  maximum_nitrogen_input:
    type: decimal
    precision: 19
    scale: 4
  meadow_humus_mineralization:
    type: decimal
    precision: 19
    scale: 4
  mineral_nitrogen_at_opening:
    type: decimal
    precision: 19
    scale: 4
  nitrogen_at_closing:
    type: decimal
    precision: 19
    scale: 4
  nitrogen_input:
    type: decimal
    precision: 19
    scale: 4
  nitrogen_need:
    type: decimal
    precision: 19
    scale: 4
  organic_fertilizer_mineral_fraction:
    type: decimal
    precision: 19
    scale: 4
  plan_id:
    type: integer
    references: manure_management_plan
    required: true
  previous_cultivation_residue_mineralization:
    type: decimal
    precision: 19
    scale: 4
  soil_nature:
    type: string
  soil_production:
    type: decimal
    precision: 19
    scale: 4
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
manure_management_plans:
  annotation:
    type: text
  campaign_id:
    type: integer
    references: campaign
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  default_computation_method:
    type: string
    required: true
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  locked:
    type: boolean
    required: true
    default: false
  name:
    type: string
    required: true
  opened_at:
    type: datetime
    required: true
  recommender_id:
    type: integer
    references: entity
    required: true
  selected:
    type: boolean
    required: true
    default: false
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
map_layers:
  attribution:
    type: string
  by_default:
    type: boolean
    required: true
    default: false
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  enabled:
    type: boolean
    required: true
    default: false
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  managed:
    type: boolean
    required: true
    default: false
  max_zoom:
    type: integer
  min_zoom:
    type: integer
  name:
    type: string
    required: true
  nature:
    type: string
  opacity:
    type: integer
  position:
    type: integer
  reference_name:
    type: string
  subdomains:
    type: string
  tms:
    type: boolean
    required: true
    default: false
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
  url:
    type: string
    required: true
net_services:
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  reference_name:
    type: string
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
notifications:
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  id:
    type: integer
    required: true
  interpolations:
    type: json
  level:
    type: string
    required: true
  lock_version:
    type: integer
    required: true
  message:
    type: string
    required: true
  read_at:
    type: datetime
  recipient_id:
    type: integer
    references: user
    required: true
  target_id:
    type: integer
    references: "~target_type"
  target_type:
    type: string
  target_url:
    type: string
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
observations:
  author_id:
    type: integer
    references: user
    required: true
  content:
    type: text
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  id:
    type: integer
    required: true
  importance:
    type: string
    required: true
  lock_version:
    type: integer
    required: true
  observed_at:
    type: datetime
    required: true
  subject_id:
    type: integer
    references: "~subject_type"
    required: true
  subject_type:
    type: string
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
outgoing_payment_lists:
  cached_payment_count:
    type: integer
  cached_total_sum:
    type: decimal
  created_at:
    type: datetime
  creator_id:
    type: integer
    references: user
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  mode_id:
    type: integer
    references: outgoing_payment_mode
    required: true
  number:
    type: string
  updated_at:
    type: datetime
  updater_id:
    type: integer
    references: user
outgoing_payment_modes:
  active:
    type: boolean
    required: true
    default: false
  cash_id:
    type: integer
    references: cash
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  name:
    type: string
    required: true
  position:
    type: integer
  sepa:
    type: boolean
    required: true
    default: false
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
  with_accounting:
    type: boolean
    required: true
    default: false
outgoing_payments:
  accounted_at:
    type: datetime
  affair_id:
    type: integer
    references: affair
  amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  bank_check_number:
    type: string
  cash_id:
    type: integer
    references: cash
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  currency:
    type: string
    required: true
  custom_fields:
    type: jsonb
  delivered:
    type: boolean
    required: true
    default: false
  downpayment:
    type: boolean
    required: true
    default: false
  id:
    type: integer
    required: true
  journal_entry_id:
    type: integer
    references: journal_entry
  list_id:
    type: integer
    references: outgoing_payment_list
  lock_version:
    type: integer
    required: true
  mode_id:
    type: integer
    references: outgoing_payment_mode
    required: true
  number:
    type: string
  paid_at:
    type: datetime
  payee_id:
    type: integer
    references: entity
    required: true
  position:
    type: integer
  responsible_id:
    type: integer
    references: user
    required: true
  to_bank_at:
    type: datetime
    required: true
  type:
    type: string
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
parcel_items:
  analysis_id:
    type: integer
    references: analysis
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  currency:
    type: string
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  parcel_id:
    type: integer
    references: parcel
    required: true
  parted:
    type: boolean
    required: true
    default: false
  population:
    type: decimal
    precision: 19
    scale: 4
  pretax_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  product_enjoyment_id:
    type: integer
    references: product_enjoyment
  product_id:
    type: integer
    references: product
  product_identification_number:
    type: string
  product_localization_id:
    type: integer
    references: product_localization
  product_movement_id:
    type: integer
    references: product_movement
  product_name:
    type: string
  product_ownership_id:
    type: integer
    references: product_ownership
  purchase_item_id:
    type: integer
    references: purchase_item
  sale_item_id:
    type: integer
    references: sale_item
  shape:
    type: geometry
    limit:
      srid: 4326
      type: multi_polygon
  source_product_id:
    type: integer
    references: product
  source_product_movement_id:
    type: integer
    references: product_movement
  unit_pretax_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  unit_pretax_stock_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
  variant_id:
    type: integer
    references: product_nature_variant
parcels:
  accounted_at:
    type: datetime
  address_id:
    type: integer
    references: entity_address
  contract_id:
    type: integer
    references: contract
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  currency:
    type: string
  custom_fields:
    type: jsonb
  delivery_id:
    type: integer
    references: delivery
  delivery_mode:
    type: string
  given_at:
    type: datetime
  id:
    type: integer
    required: true
  in_preparation_at:
    type: datetime
  journal_entry_id:
    type: integer
    references: journal_entry
  lock_version:
    type: integer
    required: true
  nature:
    type: string
    required: true
  number:
    type: string
    required: true
  ordered_at:
    type: datetime
  planned_at:
    type: datetime
    required: true
  position:
    type: integer
  prepared_at:
    type: datetime
  pretax_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  purchase_id:
    type: integer
    references: purchase
  recipient_id:
    type: integer
    references: entity
  reference_number:
    type: string
  remain_owner:
    type: boolean
    required: true
    default: false
  responsible_id:
    type: integer
    references: user
  sale_id:
    type: integer
    references: sale
  sender_id:
    type: integer
    references: entity
  separated_stock:
    type: boolean
  state:
    type: string
    required: true
  storage_id:
    type: integer
    references: product
  transporter_id:
    type: integer
    references: entity
  undelivered_invoice_journal_entry_id:
    type: integer
    references: journal_entry
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
  with_delivery:
    type: boolean
    required: true
    default: false
payslip_natures:
  account_id:
    type: integer
    references: account
  active:
    type: boolean
    required: true
    default: false
  by_default:
    type: boolean
    required: true
    default: false
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  currency:
    type: string
    required: true
  id:
    type: integer
    required: true
  journal_id:
    type: integer
    references: journal
    required: true
  lock_version:
    type: integer
    required: true
  name:
    type: string
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
  with_accounting:
    type: boolean
    required: true
    default: false
payslips:
  account_id:
    type: integer
    references: account
  accounted_at:
    type: datetime
  affair_id:
    type: integer
    references: affair
  amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  currency:
    type: string
    required: true
  custom_fields:
    type: jsonb
  emitted_on:
    type: date
  employee_id:
    type: integer
    references: entity
  id:
    type: integer
    required: true
  journal_entry_id:
    type: integer
    references: journal_entry
  lock_version:
    type: integer
    required: true
  nature_id:
    type: integer
    references: payslip_nature
    required: true
  number:
    type: string
    required: true
  started_on:
    type: date
    required: true
  state:
    type: string
    required: true
  stopped_on:
    type: date
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
plant_counting_items:
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  plant_counting_id:
    type: integer
    references: plant_counting
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
  value:
    type: integer
    required: true
plant_countings:
  average_value:
    type: decimal
    precision: 19
    scale: 4
  comment:
    type: text
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  nature:
    type: string
  number:
    type: string
  plant_density_abacus_id:
    type: integer
    references: plant_density_abacus
    required: true
  plant_density_abacus_item_id:
    type: integer
    references: plant_density_abacus_item
    required: true
  plant_id:
    type: integer
    references: plant
    required: true
  read_at:
    type: datetime
  rows_count_value:
    type: integer
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
  working_width_value:
    type: decimal
    precision: 19
    scale: 4
plant_density_abaci:
  activity_id:
    type: integer
    references: activity
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  germination_percentage:
    type: decimal
    precision: 19
    scale: 4
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  name:
    type: string
    required: true
  sampling_length_unit:
    type: string
    required: true
  seeding_density_unit:
    type: string
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
plant_density_abacus_items:
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  plant_density_abacus_id:
    type: integer
    references: plant_density_abacus
    required: true
  plants_count:
    type: integer
  seeding_density_value:
    type: decimal
    precision: 19
    scale: 4
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
postal_zones:
  city:
    type: string
  city_name:
    type: string
  code:
    type: string
  country:
    type: string
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  district_id:
    type: integer
    references: district
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  name:
    type: string
    required: true
  postal_code:
    type: string
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
preferences:
  boolean_value:
    type: boolean
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  decimal_value:
    type: decimal
    precision: 19
    scale: 4
  id:
    type: integer
    required: true
  integer_value:
    type: integer
  lock_version:
    type: integer
    required: true
  name:
    type: string
    required: true
  nature:
    type: string
    required: true
  record_value_id:
    type: integer
    references: "~record_value_type"
  record_value_type:
    type: string
  string_value:
    type: text
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
  user_id:
    type: integer
    references: user
prescriptions:
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  custom_fields:
    type: jsonb
  delivered_at:
    type: datetime
  description:
    type: text
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  prescriptor_id:
    type: integer
    references: entity
    required: true
  reference_number:
    type: string
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
product_enjoyments:
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  enjoyer_id:
    type: integer
    references: entity
  id:
    type: integer
    required: true
  intervention_id:
    type: integer
    references: intervention
  lock_version:
    type: integer
    required: true
  nature:
    type: string
    required: true
  originator_id:
    type: integer
    references: "~originator_type"
  originator_type:
    type: string
  product_id:
    type: integer
    references: product
    required: true
  started_at:
    type: datetime
  stopped_at:
    type: datetime
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
product_labellings:
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  id:
    type: integer
    required: true
  label_id:
    type: integer
    references: label
    required: true
  lock_version:
    type: integer
    required: true
  product_id:
    type: integer
    references: product
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
product_linkages:
  carried_id:
    type: integer
    references: product
  carrier_id:
    type: integer
    references: product
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  id:
    type: integer
    required: true
  intervention_id:
    type: integer
    references: intervention
  lock_version:
    type: integer
    required: true
  nature:
    type: string
    required: true
  originator_id:
    type: integer
    references: "~originator_type"
  originator_type:
    type: string
  point:
    type: string
    required: true
  started_at:
    type: datetime
  stopped_at:
    type: datetime
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
product_links:
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  id:
    type: integer
    required: true
  intervention_id:
    type: integer
    references: intervention
  linked_id:
    type: integer
    references: product
  lock_version:
    type: integer
    required: true
  nature:
    type: string
    required: true
  originator_id:
    type: integer
    references: "~originator_type"
  originator_type:
    type: string
  product_id:
    type: integer
    references: product
    required: true
  started_at:
    type: datetime
  stopped_at:
    type: datetime
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
product_localizations:
  container_id:
    type: integer
    references: product
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  id:
    type: integer
    required: true
  intervention_id:
    type: integer
    references: intervention
  lock_version:
    type: integer
    required: true
  nature:
    type: string
    required: true
  originator_id:
    type: integer
    references: "~originator_type"
  originator_type:
    type: string
  product_id:
    type: integer
    references: product
    required: true
  started_at:
    type: datetime
  stopped_at:
    type: datetime
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
product_memberships:
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  group_id:
    type: integer
    references: product_group
    required: true
  id:
    type: integer
    required: true
  intervention_id:
    type: integer
    references: intervention
  lock_version:
    type: integer
    required: true
  member_id:
    type: integer
    references: product
    required: true
  nature:
    type: string
    required: true
  originator_id:
    type: integer
    references: "~originator_type"
  originator_type:
    type: string
  started_at:
    type: datetime
    required: true
  stopped_at:
    type: datetime
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
product_movements:
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  delta:
    type: decimal
    precision: 19
    scale: 4
    required: true
  description:
    type: string
  id:
    type: integer
    required: true
  intervention_id:
    type: integer
    references: intervention
  lock_version:
    type: integer
    required: true
  originator_id:
    type: integer
    references: "~originator_type"
  originator_type:
    type: string
  population:
    type: decimal
    precision: 19
    scale: 4
    required: true
  product_id:
    type: integer
    references: product
    required: true
  started_at:
    type: datetime
    required: true
  stopped_at:
    type: datetime
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
product_nature_categories:
  active:
    type: boolean
    required: true
    default: false
  charge_account_id:
    type: integer
    references: account
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  custom_fields:
    type: jsonb
  depreciable:
    type: boolean
    required: true
    default: false
  description:
    type: text
  fixed_asset_account_id:
    type: integer
    references: account
  fixed_asset_allocation_account_id:
    type: integer
    references: account
  fixed_asset_depreciation_method:
    type: string
  fixed_asset_depreciation_percentage:
    type: decimal
    precision: 19
    scale: 4
  fixed_asset_expenses_account_id:
    type: integer
    references: account
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  name:
    type: string
    required: true
  number:
    type: string
    required: true
  pictogram:
    type: string
  product_account_id:
    type: integer
    references: account
  purchasable:
    type: boolean
    required: true
    default: false
  reductible:
    type: boolean
    required: true
    default: false
  reference_name:
    type: string
  saleable:
    type: boolean
    required: true
    default: false
  stock_account_id:
    type: integer
    references: account
  stock_movement_account_id:
    type: integer
    references: account
  storable:
    type: boolean
    required: true
    default: false
  subscribing:
    type: boolean
    required: true
    default: false
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
product_nature_category_taxations:
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  product_nature_category_id:
    type: integer
    references: product_nature_category
    required: true
  tax_id:
    type: integer
    references: tax
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
  usage:
    type: string
    required: true
product_nature_variant_components:
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  deleted_at:
    type: datetime
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  name:
    type: string
    required: true
  parent_id:
    type: integer
    references: product_nature_variant_component
  part_product_nature_variant_id:
    type: integer
    references: product_nature_variant
  product_nature_variant_id:
    type: integer
    references: product_nature_variant
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
product_nature_variant_readings:
  absolute_measure_value_unit:
    type: string
  absolute_measure_value_value:
    type: decimal
    precision: 19
    scale: 4
  boolean_value:
    type: boolean
    required: true
    default: false
  choice_value:
    type: string
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  decimal_value:
    type: decimal
    precision: 19
    scale: 4
  geometry_value:
    type: geometry
    limit:
      srid: 4326
      type: geometry
  id:
    type: integer
    required: true
  indicator_datatype:
    type: string
    required: true
  indicator_name:
    type: string
    required: true
  integer_value:
    type: integer
  lock_version:
    type: integer
    required: true
  measure_value_unit:
    type: string
  measure_value_value:
    type: decimal
    precision: 19
    scale: 4
  multi_polygon_value:
    type: geometry
    limit:
      srid: 4326
      type: multi_polygon
  point_value:
    type: geometry
    limit:
      srid: 4326
      type: st_point
  string_value:
    type: text
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
  variant_id:
    type: integer
    references: product_nature_variant
    required: true
product_nature_variants:
  active:
    type: boolean
    required: true
    default: false
  category_id:
    type: integer
    references: product_nature_category
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  custom_fields:
    type: jsonb
  derivative_of:
    type: string
  france_maaid:
    type: string
  gtin:
    type: string
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  name:
    type: string
  nature_id:
    type: integer
    references: product_nature
    required: true
  number:
    type: string
    required: true
  picture_content_type:
    type: string
  picture_file_name:
    type: string
  picture_file_size:
    type: integer
  picture_updated_at:
    type: datetime
  reference_name:
    type: string
  stock_account_id:
    type: integer
    references: account
  stock_movement_account_id:
    type: integer
    references: account
  unit_name:
    type: string
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
  variety:
    type: string
    required: true
  work_number:
    type: string
product_natures:
  abilities_list:
    type: text
  active:
    type: boolean
    required: true
    default: false
  category_id:
    type: integer
    references: product_nature_category
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  custom_fields:
    type: jsonb
  derivative_of:
    type: string
  derivatives_list:
    type: text
  description:
    type: text
  evolvable:
    type: boolean
    required: true
    default: false
  frozen_indicators_list:
    type: text
  id:
    type: integer
    required: true
  linkage_points_list:
    type: text
  lock_version:
    type: integer
    required: true
  name:
    type: string
    required: true
  number:
    type: string
    required: true
  picture_content_type:
    type: string
  picture_file_name:
    type: string
  picture_file_size:
    type: integer
  picture_updated_at:
    type: datetime
  population_counting:
    type: string
    required: true
  reference_name:
    type: string
  subscribing:
    type: boolean
    required: true
    default: false
  subscription_days_count:
    type: integer
    required: true
  subscription_months_count:
    type: integer
    required: true
  subscription_nature_id:
    type: integer
    references: subscription_nature
  subscription_years_count:
    type: integer
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
  variable_indicators_list:
    type: text
  variety:
    type: string
    required: true
product_ownerships:
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  id:
    type: integer
    required: true
  intervention_id:
    type: integer
    references: intervention
  lock_version:
    type: integer
    required: true
  nature:
    type: string
    required: true
  originator_id:
    type: integer
    references: "~originator_type"
  originator_type:
    type: string
  owner_id:
    type: integer
    references: entity
  product_id:
    type: integer
    references: product
    required: true
  started_at:
    type: datetime
  stopped_at:
    type: datetime
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
product_phases:
  category_id:
    type: integer
    references: product_nature_category
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  id:
    type: integer
    required: true
  intervention_id:
    type: integer
    references: intervention
  lock_version:
    type: integer
    required: true
  nature_id:
    type: integer
    references: product_nature
    required: true
  originator_id:
    type: integer
    references: "~originator_type"
  originator_type:
    type: string
  product_id:
    type: integer
    references: product
    required: true
  started_at:
    type: datetime
  stopped_at:
    type: datetime
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
  variant_id:
    type: integer
    references: product_nature_variant
    required: true
product_readings:
  absolute_measure_value_unit:
    type: string
  absolute_measure_value_value:
    type: decimal
    precision: 19
    scale: 4
  boolean_value:
    type: boolean
    required: true
    default: false
  choice_value:
    type: string
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  decimal_value:
    type: decimal
    precision: 19
    scale: 4
  geometry_value:
    type: geometry
    limit:
      srid: 4326
      type: geometry
  id:
    type: integer
    required: true
  indicator_datatype:
    type: string
    required: true
  indicator_name:
    type: string
    required: true
  integer_value:
    type: integer
  lock_version:
    type: integer
    required: true
  measure_value_unit:
    type: string
  measure_value_value:
    type: decimal
    precision: 19
    scale: 4
  multi_polygon_value:
    type: geometry
    limit:
      srid: 4326
      type: multi_polygon
  originator_id:
    type: integer
    references: "~originator_type"
  originator_type:
    type: string
  point_value:
    type: geometry
    limit:
      srid: 4326
      type: st_point
  product_id:
    type: integer
    references: product
    required: true
  read_at:
    type: datetime
    required: true
  string_value:
    type: text
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
products:
  address_id:
    type: integer
    references: entity_address
  birth_date_completeness:
    type: string
  birth_farm_number:
    type: string
  born_at:
    type: datetime
  category_id:
    type: integer
    references: product_nature_category
    required: true
  codes:
    type: jsonb
  country:
    type: string
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  custom_fields:
    type: jsonb
  dead_at:
    type: datetime
  default_storage_id:
    type: integer
    references: product
  derivative_of:
    type: string
  description:
    type: text
  end_of_life_reason:
    type: string
  father_country:
    type: string
  father_identification_number:
    type: string
  father_variety:
    type: string
  filiation_status:
    type: string
  first_calving_on:
    type: datetime
  fixed_asset_id:
    type: integer
    references: fixed_asset
  id:
    type: integer
    required: true
  identification_number:
    type: string
  initial_born_at:
    type: datetime
  initial_container_id:
    type: integer
    references: product
  initial_dead_at:
    type: datetime
  initial_enjoyer_id:
    type: integer
    references: entity
  initial_father_id:
    type: integer
    references: product
  initial_geolocation:
    type: geometry
    limit:
      srid: 4326
      type: st_point
  initial_mother_id:
    type: integer
    references: product
  initial_movement_id:
    type: integer
    references: product_movement
  initial_owner_id:
    type: integer
    references: entity
  initial_population:
    type: decimal
    precision: 19
    scale: 4
  initial_shape:
    type: geometry
    limit:
      srid: 4326
      type: multi_polygon
  lock_version:
    type: integer
    required: true
  member_variant_id:
    type: integer
    references: product_nature_variant
  mother_country:
    type: string
  mother_identification_number:
    type: string
  mother_variety:
    type: string
  name:
    type: string
    required: true
  nature_id:
    type: integer
    references: product_nature
    required: true
  number:
    type: string
    required: true
  origin_country:
    type: string
  origin_identification_number:
    type: string
  originator_id:
    type: integer
    references: synchronization_operation
  parent_id:
    type: integer
    references: product
  person_id:
    type: integer
    references: entity
  picture_content_type:
    type: string
  picture_file_name:
    type: string
  picture_file_size:
    type: integer
  picture_updated_at:
    type: datetime
  team_id:
    type: integer
    references: team
  tracking_id:
    type: integer
    references: tracking
  type:
    type: string
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
  uuid:
    type: uuid
  variant_id:
    type: integer
    references: product_nature_variant
    required: true
  variety:
    type: string
    required: true
  work_number:
    type: string
purchase_items:
  account_id:
    type: integer
    references: account
    required: true
  activity_budget_id:
    type: integer
    references: activity_budget
  amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  annotation:
    type: text
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  currency:
    type: string
    required: true
  depreciable_product_id:
    type: integer
    references: product
  fixed:
    type: boolean
    required: true
    default: false
  fixed_asset_id:
    type: integer
    references: fixed_asset
  id:
    type: integer
    required: true
  label:
    type: text
  lock_version:
    type: integer
    required: true
  position:
    type: integer
  preexisting_asset:
    type: boolean
  pretax_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  purchase_id:
    type: integer
    references: purchase
    required: true
  quantity:
    type: decimal
    precision: 19
    scale: 4
    required: true
  reduction_percentage:
    type: decimal
    precision: 19
    scale: 4
    required: true
  tax_id:
    type: integer
    references: tax
    required: true
  team_id:
    type: integer
    references: team
  unit_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  unit_pretax_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
  variant_id:
    type: integer
    references: product_nature_variant
    required: true
purchase_natures:
  active:
    type: boolean
    required: true
    default: true
  by_default:
    type: boolean
    required: true
    default: false
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  currency:
    type: string
    required: true
  description:
    type: text
  id:
    type: integer
    required: true
  journal_id:
    type: integer
    references: journal
  lock_version:
    type: integer
    required: true
  name:
    type: string
  nature:
    type: string
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
  with_accounting:
    type: boolean
    required: true
    default: false
purchases:
  accounted_at:
    type: datetime
  affair_id:
    type: integer
    references: affair
  amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  confirmed_at:
    type: datetime
  contract_id:
    type: integer
    references: contract
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  currency:
    type: string
    required: true
  custom_fields:
    type: jsonb
  delivery_address_id:
    type: integer
    references: entity_address
  description:
    type: text
  id:
    type: integer
    required: true
  invoiced_at:
    type: datetime
  journal_entry_id:
    type: integer
    references: journal_entry
  lock_version:
    type: integer
    required: true
  nature_id:
    type: integer
    references: purchase_nature
  number:
    type: string
    required: true
  payment_at:
    type: datetime
  payment_delay:
    type: string
  planned_at:
    type: datetime
  pretax_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  quantity_gap_on_invoice_journal_entry_id:
    type: integer
    references: journal_entry
  reference_number:
    type: string
  responsible_id:
    type: integer
    references: user
  state:
    type: string
    required: true
  supplier_id:
    type: integer
    references: entity
    required: true
  tax_payability:
    type: string
    required: true
  undelivered_invoice_journal_entry_id:
    type: integer
    references: journal_entry
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
regularizations:
  affair_id:
    type: integer
    references: affair
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  currency:
    type: string
    required: true
  id:
    type: integer
    required: true
  journal_entry_id:
    type: integer
    references: journal_entry
    required: true
  lock_version:
    type: integer
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
roles:
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  name:
    type: string
    required: true
  reference_name:
    type: string
  rights:
    type: text
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
sale_items:
  account_id:
    type: integer
    references: account
  activity_budget_id:
    type: integer
    references: activity_budget
  amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  annotation:
    type: text
  codes:
    type: jsonb
  compute_from:
    type: string
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  credited_item_id:
    type: integer
    references: sale_item
  credited_quantity:
    type: decimal
    precision: 19
    scale: 4
  currency:
    type: string
    required: true
  id:
    type: integer
    required: true
  label:
    type: text
  lock_version:
    type: integer
    required: true
  position:
    type: integer
  pretax_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  quantity:
    type: decimal
    precision: 19
    scale: 4
    required: true
  reduction_percentage:
    type: decimal
    precision: 19
    scale: 4
    required: true
  sale_id:
    type: integer
    references: sale
    required: true
  tax_id:
    type: integer
    references: tax
  team_id:
    type: integer
    references: team
  unit_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  unit_pretax_amount:
    type: decimal
    precision: 19
    scale: 4
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
  variant_id:
    type: integer
    references: product_nature_variant
    required: true
sale_natures:
  active:
    type: boolean
    required: true
    default: true
  by_default:
    type: boolean
    required: true
    default: false
  catalog_id:
    type: integer
    references: catalog
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  currency:
    type: string
    required: true
  description:
    type: text
  downpayment:
    type: boolean
    required: true
    default: false
  downpayment_minimum:
    type: decimal
    precision: 19
    scale: 4
  downpayment_percentage:
    type: decimal
    precision: 19
    scale: 4
  expiration_delay:
    type: string
    required: true
  id:
    type: integer
    required: true
  journal_id:
    type: integer
    references: journal
  lock_version:
    type: integer
    required: true
  name:
    type: string
    required: true
  payment_delay:
    type: string
    required: true
  payment_mode_complement:
    type: text
  payment_mode_id:
    type: integer
    references: incoming_payment_mode
  sales_conditions:
    type: text
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
  with_accounting:
    type: boolean
    required: true
    default: false
sales:
  accounted_at:
    type: datetime
  address_id:
    type: integer
    references: entity_address
  affair_id:
    type: integer
    references: affair
  amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  annotation:
    type: text
  client_id:
    type: integer
    references: entity
    required: true
  codes:
    type: jsonb
  conclusion:
    type: text
  confirmed_at:
    type: datetime
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  credit:
    type: boolean
    required: true
    default: false
  credited_sale_id:
    type: integer
    references: sale
  currency:
    type: string
    required: true
  custom_fields:
    type: jsonb
  delivery_address_id:
    type: integer
    references: entity_address
  description:
    type: text
  downpayment_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  expiration_delay:
    type: string
  expired_at:
    type: datetime
  function_title:
    type: string
  has_downpayment:
    type: boolean
    required: true
    default: false
  id:
    type: integer
    required: true
  initial_number:
    type: string
  introduction:
    type: text
  invoice_address_id:
    type: integer
    references: entity_address
  invoiced_at:
    type: datetime
  journal_entry_id:
    type: integer
    references: journal_entry
  letter_format:
    type: boolean
    required: true
    default: true
  lock_version:
    type: integer
    required: true
  nature_id:
    type: integer
    references: sale_nature
  number:
    type: string
    required: true
  payment_at:
    type: datetime
  payment_delay:
    type: string
    required: true
  pretax_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  quantity_gap_on_invoice_journal_entry_id:
    type: integer
    references: journal_entry
  reference_number:
    type: string
  responsible_id:
    type: integer
    references: entity
  state:
    type: string
    required: true
  subject:
    type: string
  transporter_id:
    type: integer
    references: entity
  undelivered_invoice_journal_entry_id:
    type: integer
    references: journal_entry
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
sensors:
  access_parameters:
    type: json
  active:
    type: boolean
    required: true
    default: true
  battery_level:
    type: decimal
    precision: 19
    scale: 4
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  custom_fields:
    type: jsonb
  embedded:
    type: boolean
    required: true
    default: false
  euid:
    type: string
  host_id:
    type: integer
    references: product
  id:
    type: integer
    required: true
  last_transmission_at:
    type: datetime
  lock_version:
    type: integer
    required: true
  model_euid:
    type: string
  name:
    type: string
    required: true
  partner_url:
    type: string
  product_id:
    type: integer
    references: product
  retrieval_mode:
    type: string
    required: true
  token:
    type: string
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
  vendor_euid:
    type: string
sequences:
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  id:
    type: integer
    required: true
  last_cweek:
    type: integer
  last_month:
    type: integer
  last_number:
    type: integer
  last_year:
    type: integer
  lock_version:
    type: integer
    required: true
  name:
    type: string
    required: true
  number_format:
    type: string
    required: true
  number_increment:
    type: integer
    required: true
  number_start:
    type: integer
    required: true
  period:
    type: string
    required: true
    default: number
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
  usage:
    type: string
subscription_natures:
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  description:
    type: text
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  name:
    type: string
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
subscriptions:
  address_id:
    type: integer
    references: entity_address
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  custom_fields:
    type: jsonb
  description:
    type: text
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  nature_id:
    type: integer
    references: subscription_nature
  number:
    type: string
  parent_id:
    type: integer
    references: subscription
  quantity:
    type: integer
    required: true
  sale_item_id:
    type: integer
    references: sale_item
  started_on:
    type: date
    required: true
  stopped_on:
    type: date
    required: true
  subscriber_id:
    type: integer
    references: entity
  suspended:
    type: boolean
    required: true
    default: false
  swim_lane_uuid:
    type: uuid
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
supervision_items:
  color:
    type: string
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  sensor_id:
    type: integer
    references: sensor
    required: true
  supervision_id:
    type: integer
    references: supervision
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
supervisions:
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  custom_fields:
    type: jsonb
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  name:
    type: string
    required: true
  time_window:
    type: integer
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
  view_parameters:
    type: json
synchronization_operations:
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  finished_at:
    type: datetime
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  notification_id:
    type: integer
    references: notification
  operation_name:
    type: string
    required: true
  originator_id:
    type: integer
    references: "~originator_type"
  originator_type:
    type: string
  request:
    type: jsonb
  response:
    type: jsonb
  state:
    type: string
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
target_distributions:
  activity_id:
    type: integer
    references: activity
    required: true
  activity_production_id:
    type: integer
    references: activity_production
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  started_at:
    type: datetime
  stopped_at:
    type: datetime
  target_id:
    type: integer
    references: product
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
tasks:
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  custom_fields:
    type: jsonb
  description:
    type: text
  due_at:
    type: datetime
    required: true
  entity_id:
    type: integer
    references: entity
    required: true
  executor_id:
    type: integer
    references: entity
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  name:
    type: string
    required: true
  nature:
    type: string
    required: true
  sale_opportunity_id:
    type: integer
    references: sale_opportunity
  state:
    type: string
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
tax_declaration_item_parts:
  account_id:
    type: integer
    references: account
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  direction:
    type: string
    required: true
  id:
    type: integer
    required: true
  journal_entry_item_id:
    type: integer
    references: journal_entry_item
    required: true
  lock_version:
    type: integer
    required: true
  pretax_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  tax_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  tax_declaration_item_id:
    type: integer
    references: tax_declaration_item
    required: true
  total_pretax_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  total_tax_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
tax_declaration_items:
  balance_pretax_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  balance_tax_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  collected_pretax_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  collected_tax_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  currency:
    type: string
    required: true
  deductible_pretax_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  deductible_tax_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  fixed_asset_deductible_pretax_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  fixed_asset_deductible_tax_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  id:
    type: integer
    required: true
  intracommunity_payable_pretax_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  intracommunity_payable_tax_amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  lock_version:
    type: integer
    required: true
  tax_declaration_id:
    type: integer
    references: tax_declaration
    required: true
  tax_id:
    type: integer
    references: tax
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
tax_declarations:
  accounted_at:
    type: datetime
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  currency:
    type: string
    required: true
  description:
    type: text
  financial_year_id:
    type: integer
    references: financial_year
    required: true
  id:
    type: integer
    required: true
  invoiced_on:
    type: date
  journal_entry_id:
    type: integer
    references: journal_entry
  lock_version:
    type: integer
    required: true
  mode:
    type: string
    required: true
  number:
    type: string
  reference_number:
    type: string
  responsible_id:
    type: integer
    references: user
  started_on:
    type: date
    required: true
  state:
    type: string
  stopped_on:
    type: date
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
taxes:
  active:
    type: boolean
    required: true
    default: false
  amount:
    type: decimal
    precision: 19
    scale: 4
    required: true
  collect_account_id:
    type: integer
    references: account
  country:
    type: string
    required: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  deduction_account_id:
    type: integer
    references: account
  description:
    type: text
  fixed_asset_collect_account_id:
    type: integer
    references: account
  fixed_asset_deduction_account_id:
    type: integer
    references: account
  id:
    type: integer
    required: true
  intracommunity:
    type: boolean
    required: true
    default: false
  intracommunity_payable_account_id:
    type: integer
    references: account
  lock_version:
    type: integer
    required: true
  name:
    type: string
    required: true
  nature:
    type: string
    required: true
  reference_name:
    type: string
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
teams:
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  depth:
    type: integer
    required: true
  description:
    type: text
  id:
    type: integer
    required: true
  lft:
    type: integer
  lock_version:
    type: integer
    required: true
  name:
    type: string
    required: true
  parent_id:
    type: integer
    references: team
  rgt:
    type: integer
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
tokens:
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  name:
    type: string
    required: true
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
  value:
    type: string
    required: true
trackings:
  active:
    type: boolean
    required: true
    default: true
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  description:
    type: text
  id:
    type: integer
    required: true
  lock_version:
    type: integer
    required: true
  name:
    type: string
    required: true
  producer_id:
    type: integer
    references: entity
  product_id:
    type: integer
    references: product
  serial:
    type: string
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
  usage_limit_nature:
    type: string
  usage_limit_on:
    type: date
users:
  administrator:
    type: boolean
    required: true
    default: false
  authentication_token:
    type: string
  commercial:
    type: boolean
    required: true
    default: false
  confirmation_sent_at:
    type: datetime
  confirmation_token:
    type: string
  confirmed_at:
    type: datetime
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  current_sign_in_at:
    type: datetime
  current_sign_in_ip:
    type: string
  description:
    type: text
  email:
    type: string
    required: true
  employed:
    type: boolean
    required: true
    default: false
  employment:
    type: string
  encrypted_password:
    type: string
    required: true
    default: ''
  failed_attempts:
    type: integer
  first_name:
    type: string
    required: true
  id:
    type: integer
    required: true
  invitation_accepted_at:
    type: datetime
  invitation_created_at:
    type: datetime
  invitation_limit:
    type: integer
  invitation_sent_at:
    type: datetime
  invitation_token:
    type: string
  invitations_count:
    type: integer
  invited_by_id:
    type: integer
    references: user
  language:
    type: string
    required: true
  last_name:
    type: string
    required: true
  last_sign_in_at:
    type: datetime
  last_sign_in_ip:
    type: string
  lock_version:
    type: integer
    required: true
  locked:
    type: boolean
    required: true
    default: false
  locked_at:
    type: datetime
  maximal_grantable_reduction_percentage:
    type: decimal
    precision: 19
    scale: 4
    required: true
  person_id:
    type: integer
    references: entity
  provider:
    type: string
  remember_created_at:
    type: datetime
  reset_password_sent_at:
    type: datetime
  reset_password_token:
    type: string
  rights:
    type: text
  role_id:
    type: integer
    references: role
  sign_in_count:
    type: integer
  signup_at:
    type: datetime
  team_id:
    type: integer
    references: team
  uid:
    type: string
  unconfirmed_email:
    type: string
  unlock_token:
    type: string
  updated_at:
    type: datetime
    required: true
  updater_id:
    type: integer
    references: user
versions:
  created_at:
    type: datetime
    required: true
  creator_id:
    type: integer
    references: user
  creator_name:
    type: string
  event:
    type: string
    required: true
  id:
    type: integer
    required: true
  item_changes:
    type: text
  item_id:
    type: integer
    references: "~item_type"
  item_object:
    type: text
  item_type:
    type: string