← All tables and views
AdventureWorks OLTP table
Production.Location
Product inventory and manufacturing locations.
14rows
5 columns
Schema from the provider contract| Column | Type | Nullable | Key | References |
|---|---|---|---|---|
LocationID | INTEGER | no | PK | — |
Name | TEXT | no | — | — |
CostRate | NUMERIC | no | — | — |
Availability | NUMERIC | no | — | — |
ModifiedDate | TEXT | no | — | — |
Keys and unique indexes
Physical SQLite metadataPrimary key is declared above.
Additional unique keys
Production_Location_AK_Location_NameName1 unique index inspected
Production_Location_AK_Location_NameNameCREATE UNIQUE INDEX "Production_Location_AK_Location_Name" ON "Production.Location" ("Name")Data preview
Sample records
| LocationID | Name | CostRate | Availability | ModifiedDate |
|---|---|---|---|---|
| 1 | Tool Crib | 0 | 0 | 2019-04-30 00:00:00.000 |
| 2 | Sheet Metal Racks | 0 | 0 | 2019-04-30 00:00:00.000 |
| 3 | Paint Shop | 0 | 0 | 2019-04-30 00:00:00.000 |
| 4 | Paint Storage | 0 | 0 | 2019-04-30 00:00:00.000 |
| 5 | Metal Storage | 0 | 0 | 2019-04-30 00:00:00.000 |
| 6 | Miscellaneous Storage | 0 | 0 | 2019-04-30 00:00:00.000 |
| 7 | Finished Goods Storage | 0 | 0 | 2019-04-30 00:00:00.000 |
| 10 | Frame Forming | 22.5 | 96 | 2019-04-30 00:00:00.000 |
Interactive explorer