SchemaSpy - Table testsql_comments.edifact_messages

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

int

10

√

aqinvoices.message_id

edifact_msg_fk N

fieldmapping.id

Implied Constraint R

message_type

varchar

10

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

text

65535

√

null

basketno

int

10

√

null

aqbasket.basketno

emfk_basketno C

raw_msg

mediumtext

16777215

√

null

filename

text

65535

√

null

deleted

bit

0

0

Table contained 0 rows at Tue Dec 27 17:18 NZDT 2016

Indexes:

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