edifact_messages

Columns

Related columns Constraint Comments

Search:

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

Showing 1 to 10 of 10 entries

Table contained 0 rows

Indexes

Search:

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

Showing 1 to 4 of 4 entries

Relationships

Close relationships within degrees of separation

One
Two degrees