table:
  schema: public
  name: users_restrictions
object_relationships:
  - name: restriction
    using:
      foreign_key_constraint_on: restriction_id
  - name: user
    using:
      foreign_key_constraint_on: user_id
insert_permissions:
  - role: anonymous
    permission:
      check: {}
      columns:
        - restriction_id
        - user_id
      backend_only: false
  - role: marketplace
    permission:
      check:
        user_id:
          _eq: X-Hasura-User-Id
      columns:
        - user_id
        - restriction_id
      backend_only: false
  - role: nutritionist_manager
    permission:
      check: {}
      columns:
        - user_id
        - restriction_id
      backend_only: false
  - role: personal_trainer
    permission:
      check:
        user_id:
          _eq: X-Hasura-User-Id
      columns:
        - user_id
        - restriction_id
      backend_only: false
  - role: user
    permission:
      check: {}
      columns:
        - user_id
        - restriction_id
      backend_only: false
select_permissions:
  - role: marketplace
    permission:
      columns:
        - user_id
        - restriction_id
      filter:
        user_id:
          _eq: X-Hasura-User-Id
  - role: nutritionist_manager
    permission:
      columns:
        - user_id
        - restriction_id
      filter: {}
      allow_aggregations: true
  - role: patient
    permission:
      columns:
        - restriction_id
        - user_id
      filter: {}
  - role: personal_trainer
    permission:
      columns:
        - user_id
        - restriction_id
      filter:
        user_id:
          _eq: X-Hasura-User-Id
  - role: user
    permission:
      columns:
        - user_id
        - restriction_id
      filter:
        user_id:
          _eq: X-Hasura-User-Id
      allow_aggregations: true
update_permissions:
  - role: marketplace
    permission:
      columns:
        - user_id
        - restriction_id
      filter:
        user_id:
          _eq: X-Hasura-User-Id
      check: {}
  - role: nutritionist_manager
    permission:
      columns:
        - restriction_id
      filter:
        user_id:
          _eq: X-Hasura-User-Id
      check: null
  - role: personal_trainer
    permission:
      columns:
        - user_id
        - restriction_id
      filter:
        user_id:
          _eq: X-Hasura-User-Id
      check:
        user_id:
          _eq: X-Hasura-User-Id
  - role: user
    permission:
      columns:
        - restriction_id
      filter:
        user_id:
          _eq: X-Hasura-User-Id
      check: null
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: personal_trainer
    permission:
      filter:
        user_id:
          _eq: X-Hasura-User-Id
  - role: user
    permission:
      filter:
        user_id:
          _eq: X-Hasura-User-Id