AdventureWorks Database > Production Schema : Production.TransactionHistoryArchive Table |
Creation Date | 08/01/2010 08:40 |
File Group | PRIMARY |
Text File Group | |
System Object | ![]() |
Published for Replication | ![]() |
Rows | 89253 |
Data Space Used | 4,960.00 KB |
Index Space Used | 2,352.00 KB |
Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
---|---|---|---|---|---|---|---|
![]() | TransactionID | Primary key for TransactionHistoryArchive records. | int | 4 | |||
ProductID | Product identification number. Foreign key to Product.ProductID. | int | 4 | ||||
ReferenceOrderID | Purchase order, sales order, or work order identification number. | int | 4 | ||||
ReferenceOrderLineID | Line number associated with the purchase order, sales order, or work order. | int | 4 | ((0)) | |||
TransactionDate | Date and time of the transaction. | datetime | 4 | (getdate()) | |||
TransactionType | W = Work Order, S = Sales Order, P = Purchase Order | nchar | 1 | ||||
Quantity | Product quantity. | int | 4 | ||||
ActualCost | Product cost. | money | 8 | ||||
ModifiedDate | Date and time the record was last updated. | datetime | 4 | (getdate()) |
Index | Description | Primary | Unique |
---|---|---|---|
IX_TransactionHistoryArchive_ProductID | Nonclustered index. | ||
IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID | Nonclustered index. | ||
PK_TransactionHistoryArchive_TransactionID | Primary key (clustered) constraint | ![]() | ![]() |
Name | Description | Expression |
---|---|---|
CK_TransactionHistoryArchive_TransactionType | Check constraint [TransactionType]='p' OR [TransactionType]='s' OR [TransactionType]='w' OR [TransactionType]='P' OR [TransactionType]='S' OR [TransactionType]='W' | (upper([TransactionType])='P' OR upper([TransactionType])='S' OR upper([TransactionType])='W') |
|