mgmg
Tables (13)
Appointments
- AppointmentID — int
- CustomerID — int — Foreign key → Customers.CustomerID
- BusinessID — int — Foreign key → Businesses.BusinessID
- PetID — int — Foreign key → Pets.PetID
- ServiceOptionID — int — Foreign key → ServiceOptions.ServiceOptionID
- Date — date
- Time — time
- Status — ENUM
- SpecialRequests — text
Badges
- BadgeID — int
- Name — varchar(255)
- Description — text
- ImageURL — varchar(255)
BusinessBadges
- BusinessID — int — Foreign key → Businesses.BusinessID
- BadgeID — int — Foreign key → Badges.BadgeID
- AwardedDate — date
BusinessNotices
- NoticeID — int
- BusinessID — int — Foreign key → Businesses.BusinessID
- Title — varchar(255)
- Content — text
- PostedDate — timestamp
BusinessTags
- BusinessID — int — Foreign key → Businesses.BusinessID
- TagID — int — Foreign key → Tags.TagID
Businesses
- BusinessID — int
- Name — varchar(255)
- Location — varchar(255)
- BusinessNumber — varchar(255)
- StartDate — date
- PriceGuide — text
Chats
- ChatID — int
- CustomerID — int — Foreign key → Customers.CustomerID
- BusinessID — int — Foreign key → Businesses.BusinessID
- Message — text
- SentTime — timestamp
Customers
- CustomerID — int
- Name — varchar(255)
- Contact — varchar(255)
- Address — varchar(255)
- LoginType — ENUM
Favorites
- CustomerID — int — Foreign key → Customers.CustomerID
- BusinessID — int — Foreign key → Businesses.BusinessID
- AddedDate — timestamp
Pets
- PetID — int
- CustomerID — int — Foreign key → Customers.CustomerID
- Photo — varchar(255)
- Name — varchar(255)
- Gender — ENUM
- Breed — ENUM
- Birthdate — date
- Weight — decimal(5,2)
- Neutered — boolean
- Personality — text
- VaccinationStatus — text
Reviews
- ReviewID — int
- CustomerID — int — Foreign key → Customers.CustomerID
- BusinessID — int — Foreign key → Businesses.BusinessID
- Rating — int
- Content — text
- ReviewDate — timestamp
ServiceOptions
- ServiceOptionID — int
- BusinessID — int — Foreign key → Businesses.BusinessID
- Description — varchar(255)
- Price — decimal(10,2)
- PetSize — ENUM
Tags
- TagID — int
- Name — varchar(255)