acq.po_note

↑ acq schema

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('acq.po_note_id_seq'::regclass)
purchase_order FK	`integer`	No		→ acq.purchase_order(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
vendor_public	`boolean`	No	false

id PK

integer

nextval('acq.po_note_id_seq'::regclass)

purchase_order FK

integer

→ acq.purchase_order(id)

creator FK

integer

→ actor.usr(id)

editor FK

integer

→ actor.usr(id)

create_time

timestamp with time zone

now()

edit_time

timestamp with time zone

now()

value

text

vendor_public

boolean

false

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`creator`	actor.usr(id)	NO ACTION	NO ACTION	DEFERRED	`po_note_creator_fkey`
`editor`	actor.usr(id)	NO ACTION	NO ACTION	DEFERRED	`po_note_editor_fkey`
`purchase_order`	acq.purchase_order(id)	NO ACTION	NO ACTION	DEFERRED	`po_note_purchase_order_fkey`

creator

actor.usr(id)

NO ACTION

DEFERRED

po_note_creator_fkey

editor

actor.usr(id)

NO ACTION

DEFERRED

po_note_editor_fkey

purchase_order

acq.purchase_order(id)

NO ACTION

DEFERRED

po_note_purchase_order_fkey

Indexes

Index Method Definition

Index	Method	Definition
`po_note_pkey` PK	btree	`CREATE UNIQUE INDEX po_note_pkey ON acq.po_note USING btree (id)`
`acq_po_note_creator_idx`	btree	`CREATE INDEX acq_po_note_creator_idx ON acq.po_note USING btree (creator)`
`acq_po_note_editor_idx`	btree	`CREATE INDEX acq_po_note_editor_idx ON acq.po_note USING btree (editor)`
`po_note_po_idx`	btree	`CREATE INDEX po_note_po_idx ON acq.po_note USING btree (purchase_order)`

po_note_pkey PK

btree

CREATE UNIQUE INDEX po_note_pkey ON acq.po_note USING btree (id)

acq_po_note_creator_idx

btree

CREATE INDEX acq_po_note_creator_idx ON acq.po_note USING btree (creator)

acq_po_note_editor_idx

btree

CREATE INDEX acq_po_note_editor_idx ON acq.po_note USING btree (editor)

po_note_po_idx

btree

CREATE INDEX po_note_po_idx ON acq.po_note USING btree (purchase_order)