| id | name | location |
|---|---|---|
| 1 | Village1 | Location1 |
| 2 | Village2 | Location2 |
| 3 | Village3 | Location3 |
| 4 | Village4 | Location4 |
| 5 | Village5 | Location5 |
| id | tour_name | description |
|---|---|---|
| 1 | Whale Watching | A tour to watch whales. |
| 2 | Fishing Tour | Go on a fishing trip. |
| 3 | Cruise | Relaxing cruise on the sea. |
| 4 | Dolphin Spotting | Spot dolphins in their natural habitat. |
| 5 | Sunset Cruise | Enjoy sunset over the ocean. |
| maritime_village_id | boat_tour_id |
|---|---|
| (→ Maritime_Villages.id) | (→ Boat_Tours.id) |
| 1 | 1 |
| 2 | 1 |
| 3 | 1 |
| 4 | 1 |
| 5 | 1 |
| 5 | 4 |