Tables | SQL 2005 Adventure Works OLTP |
Companies from whom Adventure Works Cycles purchases parts or other goods.
Columns
Name Data type Nullable Description VendorID int No Column has identity seed value of 1 with a step value of 1.
Primary key for Vendor records.AccountNumber AccountNumber No Vendor account (identification) number. Name Name No Company name. CreditRating tinyint No 1 = Superior, 2 = Excellent, 3 = Above average, 4 = Average, 5 = Below average PreferredVendorStatus Flag No Default value: 1
0 = Do not use if another vendor is available. 1 = Preferred over other vendors supplying the same product.ActiveFlag Flag No Default value: 1
0 = Vendor no longer used. 1 = Vendor is actively used.PurchasingWebServiceURL nvarchar(1024) Yes Vendor URL. ModifiedDate datetime No Default value: GETDATE()
Date and time the record was last updated.
Constraints
Name Type Columns Description DF_Vendor_PreferredVendorStatus DEFAULT PreferredVendorStatus Value: 1
Default constraint value of 1 (TRUE)DF_Vendor_ActiveFlag DEFAULT ActiveFlag Value: 1
Default constraint value of 1 (TRUE)DF_Vendor_ModifiedDate DEFAULT ModifiedDate Value: GETDATE()
Default constraint value of GETDATE()CK_Vendor_CreditRating CHECK N/A Value: ([CreditRating] BETWEEN 1 AND 5)
Check constraint [CreditRating] BETWEEN (1) AND (5)PK_Vendor_VendorID PRIMARY KEY VendorID Clustered index created by a primary key constraint.
Indices
Name Description AK_Vendor_AccountNumber Unique nonclustered index.
Triggers
Name Description Purchasing.dVendor INSTEAD OF DELETE trigger which keeps Vendors from being deleted. Purchasing.uVendor AFTER UPDATE trigger setting the ModifiedDate column in the Vendor table to the current date.
Linked tables
Name Description Purchasing.ProductVendor Cross-reference table mapping vendors with the products they supply. Purchasing.PurchaseOrderHeader General purchase order information. See PurchaseOrderDetail. Purchasing.VendorAddress Cross-reference mapping vendors and addresses. Purchasing.VendorContact Cross-reference table mapping vendors and their employees.
Accessed by
Name Description Purchasing.vVendor Vendor (company) names and addresses and the names of vendor employees to contact.
Modified by
Name Description Purchasing.uVendor AFTER UPDATE trigger setting the ModifiedDate column in the Vendor table to the current date.
Applies to
Tables | User