Generated using SQL Data Dictionary demo version.
Manufacturing failure reasons lookup table.
| Column | Data Type | Identity | Nullable | Default | |
|---|---|---|---|---|---|
| PK | ScrapReasonID | smallint | X | ||
| Primary key for ScrapReason records. | |||||
| UK | Name | Name(nvarchar(50)) | |||
| Failure description. | |||||
| ModifiedDate | datetime | getdate() | |||
| Date and time the record was last updated. | |||||
Primary key (clustered) constraint
Unique nonclustered index.