Databases > AdventureWorks2019 > Tables > Person.ContactType

AdventureWorks2019

Person.ContactType

//
Lookup table containing the types of business entity contacts.

Created: Modified:

Columns

  • //
    ${escapify(column.description)}
    ContactTypeID
    [int] IDENTITY (1,1) NOT NULL
  • //
    ${escapify(column.description)}
    Name
    [Name] NOT NULL
    //
    USER-DEFINED DATA TYPE
    [nvarchar](50) NULL
  • //
    ${escapify(column.description)}
    ModifiedDate
    [datetime] NOT NULL DEFAULT (getdate())

Indexes

  • //
    Clustered index created by a primary key constraint.
    PK_ContactType_ContactTypeID
    UNIQUE CLUSTERED
    ContactTypeID
  • //
    Unique nonclustered index.
    AK_ContactType_Name
    UNIQUE NONCLUSTERED
    Name

Sample Data

ContactTypeID
Name
ModifiedDate
1
Accounting Manager
2
Assistant Sales Agent
3
Assistant Sales Representative
4
Coordinator Foreign Markets
5
Export Administrator
6
International Marketing Manager
7
Marketing Assistant
8
Marketing Manager
9
Marketing Representative
10
Order Administrator
11
Owner
12
Owner/Marketing Assistant
13
Product Manager
14
Purchasing Agent
15
Purchasing Manager
16
Regional Account Representative
17
Sales Agent
18
Sales Associate
19
Sales Manager
20
Sales Representative