29rows
7 columns
Schema from the provider contract| Column | Type | Nullable | Key | References |
|---|---|---|---|---|
SalesTaxRateID | INTEGER | no | PK | — |
StateProvinceID | INTEGER | no | — | Person.StateProvince.StateProvinceID |
TaxType | INTEGER | no | — | — |
TaxRate | NUMERIC | no | — | — |
Name | TEXT | no | — | — |
rowguid | TEXT | no | — | — |
ModifiedDate | TEXT | no | — | — |
Keys and unique indexes
Physical SQLite metadataPrimary key is declared above.
Additional unique keys
Sales_SalesTaxRate_AK_SalesTaxRate_StateProvinceID_TaxTypeStateProvinceID + TaxTypeSales_SalesTaxRate_AK_SalesTaxRate_rowguidrowguid2 unique indexes inspected
Sales_SalesTaxRate_AK_SalesTaxRate_StateProvinceID_TaxTypeStateProvinceID + TaxTypeCREATE UNIQUE INDEX "Sales_SalesTaxRate_AK_SalesTaxRate_StateProvinceID_TaxType" ON "Sales.SalesTaxRate" ("StateProvinceID", "TaxType")Sales_SalesTaxRate_AK_SalesTaxRate_rowguidrowguidCREATE UNIQUE INDEX "Sales_SalesTaxRate_AK_SalesTaxRate_rowguid" ON "Sales.SalesTaxRate" ("rowguid")Data preview
Sample records
| SalesTaxRateID | StateProvinceID | TaxType | TaxRate | Name | rowguid | ModifiedDate |
|---|---|---|---|---|---|---|
| 1 | 1 | 1 | 14 | Canadian GST + Alberta Provincial Tax | 683DE5DD-521A-47D4-A573-06A3CDB1BC5D | 2019-04-30 00:00:00.000 |
| 2 | 57 | 1 | 14.25 | Canadian GST + Ontario Provincial Tax | 05C4FFDB-4F84-4CDF-ABE5-FDF3216EA74E | 2019-04-30 00:00:00.000 |
| 3 | 63 | 1 | 14.25 | Canadian GST + Quebec Provincial Tax | D4EDB557-56D7-403C-B538-4DF5E7302588 | 2019-04-30 00:00:00.000 |
| 4 | 1 | 2 | 7 | Canadian GST | F0D76907-B433-453F-B95E-16FCE73B807A | 2019-04-30 00:00:00.000 |
| 5 | 57 | 2 | 7 | Canadian GST | 7E0E97A2-878B-476F-A648-05A3DD4450ED | 2019-04-30 00:00:00.000 |
| 6 | 63 | 2 | 7 | Canadian GST | 1E285D2C-8AF7-47AA-B06A-762CF4D93ACD | 2019-04-30 00:00:00.000 |
| 7 | 7 | 3 | 7 | Canadian GST | 590CCB14-CB20-49BF-8FEE-E0C3ABC4C2B1 | 2019-04-30 00:00:00.000 |
| 8 | 29 | 3 | 7 | Canadian GST | A8365F30-78B7-4DBE-8985-F8260560126B | 2019-04-30 00:00:00.000 |
Interactive explorer