Production.TransactionHistoryArchive Table

Information

Name	TransactionHistoryArchive
Schema	Production
Row Count	0
Data Size
Index Size
Reserved Size
Unused Size
Created	29.3.2010. 21:58:18
Modified	29.3.2010. 21:58:39

Extended Properties

Name	Type	Property Name	Value
TransactionHistoryArchive	TABLE	MS_Description	Transactions for previous years.

Columns

Name	Data Type	Collation	Default
TransactionID	int
ProductID	int
ReferenceOrderID	int
ReferenceOrderLineID	int		((0))
TransactionDate	datetime		(getdate())
TransactionType	nchar(1)	SQL_Latin1_General_CP1_CI_AS
Quantity	int
ActualCost	money
ModifiedDate	datetime		(getdate())

Indexes

Name	Type	Columns
PK_TransactionHistoryArchive_TransactionID	Clustered	TransactionID
IX_TransactionHistoryArchive_ProductID	NonClustered	ProductID
IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID	NonClustered	ReferenceOrderID, ReferenceOrderLineID

Check Constraints

Name	Column	Enabled	Trusted	Expression
CK_TransactionHistoryArchive_TransactionType	TransactionType			(upper([TransactionType])='P' OR upper([TransactionType])='S' OR upper([TransactionType])='W')

SQL Script

CREATE TABLE [Production].[TransactionHistoryArchive] (
    [TransactionID] int NOT NULL,
    [ProductID] int NOT NULL,
    [ReferenceOrderID] int NOT NULL,
    [ReferenceOrderLineID] int NOT NULL DEFAULT ((0)),
    [TransactionDate] datetime NOT NULL DEFAULT (getdate()),
    [TransactionType] nchar(1) NOT NULL,
    [Quantity] int NOT NULL,
    [ActualCost] money NOT NULL,
    [ModifiedDate] datetime NOT NULL DEFAULT (getdate())
);
CREATE INDEX [IX_TransactionHistoryArchive_ProductID] on [Production].[TransactionHistoryArchive]([ProductID]);
CREATE INDEX [IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID] on [Production].[TransactionHistoryArchive]([ReferenceOrderID], [ReferenceOrderLineID]);