AdventureWorks
| Table Name: | Person.ContactType |
| Description: | Lookup table containing the types of contacts stored in Contact. |
| Primary Keys: | ContactTypeID |
| Field | Type | Defaults | Nulls? | Comments |
|---|---|---|---|---|
| ContactTypeID | int - Identity | None | No | Primary key for ContactType records. |
| Name | nvarchar (50) | None | No | Contact type description. |
| ModifiedDate | datetime | (getdate()) | No | Date and time the record was last updated. |
| Index | Clustered? | Unique? | Fields |
|---|---|---|---|
| PK_ContactType_ContactTypeID | Yes | Yes | ContactTypeID |
| AK_ContactType_Name | No | Yes | Name |
| Primary Key as Foreign Key Constraint | Affected Table | Affected Field |
|---|---|---|
| FK_StoreContact_ContactType_ContactTypeID | Sales.StoreContact | ContactTypeID |
| FK_VendorContact_ContactType_ContactTypeID | Purchasing.VendorContact | ContactTypeID |