← All tables and views
AdventureWorks OLTP table
Person.BusinessEntityContact
Cross-reference table mapping stores, vendors, and employees to people
909rows
5 columns
Schema from the provider contract| Column | Type | Nullable | Key | References |
|---|---|---|---|---|
BusinessEntityID | INTEGER | no | PK 1/3 | Person.BusinessEntity.BusinessEntityID |
PersonID | INTEGER | no | PK 2/3 | Person.Person.BusinessEntityID |
ContactTypeID | INTEGER | no | PK 3/3 | Person.ContactType.ContactTypeID |
rowguid | TEXT | no | — | — |
ModifiedDate | TEXT | no | — | — |
Keys and unique indexes
Physical SQLite metadataPrimary key is declared above.
Additional unique keys
Person_BusinessEntityContact_AK_BusinessEntityContact_rowguidrowguid2 unique indexes inspected
Person_BusinessEntityContact_AK_BusinessEntityContact_rowguidrowguidCREATE UNIQUE INDEX "Person_BusinessEntityContact_AK_BusinessEntityContact_rowguid" ON "Person.BusinessEntityContact" ("rowguid")sqlite_autoindex_Person.BusinessEntityContact_1BusinessEntityID + PersonID + ContactTypeIDData preview
Sample records
| BusinessEntityID | PersonID | ContactTypeID | rowguid | ModifiedDate |
|---|---|---|---|---|
| 292 | 291 | 11 | 7D4D2DBC-4A44-48F5-911D-A63ABAFD5120 | 2017-12-13 13:21:02.243 |
| 294 | 293 | 11 | 3EA25B65-9579-4260-977D-D6F00D7D20EE | 2017-12-13 13:21:02.320 |
| 296 | 295 | 11 | DADAC1FF-3351-4827-9AE0-95004885C193 | 2017-12-13 13:21:02.383 |
| 298 | 297 | 11 | B924F26F-6446-45D1-A92B-6F418374F075 | 2017-12-13 13:21:02.447 |
| 300 | 299 | 11 | 5BA4E7BE-8D29-46A2-B68D-67B1615B124A | 2017-12-13 13:21:02.510 |
| 302 | 301 | 11 | 6CC8F248-8D96-4AFD-ADCC-61D93E8DE3B1 | 2017-12-13 13:21:02.570 |
| 304 | 303 | 11 | 33B4DA81-4448-481F-BF7C-357EA4D23F21 | 2017-12-13 13:21:02.633 |
| 306 | 305 | 11 | 70D35526-7C2F-470F-98CB-F9299A754F16 | 2017-12-13 13:21:02.697 |
Interactive explorer