acq.claim_event_type

↑ acq schema

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

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('acq.claim_event_type_id_seq'::regclass)

org_unit FK

integer

No

→ actor.org_unit(id)

code

text

No

description

text

No

library_initiated

boolean

No

false

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

org_unit

actor.org_unit(id)

NO ACTION

NO ACTION

DEFERRED

claim_event_type_org_unit_fkey

Unique Constraints

  • event_type_once_per_org: (org_unit, code)

Indexes

Index Method Definition

claim_event_type_pkey PK

btree

CREATE UNIQUE INDEX claim_event_type_pkey ON acq.claim_event_type USING btree (id)

event_type_once_per_org UNIQUE

btree

CREATE UNIQUE INDEX event_type_once_per_org ON acq.claim_event_type USING btree (org_unit, code)

Referenced By

The following tables have foreign keys pointing to acq.claim_event_type (3 referencing table(s)):

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

acq.claim_event

type

id

claim_event_type_fkey

acq.claim_policy_action

action

id

claim_policy_action_action_fkey

acq.serial_claim_event

type

id

serial_claim_event_type_fkey
Previous
Next