Tables | SQL 2005 Adventure Works OLTP |
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.0DF_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