Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | INT | 10 | √ | null |
|
|
||||||||
| addToService | BIT | 1 | null |
|
|
|||||||||
| bomId | INT | 10 | null |
|
|
|||||||||
| bomItemGroupId | INT | 10 | √ | null |
|
|
||||||||
| description | VARCHAR | 256 | null |
|
|
|||||||||
| groupDefault | BIT | 1 | null |
|
|
|||||||||
| maxQty | DECIMAL | 28,9 | √ | null |
|
|
||||||||
| minQty | DECIMAL | 28,9 | √ | null |
|
|
||||||||
| oneTimeItem | BIT | 1 | null |
|
|
|||||||||
| partId | INT | 10 | √ | null |
|
|
||||||||
| priceAdjustment | DECIMAL | 28,9 | √ | null |
|
|
||||||||
| productId | INT | 10 | √ | null |
|
|
||||||||
| quantity | DECIMAL | 28,9 | null |
|
|
|||||||||
| sortIdConfig | INT | 10 | null |
|
|
|||||||||
| stage | BIT | 1 | null |
|
|
|||||||||
| stageBomId | INT | 10 | √ | null |
|
|
||||||||
| typeId | INT | 10 | null |
|
|
|||||||||
| uomId | INT | 10 | √ | null |
|
|
||||||||
| useItemLocation | BIT | 1 | null |
|
|
|||||||||
| variableQty | BIT | 1 | null |
|
|
|||||||||
| customFields | JSON | 1073741824 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| FK7n42xf709goe0ddpgmskkyw5c | Performance | Asc | uomId |
| FK99c2vt6pl1q6018pt4bgprt2e | Performance | Asc | typeId |
| FKafig77wjhrxl0nhfvl3rwg42m | Performance | Asc | bomItemGroupId |
| FKafsutqv162b95w8f00ykatr2q | Performance | Asc | bomId |
| FKtews6ftw81upyqqyiwq111asn | Performance | Asc | partId |