config.barcode_completion

Cascading Deletes: Deleting rows from this table will cascade to: actor.org_unit.

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('config.barcode_completion_id_seq'::regclass)
active	`boolean`	No	true
org_unit FK	`integer`	No		→ actor.org_unit(id)
prefix	`text`	Yes
suffix	`text`	Yes
length	`integer`	No	0
padding	`text`	Yes
padding_end	`boolean`	No	false
asset	`boolean`	No	true
actor	`boolean`	No	true

id PK

integer

nextval('config.barcode_completion_id_seq'::regclass)

active

boolean

true

org_unit FK

integer

→ actor.org_unit(id)

prefix

text

Yes

suffix

text

Yes

length

integer

padding

text

Yes

padding_end

boolean

false

asset

boolean

true

actor

boolean

true

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

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

org_unit

actor.org_unit(id)

CASCADE

NO ACTION

DEFERRED

config_barcode_completion_org_unit_fkey

Indexes

Index Method Definition

Index	Method	Definition
`barcode_completion_pkey` PK	btree	`CREATE UNIQUE INDEX barcode_completion_pkey ON config.barcode_completion USING btree (id)`

barcode_completion_pkey PK

btree

CREATE UNIQUE INDEX barcode_completion_pkey ON config.barcode_completion USING btree (id)