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)