Production.ScrapReason Table

Description

Manufacturing failure reasons lookup table.

Properties

Creation Date	27/10/2017 14:33
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	16
Data Space Used	8.00 KB
Index Space Used	24.00 KB

Columns

Column Name	Description	Datatype	Length	Default
ScrapReasonID	Primary key for ScrapReason records.	SmallInt	2
Name	Failure description.	dbo.Name	50
ModifiedDate	Date and time the record was last updated.	DBTimeStamp	4	(getdate())

Indexes

Index	Description	Primary	Unique
AK_ScrapReason_Name	Unique nonclustered index.
PK_ScrapReason_ScrapReasonID	Primary key (clustered) constraint

Relationships

Relationship	Description
FK_WorkOrder_ScrapReason_ScrapReasonID	Foreign key constraint referencing ScrapReason.ScrapReasonID.

Objects that depend on Production.ScrapReason

Database Object	Object Type	Description	Dep Level
iWorkOrder	Trigger	AFTER INSERT trigger that inserts a row in the TransactionHistory table.	2
uWorkOrder	Trigger	AFTER UPDATE trigger that inserts a row in the TransactionHistory table, updates ModifiedDate in the WorkOrder table.	2
Production.WorkOrder	Table	Manufacturing work orders.	1
Production.WorkOrderRouting	Table	Work order details.	2

Objects that Production.ScrapReason depends on

	Database Object	Object Type	Description	Dep Level
	dbo.Name	User Defined Data Type		1

SQL

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [Production].[ScrapReason](
    [ScrapReasonID] [smallint] IDENTITY(1,1) NOT NULL,
    [Name] [dbo].[Name] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_ScrapReason_ScrapReasonID] PRIMARY KEY CLUSTERED 
(
    [ScrapReasonID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

ALTER TABLE [Production].[ScrapReason] ADD  CONSTRAINT [DF_ScrapReason_ModifiedDate]  DEFAULT (getdate()) FOR [ModifiedDate]

Related Objects