← All tables and views
AdventureWorks OLTP table
Person.Address
Street address information for customers, employees, and vendors.
19,614rows
9 columns
Schema from the provider contract| Column | Type | Nullable | Key | References |
|---|---|---|---|---|
AddressID | INTEGER | no | PK | — |
AddressLine1 | TEXT | no | — | — |
AddressLine2 | TEXT | yes | — | — |
City | TEXT | no | — | — |
StateProvinceID | INTEGER | no | — | Person.StateProvince.StateProvinceID |
PostalCode | TEXT | no | — | — |
SpatialLocation | BLOB | yes | — | — |
rowguid | TEXT | no | — | — |
ModifiedDate | TEXT | no | — | — |
Keys and unique indexes
Physical SQLite metadataPrimary key is declared above.
Additional unique keys
Person_Address_AK_Address_rowguidrowguidPerson_Address_IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCodeAddressLine1 + AddressLine2 + City + StateProvinceID + PostalCode2 unique indexes inspected
Person_Address_AK_Address_rowguidrowguidCREATE UNIQUE INDEX "Person_Address_AK_Address_rowguid" ON "Person.Address" ("rowguid")Person_Address_IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCodeAddressLine1 + AddressLine2 + City + StateProvinceID + PostalCodeCREATE UNIQUE INDEX "Person_Address_IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode" ON "Person.Address" ("AddressLine1", "AddressLine2", "City", "StateProvinceID", "PostalCode")Data preview
Sample records
| AddressID | AddressLine1 | AddressLine2 | City | StateProvinceID | PostalCode | SpatialLocation |
|---|---|---|---|---|---|---|
| 1 | 1970 Napa Ct. | NULL | Bothell | 79 | 98011 | 5hAAAAEMrov8KLzkR0BnqJGJiYpewA== |
| 2 | 9833 Mt. Dias Blv. | NULL | Bothell | 79 | 98011 | 5hAAAAEM1vqFGubXR0C8JioKA5BewA== |
| 3 | 7484 Roundtree Drive | NULL | Bothell | 79 | 98011 | 5hAAAAEMGOMExK3hR0Dakwx4k5FewA== |
| 4 | 9539 Glenside Dr | NULL | Bothell | 79 | 98011 | 5hAAAAEMgToNX5/eR0ARpcKKfJVewA== |
| 5 | 1226 Shoe St. | NULL | Bothell | 79 | 98011 | 5hAAAAEMYcZNirvZR0DEYOo/2IVewA== |
| 6 | 1399 Firestone Drive | NULL | Bothell | 79 | 98011 | 5hAAAAEM4LTlBFjaR0AvEqX4DJdewA== |
| 7 | 5672 Hale Dr. | NULL | Bothell | 79 | 98011 | 5hAAAAEMGOMExK3hR0ARpcKKfJVewA== |
| 8 | 6387 Scenic Avenue | NULL | Bothell | 79 | 98011 | 5hAAAAEMACml2TvfR0DiSJYv1ZdewA== |
Interactive explorer