acq.provider_address

↑ acq schema

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('acq.provider_address_id_seq'::regclass)
valid	`boolean`	No	true
address_type	`text`	Yes
provider FK	`integer`	No		→ acq.provider(id)
street1	`text`	No
street2	`text`	Yes
city	`text`	No
county	`text`	Yes
state	`text`	No
country	`text`	No
post_code	`text`	No
fax_phone	`text`	Yes

id PK

integer

nextval('acq.provider_address_id_seq'::regclass)

valid

boolean

true

address_type

text

Yes

provider FK

integer

→ acq.provider(id)

street1

text

street2

text

Yes

city

text

county

text

Yes

state

text

country

text

post_code

text

fax_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_address_provider_fkey`

provider

acq.provider(id)

NO ACTION

DEFERRED

provider_address_provider_fkey

Indexes

Index Method Definition

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

provider_address_pkey PK

btree

CREATE UNIQUE INDEX provider_address_pkey ON acq.provider_address USING btree (id)