app.inbox_items
View
The signed-in person's Inbox (Section 11.10 rule 5): live notifications that are not Done or snoozed, sorted into Needs You (approvals, mentions, assignments) and For Your Information, with the approval an approval request is about. Read with the person's own row level security.
| Column | Type | Nullable | Description |
|---|---|---|---|
| id | uuid | Yes | Notification id. |
| org_id | uuid | Yes | Org of the notification. |
| created_at | timestamp with time zone | Yes | When it arrived. |
| kind | text | Yes | Notification kind. |
| actor_person_id | uuid | Yes | Person whose action caused it. |
| subject_table | text | Yes | Table of the record it is about. |
| subject_id | uuid | Yes | Record it is about. |
| project_id | uuid | Yes | Project of the record. |
| message_args | jsonb | Yes | Catalog message arguments. |
| read_at | timestamp with time zone | Yes | When the person read it. |
| section | text | Yes | Needs You or For Your Information. |
| document_type | app.spend_document_type | Yes | For an approval request: the spend document type. |
| subject_reference | text | Yes | For an approval request: the document's number or name. |
| amount_minor | bigint | Yes | For an approval request: the amount in minor units. |
| currency_code | character(3) | Yes | For an approval request: the currency. |
| approval_state | app.approval_state | Yes | For an approval request: its state now. |
| current_step | smallint | Yes | For an approval request: the step it waits on. |
| approval_policy_id | uuid | Yes | For an approval request: its policy. |