id | brand_name |
---|---|
1 | John Deere |
2 | Caterpillar |
3 | New Holland |
4 | Case IH |
5 | Fendt |
store_id | store_name | location |
---|---|---|
1 | Store A | 123 Main St |
2 | Store B | 456 Elm St |
3 | Store C | 789 Oak St |
4 | Store D | 012 Pine St |
5 | Store E | 345 Maple St |
machine_id | model_number | description |
---|---|---|
1 | Model X | Tractor Model X from John Deere. |
2 | Model Y | Combine Harvester Model Y by New Holland. |
3 | Model Z | Plow Model Z made by Case IH. |
4 | Model W | Tiller Model W produced by Fendt. |
5 | Model V | Seeder Model V created by Caterpillar. |
store_id | brand_id |
---|---|
(→ Agricultural_Machinery_Stores.store_id) | (→ Brands.id) |
1 | 1 |
2 | 1 |
3 | 1 |
4 | 1 |
5 | 1 |
5 | 2 |