acq.lineitem_note

↑ acq schema

Cascading Deletes: Deleting rows from this table will cascade to: acq.lineitem.

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: lineitem_note_alert_text_fkey, lineitem_note_creator_fkey, lineitem_note_editor_fkey, lineitem_note_lineitem_fkey.

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('acq.lineitem_note_id_seq'::regclass)

lineitem FK

integer

No

→ acq.lineitem(id)

creator FK

integer

No

→ actor.usr(id)

editor FK

integer

No

→ actor.usr(id)

create_time

timestamp with time zone

No

now()

edit_time

timestamp with time zone

No

now()

value

text

No

alert_text FK

integer

Yes

→ acq.lineitem_alert_text(id)

vendor_public

boolean

No

false

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

alert_text

acq.lineitem_alert_text(id)

NO ACTION

NO ACTION

DEFERRED

lineitem_note_alert_text_fkey

creator

actor.usr(id)

NO ACTION

NO ACTION

DEFERRED

lineitem_note_creator_fkey

editor

actor.usr(id)

NO ACTION

NO ACTION

DEFERRED

lineitem_note_editor_fkey

lineitem

acq.lineitem(id)

CASCADE

NO ACTION

DEFERRED

lineitem_note_lineitem_fkey

Indexes

Index Method Definition

lineitem_note_pkey PK

btree

CREATE UNIQUE INDEX lineitem_note_pkey ON acq.lineitem_note USING btree (id)

li_note_creator_idx

btree

CREATE INDEX li_note_creator_idx ON acq.lineitem_note USING btree (creator)

li_note_editor_idx

btree

CREATE INDEX li_note_editor_idx ON acq.lineitem_note USING btree (editor)

li_note_li_idx

btree

CREATE INDEX li_note_li_idx ON acq.lineitem_note USING btree (lineitem)
Previous
Next