acq.claim_type

↑ acq schema

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('acq.claim_type_id_seq'::regclass)
org_unit FK	`integer`	No		→ actor.org_unit(id)
code	`text`	No
description	`text`	No

id PK

integer

nextval('acq.claim_type_id_seq'::regclass)

org_unit FK

integer

→ actor.org_unit(id)

code

text

description

text

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`org_unit`	actor.org_unit(id)	NO ACTION	NO ACTION	DEFERRED	`claim_type_org_unit_fkey`

org_unit

actor.org_unit(id)

NO ACTION

DEFERRED

claim_type_org_unit_fkey

Unique Constraints

claim_type_once_per_org: (org_unit, code)

Indexes

Index Method Definition

Index	Method	Definition
`claim_type_pkey` PK	btree	`CREATE UNIQUE INDEX claim_type_pkey ON acq.claim_type USING btree (id)`
`claim_type_once_per_org` UNIQUE	btree	`CREATE UNIQUE INDEX claim_type_once_per_org ON acq.claim_type USING btree (org_unit, code)`

claim_type_pkey PK

btree

CREATE UNIQUE INDEX claim_type_pkey ON acq.claim_type USING btree (id)

claim_type_once_per_org UNIQUE

btree

CREATE UNIQUE INDEX claim_type_once_per_org ON acq.claim_type USING btree (org_unit, code)

Referenced By

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

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

Table	Referencing Column(s)	Referenced Column(s)	Constraint
acq.claim	`type`	`id`	`claim_type_fkey`
acq.serial_claim	`type`	`id`	`serial_claim_type_fkey`

acq.claim

type

id

claim_type_fkey

acq.serial_claim

type

id

serial_claim_type_fkey