config.print_template

↑ config schema

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

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('config.print_template_id_seq'::regclass)

name

text

No

label

text

No

owner FK

integer

No

→ actor.org_unit(id)

active

boolean

No

false

locale FK

text

Yes

→ config.i18n_locale(code)

content_type

text

No

'text/html'::text

template

text

No

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

owner

actor.org_unit(id)

NO ACTION

NO ACTION

DEFERRED

cpt_owner_fkey

locale

config.i18n_locale(code)

NO ACTION

CASCADE

DEFERRED

print_template_locale_fkey

Unique Constraints

  • label_once_per_lib: (owner, label)

  • name_once_per_lib: (owner, name)

Indexes

Index Method Definition

print_template_pkey PK

btree

CREATE UNIQUE INDEX print_template_pkey ON config.print_template USING btree (id)

label_once_per_lib UNIQUE

btree

CREATE UNIQUE INDEX label_once_per_lib ON config.print_template USING btree (owner, label)

name_once_per_lib UNIQUE

btree

CREATE UNIQUE INDEX name_once_per_lib ON config.print_template USING btree (owner, name)
Previous
Next