← All tables and views
AdventureWorks OLTP table
Person.PersonPhone
Telephone number and type of a person.
19,972rows
4 columns
Schema from the provider contract| Column | Type | Nullable | Key | References |
|---|---|---|---|---|
BusinessEntityID | INTEGER | no | PK 1/3 | Person.Person.BusinessEntityID |
PhoneNumber | TEXT | no | PK 2/3 | — |
PhoneNumberTypeID | INTEGER | no | PK 3/3 | Person.PhoneNumberType.PhoneNumberTypeID |
ModifiedDate | TEXT | no | — | — |
Keys and unique indexes
Physical SQLite metadataPrimary key is declared above.
No additional full-column unique key was found.
1 unique index inspected
sqlite_autoindex_Person.PersonPhone_1BusinessEntityID + PhoneNumber + PhoneNumberTypeIDData preview
Sample records
| BusinessEntityID | PhoneNumber | PhoneNumberTypeID | ModifiedDate |
|---|---|---|---|
| 1 | 697-555-0142 | 1 | 2020-01-07 00:00:00.000 |
| 2 | 819-555-0175 | 3 | 2019-01-23 00:00:00.000 |
| 3 | 212-555-0187 | 1 | 2018-11-03 00:00:00.000 |
| 4 | 612-555-0100 | 1 | 2018-11-27 00:00:00.000 |
| 5 | 849-555-0139 | 1 | 2018-12-29 00:00:00.000 |
| 6 | 122-555-0189 | 3 | 2024-12-15 00:00:00.000 |
| 7 | 181-555-0156 | 3 | 2020-02-01 00:00:00.000 |
| 8 | 815-555-0138 | 1 | 2019-12-22 00:00:00.000 |
Interactive explorer