| ServiceID | Name | Description |
|---|---|---|
| 1 | Massage | Relax and rejuvenate with our professional massage services |
| 2 | Facial | Revitalize your skin with our expertly performed facial treatments |
| SpaID | ServiceID | Address |
|---|---|---|
| (→ Services.ServiceID) | ||
| 1 | 1 | 123 Main St, New York, NY 10001 |
| 2 | 2 | 456 Broadway, Los Angeles, CA 90012 |
| RetreatID | ServiceID | Location |
|---|---|---|
| (→ Services.ServiceID) | ||
| 1 | 1 | 789 Ocean Blvd, Miami Beach, FL 33139 |
| 2 | 2 | 101 Mountain Rd, Asheville, NC 28801 |
| PriceID | PriceValue | ServiceID |
|---|---|---|
| (→ Services.ServiceID) | ||
| 1 | 150 | 1 |
| 2 | 200 | 1 |
| 3 | 250 | 2 |
| 4 | 200 | 2 |
| BookingID | CustomerName | CheckInDate | CheckOutDate | RoomNumber | TotalCost | ForeignKey |
|---|---|---|---|---|---|---|
| (→ TableThatHasntBeenDefinedYet.PrimaryKeyOfTableThatHasntBeenDefinedYet) | ||||||
| 1 | John Doe | 2021-10-01 | 2021-10-05 | 101 | 500.0 | 1 |
| 2 | Jane Smith | 2021-10-10 | 2021-10-14 | 102 | 600.0 | 2 |
| 3 | Alice Johnson | 2021-11-01 | 2021-11-05 | 103 | 550.0 | 3 |
| 4 | Bob Brown | 2021-11-10 | 2021-11-14 | 104 | 650.0 | 4 |
| RoomID | RoomType | NumberOfGuests | Rate | Amenities |
|---|---|---|---|---|
| 101 | Deluxe King | 2 | 150 | WiFi, Mini fridge, Flat screen TV |
| 102 | Standard Queen | 2 | 100 | WiFi, Coffee maker, Flat screen TV |
| 103 | Suite | 4 | 200 | Separate living area, WiFi, Mini fridge, Flat screen TV |
| 104 | Accessible King | 2 | 120 | Roll-in shower, Wider doorways, WiFi, Mini fridge, Flat screen TV |