• lsrep17 Documentation
  • Tables [Production].[WorkOrderRouting]
    Work order details.
    PropertyValue
    Row Count (~)67131
    Created13:14:19 14 marca 2012
    Last Modified13:14:55 14 marca 2012
    KeyNameData TypeMax Length (Bytes)Allow NullsDefaultDescription
    Cluster Primary Key PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence: WorkOrderID\ProductID\OperationSequenceForeign Keys FK_WorkOrderRouting_WorkOrder_WorkOrderID: [Production].[WorkOrder].WorkOrderIDWorkOrderIDint4
    False
    Primary key. Foreign key to WorkOrder.WorkOrderID.
    Cluster Primary Key PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence: WorkOrderID\ProductID\OperationSequenceIndexes IX_WorkOrderRouting_ProductIDProductIDint4
    False
    Primary key. Foreign key to Product.ProductID.
    Cluster Primary Key PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence: WorkOrderID\ProductID\OperationSequenceOperationSequencesmallint2
    False
    Primary key. Indicates the manufacturing process sequence.
    Foreign Keys FK_WorkOrderRouting_Location_LocationID: [Production].[Location].LocationIDLocationIDsmallint2
    False
    Manufacturing location where the part is processed. Foreign key to Location.LocationID.
    ScheduledStartDatedatetime8
    False
    Planned manufacturing start date.
    ScheduledEndDatedatetime8
    False
    Planned manufacturing end date.
    ActualStartDatedatetime8
    True
    Actual start date.
    ActualEndDatedatetime8
    True
    Actual end date.
    Check Constraints CK_WorkOrderRouting_ActualResourceHrs : ([ActualResourceHrs]>=(0.0000))ActualResourceHrsdecimal(9,4)5
    True
    Number of manufacturing hours used.
    Check Constraints CK_WorkOrderRouting_PlannedCost : ([PlannedCost]>(0.00))PlannedCostmoney8
    False
    Estimated manufacturing cost.
    Check Constraints CK_WorkOrderRouting_ActualCost : ([ActualCost]>(0.00))ActualCostmoney8
    True
    Actual manufacturing cost.
    ModifiedDatedatetime8
    False
    (getdate())Date and time the record was last updated.
    KeyNameKey ColumnsUniqueDescription
    Cluster Primary Key PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence: WorkOrderID\ProductID\OperationSequencePK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequenceWorkOrderID, ProductID, OperationSequence
    True
    Primary key (clustered) constraint
    IX_WorkOrderRouting_ProductIDProductIDNonclustered index.
    NameOn ColumnConstraintDescription
    CK_WorkOrderRouting_ActualCostActualCost([ActualCost]>(0.00))Check constraint [ActualCost] > (0.00)
    CK_WorkOrderRouting_ActualEndDate([ActualEndDate]>=[ActualStartDate] OR [ActualEndDate] IS NULL OR [ActualStartDate] IS NULL)Check constraint [ActualEndDate] >= [ActualStartDate] OR [ActualEndDate] IS NULL OR [ActualStartDate] IS NULL
    CK_WorkOrderRouting_ActualResourceHrsActualResourceHrs([ActualResourceHrs]>=(0.0000))Check constraint [ActualResourceHrs] >= (0.0000)
    CK_WorkOrderRouting_PlannedCostPlannedCost([PlannedCost]>(0.00))Check constraint [PlannedCost] > (0.00)
    CK_WorkOrderRouting_ScheduledEndDate([ScheduledEndDate]>=[ScheduledStartDate])Check constraint [ScheduledEndDate] >= [ScheduledStartDate]
    NameColumnsDescription
    FK_WorkOrderRouting_Location_LocationIDLocationID->[Production].[Location].[LocationID]Foreign key constraint referencing Location.LocationID.
    FK_WorkOrderRouting_WorkOrder_WorkOrderIDWorkOrderID->[Production].[WorkOrder].[WorkOrderID]Foreign key constraint referencing WorkOrder.WorkOrderID.
    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 CONSTRAINT [DF_WorkOrderRouting_ModifiedDate] DEFAULT (getdate())
    ) ON [PRIMARY]
    GO
    ALTER TABLE [Production].[WorkOrderRouting] ADD CONSTRAINT [CK_WorkOrderRouting_ActualCost] CHECK (([ActualCost]>(0.00)))
    GO
    ALTER TABLE [Production].[WorkOrderRouting] ADD CONSTRAINT [CK_WorkOrderRouting_ActualEndDate] CHECK (([ActualEndDate]>=[ActualStartDate] OR [ActualEndDate] IS NULL OR [ActualStartDate] IS NULL))
    GO
    ALTER TABLE [Production].[WorkOrderRouting] ADD CONSTRAINT [CK_WorkOrderRouting_ActualResourceHrs] CHECK (([ActualResourceHrs]>=(0.0000)))
    GO
    ALTER TABLE [Production].[WorkOrderRouting] ADD CONSTRAINT [CK_WorkOrderRouting_PlannedCost] CHECK (([PlannedCost]>(0.00)))
    GO
    ALTER TABLE [Production].[WorkOrderRouting] ADD CONSTRAINT [CK_WorkOrderRouting_ScheduledEndDate] CHECK (([ScheduledEndDate]>=[ScheduledStartDate]))
    GO
    ALTER TABLE [Production].[WorkOrderRouting] ADD CONSTRAINT [PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence] PRIMARY KEY CLUSTERED  ([WorkOrderID], [ProductID], [OperationSequence]) ON [PRIMARY]
    GO
    CREATE NONCLUSTERED INDEX [IX_WorkOrderRouting_ProductID] ON [Production].[WorkOrderRouting] ([ProductID]) ON [PRIMARY]
    GO
    ALTER TABLE [Production].[WorkOrderRouting] ADD CONSTRAINT [FK_WorkOrderRouting_Location_LocationID] FOREIGN KEY ([LocationID]) REFERENCES [Production].[Location] ([LocationID])
    GO
    ALTER TABLE [Production].[WorkOrderRouting] ADD CONSTRAINT [FK_WorkOrderRouting_WorkOrder_WorkOrderID] FOREIGN KEY ([WorkOrderID]) REFERENCES [Production].[WorkOrder] ([WorkOrderID])
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Work order details.', 'SCHEMA', N'Production', 'TABLE', N'WorkOrderRouting', NULL, NULL
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Actual manufacturing cost.', 'SCHEMA', N'Production', 'TABLE', N'WorkOrderRouting', 'COLUMN', N'ActualCost'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Actual end date.', 'SCHEMA', N'Production', 'TABLE', N'WorkOrderRouting', 'COLUMN', N'ActualEndDate'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Number of manufacturing hours used.', 'SCHEMA', N'Production', 'TABLE', N'WorkOrderRouting', 'COLUMN', N'ActualResourceHrs'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Actual start date.', 'SCHEMA', N'Production', 'TABLE', N'WorkOrderRouting', 'COLUMN', N'ActualStartDate'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Manufacturing location where the part is processed. Foreign key to Location.LocationID.', 'SCHEMA', N'Production', 'TABLE', N'WorkOrderRouting', 'COLUMN', N'LocationID'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Date and time the record was last updated.', 'SCHEMA', N'Production', 'TABLE', N'WorkOrderRouting', 'COLUMN', N'ModifiedDate'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Primary key. Indicates the manufacturing process sequence.', 'SCHEMA', N'Production', 'TABLE', N'WorkOrderRouting', 'COLUMN', N'OperationSequence'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Estimated manufacturing cost.', 'SCHEMA', N'Production', 'TABLE', N'WorkOrderRouting', 'COLUMN', N'PlannedCost'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Primary key. Foreign key to Product.ProductID.', 'SCHEMA', N'Production', 'TABLE', N'WorkOrderRouting', 'COLUMN', N'ProductID'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Planned manufacturing end date.', 'SCHEMA', N'Production', 'TABLE', N'WorkOrderRouting', 'COLUMN', N'ScheduledEndDate'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Planned manufacturing start date.', 'SCHEMA', N'Production', 'TABLE', N'WorkOrderRouting', 'COLUMN', N'ScheduledStartDate'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Primary key. Foreign key to WorkOrder.WorkOrderID.', 'SCHEMA', N'Production', 'TABLE', N'WorkOrderRouting', 'COLUMN', N'WorkOrderID'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Check constraint [ActualCost] > (0.00)', 'SCHEMA', N'Production', 'TABLE', N'WorkOrderRouting', 'CONSTRAINT', N'CK_WorkOrderRouting_ActualCost'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Check constraint [ActualEndDate] >= [ActualStartDate] OR [ActualEndDate] IS NULL OR [ActualStartDate] IS NULL', 'SCHEMA', N'Production', 'TABLE', N'WorkOrderRouting', 'CONSTRAINT', N'CK_WorkOrderRouting_ActualEndDate'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Check constraint [ActualResourceHrs] >= (0.0000)', 'SCHEMA', N'Production', 'TABLE', N'WorkOrderRouting', 'CONSTRAINT', N'CK_WorkOrderRouting_ActualResourceHrs'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Check constraint [PlannedCost] > (0.00)', 'SCHEMA', N'Production', 'TABLE', N'WorkOrderRouting', 'CONSTRAINT', N'CK_WorkOrderRouting_PlannedCost'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Check constraint [ScheduledEndDate] >= [ScheduledStartDate]', 'SCHEMA', N'Production', 'TABLE', N'WorkOrderRouting', 'CONSTRAINT', N'CK_WorkOrderRouting_ScheduledEndDate'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Default constraint value of GETDATE()', 'SCHEMA', N'Production', 'TABLE', N'WorkOrderRouting', 'CONSTRAINT', N'DF_WorkOrderRouting_ModifiedDate'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Foreign key constraint referencing Location.LocationID.', 'SCHEMA', N'Production', 'TABLE', N'WorkOrderRouting', 'CONSTRAINT', N'FK_WorkOrderRouting_Location_LocationID'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Foreign key constraint referencing WorkOrder.WorkOrderID.', 'SCHEMA', N'Production', 'TABLE', N'WorkOrderRouting', 'CONSTRAINT', N'FK_WorkOrderRouting_WorkOrder_WorkOrderID'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Primary key (clustered) constraint', 'SCHEMA', N'Production', 'TABLE', N'WorkOrderRouting', 'CONSTRAINT', N'PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Nonclustered index.', 'SCHEMA', N'Production', 'TABLE', N'WorkOrderRouting', 'INDEX', N'IX_WorkOrderRouting_ProductID'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Clustered index created by a primary key constraint.', 'SCHEMA', N'Production', 'TABLE', N'WorkOrderRouting', 'INDEX', N'PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence'
    GO