acq.provider

↑ acq schema

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: acq_provider_edi_default_fkey, acq_provider_primary_contact_fkey, provider_currency_type_fkey, provider_default_claim_policy_fkey, provider_owner_fkey.

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('acq.provider_id_seq'::regclass)
name	`text`	No
owner FK	`integer`	No		→ actor.org_unit(id)
currency_type FK	`text`	No		→ acq.currency_type(code)
code	`text`	No
holding_tag	`text`	Yes
san	`text`	Yes
buyer_san	`text`	Yes
edi_default FK	`integer`	Yes		→ acq.edi_account(id)
active	`boolean`	No	true
prepayment_required	`boolean`	No	false
url	`text`	Yes
email	`text`	Yes
phone	`text`	Yes
fax_phone	`text`	Yes
default_copy_count	`integer`	No	0
default_claim_policy FK	`integer`	Yes		→ acq.claim_policy(id)
primary_contact FK	`integer`	Yes		→ acq.provider_contact(id)

id PK

integer

nextval('acq.provider_id_seq'::regclass)

name

text

owner FK

integer

→ actor.org_unit(id)

currency_type FK

text

→ acq.currency_type(code)

code

text

holding_tag

text

Yes

san

text

Yes

buyer_san

text

Yes

edi_default FK

integer

Yes

→ acq.edi_account(id)

active

boolean

true

prepayment_required

boolean

false

url

text

Yes

text

Yes

phone

text

Yes

fax_phone

text

Yes

default_copy_count

integer

default_claim_policy FK

integer

Yes

→ acq.claim_policy(id)

primary_contact FK

integer

Yes

→ acq.provider_contact(id)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`edi_default`	acq.edi_account(id)	NO ACTION	NO ACTION	DEFERRED	`acq_provider_edi_default_fkey`
`primary_contact`	acq.provider_contact(id)	SET NULL	CASCADE	DEFERRED	`acq_provider_primary_contact_fkey`
`currency_type`	acq.currency_type(code)	NO ACTION	NO ACTION	DEFERRED	`provider_currency_type_fkey`
`default_claim_policy`	acq.claim_policy(id)	NO ACTION	NO ACTION	DEFERRED	`provider_default_claim_policy_fkey`
`owner`	actor.org_unit(id)	NO ACTION	NO ACTION	DEFERRED	`provider_owner_fkey`

edi_default

acq.edi_account(id)

NO ACTION

DEFERRED

acq_provider_edi_default_fkey

primary_contact

acq.provider_contact(id)

SET NULL

CASCADE

DEFERRED

acq_provider_primary_contact_fkey

currency_type

acq.currency_type(code)

NO ACTION

DEFERRED

provider_currency_type_fkey

default_claim_policy

acq.claim_policy(id)

NO ACTION

DEFERRED

provider_default_claim_policy_fkey

owner

actor.org_unit(id)

NO ACTION

DEFERRED

provider_owner_fkey

Unique Constraints

code_once_per_owner: (code, owner)
provider_name_once_per_owner: (name, owner)

Indexes

Index Method Definition

Index	Method	Definition
`provider_pkey` PK	btree	`CREATE UNIQUE INDEX provider_pkey ON acq.provider USING btree (id)`
`code_once_per_owner` UNIQUE	btree	`CREATE UNIQUE INDEX code_once_per_owner ON acq.provider USING btree (code, owner)`
`provider_name_once_per_owner` UNIQUE	btree	`CREATE UNIQUE INDEX provider_name_once_per_owner ON acq.provider USING btree (name, owner)`

provider_pkey PK

btree

CREATE UNIQUE INDEX provider_pkey ON acq.provider USING btree (id)

code_once_per_owner UNIQUE

btree

CREATE UNIQUE INDEX code_once_per_owner ON acq.provider USING btree (code, owner)

provider_name_once_per_owner UNIQUE

btree

CREATE UNIQUE INDEX provider_name_once_per_owner ON acq.provider USING btree (name, owner)

Referenced By

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

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

Table	Referencing Column(s)	Referenced Column(s)	Constraint
acq.edi_account	`provider`	`id`	`edi_account_provider_fkey`
acq.invoice	`provider`	`id`	`invoice_provider_fkey`
acq.invoice	`shipper`	`id`	`invoice_shipper_fkey`
acq.lineitem	`provider`	`id`	`lineitem_provider_fkey`
acq.lineitem_provider_attr_definition	`provider`	`id`	`lineitem_provider_attr_definition_provider_fkey`
acq.provider_address	`provider`	`id`	`provider_address_provider_fkey`
acq.provider_contact	`provider`	`id`	`provider_contact_provider_fkey`
acq.provider_holding_subfield_map	`provider`	`id`	`provider_holding_subfield_map_provider_fkey`
acq.provider_note	`provider`	`id`	`provider_note_provider_fkey`
acq.purchase_order	`provider`	`id`	`purchase_order_provider_fkey`
acq.shipment_notification	`provider`	`id`	`shipment_notification_provider_fkey`
acq.shipment_notification	`shipper`	`id`	`shipment_notification_shipper_fkey`