serial.routing_list_user

↑ serial schema

Cascading Deletes: Rows in this table will be automatically deleted when rows are deleted from: actor.usr, serial.stream.

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

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('serial.routing_list_user_id_seq'::regclass)

stream FK

integer

No

→ serial.stream(id)

pos

integer

No

1

reader FK

integer

Yes

→ actor.usr(id)

department

text

Yes

note

text

Yes

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

reader

actor.usr(id)

CASCADE

NO ACTION

DEFERRED

routing_list_user_reader_fkey

stream

serial.stream(id)

CASCADE

NO ACTION

DEFERRED

routing_list_user_stream_fkey

Unique Constraints

  • one_pos_per_routing_list: (stream, pos)

Check Constraints

  • reader_or_dept: CHECK ((reader IS NOT NULL) AND (department IS NULL OR reader IS NULL) AND (department IS NOT NULL))

Indexes

Index Method Definition

routing_list_user_pkey PK

btree

CREATE UNIQUE INDEX routing_list_user_pkey ON serial.routing_list_user USING btree (id)

one_pos_per_routing_list UNIQUE

btree

CREATE UNIQUE INDEX one_pos_per_routing_list ON serial.routing_list_user USING btree (stream, pos)

serial_routing_list_user_reader_idx

btree

CREATE INDEX serial_routing_list_user_reader_idx ON serial.routing_list_user USING btree (reader)

serial_routing_list_user_stream_idx

btree

CREATE INDEX serial_routing_list_user_stream_idx ON serial.routing_list_user USING btree (stream)
Previous
Next