serial.pattern_template

↑ serial schema

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('serial.pattern_template_id_seq'::regclass)
name	`text`	No
pattern_code	`text`	No
owning_lib FK	`integer`	Yes		→ actor.org_unit(id)
share_depth	`integer`	No	0

id PK

integer

nextval('serial.pattern_template_id_seq'::regclass)

name

text

pattern_code

text

owning_lib FK

integer

Yes

→ actor.org_unit(id)

share_depth

integer

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	`pattern_template_owning_lib_fkey`

owning_lib

actor.org_unit(id)

NO ACTION

DEFERRED

pattern_template_owning_lib_fkey

Indexes

Index Method Definition

Index	Method	Definition
`pattern_template_pkey` PK	btree	`CREATE UNIQUE INDEX pattern_template_pkey ON serial.pattern_template USING btree (id)`
`serial_pattern_template_name_idx`	btree	`CREATE INDEX serial_pattern_template_name_idx ON serial.pattern_template USING btree (lowercase(name))`

pattern_template_pkey PK

btree

CREATE UNIQUE INDEX pattern_template_pkey ON serial.pattern_template USING btree (id)

serial_pattern_template_name_idx

btree

CREATE INDEX serial_pattern_template_name_idx ON serial.pattern_template USING btree (lowercase(name))