serial.stream

↑ serial schema

Cascading Deletes: Deleting rows from this table will cascade to: serial.distribution.

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

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('serial.stream_id_seq'::regclass)

distribution FK

integer

No

→ serial.distribution(id)

routing_label

text

Yes

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

distribution

serial.distribution(id)

CASCADE

NO ACTION

DEFERRED

stream_distribution_fkey

Indexes

Index Method Definition

stream_pkey PK

btree

CREATE UNIQUE INDEX stream_pkey ON serial.stream USING btree (id)

label_once_per_dist UNIQUE

btree

CREATE UNIQUE INDEX label_once_per_dist ON serial.stream USING btree (distribution, routing_label) WHERE (routing_label IS NOT NULL)

serial_stream_dist_idx

btree

CREATE INDEX serial_stream_dist_idx ON serial.stream USING btree (distribution)

Referenced By

The following tables have foreign keys pointing to serial.stream (2 referencing table(s)):

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

serial.item

stream

id

item_stream_fkey

serial.routing_list_user

stream

id

routing_list_user_stream_fkey
Previous
Next