← All tables and views
AdventureWorks OLTP table
Production.WorkOrderRouting
Manufacturing routing operations and scheduling information for each work order.
67,131rows
12 columns
Schema from the provider contract| Column | Type | Nullable | Key | References |
|---|---|---|---|---|
WorkOrderID | INTEGER | no | PK 1/3 | Production.WorkOrder.WorkOrderID |
ProductID | INTEGER | no | PK 2/3 | — |
OperationSequence | INTEGER | no | PK 3/3 | — |
LocationID | INTEGER | no | — | Production.Location.LocationID |
ScheduledStartDate | TEXT | no | — | — |
ScheduledEndDate | TEXT | no | — | — |
ActualStartDate | TEXT | yes | — | — |
ActualEndDate | TEXT | yes | — | — |
ActualResourceHrs | NUMERIC | yes | — | — |
PlannedCost | NUMERIC | no | — | — |
ActualCost | NUMERIC | yes | — | — |
ModifiedDate | TEXT | no | — | — |
Keys and unique indexes
Physical SQLite metadataPrimary key is declared above.
No additional full-column unique key was found.
1 unique index inspected
sqlite_autoindex_Production.WorkOrderRouting_1WorkOrderID + ProductID + OperationSequenceData preview
Sample records
| WorkOrderID | ProductID | OperationSequence | LocationID | ScheduledStartDate | ScheduledEndDate | ActualStartDate |
|---|---|---|---|---|---|---|
| 13 | 747 | 1 | 10 | 2022-06-02 00:00:00.000 | 2022-06-13 00:00:00.000 | 2022-06-02 00:00:00.000 |
| 13 | 747 | 2 | 20 | 2022-06-02 00:00:00.000 | 2022-06-13 00:00:00.000 | 2022-06-02 00:00:00.000 |
| 13 | 747 | 3 | 30 | 2022-06-02 00:00:00.000 | 2022-06-13 00:00:00.000 | 2022-06-02 00:00:00.000 |
| 13 | 747 | 4 | 40 | 2022-06-02 00:00:00.000 | 2022-06-13 00:00:00.000 | 2022-06-02 00:00:00.000 |
| 13 | 747 | 6 | 50 | 2022-06-02 00:00:00.000 | 2022-06-13 00:00:00.000 | 2022-06-02 00:00:00.000 |
| 13 | 747 | 7 | 60 | 2022-06-02 00:00:00.000 | 2022-06-13 00:00:00.000 | 2022-06-02 00:00:00.000 |
| 14 | 748 | 1 | 10 | 2022-06-02 00:00:00.000 | 2022-06-13 00:00:00.000 | 2022-06-02 00:00:00.000 |
| 14 | 748 | 2 | 20 | 2022-06-02 00:00:00.000 | 2022-06-13 00:00:00.000 | 2022-06-02 00:00:00.000 |
Interactive explorer