19,972rows
5 columns
Schema from the provider contract| Column | Type | Nullable | Key | References |
|---|---|---|---|---|
BusinessEntityID | INTEGER | no | PK 1/2 | Person.Person.BusinessEntityID |
EmailAddressID | INTEGER | no | PK 2/2 | — |
EmailAddress | TEXT | yes | — | — |
rowguid | TEXT | no | — | — |
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.EmailAddress_1BusinessEntityID + EmailAddressIDData preview
Sample records
| BusinessEntityID | EmailAddressID | EmailAddress | rowguid | ModifiedDate |
|---|---|---|---|---|
| 1 | 1 | ken0@adventure-works.com | 8A1901E4-671B-431A-871C-EADB2942E9EE | 2020-01-07 00:00:00.000 |
| 2 | 2 | terri0@adventure-works.com | B5FF9EFD-72A2-4F87-830B-F338FDD4D162 | 2019-01-23 00:00:00.000 |
| 3 | 3 | roberto0@adventure-works.com | C8A51084-1C03-4C58-A8B3-55854AE7C499 | 2018-11-03 00:00:00.000 |
| 4 | 4 | rob0@adventure-works.com | 17703ED1-0031-4B4A-AFD2-77487A556B3B | 2018-11-27 00:00:00.000 |
| 5 | 5 | gail0@adventure-works.com | E76D2EA3-08E5-409C-BBE2-5DD1CDF89A3B | 2018-12-29 00:00:00.000 |
| 6 | 6 | jossef0@adventure-works.com | A9C4093A-4F4A-4CAD-BBB4-2C4E920BACCB | 2024-12-15 00:00:00.000 |
| 7 | 7 | dylan0@adventure-works.com | 70429DE4-C3BF-4F19-A00A-E976C8017FB3 | 2020-02-01 00:00:00.000 |
| 8 | 8 | diane1@adventure-works.com | 37F02A87-058D-49F8-A20D-965738B0A71F | 2019-12-22 00:00:00.000 |
Interactive explorer