process queue for async job
Name Type Default Nullable Comment
channel text false id integer false payload text false processed timestamp with time zone true ref_id text false either user_id or vessel_id stored timestamp with time zone false
Name Type Definition
process_queue_channel_not_null n NOT NULL channel process_queue_id_not_null n NOT NULL id process_queue_payload_not_null n NOT NULL payload process_queue_pkey PRIMARY KEY PRIMARY KEY (id) process_queue_ref_id_not_null n NOT NULL ref_id process_queue_stored_not_null n NOT NULL stored
Name Definition
process_queue_channel_idx CREATE INDEX process_queue_channel_idx ON public.process_queue USING btree (channel) process_queue_new_logbook_priority_idx CREATE INDEX process_queue_new_logbook_priority_idx ON public.process_queue USING btree (channel, processed, stored) WHERE (processed IS NULL) process_queue_pending_idx CREATE INDEX process_queue_pending_idx ON public.process_queue USING btree (channel, stored DESC) WHERE (processed IS NULL) process_queue_pkey CREATE UNIQUE INDEX process_queue_pkey ON public.process_queue USING btree (id) process_queue_processed_idx CREATE INDEX process_queue_processed_idx ON public.process_queue USING btree (processed) process_queue_ref_id_idx CREATE INDEX process_queue_ref_id_idx ON public.process_queue USING btree (ref_id) process_queue_stored_idx CREATE INDEX process_queue_stored_idx ON public.process_queue USING btree (stored)
erDiagram
"public.process_queue" {
text channel ""
integer id ""
text payload ""
timestamp_with_time_zone processed ""
text ref_id "either user_id or vessel_id"
timestamp_with_time_zone stored ""
}
Generated by tbls