Difference between revisions of "Production.WorkOrderRouting (table)"

From dbscript Online Help
Jump to: navigation, search
Line 12: Line 12:
  
  
 +
=== Columns ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 18: Line 19:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''Description / PK / Index
+
| '''Description
 
 
 
|- valign="top"
 
|- valign="top"
Line 25: Line 26:
 
| not null
 
| not null
 
|  
 
|  
−
| Primary key. Foreign key to WorkOrder.WorkOrderID.<br />PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence
+
| Primary key. Foreign key to WorkOrder.WorkOrderID.
 
|- valign="top"
 
|- valign="top"
 
| ProductID
 
| ProductID
Line 31: Line 32:
 
| not null
 
| not null
 
|  
 
|  
−
| Primary key. Foreign key to Product.ProductID.<br />PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequenceIX_WorkOrderRouting_ProductID
+
| Primary key. Foreign key to Product.ProductID.
 
|- valign="top"
 
|- valign="top"
 
| OperationSequence
 
| OperationSequence
Line 37: Line 38:
 
| not null
 
| not null
 
|  
 
|  
−
| Primary key. Indicates the manufacturing process sequence.<br />PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence
+
| Primary key. Indicates the manufacturing process sequence.
 
|- valign="top"
 
|- valign="top"
 
| LocationID
 
| LocationID
Line 43: Line 44:
 
| not null
 
| not null
 
|  
 
|  
−
| Manufacturing location where the part is processed. Foreign key to Location.LocationID.<br />
+
| Manufacturing location where the part is processed. Foreign key to Location.LocationID.
 
|- valign="top"
 
|- valign="top"
 
| ScheduledStartDate
 
| ScheduledStartDate
Line 49: Line 50:
 
| not null
 
| not null
 
|  
 
|  
−
| Planned manufacturing start date.<br />
+
| Planned manufacturing start date.
 
|- valign="top"
 
|- valign="top"
 
| ScheduledEndDate
 
| ScheduledEndDate
Line 55: Line 56:
 
| not null
 
| not null
 
|  
 
|  
−
| Planned manufacturing end date.<br />
+
| Planned manufacturing end date.
 
|- valign="top"
 
|- valign="top"
 
| ActualStartDate
 
| ActualStartDate
Line 61: Line 62:
 
| null
 
| null
 
|  
 
|  
−
| Actual start date.<br />
+
| Actual start date.
 
|- valign="top"
 
|- valign="top"
 
| ActualEndDate
 
| ActualEndDate
Line 67: Line 68:
 
| null
 
| null
 
|  
 
|  
−
| Actual end date.<br />
+
| Actual end date.
 
|- valign="top"
 
|- valign="top"
 
| ActualResourceHrs
 
| ActualResourceHrs
Line 73: Line 74:
 
| null
 
| null
 
|  
 
|  
−
| Number of manufacturing hours used.<br />
+
| Number of manufacturing hours used.
 
|- valign="top"
 
|- valign="top"
 
| PlannedCost
 
| PlannedCost
Line 79: Line 80:
 
| not null
 
| not null
 
|  
 
|  
−
| Estimated manufacturing cost.<br />
+
| Estimated manufacturing cost.
 
|- valign="top"
 
|- valign="top"
 
| ActualCost
 
| ActualCost
Line 85: Line 86:
 
| null
 
| null
 
|  
 
|  
−
| Actual manufacturing cost.<br />
+
| Actual manufacturing cost.
 
|- valign="top"
 
|- valign="top"
 
| ModifiedDate
 
| ModifiedDate
Line 91: Line 92:
 
| not null
 
| not null
 
| (getdate())
 
| (getdate())
−
| Date and time the record was last updated.<br />
+
| Date and time the record was last updated.
 
|}
 
|}
  
 +
=== Primary Key ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|-
 +
| PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence
 +
| WorkOrderID, ProductID, OperationSequence
 +
|}
  
 +
=== Indexes ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Index
 +
| '''Type
 +
| '''Columns
 +
 +
|-
 +
| IX_WorkOrderRouting_ProductID
 +
|
 +
| ProductID
 +
|}
  
 +
=== Check Constraints ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Check Constraint
 +
| '''Expression
 +
