← All tables and views
AdventureWorks OLTP table
Production.ScrapReason
Manufacturing failure reasons lookup table.
16rows
3 columns
Schema from the provider contract| Column | Type | Nullable | Key | References |
|---|---|---|---|---|
ScrapReasonID | INTEGER | no | PK | — |
Name | TEXT | no | — | — |
ModifiedDate | TEXT | no | — | — |
Keys and unique indexes
Physical SQLite metadataPrimary key is declared above.
Additional unique keys
Production_ScrapReason_AK_ScrapReason_NameName1 unique index inspected
Production_ScrapReason_AK_ScrapReason_NameNameCREATE UNIQUE INDEX "Production_ScrapReason_AK_ScrapReason_Name" ON "Production.ScrapReason" ("Name")Data preview
Sample records
| ScrapReasonID | Name | ModifiedDate |
|---|---|---|
| 1 | Brake assembly not as ordered | 2019-04-30 00:00:00.000 |
| 2 | Color incorrect | 2019-04-30 00:00:00.000 |
| 3 | Gouge in metal | 2019-04-30 00:00:00.000 |
| 4 | Drill pattern incorrect | 2019-04-30 00:00:00.000 |
| 5 | Drill size too large | 2019-04-30 00:00:00.000 |
| 6 | Drill size too small | 2019-04-30 00:00:00.000 |
| 7 | Handling damage | 2019-04-30 00:00:00.000 |
| 8 | Paint process failed | 2019-04-30 00:00:00.000 |
Interactive explorer