table:
  schema: public
  name: macros_reference_value
object_relationships:
  - name: patient
    using:
      foreign_key_constraint_on: patient_id
insert_permissions:
  - role: marketplace
    permission:
      check:
        patient:
          user_id:
            _eq: X-Hasura-User-Id
      columns:
        - carbohydrates
        - kcal
        - lipids
        - proteins
        - id
        - patient_id
        - created_at
        - updated_at
      backend_only: false
  - role: nutritionist_manager
    permission:
      check: {}
      columns:
        - id
        - patient_id
        - kcal
        - proteins
        - carbohydrates
        - lipids
        - created_at
        - updated_at
      backend_only: false
  - role: user
    permission:
      check: {}
      columns:
        - id
        - patient_id
        - kcal
        - proteins
        - carbohydrates
        - lipids
        - created_at
        - updated_at
      backend_only: false
select_permissions:
  - role: marketplace
    permission:
      columns:
        - id
        - patient_id
        - kcal
        - proteins
        - carbohydrates
        - lipids
        - created_at
        - updated_at
      filter:
        patient:
          user_id:
            _eq: X-Hasura-User-Id
  - role: nutritionist_manager
    permission:
      columns:
        - carbohydrates
        - kcal
        - lipids
        - proteins
        - id
        - patient_id
        - created_at
        - updated_at
      filter: {}
  - role: patient
    permission:
      columns:
        - carbohydrates
        - kcal
        - lipids
        - proteins
        - id
        - patient_id
        - created_at
        - updated_at
      filter:
        patient_id:
          _eq: X-Hasura-User-Id
  - role: user
    permission:
      columns:
        - carbohydrates
        - kcal
        - lipids
        - proteins
        - id
        - patient_id
        - created_at
        - updated_at
      filter: {}
update_permissions:
  - role: marketplace
    permission:
      columns:
        - carbohydrates
        - kcal
        - lipids
        - proteins
        - id
        - patient_id
        - created_at
        - updated_at
      filter:
        patient:
          user_id:
            _eq: X-Hasura-User-Id
      check:
        patient:
          user_id:
            _eq: X-Hasura-User-Id
  - role: nutritionist_manager
    permission:
      columns:
        - id
        - patient_id
        - kcal
        - proteins
        - carbohydrates
        - lipids
        - created_at
        - updated_at
      filter: {}
      check: {}
  - role: user
    permission:
      columns:
        - carbohydrates
        - kcal
        - lipids
        - proteins
        - id
        - patient_id
        - created_at
        - updated_at
      filter: {}
      check: {}
delete_permissions:
  - role: marketplace
    permission:
      filter:
        patient:
          user_id:
            _eq: X-Hasura-User-Id
  - role: nutritionist_manager
    permission:
      filter: {}
  - role: user
    permission:
      filter: {}