serial.distribution_note

↑ 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: distribution_note_creator_fkey, distribution_note_distribution_fkey.

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('serial.distribution_note_id_seq'::regclass)

distribution FK

integer

No

→ serial.distribution(id)

creator FK

integer

No

→ actor.usr(id)

create_date

timestamp with time zone

Yes

now()

pub

boolean

No

false

alert

boolean

No

false

title

text

No

value

text

No

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

creator

actor.usr(id)

NO ACTION

NO ACTION

DEFERRED

distribution_note_creator_fkey

distribution

serial.distribution(id)

CASCADE

NO ACTION

DEFERRED

distribution_note_distribution_fkey

Indexes

Index Method Definition

distribution_note_pkey PK

btree

CREATE UNIQUE INDEX distribution_note_pkey ON serial.distribution_note USING btree (id)

serial_distribution_note_dist_idx

btree

CREATE INDEX serial_distribution_note_dist_idx ON serial.distribution_note USING btree (distribution)
Previous
Next