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 |