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