Hungry Hub — Q&A Reference
1. What are XP Reservation, PP Reservation, and AYCE Reservation?
These are reservation package types on Hungry Hub.
We have three active package types:
- AYCE (All You Can Eat)
- PP (Party Pack)
- XP (Experience)
When a user books one of these package types, we call it a “package type + reservation”.
That’s why we use the terms XP reservation, PP reservation, and AYCE reservation.
2. What is the difference between the columns loyalty_level_id and last_loyalty_level_id?
Loyalty Level is a feature to mark user achievements and provide benefits based on booking milestones.
There are four tiers of loyalty levels:
- RED
- SILVER
- GOLD
- PLATINUM
Users earn points by booking, writing reviews, and using referral programs.
To maintain their loyalty level, users must complete certain missions — either by making a minimum number of bookings or spending a minimum amount every four months.
| Column | Description |
|---|---|
loyalty_level_id | The current loyalty level ID of the user. |
last_loyalty_level_id | The previous loyalty level ID before being upgraded or downgraded. |
3. Which table do we look at for restaurant information (such as restaurant names)?
- The restaurant name can be found in the
restaurant_translationtable. - For other details, refer to the restaurant table.
4. What do mon, tue, wed … sun in the restaurants table mean?
These columns are used for inventory scheduling.
Each day connects to an inventory template group that defines when the restaurant is open.
- If the value is NULL, the restaurant is closed or cannot be booked for that day.
- Every restaurant has an inventory template for weekdays and weekends.
- Restaurants can specify:
- How many hours they’re open each day.
- How many tables are available at specific times.
On the package level, each package also has an agenda (mon–sun) that defines:
- The available hours.
- The number of tables for each time slot.
Users can only book the restaurant if both the restaurant’s inventory and the package agenda are set.