push_notifications rows
Inspect real data stored in Neon for this table.
Table
push_notifications
Schema
public
Columns
19
Storage
96.0 KB
Column schema
Column names and Postgres data types for this table.
iduuidcreated_attimestamp with time zonesourcetextrule_keytexttitletextmessagetextcategorytextdeep_linkjsonbaudiencejsonbsend_after_attimestamp with time zonestatustextguardjsonbdedupe_keytextcreated_byjsonbattemptsintegerlast_errortextsent_attimestamp with time zoneblast_audit_idintegerupdated_attimestamp with time zone
Sample rows
Showing the first 4 rows from this table.
| id | created_at | source | rule_key | title | message | category | deep_link | audience | send_after_at | status | guard | dedupe_key | created_by | attempts | last_error | sent_at | blast_audit_id | updated_at |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| b1f54cca-a4db-4abc-a057-8ed994be13e1 | "2026-07-07T02:09:56.705Z" | manual | null | Welcome to the new portal | Your TaxRise mobile experience just got better. Take a look! | announcement | {"destination":"home"} | {"externalUserIds":["001Nu000003uwsRIAQ"]} | "2026-07-07T02:09:56.994Z" | sent | null | null | {"id":"staff-demo","name":"Jake Bodea","role":"Admin","type":"staff","email":"jake@taxrise.com","authMode":"staff"} | 0 | null | "2026-07-07T02:09:58.140Z" | 18 | "2026-07-07T02:09:56.834Z" |
| f1b55f63-0392-4e0f-bb9c-4a652c755afb | "2026-07-07T02:05:57.663Z" | manual | null | Documents still needed | A few documents on your case are still outstanding. Tap to upload them. | reminder | {"tab":"documents","destination":"inbox"} | {"externalUserIds":["001Nu00000FeBJgIAN"]} | "2026-07-07T02:22:02.032Z" | sent | {"key":"outstanding-requested-docs","params":{"accountId":"001Nu00000FeBJgIAN"}} | null | {"id":"staff-demo","name":"Jake Bodea","role":"Admin","type":"staff","email":"jake@taxrise.com","authMode":"staff"} | 0 | null | "2026-07-07T02:24:18.265Z" | 19 | "2026-07-07T02:24:16.634Z" |
| b080f752-3e39-42fa-b1eb-bdd55b1cb277 | "2026-07-07T02:22:33.153Z" | manual | null | Documents still needed | A few documents on your case are still outstanding. Tap to upload them. | reminder | {"tab":"documents","destination":"inbox"} | {"externalUserIds":["001Nu000003uwsRIAQ"]} | "2026-07-07T02:22:02.126Z" | invalidated | {"key":"outstanding-requested-docs","params":{"accountId":"001Nu000003uwsRIAQ"}} | null | {"id":"staff-demo","name":"Jake Bodea","role":"Admin","type":"staff","email":"jake@taxrise.com","authMode":"staff"} | 0 | guard_condition_cleared | null | null | "2026-07-07T02:24:18.499Z" |
| 9d67b198-b144-4374-b6b5-70b64fe2009e | "2026-07-07T01:57:30.400Z" | rule | tax-organizer-docs-reminder | Documents needed | Thanks for finishing your tax organizer! We still need a few documents to keep your case moving. Tap to upload them. | reminder | {"tab":"documents","destination":"inbox"} | {"externalUserIds":["001Nu00000FeBJgIAN"]} | "2026-07-10T01:57:29.396Z" | canceled | {"key":"outstanding-requested-docs","params":{"accountId":"001Nu00000FeBJgIAN"}} | tax-organizer-docs-reminder:001Nu00000FeBJgIAN:2025 | null | 0 | null | null | null | "2026-07-07T02:30:24.719Z" |