-
Notifications
You must be signed in to change notification settings - Fork 1
Database Sample Data
Luke Pring edited this page Apr 7, 2025
·
1 revision
| StaffID | Type | AccessLevel | Name | Passcode |
|---|---|---|---|---|
| 1 | Admin | 3 | Jack Turner | 2468 |
| 2 | Admin | 2 | Caffe Nero | 9876 |
| PetID | Name | Breed | Age | MedicalHistory | VaccinationStatus | OwnerID |
|---|---|---|---|---|---|---|
| 1 | Bob | Pug | 3 | Has asthma | 1 | 1 |
| 2 | Henry | Syrian Hamster | 1 | Bites a lot | 0 | 2 |
| 3 | Alan | Polish Hound | 4 | Allergic to mayonnaise | 1 | 2 |
| 4 | Steve | XL Bully | 3 | Quite violent | 0 | 2 |
| OwnerID | Name | Address | PhoneNumber | |
|---|---|---|---|---|
| 1 | John Smith | 12 Street Lane, Lewes | 07628 2765889 | johnsmith@gmail.com |
| 2 | Luke Pring | University of Roehampton, London | 07565 455676 | hello@lukepr.ing |
| AppointmentID | DateTime | AppointmentDetails | PetID | OwnerID |
|---|---|---|---|---|
| 0 | ||||
| 1 | 19-03-2025 09:00 | Routine Checkup | 2 | 2 |
| 2 | 20-03-2025 19:00 | Heart Surgery | 3 | 2 |
By Luke Pring and Jack Turner for the Software Development 2 module at University of Roehampton, London.