id | name | location |
---|---|---|
1 | Blue Wave | Cancun |
2 | Sea Explorer | Mauritius |
3 | Underwater World | Bali |
4 | Aquatic Adventures | Hawaii |
5 | Poseidon Divers | Greece |
id | site_name | type |
---|---|---|
1 | Great Barrier Reef | Coral_Reefs |
2 | Shipwreck Cove | Wrecks |
3 | Shark Alley | Marine Life |
4 | Turtle Bay | Marine Life |
5 | The Blue Hole | Caverns |
id | first_name | last_name | |
---|---|---|---|
1 | John | Smith | johnsmith@example.com |
2 | Jane | Doe | janedoe@example.com |
3 | Alice | King | aliceking@example.com |
4 | Bob | Johnson | bobjohnson@example.com |
5 | Charlie | Williams | charliewilliams@example.com |
booking_id | customer_id | scuba_center_id | dive_site_id | date | time |
---|---|---|---|---|---|
(→ Customers.id) | (→ Scuba_Diving_Centers.id) | (→ Dive_Sites.id) | |||
1 | 1 | 1 | 1 | 2023-07-16 | 10:00 |
2 | 2 | 2 | 2 | 2023-08-09 | 11:00 |
3 | 3 | 3 | 3 | 2023-09-17 | 12:00 |
4 | 4 | 4 | 4 | 2023-10-23 | 13:00 |
5 | 5 | 5 | 5 | 2023-11-30 | 14:00 |
6 | 2 | 2 | 1 | 2023-08-09 | 11:00 |
7 | 3 | 3 | 1 | 2023-09-17 | 12:00 |
8 | 4 | 4 | 1 | 2023-10-23 | 13:00 |
9 | 5 | 5 | 1 | 2023-11-30 | 14:00 |