acq.lineitem_alert_text

↑ acq schema

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('acq.lineitem_alert_text_id_seq'::regclass)
code	`text`	No
description	`text`	Yes
owning_lib FK	`integer`	No		→ actor.org_unit(id)

id PK

integer

nextval('acq.lineitem_alert_text_id_seq'::regclass)

code

text

description

text

Yes

owning_lib FK

integer

→ actor.org_unit(id)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`owning_lib`	actor.org_unit(id)	NO ACTION	NO ACTION	DEFERRED	`lineitem_alert_text_owning_lib_fkey`

owning_lib

actor.org_unit(id)

NO ACTION

DEFERRED

lineitem_alert_text_owning_lib_fkey

Unique Constraints

alert_one_code_per_org: (code, owning_lib)

Indexes

Index Method Definition

Index	Method	Definition
`lineitem_alert_text_pkey` PK	btree	`CREATE UNIQUE INDEX lineitem_alert_text_pkey ON acq.lineitem_alert_text USING btree (id)`
`alert_one_code_per_org` UNIQUE	btree	`CREATE UNIQUE INDEX alert_one_code_per_org ON acq.lineitem_alert_text USING btree (code, owning_lib)`

lineitem_alert_text_pkey PK

btree

CREATE UNIQUE INDEX lineitem_alert_text_pkey ON acq.lineitem_alert_text USING btree (id)

alert_one_code_per_org UNIQUE

btree

CREATE UNIQUE INDEX alert_one_code_per_org ON acq.lineitem_alert_text USING btree (code, owning_lib)

Referenced By

The following tables have foreign keys pointing to acq.lineitem_alert_text (1 referencing table(s)):

Table Referencing Column(s) Referenced Column(s) Constraint

Table	Referencing Column(s)	Referenced Column(s)	Constraint
acq.lineitem_note	`alert_text`	`id`	`lineitem_note_alert_text_fkey`

acq.lineitem_note

alert_text

id

lineitem_note_alert_text_fkey