Live analytics
Message Packs
Top-up purchases and remaining message balances.
Table metadata
Rows: 2Page: 1 / 1Page size: 100Mode: read-write
Columns
| name | type | primary_key | not_null | default_value |
|---|---|---|---|---|
| id | TEXT | 1 | 0 | — |
| user_id | TEXT | 0 | 1 | — |
| pack_type | TEXT | 0 | 1 | — |
| messages_bought | INTEGER | 0 | 1 | — |
| messages_remaining | INTEGER | 0 | 1 | — |
| razorpay_payment_id | TEXT | 0 | 0 | — |
| razorpay_order_id | TEXT | 0 | 0 | — |
| price_paid | INTEGER | 0 | 1 | — |
| purchased_at | TEXT | 0 | 0 | datetime('now') |
| status | TEXT | 0 | 0 | 'active' |
Rows
Manage rows
Create, edit, and delete live rows directly from the SQLite database.
| __rowid__ | id | user_id | pack_type | messages_bought | messages_remaining | razorpay_payment_id | razorpay_order_id | price_paid | purchased_at | status | Actions |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2 | 0ca319af-739d-4196-b07f-c77c78b4d159 | a76b6793-aa4b-4451-96ae-7f6dee8ace55 | starter | 10 | 10 | GPA.3378-9345-0780-28845 | GPA.3378-9345-0780-28845 | 1000 | 2026-04-09 04:19:35 | active | |
| 1 | 49e882e3-b274-4e75-ad07-e1ea1d44eaa8 | 73bfbf07-a92a-4767-af69-0c39fdef7b8b | regular | 30 | 30 | GPA.3382-3831-8904-37779 | GPA.3382-3831-8904-37779 | 2500 | 2026-04-08 19:15:02 | active |