Tables | SQL 2005 Adventure Works OLTP |
Lookup table containing the types of contacts stored in Contact.
Columns
Name Data type Nullable Description ContactTypeID int No Column has identity seed value of 1 with a step value of 1.
Primary key for ContactType records.Name Name No Contact type description. ModifiedDate datetime No Default value: GETDATE()
Date and time the record was last updated.
Constraints
Name Type Columns Description DF_ContactType_ModifiedDate DEFAULT ModifiedDate Value: GETDATE()
Default constraint value of GETDATE()PK_ContactType_ContactTypeID PRIMARY KEY ContactTypeID Clustered index created by a primary key constraint.
Indices
Name Description AK_ContactType_Name Unique nonclustered index.
Triggers
Name Description Person.uContactType AFTER UPDATE trigger setting the ModifiedDate column in the ContactType table to the current date.
Linked tables
Name Description Purchasing.VendorContact Cross-reference table mapping vendors and their employees. Sales.StoreContact Cross-reference table mapping stores and their employees.
Accessed by
Name Description dbo.ufnGetContactInformation Table value function returning the first name, last name, job title and contact type for a given contact. Purchasing.vVendor Vendor (company) names and addresses and the names of vendor employees to contact. Sales.vStoreWithDemographics Stores (names and addresses) that sell Adventure Works Cycles products to consumers.
Modified by
Name Description Person.uContactType AFTER UPDATE trigger setting the ModifiedDate column in the ContactType table to the current date.
Applies to
Tables | User