invoiceledgeritem

647 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
type VARCHAR 255 null
invoiceNumber INT 10 null
date DATETIME 19 null
firstName VARCHAR 255 √ null
lastName VARCHAR 255 √ null
company VARCHAR 255 √ null
street VARCHAR 255 √ null
zip VARCHAR 255 √ null
city VARCHAR 255 null
nettoValue DECIMAL 10,2 null
bruttoValue DECIMAL 10,2 null
vatValue DECIMAL 10,2 null
invoiceLedger_id VARCHAR 36 √ null
invoiceledger.id FK_E952138C14A08E46R
payment_id VARCHAR 36 √ null
payment.id FK_E952138C4C3A3BBR
customer_id VARCHAR 36 √ null
customer.id FK_E952138C9395C3F3R
orderNumber INT 10 null
order_id VARCHAR 36 √ null
orders.id FK_E952138C8D9F6D38R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_E952138C14A08E46 Performance Asc invoiceLedger_id
IDX_E952138C4C3A3BB Performance Asc payment_id
IDX_E952138C8D9F6D38 Performance Asc order_id
IDX_E952138C9395C3F3 Performance Asc customer_id

Relationships

Close relationships within degrees of separation