table:
  schema: public
  name: plan
array_relationships:
  - name: features
    using:
      foreign_key_constraint_on:
        column: plan_id
        table:
          schema: public
          name: plan_feature
  - name: payment_providers
    using:
      foreign_key_constraint_on:
        column: plan_id
        table:
          schema: public
          name: plan_payment_provider
  - name: plan_discount_coupons
    using:
      foreign_key_constraint_on:
        column: plan_id
        table:
          schema: public
          name: plan_discount_coupon
  - name: subscriptions
    using:
      foreign_key_constraint_on:
        column: plan_id
        table:
          schema: public
          name: subscription
  - name: upgradeables
    using:
      foreign_key_constraint_on:
        column: plan_id_from
        table:
          schema: public
          name: plans_upgradeables
insert_permissions:
  - role: nutritionist_manager
    permission:
      check: {}
      columns:
        - active_since
        - active_until
        - collaborator
        - complete
        - enabled
        - grace_period_days
        - interval
        - name
        - order
        - trial_interval
        - trial_value
        - version_gte
        - visible
      backend_only: false
select_permissions:
  - role: marketplace
    permission:
      columns:
        - collaborator
        - complete
        - enabled
        - id
        - interval
        - name
        - order
        - trial_interval
        - trial_value
        - visible
      filter: {}
      allow_aggregations: true
  - role: nutritionist_manager
    permission:
      columns:
        - active_since
        - active_until
        - collaborator
        - complete
        - enabled
        - grace_period_days
        - id
        - interval
        - name
        - order
        - trial_interval
        - trial_value
        - version_gte
        - visible
      filter: {}
      allow_aggregations: true
  - role: patient
    permission:
      columns:
        - collaborator
        - complete
        - enabled
        - id
        - interval
        - name
        - order
        - trial_interval
        - trial_value
        - visible
      filter: {}
      allow_aggregations: true
  - role: personal_trainer
    permission:
      columns:
        - collaborator
        - complete
        - enabled
        - id
        - interval
        - name
        - order
        - trial_interval
        - trial_value
        - visible
      filter: {}
      allow_aggregations: true
  - role: user
    permission:
      columns:
        - collaborator
        - complete
        - enabled
        - id
        - interval
        - name
        - order
        - trial_interval
        - trial_value
        - visible
      filter: {}
      allow_aggregations: true
update_permissions:
  - role: nutritionist_manager
    permission:
      columns:
        - active_since
        - active_until
        - collaborator
        - complete
        - enabled
        - grace_period_days
        - interval
        - name
        - order
        - trial_interval
        - trial_value
        - version_gte
        - visible
      filter: {}
      check: null