Tables SQL 2005 Adventure Works OLTP

Sales.SalesTaxRate

Object type: Table

Tax rate lookup table.

Columns 

Name  Data type  Nullable  Description 
SalesTaxRateID  int  No Column has identity seed value of 1 with a step value of 1.
Primary key for SalesTaxRate records. 
StateProvinceID  int  No State, province, or country/region the sales tax applies to. 
TaxType  tinyint  No 1 = Tax applied to retail transactions, 2 = Tax applied to wholesale transactions, 3 = Tax applied to all sales (retail and wholesale) transactions. 
TaxRate  smallmoney  No Default value: 0.00
Tax rate amount. 
Name  Name  No Tax rate description. 
rowguid  uniqueidentifier  No Default value: NEWID()
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
ModifiedDate  datetime  No Default value: GETDATE()
Date and time the record was last updated. 

Constraints 

Name  Type  Columns  Description 
DF_SalesTaxRate_TaxRate  DEFAULT  TaxRate  Value: 0.00
Default constraint value of 0.0 
DF_SalesTaxRate_rowguid  DEFAULT  rowguid  Value: NEWID()
Default constraint value of NEWID() 
DF_SalesTaxRate_ModifiedDate  DEFAULT  ModifiedDate  Value: GETDATE()
Default constraint value of GETDATE() 
CK_SalesTaxRate_TaxType  CHECK  N/A  Value: ([TaxType] BETWEEN 1 AND 3)
Check constraint [TaxType] BETWEEN (1) AND (3) 
PK_SalesTaxRate_SalesTaxRateID  PRIMARY KEY  SalesTaxRateID  Clustered index created by a primary key constraint. 
FK_SalesTaxRate_StateProvince_StateProvinceID  FOREIGN KEY  StateProvinceID  Reference table: Person.StateProvince
Foreign key constraint referencing StateProvince.StateProvinceID. 

Indices 

Name  Description 
AK_SalesTaxRate_rowguid  Unique nonclustered index.Used to support replication samples. 
AK_SalesTaxRate_StateProvinceID_TaxType  Unique nonclustered index. 

Triggers 

Name  Description 
Sales.uSalesTaxRate  AFTER UPDATE trigger setting the ModifiedDate column in the SalesTaxRate table to the current date. 

Modified by 

Name  Description 
Sales.uSalesTaxRate  AFTER UPDATE trigger setting the ModifiedDate column in the SalesTaxRate table to the current date. 

Applies to

Tables | User
The AdventureWorks database sample was developed by Microsoft Corporation, copyright 2005. SQL Server is a trademark of Microsoft Corporation

Document was prepared on: Thursday, April 05, 2007
Help compiled by DBDocumentor, a Pikauba Software product. All rights reserved.