int PetID PK
varchar PetName
varchar Breed
enum Type
int Age
enum Gender
decimal Weight
enum HealthStatus
date AdmissionDate
enum Status
text Description
timestamp CreatedAt
int AdopterID PK
varchar FirstName
varchar LastName
varchar Email
varchar Phone
text Address
varchar City
varchar State
varchar ZipCode
timestamp RegistrationDate
int AdoptionID PK
int PetID FK
int AdopterID FK
date AdoptionDate
text Notes
by kaya