table:
  schema: public
  name: product
object_relationships:
  - name: category
    using:
      foreign_key_constraint_on: category_display_name
array_relationships:
  - name: orders
    using:
      foreign_key_constraint_on:
        column: product_id
        table:
          schema: public
          name: order_product
  - name: product_reviews
    using:
      foreign_key_constraint_on:
        column: product_id
        table:
          schema: public
          name: product_review
insert_permissions:
  - role: site-admin
    permission:
      check: {}
      columns: '*'
select_permissions:
  - role: anonymous
    permission:
      columns: '*'
      filter: {}
      allow_aggregations: true
  - role: site-admin
    permission:
      columns: '*'
      filter: {}
      allow_aggregations: true
  - role: user
    permission:
      columns: '*'
      filter: {}
update_permissions:
  - role: site-admin
    permission:
      columns: '*'
      filter: {}
      check: null
delete_permissions:
  - role: site-admin
    permission:
      filter: {}