← All tables and views
AdventureWorks OLTP table
Person.BusinessEntityAddress
Cross-reference table mapping customers, vendors, and employees to their addresses.
19,614rows
5 columns
Schema from the provider contract| Column | Type | Nullable | Key | References |
|---|---|---|---|---|
BusinessEntityID | INTEGER | no | PK 1/3 | Person.BusinessEntity.BusinessEntityID |
AddressID | INTEGER | no | PK 2/3 | Person.Address.AddressID |
AddressTypeID | INTEGER | no | PK 3/3 | Person.AddressType.AddressTypeID |
rowguid | TEXT | no | — | — |
ModifiedDate | TEXT | no | — | — |
Keys and unique indexes
Physical SQLite metadataPrimary key is declared above.
Additional unique keys
Person_BusinessEntityAddress_AK_BusinessEntityAddress_rowguidrowguid2 unique indexes inspected
Person_BusinessEntityAddress_AK_BusinessEntityAddress_rowguidrowguidCREATE UNIQUE INDEX "Person_BusinessEntityAddress_AK_BusinessEntityAddress_rowguid" ON "Person.BusinessEntityAddress" ("rowguid")sqlite_autoindex_Person.BusinessEntityAddress_1BusinessEntityID + AddressID + AddressTypeIDData preview
Sample records
| BusinessEntityID | AddressID | AddressTypeID | rowguid | ModifiedDate |
|---|---|---|---|---|
| 1 | 249 | 2 | 3A5D0A00-6739-4DFE-A8F7-844CD9DEE3DF | 2025-09-11 11:15:06.967 |
| 2 | 293 | 2 | 84AE7057-EDF4-4C51-8B8D-3AEAEFBFB4A1 | 2025-09-11 11:15:06.967 |
| 3 | 224 | 2 | 3C915B31-7C05-4A05-9859-0DF663677240 | 2025-09-11 11:15:06.967 |
| 4 | 11387 | 2 | 3DC70CC4-3AE8-424F-8B1F-481C5478E941 | 2025-09-11 11:15:06.967 |
| 5 | 190 | 2 | C0ED2F68-937B-4594-9459-581AC53C98E3 | 2025-09-11 11:15:06.967 |
| 6 | 286 | 2 | 4CA1686A-A7DF-4BD8-9D7D-82A63210208A | 2025-09-11 11:15:06.967 |
| 7 | 49 | 2 | 1528E305-3E34-4DEA-BDD7-C7DDCDD11EF8 | 2025-09-11 11:15:06.967 |
| 8 | 230 | 2 | 38F80F8F-5CA7-4D06-AEFA-CD930A0A7B3F | 2025-09-11 11:15:06.967 |
Interactive explorer