Ownder
Tables (19)
FavoriteRestaurant
- FavoriteID — INT
- MemberID — INT
- RestaurantID — INT
- CreatedAt — DATETIME
HealthConditionType
- HealthConditionID — INT
- Label — VARCHAR(255)
- IsActive — BOOLEAN
Ingredient
- IngredientID — INT
- Name — VARCHAR(255)
- Category — VARCHAR(255)
- IsAllergenic — BOOLEAN
- CaloriesPer100g — DECIMAL(10,2)
Member
- MemberID — INT
- Username — VARCHAR(255)
- Password — VARCHAR(255)
- Name — VARCHAR(255)
- Age — INT
- Address — TEXT
- PhoneNumber — VARCHAR(20)
- AgreementConsent — BOOLEAN
- NfcToken — VARCHAR(255)
MemberOrder
- OrderID — INT
- MemberID — INT
- OrderDate — DATETIME
- TotalAmount — DECIMAL(10,2)
- PaymentStatus — VARCHAR(255)
Menu
- MenuID — INT
- RestaurantID — INT
- MenuName — VARCHAR(255)
- Description — TEXT
- Price — DECIMAL(10,2)
- ImageURL — TEXT
MenuIngredient
- MenuIngredientID — INT
- MenuID — INT
- IngredientID — INT
MenuOption
- MenuOptionID — INT
- MenuID — INT
- OptionID — INT
- IsDefault — BOOLEAN
Onboarding
- OnboardingID — INT
- MemberID — INT
- DietType — VARCHAR(255)
Option
- OptionID — INT
- OptionName — VARCHAR(255)
- OptionType — VARCHAR(255)
- IngredientID — INT
- AdditionalPrice — DECIMAL(10,2)
OrderItem
- OrderItemID — INT
- OrderID — INT
- RestaurantID — INT
- MenuID — INT
- Quantity — INT
- OptionNote — TEXT
- Subtotal — DECIMAL(10,2)
PaymentMethod
- PaymentMethodID — INT
- MemberID — INT
- MethodType — VARCHAR(255)
- Provider — VARCHAR(255)
- MaskedCardNumber — VARCHAR(20)
- TokenRef — VARCHAR(255)
- IsDefault — BOOLEAN
- CreatedAt — DATETIME
PreferenceType
- PreferenceID — INT
- Category — VARCHAR(255)
- Label — VARCHAR(255)
- IsActive — BOOLEAN
Restaurant
- RestaurantID — INT
- Name — VARCHAR(255)
- Category — VARCHAR(255)
- PhoneNumber — VARCHAR(20)
- RoadAddress — TEXT
- Latitude — FLOAT
- Longitude — FLOAT
- District — VARCHAR(255)
- ImageURL — TEXT
RestaurantReview
- ReviewID — INT
- MemberID — INT
- RestaurantID — INT
- Rating — INT
- ReviewText — TEXT
- ImageURL — TEXT
- CreatedAt — DATETIME
- UpdatedAt — DATETIME
UserAllergy
- UserAllergyID — INT
- OnboardingID — INT
- IngredientID — INT
UserDietPreference
- UserDietPrefID — INT
- OnboardingID — INT
- PreferenceID — INT
UserDislikeIngredient
- UserDislikeID — INT
- OnboardingID — INT
- IngredientID — INT
UserHealthCondition
- UserHealthCondID — INT
- OnboardingID — INT
- HealthConditionID — INT