Person.ContactType
Documentation | AdventureWorks |
Schema | Person |
Name | ContactType |
Module | People |
Lookup table containing the types of business entity contacts.
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | ContactTypeID | int | Identity | Primary key for ContactType records. | ||||
Primary key for ContactType records. Identity |
||||||||
2 | Name | nvarchar(50) | Contact type description. | |||||
Contact type description. |
||||||||
3 | ModifiedDate | datetime | Default: getdate() | Date and time the record was last updated. | ||||
Date and time the record was last updated. Default: getdate() |
Relations
Foreign table | Primary table | Join | Title / Name / Description | |
---|---|---|---|---|
Person.BusinessEntityContact | Person.ContactType | Person.BusinessEntityContact.ContactTypeID = Person.ContactType.ContactTypeID | FK_BusinessEntityContact_ContactType_ContactTypeID Foreign key constraint referencing ContactType.ContactTypeID. |
|
Person.BusinessEntityContact.ContactTypeID = Person.ContactType.ContactTypeID Name: FK_BusinessEntityContact_ContactType_ContactTypeIDForeign key constraint referencing ContactType.ContactTypeID. |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
PK_ContactType_ContactTypeID | ContactTypeID | Primary key (clustered) constraint | |
Primary key (clustered) constraint | |||
AK_ContactType_Name | Name | Unique nonclustered index. | |
Unique nonclustered index. |
Used by
Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56