action.ingest_queue

↑ action schema

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: ingest_queue_who_fkey.

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('action.ingest_queue_id_seq'::regclass)
created	`timestamp with time zone`	No	now()
run_at	`timestamp with time zone`	No	now()
who FK	`integer`	Yes		→ actor.usr(id)
start_time	`timestamp with time zone`	Yes
end_time	`timestamp with time zone`	Yes
threads	`integer`	Yes
why	`text`	Yes

id PK

integer

nextval('action.ingest_queue_id_seq'::regclass)

created

timestamp with time zone

now()

run_at

timestamp with time zone

now()

who FK

integer

Yes

→ actor.usr(id)

start_time

timestamp with time zone

Yes

end_time

timestamp with time zone

Yes

threads

integer

Yes

why

text

Yes

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`who`	actor.usr(id)	SET NULL	CASCADE	DEFERRED	`ingest_queue_who_fkey`

who

actor.usr(id)

SET NULL

CASCADE

DEFERRED

ingest_queue_who_fkey

Indexes

Index Method Definition

Index	Method	Definition
`ingest_queue_pkey` PK	btree	`CREATE UNIQUE INDEX ingest_queue_pkey ON action.ingest_queue USING btree (id)`

ingest_queue_pkey PK

btree

CREATE UNIQUE INDEX ingest_queue_pkey ON action.ingest_queue USING btree (id)

Referenced By

The following tables have foreign keys pointing to action.ingest_queue (1 referencing table(s)):

Table Referencing Column(s) Referenced Column(s) Constraint

Table	Referencing Column(s)	Referenced Column(s)	Constraint
action.ingest_queue_entry	`queue`	`id`	`ingest_queue_entry_queue_fkey`

action.ingest_queue_entry

queue

id

ingest_queue_entry_queue_fkey