edifact_errors

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
message_id INT 10 null
edifact_messages.id emfk_message C
invoicenumber VARCHAR 48 √ NULL
date DATE 10 √ NULL
section MEDIUMTEXT 16777215 √ NULL
details MEDIUMTEXT 16777215 √ NULL

Indexes

Constraint Name Type Sort Column(s)
edifact_errors_s_pk Primary key Asc id
message_id_invoicenumber Performance Asc/Asc message_id + invoicenumber
messageid Performance Asc message_id
PRIMARY Must be unique Asc id

Relationships