Live analytics
Day Passes
Purchased, active and expired day passes.
Table metadata
Rows: 4Page: 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_payment_id | TEXT | 0 | 0 | — |
| razorpay_order_id | TEXT | 0 | 0 | — |
| price_paid | INTEGER | 0 | 1 | — |
| purchased_at | TEXT | 0 | 0 | datetime('now') |
| activated_at | TEXT | 0 | 0 | — |
| expires_at | TEXT | 0 | 0 | — |
| status | TEXT | 0 | 0 | 'purchased' |
Rows
Manage rows
Create, edit, and delete live rows directly from the SQLite database.
| __rowid__ | id | user_id | razorpay_payment_id | razorpay_order_id | price_paid | purchased_at | activated_at | expires_at | status | Actions |
|---|---|---|---|---|---|---|---|---|---|---|
| 4 | 768d426d-d1a7-4cc4-80c0-685543877ae6 | 965ca4fb-4144-4b05-b438-36e38d3ca019 | GPA.3372-5901-4704-53809 | GPA.3372-5901-4704-53809 | 3900 | 2026-04-13 14:30:15 | 2026-04-18T20:22:51.619Z | 2026-04-19T20:22:51.619Z | active | |
| 3 | 81531715-105a-4114-aaa8-59a0b27924c2 | 73bfbf07-a92a-4767-af69-0c39fdef7b8b | GPA.3375-6699-8946-03898 | GPA.3375-6699-8946-03898 | 3900 | 2026-04-09 15:09:16 | — | — | purchased | |
| 2 | e9b1c925-82e2-464e-b231-fab54395a0a2 | 2cc17424-c6f7-471e-861f-443267285a6c | GPA.3395-5399-6301-96673 | GPA.3395-5399-6301-96673 | 3900 | 2026-04-09 04:54:38 | 2026-04-09T13:42:09.024Z | 2026-04-10T13:42:09.024Z | expired | |
| 1 | 5f1fa1a9-40b7-4e1e-b230-07c4910c6f8a | a76b6793-aa4b-4451-96ae-7f6dee8ace55 | GPA.3353-7972-5666-57341 | GPA.3353-7972-5666-57341 | 3900 | 2026-04-09 04:20:12 | 2026-04-10T02:41:04.971Z | 2026-04-11T02:41:04.971Z | expired |