PB
Tables (17)
Appointments
- AppointmentID — INT
- CustomerID — INT
- BusinessID — INT
- PetID — INT
- ServiceOptionID — INT
- Date — DATE
- Time — TIME
- Status — VARCHAR(255)
- SpecialRequests — TEXT
Badges
- BadgeID — INT
- Name — VARCHAR(255) — NOT NULL
- Description — TEXT — NOT NULL
- ImageURL — VARCHAR(255)
BusinessBadges
- BusinessID — INT — Primary key — NOT NULL
- BadgeID — INT — Primary key — NOT NULL
- AwardedDate — DATE
BusinessNotices
- NoticeID — INT
- BusinessID — INT — NOT NULL
- Title — VARCHAR(255) — NOT NULL
- Content — TEXT — NOT NULL
- PostedDate — TIMESTAMP
BusinessTags
- BusinessID — INT — Primary key — NOT NULL
- TagID — INT — Primary key — NOT NULL
Businesses
- BusinessID — INT
- Name — VARCHAR(255)
- Location — VARCHAR(255)
- BusinessNumber — VARCHAR(255)
- StartDate — DATE
- PriceGuide — TEXT
Customers
- CustomerID — INT
- Name — VARCHAR(255)
- Contact — VARCHAR(255)
- Address — VARCHAR(255)
- LoginType — VARCHAR(255)
- AuthStatus — BOOLEAN
Favorites
- CustomerID — INT — Primary key — NOT NULL
- BusinessID — INT — Primary key — NOT NULL
- AddedDate — TIMESTAMP
Pets
- PetID — INT
- CustomerID — INT
- Photo — VARCHAR(255)
- Name — VARCHAR(255)
- Gender — VARCHAR(255)
- Breed — VARCHAR(255)
- Birthdate — DATE
- Weight — DECIMAL(5,2)
- Neutered — BOOLEAN
- Personality — TEXT
- VaccinationStatus — TEXT
Reviews
- ReviewID — INT
- CustomerID — INT — NOT NULL
- BusinessID — INT — NOT NULL
- Rating — INT — NOT NULL
- Content — TEXT — NOT NULL
- ReviewDate — TIMESTAMP
ServiceOptions
- ServiceOptionID — INT
- BusinessID — INT
- Description — VARCHAR(255)
- Price — DECIMAL(10,2)
- PetSize — VARCHAR(255)
Tags
- TagID — INT
- Name — VARCHAR(255) — NOT NULL