SaaSCloud schema

All tables live in the saascloud schema, so write saascloud.customers in your queries.

saascloud.customers

Customer accounts (companies).

• customer_id (INT) — PK
• company_name (VARCHAR(80))
• industry (VARCHAR(30))
• country (VARCHAR(40))
• segment (VARCHAR(12)) — 'SMB', 'Mid-Market', 'Enterprise'
• signup_date (DATE)

saascloud.plans

Plans and their list price per seat.

• plan_id (INT) — PK
• plan_name (VARCHAR(20)) — 'Starter', 'Growth', 'Business', 'Enterprise'
• tier (INT) — 1 (lowest) to 4 (highest)
• price_per_seat (DECIMAL(8,2)) — USD per seat per month

saascloud.subscriptions

Subscription periods. A plan or seat change ends the current period and starts a new one the next day.

• subscription_id (INT) — PK
• customer_id (INT) — FK → customers.customer_id
• plan_id (INT) — FK → plans.plan_id
• seats (INT)
• billing_period (VARCHAR(8)) — 'monthly' or 'yearly' (yearly gets 20% off)
• mrr (DECIMAL(12,2)) — monthly recurring revenue of this period, USD
• start_date (DATE)
• end_date (DATE) — nullable; last day of the period; NULL while running
• change_type (VARCHAR(10)) — how the period began: 'new', 'upgrade', 'downgrade'

saascloud.invoices

Invoices and payment attempts (USD).

• invoice_id (INT) — PK
• customer_id (INT) — FK → customers.customer_id
• subscription_id (INT) — FK → subscriptions.subscription_id
• invoice_date (DATE)
• due_date (DATE)
• amount (DECIMAL(12,2))
• status (VARCHAR(8)) — 'PAID', 'PENDING', 'FAILED'
• paid_at (DATE) — nullable

saascloud.churn_reports

One row per customer that cancelled.

• churn_id (INT) — PK
• customer_id (INT) — FK → customers.customer_id
• churn_date (DATE)
• churn_reason (VARCHAR(30)) — 'price', 'missing_features', 'switched_competitor', 'business_closed', 'low_usage'

saascloud.usage_metrics

Daily product usage per customer (last 120 days).

• usage_id (INT) — PK
• customer_id (INT) — FK → customers.customer_id
• metric_date (DATE)
• active_users (INT) — distinct users active that day
• api_calls (INT)
• storage_gb (DECIMAL(10,2))

saascloud.support_tickets

Support requests.

• ticket_id (INT) — PK
• customer_id (INT) — FK → customers.customer_id
• created_at (TIMESTAMP)
• priority (VARCHAR(8)) — 'low', 'medium', 'high', 'urgent'
• resolved_at (TIMESTAMP) — nullable; NULL while open