table:
  schema: public
  name: menu
object_relationships:
  - name: created_by_user
    using:
      foreign_key_constraint_on: created_by
  - name: goal
    using:
      foreign_key_constraint_on: goal_id
array_relationships:
  - name: meal_groups
    using:
      foreign_key_constraint_on:
        column: menu_id
        table:
          schema: public
          name: meal_group
  - name: menu_restrictions
    using:
      foreign_key_constraint_on:
        column: menu_id
        table:
          schema: public
          name: menu_restriction
insert_permissions:
  - role: marketplace
    permission:
      check: {}
      set:
        created_by: x-hasura-User-Id
      columns:
        - created_at
        - goal_id
        - id
        - title
        - updated_at
      backend_only: false
  - role: nutritionist_manager
    permission:
      check: {}
      set:
        created_by: x-hasura-User-Id
      columns:
        - created_at
        - goal_id
        - id
        - title
        - updated_at
      backend_only: false
  - role: user
    permission:
      check: {}
      set:
        created_by: x-hasura-User-Id
      columns:
        - created_at
        - goal_id
        - id
        - title
        - updated_at
      backend_only: false
select_permissions:
  - role: marketplace
    permission:
      columns:
        - created_at
        - goal_id
        - id
        - title
        - updated_at
      filter: {}
  - role: nutritionist_manager
    permission:
      columns:
        - active
        - created_at
        - created_by
        - goal_id
        - id
        - title
        - updated_at
        - updated_by
      filter: {}
      allow_aggregations: true
  - role: patient
    permission:
      columns:
        - active
        - created_at
        - created_by
        - goal_id
        - id
        - is_autogenerated
        - title
        - updated_at
        - updated_by
      filter: {}
      allow_aggregations: true
  - role: personal_trainer
    permission:
      columns:
        - created_at
        - goal_id
        - id
        - title
        - updated_at
      filter: {}
  - role: user
    permission:
      columns:
        - active
        - created_at
        - created_by
        - goal_id
        - id
        - title
        - updated_at
        - updated_by
      filter: {}
      allow_aggregations: true
update_permissions:
  - role: marketplace
    permission:
      columns:
        - created_at
        - goal_id
        - id
        - title
        - updated_at
      filter: {}
      check: {}
      set:
        created_by: x-hasura-User-Id
  - role: nutritionist_manager
    permission:
      columns:
        - active
        - goal_id
        - title
      filter: {}
      check: null
      set:
        updated_at: now()
        updated_by: x-hasura-User-Id
  - role: user
    permission:
      columns:
        - active
        - goal_id
        - title
      filter: {}
      check: null
      set:
        updated_at: now()
        updated_by: x-hasura-User-Id
delete_permissions:
  - role: marketplace
    permission:
      filter: {}
  - role: nutritionist_manager
    permission:
      filter: {}
  - role: user
    permission:
      filter: {}
