table:
  schema: public
  name: meal_template
object_relationships:
  - name: user
    using:
      foreign_key_constraint_on: user_id
array_relationships:
  - name: items
    using:
      foreign_key_constraint_on:
        column: meal_template_id
        table:
          schema: public
          name: meal_item
  - name: tags
    using:
      foreign_key_constraint_on:
        column: meal_template_id
        table:
          schema: public
          name: meal_template_tag
  - name: types
    using:
      manual_configuration:
        remote_table:
          schema: public
          name: meal_template_type
        insertion_order: null
        column_mapping:
          id: meal_template_id
computed_fields:
  - name: total_kcal
    definition:
      function:
        schema: public
        name: template_total_kcal
    comment: ""
insert_permissions:
  - role: marketplace
    permission:
      check:
        user_id:
          _eq: X-Hasura-User-Id
      columns:
        - template_title
        - user_id
      backend_only: false
  - role: nutritionist_manager
    permission:
      check: {}
      columns:
        - template_title
        - user_id
      backend_only: false
  - role: user
    permission:
      check: {}
      columns:
        - template_title
        - user_id
      backend_only: false
select_permissions:
  - role: marketplace
    permission:
      columns:
        - id
        - template_title
        - user_id
      computed_fields:
        - total_kcal
      filter: {}
      allow_aggregations: true
  - role: nutritionist_manager
    permission:
      columns:
        - template_title
        - user_id
        - created_at
        - updated_at
        - id
      computed_fields:
        - total_kcal
      filter: {}
      allow_aggregations: true
  - role: personal_trainer
    permission:
      columns:
        - id
        - template_title
        - user_id
      computed_fields:
        - total_kcal
      filter: {}
      allow_aggregations: true
  - role: user
    permission:
      columns:
        - template_title
        - user_id
        - created_at
        - updated_at
        - id
      computed_fields:
        - total_kcal
      filter: {}
      allow_aggregations: true
update_permissions:
  - role: marketplace
    permission:
      columns:
        - template_title
        - user_id
      filter:
        user_id:
          _eq: X-Hasura-User-Id
      check: {}
  - role: nutritionist_manager
    permission:
      columns:
        - template_title
      filter: {}
      check: null
      set:
        updated_at: now()
  - role: user
    permission:
      columns:
        - template_title
      filter: {}
      check: null
      set:
        updated_at: now()
delete_permissions:
  - role: marketplace
    permission:
      filter:
        user_id:
          _eq: X-Hasura-User-Id
  - role: nutritionist_manager
    permission:
      filter:
        user_id:
          _eq: X-Hasura-User-Id
  - role: user
    permission:
      filter:
        user_id:
          _eq: X-Hasura-User-Id
