edifact_messages

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
aqinvoices.message_id edifact_msg_fk N
message_type VARCHAR 10 null
transfer_date DATE 10 √ NULL
vendor_id INT 10 √ NULL
aqbooksellers.id emfk_vendor C
edi_acct INT 10 √ NULL
vendor_edi_accounts.id emfk_edi_acct C
status MEDIUMTEXT 16777215 √ NULL
basketno INT 10 √ NULL
aqbasket.basketno emfk_basketno C
raw_msg LONGTEXT 2147483647 √ NULL
filename MEDIUMTEXT 16777215 √ NULL
deleted BOOLEAN 3 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
basketno Performance Asc basketno
ediacct Performance Asc edi_acct
vendorid Performance Asc vendor_id

Relationships

Close relationships within degrees of separation