Sales.SalesTaxRate Table

Information

Name	SalesTaxRate
Schema	Sales
Row Count	0
Data Size
Index Size
Reserved Size
Unused Size
Created	29.3.2010. 21:58:18
Modified	29.3.2010. 21:58:55

Extended Properties

Name	Type	Property Name	Value
SalesTaxRate	TABLE	MS_Description	Tax rate lookup table.

Columns

Name	Data Type	Collation	References	Default
SalesTaxRateID	int
StateProvinceID	int		Person.StateProvince.StateProvinceID
TaxType	tinyint
TaxRate	smallmoney			((0.00))
Name	nvarchar(50)	SQL_Latin1_General_CP1_CI_AS
rowguid	uniqueidentifier			(newid())
ModifiedDate	datetime			(getdate())

Indexes

Name	Type	Columns
PK_SalesTaxRate_SalesTaxRateID	Clustered	SalesTaxRateID
AK_SalesTaxRate_StateProvinceID_TaxType	NonClustered	StateProvinceID, TaxType
AK_SalesTaxRate_rowguid	NonClustered	rowguid

Check Constraints

Name	Column	Enabled	Trusted	Expression
CK_SalesTaxRate_TaxType	TaxType			([TaxType]>=(1) AND [TaxType]<=(3))

Foreign Key Constraints

Name	Type	Referenced Table
FK_SalesTaxRate_StateProvince_StateProvinceID	Foreign key	Person.StateProvince

SQL Script

CREATE TABLE [Sales].[SalesTaxRate] (
    [SalesTaxRateID] int NOT NULL IDENTITY,
    [StateProvinceID] int NOT NULL,
    [TaxType] tinyint NOT NULL,
    [TaxRate] smallmoney NOT NULL DEFAULT ((0.00)),
    [Name] nvarchar(50) NOT NULL,
    [rowguid] uniqueidentifier NOT NULL DEFAULT (newid()),
    [ModifiedDate] datetime NOT NULL DEFAULT (getdate())
);
CREATE UNIQUE INDEX [AK_SalesTaxRate_StateProvinceID_TaxType] on [Sales].[SalesTaxRate]([StateProvinceID], [TaxType]);
CREATE UNIQUE INDEX [AK_SalesTaxRate_rowguid] on [Sales].[SalesTaxRate]([rowguid]);