← All tables and views
AdventureWorks OLTP table
Purchasing.Vendor
Companies from whom Adventure Works Cycles purchases parts or other goods.
104rows
8 columns
Schema from the provider contract| Column | Type | Nullable | Key | References |
|---|---|---|---|---|
BusinessEntityID | INTEGER | no | PK | Person.BusinessEntity.BusinessEntityID |
AccountNumber | TEXT | no | — | — |
Name | TEXT | no | — | — |
CreditRating | INTEGER | no | — | — |
PreferredVendorStatus | INTEGER | no | — | — |
ActiveFlag | INTEGER | no | — | — |
PurchasingWebServiceURL | TEXT | yes | — | — |
ModifiedDate | TEXT | no | — | — |
Keys and unique indexes
Physical SQLite metadataPrimary key is declared above.
Additional unique keys
Purchasing_Vendor_AK_Vendor_AccountNumberAccountNumber1 unique index inspected
Purchasing_Vendor_AK_Vendor_AccountNumberAccountNumberCREATE UNIQUE INDEX "Purchasing_Vendor_AK_Vendor_AccountNumber" ON "Purchasing.Vendor" ("AccountNumber")Data preview
Sample records
| BusinessEntityID | AccountNumber | Name | CreditRating | PreferredVendorStatus | ActiveFlag | PurchasingWebServiceURL |
|---|---|---|---|---|---|---|
| 1492 | AUSTRALI0001 | Australia Bike Retailer | 1 | 1 | 1 | NULL |
| 1494 | ALLENSON0001 | Allenson Cycles | 2 | 1 | 1 | NULL |
| 1496 | ADVANCED0001 | Advanced Bicycles | 1 | 1 | 1 | NULL |
| 1498 | TRIKES0001 | Trikes, Inc. | 2 | 1 | 1 | NULL |
| 1500 | MORGANB0001 | Morgan Bike Accessories | 1 | 1 | 1 | NULL |
| 1502 | CYCLING0001 | Cycling Master | 1 | 1 | 1 | NULL |
| 1504 | CHICAGO0002 | Chicago Rent-All | 2 | 1 | 1 | NULL |
| 1506 | GREENWOO0001 | Greenwood Athletic Company | 1 | 1 | 1 | NULL |
Interactive explorer