Live analytics
Subscriptions
Recurring subscription lifecycle, tiers, Razorpay IDs and renewal dates.
Table metadata
Rows: 5Page: 1 / 1Page size: 100Mode: read-write
Columns
| name | type | primary_key | not_null | default_value |
|---|---|---|---|---|
| id | TEXT | 1 | 0 | — |
| user_id | TEXT | 0 | 1 | — |
| razorpay_subscription_id | TEXT | 0 | 0 | — |
| razorpay_plan_id | TEXT | 0 | 1 | — |
| plan_tier | TEXT | 0 | 1 | — |
| status | TEXT | 0 | 1 | 'created' |
| current_start | TEXT | 0 | 0 | — |
| current_end | TEXT | 0 | 0 | — |
| charge_at | TEXT | 0 | 0 | — |
| short_url | TEXT | 0 | 0 | — |
| created_at | TEXT | 0 | 0 | datetime('now') |
| updated_at | TEXT | 0 | 0 | datetime('now') |
Rows
Manage rows
Create, edit, and delete live rows directly from the SQLite database.
| __rowid__ | id | user_id | razorpay_subscription_id | razorpay_plan_id | plan_tier | status | current_start | current_end | charge_at | short_url | created_at | updated_at | Actions |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5 | e2a921d9-6b71-4a0d-9a0e-6ae4aeb99580 | 2cc17424-c6f7-471e-861f-443267285a6c | GPA.3320-3584-1200-73141 | plus_annual | plus_annual | expired | 2026-04-12T18:04:22.371Z | 2026-04-12T18:34:22.371Z | — | — | 2026-04-12 18:04:26 | 2026-04-13 13:43:12 | |
| 4 | 51971dbd-3e6f-4173-9208-6890f58726c0 | 2cc17424-c6f7-471e-861f-443267285a6c | GPA.3310-2012-5227-61460 | lite_annual | lite_annual | active | 2026-04-12T18:04:11.018Z | 2026-04-12T18:34:11.018Z | — | — | 2026-04-12 18:04:13 | 2026-04-12 18:04:13 | |
| 3 | 27fe7473-6176-4e4b-9527-c924ec804161 | 2cc17424-c6f7-471e-861f-443267285a6c | GPA.3342-1311-9218-38420 | lite_monthly | lite | active | 2026-04-12T18:03:30.507Z | 2026-04-12T18:08:30.507Z | — | — | 2026-04-12 18:03:40 | 2026-04-12 18:03:40 | |
| 2 | 81fd184b-93c4-4c61-91ef-f4658828a332 | 9b16341f-5923-4110-af9e-996e5d859748 | reviewer-9b16341f-5923-4110-af9e-996e5d859748 | pro_annual_reviewer | pro | active | 2026-04-10T12:03:58.064Z | 2027-04-10T12:03:58.055Z | — | — | 2026-04-10 12:03:58 | 2026-04-10 12:03:58 | |
| 1 | e8bf53ce-1379-468d-a8ff-df6b2f2091b9 | 2cc17424-c6f7-471e-861f-443267285a6c | GPA.3361-4571-2515-81559 | lite_monthly | lite | expired | 2026-04-09T13:41:34.091Z | 2026-04-09T13:46:34.091Z | — | — | 2026-04-09 13:41:38 | 2026-04-09 13:48:42 |