Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | INT | 10 | √ | null |
|
|
|||||||||||
| activeFlag | BIT | 1 | null |
|
|
||||||||||||
| amount | DECIMAL | 28,9 | √ | null |
|
|
|||||||||||
| description | VARCHAR | 256 | √ | null |
|
|
|||||||||||
| expenseAsAccountId | INT | 10 | √ | null |
|
|
|||||||||||
| incomeAsAccountId | INT | 10 | √ | null |
|
|
|||||||||||
| name | VARCHAR | 31 | null |
|
|
||||||||||||
| percentage | DECIMAL | 28,9 | √ | null |
|
|
|||||||||||
| taxRateId | INT | 10 | √ | null |
|
|
|||||||||||
| taxableFlag | BIT | 1 | null |
|
|
||||||||||||
| typeId | INT | 10 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| FKc887ofbnk53piop7m7egnepln | Performance | Asc | typeId |
| FKhvpil6mta70ljvm479yx8s7vu | Performance | Asc | taxRateId |
| FKpc2eephng0wl94was17rfmuwm | Performance | Asc | expenseAsAccountId |
| FKq836ouecal64y945gsdpm2dvl | Performance | Asc | incomeAsAccountId |
| UKku8d1velqaotmunayhiqpi9wg | Must be unique | Asc | name |