acq.edi_account

↑ acq schema

Cascading Deletes: Deleting rows from this table will cascade to: acq.provider.

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

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('config.remote_account_id_seq'::regclass)

label

text

No

host

text

No

username

text

Yes

password

text

Yes

account

text

Yes

path

text

Yes

owner

integer

No

last_activity

timestamp with time zone

Yes

provider FK

integer

No

→ acq.provider(id)

in_dir

text

Yes

vendcode

text

Yes

vendacct

text

Yes

attr_set FK

integer

Yes

→ acq.edi_attr_set(id)

use_attrs

boolean

No

false

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

attr_set

acq.edi_attr_set(id)

NO ACTION

NO ACTION

No

edi_account_attr_set_fkey

provider

acq.provider(id)

CASCADE

NO ACTION

DEFERRED

edi_account_provider_fkey

Indexes

Index Method Definition

edi_account_pkey PK

btree

CREATE UNIQUE INDEX edi_account_pkey ON acq.edi_account USING btree (id)

Referenced By

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

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

acq.edi_message

account

id

edi_message_account_fkey

acq.provider

edi_default

id

acq_provider_edi_default_fkey
Previous
Next