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 |
|
|
||||
payment_id | VARCHAR | 36 | √ | null |
|
|
||||
customer_id | VARCHAR | 36 | √ | null |
|
|
||||
orderNumber | INT | 10 | null |
|
|
|||||
order_id | VARCHAR | 36 | √ | null |
|
|
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 |