aqinvoices - testsql_comments Database

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

invoiceid

INT

10

√

null

aqinvoice_adjustments.invoiceid	aqinvoice_adjustments_fk_invoiceid C
aqorders.invoiceid	aqorders_ibfk_3 N

invoicenumber

LONGTEXT

2147483647

null

booksellerid

INT

10

null

aqbooksellers.id

aqinvoices_fk_aqbooksellerid C

shipmentdate

DATE

10

√

null

billingdate

DATE

10

√

null

closedate

DATE

10

√

null

shipmentcost

DECIMAL

28,6

√

null

shipmentcost_budgetid

INT

10

√

null

aqbudgets.budget_id

aqinvoices_fk_shipmentcost_budgetid N

message_id

INT

10

√

null

edifact_messages.id

edifact_msg_fk N

foreign key to edifact invoice message

Showing 1 to 9 of 9 entries

Table contained 0 rows

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	invoiceid
aqinvoices_fk_aqbooksellerid	Performance	Asc	booksellerid
aqinvoices_fk_shipmentcost_budgetid	Performance	Asc	shipmentcost_budgetid
edifact_msg_fk	Performance	Asc	message_id

Showing 1 to 4 of 4 entries

Relationships

Close relationships within degrees of separation

One
Two degrees