edifact_messages


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 BIT 0 0

Table contained 0 rows

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