← All tables and views
AdventureWorks OLTP table
Person.BusinessEntity
Source of the ID that connects vendors, customers, and employees with address and contact information.
20,777rows
3 columns
Schema from the provider contract| Column | Type | Nullable | Key | References |
|---|---|---|---|---|
BusinessEntityID | INTEGER | no | PK | — |
rowguid | TEXT | no | — | — |
ModifiedDate | TEXT | no | — | — |
Keys and unique indexes
Physical SQLite metadataPrimary key is declared above.
Additional unique keys
Person_BusinessEntity_AK_BusinessEntity_rowguidrowguid1 unique index inspected
Person_BusinessEntity_AK_BusinessEntity_rowguidrowguidCREATE UNIQUE INDEX "Person_BusinessEntity_AK_BusinessEntity_rowguid" ON "Person.BusinessEntity" ("rowguid")Data preview
Sample records
| BusinessEntityID | rowguid | ModifiedDate |
|---|---|---|
| 1 | 0C7D8F81-D7B1-4CF0-9C0A-4CD8B6B50087 | 2017-12-13 13:20:24.150 |
| 2 | 6648747F-7843-4002-B317-65389684C398 | 2017-12-13 13:20:24.430 |
| 3 | 568204DA-93D7-42F4-8A7A-4446A144277D | 2017-12-13 13:20:24.540 |
| 4 | 0EFF57B9-4F4F-41A6-8867-658C199A5FC0 | 2017-12-13 13:20:24.570 |
| 5 | B82F88D1-FF79-4FD9-8C54-9D24C140F647 | 2017-12-13 13:20:24.633 |
| 6 | 1B3D077A-1941-4D6E-8328-F7DC03595565 | 2017-12-13 13:20:24.680 |
| 7 | C1898370-A36F-43A2-987C-0BF24FE3FB82 | 2017-12-13 13:20:24.727 |
| 8 | 2B50ABB8-ABAB-412B-A4D0-4FD5EBEB5CBE | 2017-12-13 13:20:24.773 |
Interactive explorer