Production.WorkOrderRouting Table

Information

Name	WorkOrderRouting
Schema	Production
Row Count	0
Data Size
Index Size
Reserved Size
Unused Size
Created	29.3.2010. 21:58:18
Modified	29.3.2010. 21:58:56

Extended Properties

Name	Type	Property Name	Value
WorkOrderRouting	TABLE	MS_Description	Work order details.

Columns

Name	Data Type	References	Default
WorkOrderID	int	Production.WorkOrder.WorkOrderID
ProductID	int
OperationSequence	smallint
LocationID	smallint	Production.Location.LocationID
ScheduledStartDate	datetime
ScheduledEndDate	datetime
ActualStartDate	datetime
ActualEndDate	datetime
ActualResourceHrs	decimal(9,4)
PlannedCost	money
ActualCost	money
ModifiedDate	datetime		(getdate())

Indexes

Name	Type	Primary	Unique	Columns
PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence	Clustered			WorkOrderID, ProductID, OperationSequence
IX_WorkOrderRouting_ProductID	NonClustered			ProductID

Check Constraints

Name	Column	Expression
CK_WorkOrderRouting_ActualEndDate		([ActualEndDate]>=[ActualStartDate] OR [ActualEndDate] IS NULL OR [ActualStartDate] IS NULL)
CK_WorkOrderRouting_ScheduledEndDate		([ScheduledEndDate]>=[ScheduledStartDate])
CK_WorkOrderRouting_ActualResourceHrs	ActualResourceHrs	([ActualResourceHrs]>=(0.0000))
CK_WorkOrderRouting_PlannedCost	PlannedCost	([PlannedCost]>(0.00))
CK_WorkOrderRouting_ActualCost	ActualCost	([ActualCost]>(0.00))

Foreign Key Constraints

Name	Type	Referenced Table
FK_WorkOrderRouting_Location_LocationID	Foreign key	Production.Location
FK_WorkOrderRouting_WorkOrder_WorkOrderID	Foreign key	Production.WorkOrder

SQL Script

CREATE TABLE [Production].[WorkOrderRouting] (
    [WorkOrderID] int NOT NULL,
    [ProductID] int NOT NULL,
    [OperationSequence] smallint NOT NULL,
    [LocationID] smallint NOT NULL,
    [ScheduledStartDate] datetime NOT NULL,
    [ScheduledEndDate] datetime NOT NULL,
    [ActualStartDate] datetime NULL,
    [ActualEndDate] datetime NULL,
    [ActualResourceHrs] decimal(9,4) NULL,
    [PlannedCost] money NOT NULL,
    [ActualCost] money NULL,
    [ModifiedDate] datetime NOT NULL DEFAULT (getdate())
);
CREATE INDEX [IX_WorkOrderRouting_ProductID] on [Production].[WorkOrderRouting]([ProductID]);