provider

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('acq.provider_id_seq'::regclass)
edi_account.provider edi_account_provider_fkey C
invoice.provider invoice_provider_fkey R
invoice.shipper invoice_shipper_fkey R
lineitem.provider lineitem_provider_fkey R
lineitem_provider_attr_definition.provider lineitem_provider_attr_definition_provider_fkey R
provider_address.provider provider_address_provider_fkey R
provider_contact.provider provider_contact_provider_fkey R
provider_holding_subfield_map.provider provider_holding_subfield_map_provider_fkey R
provider_note.provider provider_note_provider_fkey R
purchase_order.provider purchase_order_provider_fkey R
shipment_notification.provider shipment_notification_provider_fkey R
shipment_notification.shipper shipment_notification_shipper_fkey R
name text 2147483647 null
owner int4 10 null
org_unit.id provider_owner_fkey R
currency_type text 2147483647 null
currency_type.code provider_currency_type_fkey R
code text 2147483647 null
holding_tag text 2147483647 √ null
san text 2147483647 √ null
buyer_san text 2147483647 √ null
edi_default int4 10 √ null
edi_account.id acq_provider_edi_default_fkey R
active bool 1 true
prepayment_required bool 1 false
url text 2147483647 √ null
email text 2147483647 √ null
phone text 2147483647 √ null
fax_phone text 2147483647 √ null
default_copy_count int4 10 0
default_claim_policy int4 10 √ null
claim_policy.id provider_default_claim_policy_fkey R
primary_contact int4 10 √ null
provider_contact.id acq_provider_primary_contact_fkey N

Indexes

Constraint Name Type Sort Column(s)
provider_pkey Primary key Asc id
code_once_per_owner Must be unique Asc/Asc code + owner
provider_name_once_per_owner Must be unique Asc/Asc name + owner

Relationships

Close relationships within degrees of separation