Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | INT | 10 | √ | null |
|
|
|||||
| crossShipFlag | BIT | 1 | null |
|
|
||||||
| dateResolved | DATETIME | 26 | √ | null |
|
|
|||||
| issueId | INT | 10 | √ | null |
|
|
|||||
| lineNum | INT | 10 | null |
|
|
||||||
| note | LONGTEXT | 2147483647 | √ | null |
|
|
|||||
| productId | INT | 10 | null |
|
|
||||||
| productSubId | INT | 10 | √ | null |
|
|
|||||
| qty | DECIMAL | 28,9 | √ | null |
|
|
|||||
| resolutionId | INT | 10 | √ | null |
|
|
|||||
| returnFlag | BIT | 1 | null |
|
|
||||||
| rmaId | INT | 10 | null |
|
|
||||||
| shipFlag | BIT | 1 | null |
|
|
||||||
| typeId | INT | 10 | null |
|
|
||||||
| uomId | INT | 10 | null |
|
|
||||||
| vendorId | INT | 10 | √ | null |
|
|
|||||
| vendorRMA | VARCHAR | 25 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| FK422sbdwhwbqx2q2mh3pok8s3 | Performance | Asc | productId |
| FK7wejyg9945fkksqjr94mmx1ko | Performance | Asc | vendorId |
| FK8b8k2bq6m53krwkyj76m7xpbc | Performance | Asc | typeId |
| FKcmlrb6s44mv1tylo01g7gn48d | Performance | Asc | rmaId |
| FKm7ik7bejnd1o9t9mj4st10s8 | Performance | Asc | uomId |
| FKn1iu90y8r0xlkset9273ami9t | Performance | Asc | productSubId |