Latest revision |
Your text |
Line 2: |
Line 2: |
| | | |
| {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |
− | |- valign="top" | + | |- |
| | '''Table | | | '''Table |
| | Production.WorkOrderRouting | | | Production.WorkOrderRouting |
− | |- valign="top" | + | |- |
− | | '''Description
| |
− | | Work order details.
| |
| |} | | |} |
| | | |
− | === 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 17: |
Line 15: |
| | '''Nullable | | | '''Nullable |
| | '''Default | | | '''Default |
− | | '''Description | + | | '''PK |
− | | + | | '''Index |
− | |- valign="top" | + | |
| + | |- |
| | WorkOrderID | | | WorkOrderID |
| | int | | | int |
| | not null | | | not null |
| | | | | |
− | | Primary key. Foreign key to WorkOrder.WorkOrderID. | + | | PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence |
− | |- valign="top" | + | | |
| + | |- |
| | ProductID | | | ProductID |
| | int | | | int |
| | not null | | | not null |
| | | | | |
− | | Primary key. Foreign key to Product.ProductID. | + | | PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence |
− | |- valign="top" | + | | IX_WorkOrderRouting_ProductID |
| + | |- |
| | OperationSequence | | | OperationSequence |
| | smallint | | | smallint |
| | not null | | | not null |
| | | | | |
− | | Primary key. Indicates the manufacturing process sequence. | + | | PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence |
− | |- valign="top" | + | | |
| + | |- |
| | LocationID | | | LocationID |
| | smallint | | | smallint |
| | not null | | | not null |
| | | | | |
− | | Manufacturing location where the part is processed. Foreign key to Location.LocationID. | + | | |
− | |- valign="top" | + | | |
| + | |- |
| | ScheduledStartDate | | | ScheduledStartDate |
| | datetime | | | datetime |
| | not null | | | not null |
| | | | | |
− | | Planned manufacturing start date.
| |
− | |- valign="top"
| |
− | | ScheduledEndDate
| |
− | | datetime
| |
− | | not null
| |
| | | | | |
− | | Planned manufacturing end date.
| |
− | |- valign="top"
| |
− | | ActualStartDate
| |
− | | datetime
| |
− | | null
| |
| | | | | |
− | | Actual start date.
| + | |- |
− | |- valign="top" | + | | ScheduledEndDate |
− | | ActualEndDate | |
| | datetime | | | datetime |
− | | null
| |
− | |
| |
− | | Actual end date.
| |
− | |- valign="top"
| |
− | | ActualResourceHrs
| |
− | | decimal(9, 4)
| |
− | | null
| |
− | |
| |
− | | Number of manufacturing hours used.
| |
− | |- valign="top"
| |
− | | PlannedCost
| |
− | | money
| |
| | not null | | | not null |
| | | | | |
− | | Estimated manufacturing cost.
| |
− | |- valign="top"
| |
− | | ActualCost
| |
− | | money
| |
− | | null
| |
| | | | | |
− | | Actual manufacturing cost.
| |
− | |- valign="top"
| |
− | | ModifiedDate
| |
− | | datetime
| |
− | | not null
| |
− | | (getdate())
| |
− | | 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
| |
− | |- valign="top"
| |
− | | 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
| |
− |
| |
− | |- valign="top"
| |
− | | IX_WorkOrderRouting_ProductID
| |
| | | | | |
− | | ProductID
| |
− | |}
| |
− |
| |
− | === Check Constraints ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Check Constraint
| |
− | | '''Expression
| |
− | | '''Description
| |
− |
| |
− | |- valign="top"
| |
− | | CK_WorkOrderRouting_ActualCost
| |
− | | ([ActualCost]>(0.00))
| |
− | | Check constraint [ActualCost] > (0.00)
| |
− | |- valign="top"
| |
− | | 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
| |
− | |- valign="top"
| |
− | | CK_WorkOrderRouting_ActualResourceHrs
| |
− | | ([ActualResourceHrs]>=(0.0000))
| |
− | | Check constraint [ActualResourceHrs] >= (0.0000)
| |
− | |- valign="top"
| |
− | | CK_WorkOrderRouting_PlannedCost
| |
− | | ([PlannedCost]>(0.00))
| |
− | | Check constraint [PlannedCost] > (0.00)
| |
− | |- valign="top"
| |
− | | CK_WorkOrderRouting_ScheduledEndDate
| |
− | | ([ScheduledEndDate]>=[ScheduledStartDate])
| |
− | | Check constraint [ScheduledEndDate] >= [ScheduledStartDate]
| |
− | |}
| |
− |
| |
− | === Foreign Keys ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Relation
| |
− | | '''Column
| |
− | | '''Referenced Column
| |
− |
| |
− | |- valign="top"
| |
− | | [[Production.Location_(table)|Production.Location]]
| |
− | | LocationID
| |
− | | LocationID
| |
− | |- valign="top"
| |
− | | [[Production.WorkOrder_(table)|Production.WorkOrder]]
| |
− | | WorkOrderID
| |
− | | WorkOrderID
| |
− | |}
| |
− |
| |
− | === References ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Dependency Type
| |
− | | '''Object Type
| |
− | | '''Referenced Object
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | Schema
| |
− | | [[Production_(schema)|Production]]
| |
− |
| |
− | |}
| |
− |
| |
− |
| |
− | == automatically generated ==
| |
− |
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
| |- | | |- |
− | | '''Table | + | | ActualStartDate |
− | | Production.WorkOrderRouting
| |
− | |- valign="top"
| |
− | | '''Description
| |
− | | Work order details.
| |
− | |-
| |
− | |}
| |
− | | |
− | | |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Column
| |
− | | '''Data Type
| |
− | | '''Nullable
| |
− | | '''Default
| |
− | | '''Description / PK / Index
| |
− |
| |
− | |- valign="top"
| |
− | | WorkOrderID
| |
− | | int
| |
− | | not null
| |
− | |
| |
− | | Primary key. Foreign key to WorkOrder.WorkOrderID.<br />PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence
| |
− | |- valign="top"
| |
− | | ProductID
| |
− | | int
| |
− | | not null
| |
− | |
| |
− | | Primary key. Foreign key to Product.ProductID.<br />PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequenceIX_WorkOrderRouting_ProductID
| |
− | |- valign="top"
| |
− | | OperationSequence
| |
− | | smallint
| |
− | | not null
| |
− | |
| |
− | | Primary key. Indicates the manufacturing process sequence.<br />PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence
| |
− | |- valign="top"
| |
− | | LocationID
| |
− | | smallint
| |
− | | not null
| |
− | |
| |
− | | Manufacturing location where the part is processed. Foreign key to Location.LocationID.<br />
| |
− | |- valign="top"
| |
− | | ScheduledStartDate
| |
| | datetime | | | datetime |
− | | not null | + | | null |
| | | | | |
− | | Planned manufacturing start date.<br />
| |
− | |- valign="top"
| |
− | | ScheduledEndDate
| |
− | | datetime
| |
− | | not null
| |
| | | | | |
− | | Planned manufacturing end date.<br />
| |
− | |- valign="top"
| |
− | | ActualStartDate
| |
− | | datetime
| |
− | | null
| |
| | | | | |
− | | Actual start date.<br />
| + | |- |
− | |- valign="top" | |
| | ActualEndDate | | | ActualEndDate |
| | datetime | | | datetime |
| | null | | | null |
| | | | | |
− | | Actual end date.<br /> | + | | |
− | |- valign="top" | + | | |
| + | |- |
| | ActualResourceHrs | | | ActualResourceHrs |
| | decimal(9, 4) | | | decimal(9, 4) |
| | null | | | null |
| | | | | |
− | | Number of manufacturing hours used.<br /> | + | | |
− | |- valign="top" | + | | |
| + | |- |
| | PlannedCost | | | PlannedCost |
| | money | | | money |
| | not null | | | not null |
| | | | | |
− | | Estimated manufacturing cost.<br /> | + | | |
− | |- valign="top" | + | | |
| + | |- |
| | ActualCost | | | ActualCost |
| | money | | | money |
| | null | | | null |
| | | | | |
− | | Actual manufacturing cost.<br /> | + | | |
− | |- valign="top" | + | | |
| + | |- |
| | ModifiedDate | | | ModifiedDate |
| | datetime | | | datetime |
| | not null | | | not null |
− | | (GETDATE()) | + | | (getdate()) |
− | | Date and time the record was last updated.<br /> | + | | |
| + | | |
| |} | | |} |
| | | |
Line 288: |
Line 120: |
| | WorkOrderID | | | WorkOrderID |
| | WorkOrderID | | | WorkOrderID |
− | |}
| |
− |
| |
− |
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Dependency Type
| |
− | | '''Object Type
| |
− | | '''Referenced Object
| |
− |
| |
− | |-
| |
− | | Schema
| |
− | | Schema
| |
− | | [[Production_(schema)|Production]]
| |
− |
| |
| |} | | |} |