Person.PhoneNumberType
Documentation | AdventureWorks |
Schema | Person |
Name | PhoneNumberType |
Module | People |
Type of phone number of a person.
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | PhoneNumberTypeID | int | Identity | Primary key for telephone number type records. | ||||
Primary key for telephone number type records. Identity |
||||||||
2 | Name | nvarchar(50) | Name of the telephone number type | |||||
Name of the telephone number type |
||||||||
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.PersonPhone | Person.PhoneNumberType | Person.PersonPhone.PhoneNumberTypeID = Person.PhoneNumberType.PhoneNumberTypeID | FK_PersonPhone_PhoneNumberType_PhoneNumberTypeID Foreign key constraint referencing PhoneNumberType.PhoneNumberTypeID. |
|
Person.PersonPhone.PhoneNumberTypeID = Person.PhoneNumberType.PhoneNumberTypeID Name: FK_PersonPhone_PhoneNumberType_PhoneNumberTypeIDForeign key constraint referencing PhoneNumberType.PhoneNumberTypeID. |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
PK_PhoneNumberType_PhoneNumberTypeID | PhoneNumberTypeID | Primary key (clustered) constraint | |
Primary key (clustered) constraint |
Used by
Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56