table:
  schema: public
  name: meal
object_relationships:
  - name: meal_group
    using:
      foreign_key_constraint_on: meal_group_id
array_relationships:
  - name: items
    using:
      foreign_key_constraint_on:
        column: meal_id
        table:
          schema: public
          name: meal_item
insert_permissions:
  - role: marketplace
    permission:
      check: {}
      columns:
        - id
        - meal_group_id
  - role: nutritionist_manager
    permission:
      check: {}
      columns:
        - id
        - meal_group_id
  - role: user
    permission:
      check: {}
      columns:
        - id
        - meal_group_id
select_permissions:
  - role: marketplace
    permission:
      columns:
        - id
        - meal_group_id
      filter: {}
  - role: nutritionist_manager
    permission:
      columns:
        - created_at
        - id
        - meal_group_id
        - updated_at
      filter: {}
  - role: patient
    permission:
      columns:
        - created_at
        - id
        - meal_group_id
        - updated_at
      filter: {}
  - role: personal_trainer
    permission:
      columns:
        - id
        - created_at
        - updated_at
        - meal_group_id
      filter: {}
  - role: user
    permission:
      columns:
        - created_at
        - id
        - meal_group_id
        - updated_at
      filter: {}
update_permissions:
  - role: marketplace
    permission:
      columns:
        - delete_requested_at
        - id
        - meal_group_id
      filter: {}
      check: {}
  - role: nutritionist_manager
    permission:
      columns:
        - delete_requested_at
        - id
        - meal_group_id
      filter: {}
      check: null
      set:
        updated_at: now()
  - role: user
    permission:
      columns:
        - delete_requested_at
        - id
        - meal_group_id
      filter: {}
      check: null
      set:
        updated_at: now()
delete_permissions:
  - role: marketplace
    permission:
      filter: {}
  - role: nutritionist_manager
    permission:
      filter: {}
  - role: user
    permission:
      filter: {}
event_triggers:
  - name: request_meal_delete
    definition:
      enable_manual: false
      update:
        columns:
          - delete_requested_at
    retry_conf:
      num_retries: 0
      interval_sec: 10
      timeout_sec: 60
    webhook: '{{ACTIONS_HANDLER_URL}}/nutritionists/food-plans/delete-meal'
    headers:
      - name: Authorization
        value_from_env: ACTIONS_HANDLER_ACCESS_TOKEN