goorm_team_mission

Tables (4)

plan_subscription_summary

  • snapshot_date — TEXT — Primary key — NOT NULL
  • plan_id — TEXT — Foreign key → subscription_plans.plan_id — NOT NULL
  • active_users — INTEGER — NOT NULL
  • new_users — INTEGER — NOT NULL
  • churned_users — INTEGER — NOT NULL
  • estimated_rev — REAL — NOT NULL

subscription_plans

  • plan_id — TEXT
  • plan_name — TEXT — NOT NULL
  • billing_cycle — TEXT — NOT NULL
  • price — REAL — NOT NULL
  • max_users — INTEGER — NOT NULL
  • trial_days — INTEGER

user_subscriptions

  • subscription_id — TEXT
  • user_id — TEXT — Foreign key → users.user_id — NOT NULL
  • plan_id — TEXT — Foreign key → subscription_plans.plan_id — NOT NULL
  • sub_status — TEXT — NOT NULL
  • start_date — TEXT — NOT NULL
  • end_date — TEXT — NOT NULL
  • is_auto_renew — INTEGER — NOT NULL

users

  • user_id — TEXT
  • apple_id — TEXT — NOT NULL
  • user_name — TEXT — NOT NULL
  • country_code — TEXT — NOT NULL
  • joined_at — TEXT — NOT NULL
  • account_status — TEXT — NOT NULL