edi_message

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('acq.edi_message_id_seq'::regclass)
account int4 10 √ null
edi_account.id edi_message_account_fkey R
remote_file text 2147483647 √ null
create_time timestamptz 35,6 now()
translate_time timestamptz 35,6 √ null
process_time timestamptz 35,6 √ null
error_time timestamptz 35,6 √ null
status text 2147483647 'new'::text
edi text 2147483647 √ null
jedi text 2147483647 √ null
error text 2147483647 √ null
purchase_order int4 10 √ null
purchase_order.id edi_message_purchase_order_fkey R
message_type text 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
edi_message_pkey Primary key Asc id
edi_message_account_status_idx Performance Asc/Asc account + status
edi_message_po_idx Performance Asc purchase_order
edi_message_remote_file_idx Performance

Check Constraints

Constraint Name Constraint
valid_message_type ((message_type = ANY (ARRAY['ORDERS'::text, 'ORDRSP'::text, 'INVOIC'::text, 'OSTENQ'::text, 'OSTRPT'::text, 'DESADV'::text])))
status_value ((status = ANY (ARRAY['new'::text, 'translated'::text, 'trans_error'::text, 'processed'::text, 'proc_error'::text, 'delete_error'::text, 'retry'::text, 'complete'::text])))

Relationships

Close relationships within degrees of separation