Data Model

erDiagram TENANTS ||--o{ USERS : has TENANTS ||--o{ API_KEYS : has TENANTS ||--o{ ITEM_TYPES : has ITEM_TYPES ||--o{ ITEMS : has ITEM_TYPES ||--o{ ITEM_TYPE_SCHEMA_VERSIONS : has TENANTS ||--o{ CONSUMERS : has CONSUMERS ||--o{ CONTACT_POINTS : has CONSUMERS ||--o{ SUBSCRIPTIONS : has SUBSCRIPTIONS ||--o{ SUBSCRIPTION_TOKENS : has SUBSCRIPTIONS ||--o{ NOTIFICATIONS : has AVAILABILITY_EVENTS ||--o{ NOTIFICATIONS : triggers TENANTS ||--o{ AVAILABILITY_EVENTS : has TENANTS ||--o{ OUTBOX_MESSAGES : has TENANTS { uuid id PK string name string slug UK string timezone jsonb domains string from_name string from_email timestamp created_at timestamp updated_at } USERS { uuid id PK uuid tenant_id FK string name string email string password timestamp email_verified_at timestamp created_at timestamp updated_at } API_KEYS { uuid id PK uuid tenant_id FK string name string kind string prefix UK char hash string reusable_plaintext timestamp last_used_at timestamp revoked_at timestamp created_at timestamp updated_at } ITEM_TYPES { uuid id PK uuid tenant_id FK string name string slug jsonb attribute_schema int schema_version enum notify_policy int notify_factor enum subscription_mode string action_url_template timestamp created_at timestamp updated_at } ITEMS { uuid id PK uuid tenant_id FK uuid item_type_id FK string name string external_ref string action_url timestamp created_at timestamp updated_at } CONSUMERS { uuid id PK uuid tenant_id FK timestamp created_at timestamp updated_at } CONTACT_POINTS { uuid id PK uuid tenant_id FK uuid consumer_id FK enum channel string value timestamp verified_at timestamp unsubscribed_at timestamp invalidated_at string invalidation_detail timestamp created_at timestamp updated_at } CONSENT_EVENTS { uuid id PK uuid tenant_id FK uuid contact_point_id FK uuid subscription_id enum action enum source string ip_address string user_agent timestamp created_at } SUBSCRIPTIONS { uuid id PK uuid tenant_id FK uuid consumer_id FK uuid contact_point_id FK uuid item_type_id FK uuid item_id FK jsonb attributes int schema_version jsonb channels string fingerprint enum status timestamp last_notified_at timestamp cooldown_until timestamp expires_at timestamp created_at timestamp updated_at } SUBSCRIPTION_TOKENS { uuid id PK uuid tenant_id FK uuid subscription_id FK uuid contact_point_id FK enum purpose char token_hash string reusable_plaintext timestamp expires_at timestamp used_at timestamp created_at } AVAILABILITY_EVENTS { uuid id PK uuid tenant_id FK uuid item_type_id FK uuid item_id FK jsonb attributes int capacity timestamp available_from timestamp available_until enum source string idempotency_key UK string correlation_id timestamp occurred_at timestamp created_at } NOTIFICATIONS { uuid id PK uuid tenant_id FK uuid subscription_id FK uuid availability_event_id FK uuid contact_point_id FK uuid delivery_id enum status timestamp created_at timestamp updated_at } OUTBOX_MESSAGES { uuid id PK string topic jsonb payload string correlation_id timestamp published_at string error timestamp created_at }

[
  {
    "key": "size",
    "label": "Size",
    "type": "enum",
    "options": ["40", "41", "42"],
    "required": true,
    "matchable": true,
    "multiple": false
  }
]

pending_confirmation → active → notified
                     → expired
                     → unsubscribed

queued → sending → accepted → delivered
                 → failed
                 → bounced