← All tables and views
AdventureWorks OLTP table
Person.Person
Human beings involved with AdventureWorks: employees, customer contacts, and vendor contacts.
19,972rows
13 columns
Schema from the provider contract| Column | Type | Nullable | Key | References |
|---|---|---|---|---|
BusinessEntityID | INTEGER | no | PK | Person.BusinessEntity.BusinessEntityID |
PersonType | TEXT | no | — | — |
NameStyle | INTEGER | no | — | — |
Title | TEXT | yes | — | — |
FirstName | TEXT | no | — | — |
MiddleName | TEXT | yes | — | — |
LastName | TEXT | no | — | — |
Suffix | TEXT | yes | — | — |
EmailPromotion | INTEGER | no | — | — |
AdditionalContactInfo | TEXT | yes | — | — |
Demographics | TEXT | yes | — | — |
rowguid | TEXT | no | — | — |
ModifiedDate | TEXT | no | — | — |
Keys and unique indexes
Physical SQLite metadataPrimary key is declared above.
Additional unique keys
Person_Person_AK_Person_rowguidrowguid1 unique index inspected
Person_Person_AK_Person_rowguidrowguidCREATE UNIQUE INDEX "Person_Person_AK_Person_rowguid" ON "Person.Person" ("rowguid")Data preview
Sample records
| BusinessEntityID | PersonType | NameStyle | Title | FirstName | MiddleName | LastName |
|---|---|---|---|---|---|---|
| 1 | EM | 0 | NULL | Ken | J | Sánchez |
| 2 | EM | 0 | NULL | Terri | Lee | Duffy |
| 3 | EM | 0 | NULL | Roberto | NULL | Tamburello |
| 4 | EM | 0 | NULL | Rob | NULL | Walters |
| 5 | EM | 0 | Ms. | Gail | A | Erickson |
| 6 | EM | 0 | Mr. | Jossef | H | Goldberg |
| 7 | EM | 0 | NULL | Dylan | A | Miller |
| 8 | EM | 0 | NULL | Diane | L | Margheim |
Interactive explorer