saas
Version 1.0
Multi-tenant application: tenants, authentication, billing.
Subject areas
| Name | Description | Entities |
|---|---|---|
| Auth | Tenants, users and credentials. | 4 |
| Billing | Plans, subscriptions and invoices. | 5 |
Entities
| Name | Description | Attributes | Subject areas |
|---|---|---|---|
| api_key | A secret used by integrations to call the API. | 6 | Auth |
| invoice | 6 | Billing | |
| invoice_line | 5 | Billing | |
| membership | A user's role within a tenant. | 3 | Auth |
| plan | A price plan. | 3 | Billing |
| subscription | 6 | Billing | |
| tenant | An isolated customer organisation. | 4 | Auth, Billing |
| user | 6 | Auth |
Domains
| Name | Type | Null | Default | Check | Description |
|---|---|---|---|---|---|
| tenant_ref | bigint | yes |
Enums
| Name | Values | Description |
|---|---|---|
| subscription_status | trialing, active, past_due, cancelled |
Targets
| Name | Dialect | Schemas | Tables |
|---|---|---|---|
| lite | sqlite | 1 | 8 |
| pg | postgresql | 1 | 8 |
Classifications
- pii (3 levels)