serial.subscription_note

↑ serial schema

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

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

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('serial.subscription_note_id_seq'::regclass)

subscription FK

integer

No

→ serial.subscription(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

subscription_note_creator_fkey

subscription

serial.subscription(id)

CASCADE

NO ACTION

DEFERRED

subscription_note_subscription_fkey

Indexes

Index Method Definition

subscription_note_pkey PK

btree

CREATE UNIQUE INDEX subscription_note_pkey ON serial.subscription_note USING btree (id)

serial_subscription_note_sub_idx

btree

CREATE INDEX serial_subscription_note_sub_idx ON serial.subscription_note USING btree (subscription)
Previous
Next