api.eventlogs_view
Description
Event logs view
Table Definition
CREATE VIEW eventlogs_view AS (
SELECT id,
channel,
payload,
ref_id,
stored,
processed
FROM process_queue pq
WHERE ((processed IS NOT NULL) AND (channel <> ALL (ARRAY['new_stay'::text, 'pre_logbook'::text, 'post_logbook'::text])) AND ((ref_id = current_setting('user.id'::text, true)) OR (ref_id = current_setting('vessel.id'::text, true))))
ORDER BY id DESC
)
Columns
| Name | Type | Default | Nullable |
|---|---|---|---|
| channel | text | true | |
| id | bigint | true | |
| payload | text | true | |
| processed | timestamp with time zone | true | |
| ref_id | text | true | |
| stored | timestamp with time zone | true |
Referenced Tables
| Name | Columns | Comment | Type |
|---|---|---|---|
| public.process_queue | 6 | process queue for async job | BASE TABLE |
Relations
erDiagram
"api.eventlogs_view" {
text channel ""
bigint id ""
text payload ""
timestamp_with_time_zone processed ""
text ref_id ""
timestamp_with_time_zone stored ""
}
Generated by tbls