Plans
Service: subscription-api
Table: plans
Fields
| Field | Type | Required | Default | Notes |
|---|---|---|---|---|
id | uuid | no | - | - |
slug | string | yes | - | unique |
name | string | yes | - | - |
description | text | no | - | - |
tier | enum | no | - | enum: free, starter, professional, enterprise, custom |
interval | enum | no | - | enum: monthly, yearly, weekly, custom |
interval_count | integer | no | - | - |
price | integer | no | - | - |
currency | string | no | - | - |
trial_days | integer | no | - | - |
entitlements | jsonb | no | - | - |
metadata | jsonb | no | - | - |
status | enum | no | - | enum: active, inactive, deprecated |
is_public | boolean | no | - | - |
sort_order | integer | no | - | - |
stripe_product_id | string | no | - | - |
stripe_price_id | string | no | - | - |
version | integer | no | - | - |
superseded_by | uuid | no | - | - |
max_workspace_seats | integer | no | - | - |
max_end_user_seats | integer | no | - | - |
max_workspaces | integer | no | - | - |
max_portals | integer | no | - | - |
storage_limit_gb | integer | no | - | - |
cache_limit_gb | string | no | - | - |
api_calls_per_day | integer | no | - | - |
portal_traffic_gb | integer | no | - | - |
audit_retention_days | integer | no | - | - |
support_level | enum | no | - | enum: community, email, priority, dedicated |
support_sla_hours | integer | no | - | - |
sla_uptime | string | no | - | - |
commercial_features | jsonb | no | - | - |
fair_use_policy | jsonb | no | - | - |
display_order | integer | no | - | - |
platform_definition_id | uuid | no | - | - |
app_edition_id | uuid | no | - | - |
app_edition_slug | string | no | - | - |
created_at | timestamp | no | - | - |
updated_at | timestamp | no | - | - |