AdventureWorks

Basic Index   Expanded Index

Table Name:Sales.SalesTaxRate
Description:Tax rate lookup table.
Primary Keys:SalesTaxRateID
FieldTypeDefaultsNulls?Comments
SalesTaxRateIDint - IdentityNoneNoPrimary key for SalesTaxRate records.
StateProvinceIDintNoneNoState, province, or country/region the sales tax applies to.
TaxTypetinyintNoneNo1 = Tax applied to retail transactions, 2 = Tax applied to wholesale transactions, 3 = Tax applied to all sales (retail and wholesale) transactions.
TaxRatesmallmoney((0.00))NoTax rate amount.
Namenvarchar (50)NoneNoTax rate description.
rowguiduniqueidentifier(newid())NoROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDatedatetime(getdate())NoDate and time the record was last updated.

IndexClustered?Unique?Fields
PK_SalesTaxRate_SalesTaxRateIDYesYesSalesTaxRateID
AK_SalesTaxRate_StateProvinceID_TaxTypeNoYesStateProvinceID
TaxType
AK_SalesTaxRate_rowguidNoYesrowguid

Check ConstraintText
CK_SalesTaxRate_TaxType([TaxType]>=(1) AND [TaxType]<=(3))

Internal Foreign Key ConstraintAffected FieldSource Table
FK_SalesTaxRate_StateProvince_StateProvinceIDStateProvinceIDPerson.StateProvince

No primary keys as foreign key constraints
No triggers