table:
  schema: public
  name: users_goals
object_relationships:
  - name: goal
    using:
      foreign_key_constraint_on: goal_id
  - name: user
    using:
      foreign_key_constraint_on: user_id
insert_permissions:
  - role: anonymous
    permission:
      check: {}
      columns:
        - user_id
        - goal_id
      backend_only: false
  - role: marketplace
    permission:
      check:
        user_id:
          _eq: X-Hasura-User-Id
      columns:
        - user_id
        - goal_id
      backend_only: false
  - role: nutritionist_manager
    permission:
      check: {}
      columns:
        - user_id
        - goal_id
      backend_only: false
  - role: user
    permission:
      check: {}
      columns:
        - user_id
        - goal_id
      backend_only: false
select_permissions:
  - role: marketplace
    permission:
      columns:
        - user_id
        - goal_id
      filter:
        user_id:
          _eq: X-Hasura-User-Id
  - role: nutritionist_manager
    permission:
      columns:
        - user_id
        - goal_id
      filter: {}
  - role: patient
    permission:
      columns:
        - user_id
        - goal_id
      filter: {}
  - role: personal_trainer
    permission:
      columns:
        - user_id
        - goal_id
      filter:
        user_id:
          _eq: X-Hasura-User-Id
  - role: user
    permission:
      columns:
        - user_id
        - goal_id
      filter: {}
delete_permissions:
  - role: marketplace
    permission:
      filter:
        user_id:
          _eq: X-Hasura-User-Id
  - role: nutritionist_manager
    permission:
      filter: {}
  - role: personal_trainer
    permission:
      filter:
        user_id:
          _eq: X-Hasura-User-Id
  - role: user
    permission:
      filter: {}