acq.provider_contact

↑ acq schema

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('acq.provider_contact_id_seq'::regclass)
provider FK	`integer`	No		→ acq.provider(id)
name	`text`	No
role	`text`	Yes
email	`text`	Yes
phone	`text`	Yes

id PK

integer

nextval('acq.provider_contact_id_seq'::regclass)

provider FK

integer

→ acq.provider(id)

name

text

role

text

Yes

text

Yes

phone

text

Yes

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`provider`	acq.provider(id)	NO ACTION	NO ACTION	DEFERRED	`provider_contact_provider_fkey`

provider

acq.provider(id)

NO ACTION

DEFERRED

provider_contact_provider_fkey

Indexes

Index Method Definition

Index	Method	Definition
`provider_contact_pkey` PK	btree	`CREATE UNIQUE INDEX provider_contact_pkey ON acq.provider_contact USING btree (id)`

provider_contact_pkey PK

btree

CREATE UNIQUE INDEX provider_contact_pkey ON acq.provider_contact USING btree (id)

Referenced By

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

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

Table	Referencing Column(s)	Referenced Column(s)	Constraint
acq.provider	`primary_contact`	`id`	`acq_provider_primary_contact_fkey`
acq.provider_contact_address	`contact`	`id`	`provider_contact_address_contact_fkey`

acq.provider

primary_contact

id

acq_provider_primary_contact_fkey

acq.provider_contact_address

contact

id

provider_contact_address_contact_fkey