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 <> 'new_stay'::text) AND (channel <> 'pre_logbook'::text) AND (channel <> 'post_logbook'::text) AND ((ref_id = current_setting('user.id'::text, false)) OR (ref_id = current_setting('vessel.id'::text, true))))
ORDER BY id DESC
)
Columns
| Name | Type | Default | Nullable |
|---|---|---|---|
| channel | text | true | |
| id | integer | 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 ""
integer id ""
text payload ""
timestamp_with_time_zone processed ""
text ref_id ""
timestamp_with_time_zone stored ""
}
Generated by tbls