Database reference - AdventureWorks2008

AdventureWorks2008 -  tables -  [Sales].[SalesTaxRate]

Description

Tax rate lookup table. 

Table properties

namevalue
name[Sales].[SalesTaxRate]
createdMar 19 2009 9:09PM
modifiedMar 19 2009 9:10PM 
ansi nullson 
quoted identifieron 
row count29
Size of data8 kb
Size of indexes40 kb
Maximum size of a single row237 bytes

Columns

columndatatypelengthbytesdefaultnullsPKFKUQcomputedcomment
SalesTaxRateIDint identity(1,1)104 no  yes    no  Primary key for SalesTaxRate records. 
StateProvinceIDint104 no    StateProvince.StateProvinceID      no  State, province, or country/region the sales tax applies to. 
TaxTypetinyint31 no      no  1 = Tax applied to retail transactions, 2 = Tax applied to wholesale transactions, 3 = Tax applied to all sales (retail and wholesale) transactions. 
TaxRatesmallmoney104((0.00))no      no  Tax rate amount. 
NameName50200 no      no  Tax rate description. 
rowguiduniqueidentifier3616(newid())no      no  ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
ModifiedDatedatetime238(getdate())no      no  Date and time the record was last updated. 

Indexes

namedescriptioncolumncomment
AK_SalesTaxRate_rowguidnonclustered, unique located on PRIMARYrowguidUnique nonclustered index. Used to support replication samples. 
AK_SalesTaxRate_StateProvinceID_TaxTypenonclustered, unique located on PRIMARYStateProvinceID, TaxTypeUnique nonclustered index. 
PK_SalesTaxRate_SalesTaxRateIDclustered, unique, primary key located on PRIMARYSalesTaxRateIDClustered index created by a primary key constraint. 

References

name
StateProvince

Foreign key graph

StateProvinceSalesTaxRate

Foreign keys

namecolumnsforeign columnstypecomment
FK_SalesTaxRate_StateProvince_StateProvinceIDStateProvinceIDStateProvince.StateProvinceID   Foreign key constraint referencing StateProvince.StateProvinceID. 

Check constraints

namecolumncomment
CK_SalesTaxRate_TaxTypeTaxType    Check constraint [TaxType] BETWEEN (1) AND (3) 

Defaults

default namecolumncomment
DF_SalesTaxRate_TaxRateTaxRateDefault constraint value of 0.0 
DF_SalesTaxRate_rowguidrowguidDefault constraint value of NEWID() 
DF_SalesTaxRate_ModifiedDateModifiedDateDefault constraint value of GETDATE() 

Dependency graph

DF_SalesTaxRate_ModifiedDateDF_SalesTaxRate_rowguidDF_SalesTaxRate_TaxRateNameSalesTaxRateCK_SalesTaxRate_TaxTypeAK_SalesTaxRate_rowguidAK_SalesTaxRate_StateProvinceID_TaxType...PK_SalesTaxRate_SalesTaxRateID...

Objects that [Sales].[SalesTaxRate] depends on

nameobject typedatabaseserverlevel
NametypeAdventureWorks2008SPRING\KATMAI1

Sample rows

SalesTaxRateIDStateProvinceIDTaxTypeTaxRateNamerowguidModifiedDate
1  1  1  14.0000  Canadian GST + Alberta Provincial Tax  683de5dd-521a-47d4-a573-06a3cdb1bc5d  6/1/1998 12:00:00 AM 
2  57  1  14.2500  Canadian GST + Ontario Provincial Tax  05c4ffdb-4f84-4cdf-abe5-fdf3216ea74e  6/1/1998 12:00:00 AM 
3  63  1  14.2500  Canadian GST + Quebec Provincial Tax  d4edb557-56d7-403c-b538-4df5e7302588  6/1/1998 12:00:00 AM 
4  1  2  7.0000  Canadian GST  f0d76907-b433-453f-b95e-16fce73b807a  6/1/1998 12:00:00 AM 
5  57  2  7.0000  Canadian GST  7e0e97a2-878b-476f-a648-05a3dd4450ed  6/1/1998 12:00:00 AM 
6  63  2  7.0000  Canadian GST  1e285d2c-8af7-47aa-b06a-762cf4d93acd  6/1/1998 12:00:00 AM 
7  7  3  7.0000  Canadian GST  590ccb14-cb20-49bf-8fee-e0c3abc4c2b1  6/1/1998 12:00:00 AM 
8  29  3  7.0000  Canadian GST  a8365f30-78b7-4dbe-8985-f8260560126b  6/1/1998 12:00:00 AM 
9  31  3  7.0000  Canadian GST  f4fde24b-7a53-4340-9d10-173e9424864a  6/1/1998 12:00:00 AM 
10  41  3  7.0000  Canadian GST  383d465b-e1d1-492a-83f3-ab3e9cbf3282  6/1/1998 12:00:00 AM 

Code

CREATE TABLE [Sales].[SalesTaxRate](
    [SalesTaxRateID] [int] IDENTITY(1,1) NOT NULL,
    [StateProvinceID] [int] NOT NULL,
    [TaxType] [tinyint] NOT NULL,
    [TaxRate] [smallmoney] NOT NULL,
    [Name] [dbo].[Name] NOT NULL,
    [rowguid] [uniqueidentifier] ROWGUIDCOL  NOT NULL,
    [SalesTaxRateID] [int] IDENTITY(1,1) NOT NULL,
    [StateProvinceID] [int] NOT NULL,
    [TaxType] [tinyint] NOT NULL,
    [TaxRate] [smallmoney] NOT NULL,
    [Name] [dbo].[Name] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_SalesTaxRate_SalesTaxRateID] PRIMARY KEY CLUSTERED 
(
    [SalesTaxRateID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

ALTER TABLE [Sales].[SalesTaxRate]  WITH CHECK ADD  CONSTRAINT [FK_SalesTaxRate_StateProvince_StateProvinceID] FOREIGN KEY([StateProvinceID])
REFERENCES [Person].[StateProvince] ([StateProvinceID])
ALTER TABLE [Sales].[SalesTaxRate] CHECK CONSTRAINT [FK_SalesTaxRate_StateProvince_StateProvinceID]
ALTER TABLE [Sales].[SalesTaxRate]  WITH CHECK ADD  CONSTRAINT [CK_SalesTaxRate_TaxType] CHECK  (([TaxType]>=(1) AND [TaxType]<=(3)))
ALTER TABLE [Sales].[SalesTaxRate] CHECK CONSTRAINT [CK_SalesTaxRate_TaxType]
ALTER TABLE [Sales].[SalesTaxRate] ADD  CONSTRAINT [DF_SalesTaxRate_TaxRate]  DEFAULT ((0.00)) FOR [TaxRate]
ALTER TABLE [Sales].[SalesTaxRate] ADD  CONSTRAINT [DF_SalesTaxRate_rowguid]  DEFAULT (newid()) FOR [rowguid]
ALTER TABLE [Sales].[SalesTaxRate] ADD  CONSTRAINT [DF_SalesTaxRate_ModifiedDate]  DEFAULT (getdate()) FOR [ModifiedDate]



Documentation generated by SqlSpec