config.copy_alert_type

↑ config schema

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

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('config.copy_alert_type_id_seq'::regclass)

scope_org FK

integer

No

→ actor.org_unit(id)

active

boolean

No

true

name

text

No

state

config.copy_alert_type_state

Yes

event

config.copy_alert_type_event

Yes

in_renew

boolean

Yes

invert_location

boolean

No

false

at_circ

boolean

Yes

at_owning

boolean

Yes

next_status

integer[]

Yes

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

scope_org

actor.org_unit(id)

CASCADE

NO ACTION

No

copy_alert_type_scope_org_fkey

Unique Constraints

  • copy_alert_type_name_key: (name)

Indexes

Index Method Definition

copy_alert_type_pkey PK

btree

CREATE UNIQUE INDEX copy_alert_type_pkey ON config.copy_alert_type USING btree (id)

copy_alert_type_name_key UNIQUE

btree

CREATE UNIQUE INDEX copy_alert_type_name_key ON config.copy_alert_type USING btree (name)

Referenced By

The following tables have foreign keys pointing to config.copy_alert_type (2 referencing table(s)):

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

actor.copy_alert_suppress

alert_type

id

copy_alert_suppress_alert_type_fkey

asset.copy_alert

alert_type

id

copy_alert_alert_type_fkey
Previous
Next