table:
  schema: public
  name: competition
object_relationships:
  - name: competition_category
    using:
      foreign_key_constraint_on: category
  - name: patient
    using:
      foreign_key_constraint_on: patient_id
  - name: winner
    using:
      manual_configuration:
        remote_table:
          schema: public
          name: competition_competitor
        insertion_order: null
        column_mapping:
          winner_id: patient_id
          id: competition_id
array_relationships:
  - name: competitors
    using:
      foreign_key_constraint_on:
        column: competition_id
        table:
          schema: public
          name: competition_competitor
select_permissions:
  - role: patient
    permission:
      columns:
        - id
        - title
        - category
        - patient_id
        - winner_id
        - link
        - created_at
        - finished_at
        - will_end_at
        - cancelled_at
      filter:
        _or:
          - patient_id:
              _eq: X-Hasura-User-Id
          - competitors:
              patient_id:
                _eq: X-Hasura-User-Id