| '''Description
 +
 +
|-
 +
| CK_WorkOrderRouting_ActualCost
 +
| ([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_ActualResourceHrs
 +
| ([ActualResourceHrs]>=(0.0000))
 +
| Check constraint [ActualResourceHrs] >= (0.0000)
 +
|-
 +
| CK_WorkOrderRouting_PlannedCost
 +
| ([PlannedCost]>(0.00))
 +
| Check constraint [PlannedCost] > (0.00)
 +
|-
 +
| CK_WorkOrderRouting_ScheduledEndDate
 +
| ([ScheduledEndDate]>=[ScheduledStartDate])
 +
| Check constraint [ScheduledEndDate] >= [ScheduledStartDate]
 +
|}
 +
 +
=== Foreign Keys ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 112: Line 164:
 
|}
 
|}
  
 +
=== References ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Dependency Type
 +
| '''Object Type
 +
| '''Referenced Object
 +
 +
|-
 +
| Schema
 +
| Schema
 +
| [[Production_(schema)|Production]]
 +
 +
|}
  
  

Revision as of 00:05, 3 February 2010

wikibot

Table Production.WorkOrderRouting
Description Work order details.


Columns

Column Data Type Nullable Default Description
WorkOrderID int not null Primary key. Foreign key to WorkOrder.WorkOrderID.
ProductID int not null Primary key. Foreign key to Product.ProductID.
OperationSequence smallint not null Primary key. Indicates the manufacturing process sequence.
LocationID smallint not null Manufacturing location where the part is processed. Foreign key to Location.LocationID.
ScheduledStartDate datetime not null Planned manufacturing start date.
ScheduledEndDate datetime not null Planned manufacturing end date.
ActualStartDate datetime null Actual start date.
ActualEndDate datetime null Actual end date.
ActualResourceHrs decimal(9, 4) null Number of manufacturing hours used.
PlannedCost money not null Estimated manufacturing cost.
ActualCost money null Actual manufacturing cost.
ModifiedDate datetime not null (getdate()) Date and time the record was last updated.

Primary Key

Primary Key Columns
PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence WorkOrderID, ProductID, OperationSequence

Indexes

Index Type Columns
IX_WorkOrderRouting_ProductID ProductID

Check Constraints

Check Constraint Expression Description
CK_WorkOrderRouting_ActualCost ([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_ActualResourceHrs ([ActualResourceHrs]>=(0.0000)) Check constraint [ActualResourceHrs] >= (0.0000)
CK_WorkOrderRouting_PlannedCost ([PlannedCost]>(0.00)) Check constraint [PlannedCost] > (0.00)
CK_WorkOrderRouting_ScheduledEndDate ([ScheduledEndDate]>=[ScheduledStartDate]) Check constraint [ScheduledEndDate] >= [ScheduledStartDate]

Foreign Keys

Relation Column Referenced Column
Production.Location LocationID LocationID
Production.WorkOrder WorkOrderID WorkOrderID

References

Dependency Type Object Type Referenced Object
Schema Schema Production


automatically generated

Table Production.WorkOrderRouting
Description Work order details.


Column Data Type Nullable Default Description / PK / Index
WorkOrderID int not null Primary key. Foreign key to WorkOrder.WorkOrderID.
PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence
ProductID int not null Primary key. Foreign key to Product.ProductID.
PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequenceIX_WorkOrderRouting_ProductID
OperationSequence smallint not null Primary key. Indicates the manufacturing process sequence.
PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence
LocationID smallint not null Manufacturing location where the part is processed. Foreign key to Location.LocationID.
ScheduledStartDate datetime not null Planned manufacturing start date.
ScheduledEndDate datetime not null Planned manufacturing end date.
ActualStartDate datetime null Actual start date.
ActualEndDate datetime null Actual end date.
ActualResourceHrs decimal(9, 4) null Number of manufacturing hours used.
PlannedCost money not null Estimated manufacturing cost.
ActualCost money null Actual manufacturing cost.
ModifiedDate datetime not null (GETDATE()) Date and time the record was last updated.


Relation Column Referenced Column
Production.Location LocationID LocationID
Production.WorkOrder WorkOrderID WorkOrderID


Dependency Type Object Type Referenced Object
Schema Schema Production
Retrieved from "http://dbshelp.devio.at/index.php?title=Production.WorkOrderRouting_(table)&oldid=2107"