Dreamweaver
Well-known member
- Local time
- Today, 14:52
- Joined
- Nov 28, 2005
- Messages
- 2,466
I've just started this and am in the very early stage before even a ERD is developed this is what Ive come up with so far
The main sections are
I did sort of have a peak at Data Models
It's something I haven't tackled before if you see anything amis please let me know
Animals
Basic details would be name, type, breed, Colour Description, Gender, DateIn, DateOut, Status, DangerLevel.
Activaty Records
Feeding Records
Medication records
Health Records
A set of photos should be able to be created with comments Etc
Employees
General Employee Records
Tasks this might be daily to x times a day depending on animal
Animal Skills Records I.E. Which animals can that employees care for/Has been trained to handle
Foods
Where do they get it
Food Information Record
Stock
Vets
Vets contact details
Customers
Customer Can bring animals in or take them out, If taking home they may need veting so a system should be designed where the admin user can add the Questions that would need to be answered.
Customer Could also make donations to the sanctuary
Environment
the enviroment could be a cage, kennel padock Etc
it would be important to keep clean and maintained
Financial
Costs per animal, feed, maintenance, employee Not wages system just totals
The main sections are
I did sort of have a peak at Data Models
It's something I haven't tackled before if you see anything amis please let me know
Animals
Basic details would be name, type, breed, Colour Description, Gender, DateIn, DateOut, Status, DangerLevel.
Activaty Records
Feeding Records
Medication records
Health Records
A set of photos should be able to be created with comments Etc
Employees
General Employee Records
Tasks this might be daily to x times a day depending on animal
Animal Skills Records I.E. Which animals can that employees care for/Has been trained to handle
Foods
Where do they get it
Food Information Record
Stock
Vets
Vets contact details
Customers
Customer Can bring animals in or take them out, If taking home they may need veting so a system should be designed where the admin user can add the Questions that would need to be answered.
Customer Could also make donations to the sanctuary
Environment
the enviroment could be a cage, kennel padock Etc
it would be important to keep clean and maintained
Financial
Costs per animal, feed, maintenance, employee Not wages system just totals