actor.stat_cat_entry_default

↑ actor schema

User Statistical Category Default Entry

A library may choose one of the stat_cat entries to be the default entry.

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

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

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('actor.stat_cat_entry_default_id_seq'::regclass)

stat_cat_entry FK

integer

No

→ actor.stat_cat_entry(id)

stat_cat FK

integer

No

→ actor.stat_cat(id)

owner FK

integer

No

→ actor.org_unit(id)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

owner

actor.org_unit(id)

CASCADE

NO ACTION

DEFERRED

stat_cat_entry_default_owner_fkey

stat_cat_entry

actor.stat_cat_entry(id)

CASCADE

NO ACTION

DEFERRED

stat_cat_entry_default_stat_cat_entry_fkey

stat_cat

actor.stat_cat(id)

CASCADE

NO ACTION

DEFERRED

stat_cat_entry_default_stat_cat_fkey

Unique Constraints

  • sced_once_per_owner: (stat_cat, owner)

Indexes

Index Method Definition

stat_cat_entry_default_pkey PK

btree

CREATE UNIQUE INDEX stat_cat_entry_default_pkey ON actor.stat_cat_entry_default USING btree (id)

sced_once_per_owner UNIQUE

btree

CREATE UNIQUE INDEX sced_once_per_owner ON actor.stat_cat_entry_default USING btree (stat_cat, owner)
Previous
Next