Thank you for your time and advice!As a beginner you first need to tell us about the business context - what is the database for, how you expect to use it in your work. The start and fundamentals for your database are to understand the scope and business requirements to then define a database schema on which you can build the application. As it is written using a language that is not English - it is difficult to interpret. If your tables are well-formed, you are not enforcing referential integrity in any of the relationships. That is about the rules that determine such things as what record must exist before a record in a child table can be added, or when deleting a record do you want the child records to also be deleted, or will they be orphaned. Cannot tell if valid but KOMB_ID in KombiT relates correctly to Vakcin_veids. But difficult to move further without more explanation of your business.
Language" Latvian, seems to be about vaccinations?
For a veterinary clinic. - 1 onlydatabase purpose is to collect data about simple things as - client info, visits, vaccinations and some medications used in visits. some forms just show aftermath about vaccinations and medicine
ok, i see that we will dig deep , i will reply in few days about this.No need to apologize - you are doing well. If I can just review some things you have said:
For a veterinary clinic. - 1 only
Your clients (in the client table) I presume are people, but as a vet clinic it is the animals that are treated - so perhaps you need a separate table for Clients and Animals (a Client can have multiple Animals). A Visit occurs when a client brings an Animal to the clinic - no offsite visits? Do you want to allow for this or perhaps later another clinic? At a Visit, one or more treatments are applied (instanced through a TxApplied table) which identifies each Treatment (type) - it may be medication, vaccination, some other procedure, or investigation to diagnose or treat the animal (if it can be generalised to this level). The animal then may have one or more Conditions as diagnosed through TxApplied.
Initial thoughts - preliminary schema - that you might consider how it corresponds to yours:
View attachment 121218
Depending on generalisations Procedure/ Medication / Vax might able to be combined into Treatment, designated as types. and VaxApplied to TxApplied. It is difficult to comment on the attributes you have assigned to your tables. The process to review and assign these attributes is called database normalisation. A fully specified vet clinic schema would appear much more complex than above however I assume you are trying to keep it simple.
You do need to apply referential integrity constraints in your schema.
Not sure if you mean Aftermath - as the consequence of an action - or Outcomes - as the result or effect of a treatment.
Re deletions - whether normal use permits them or not, you will need to set the constraints up so that say a client record cannot be deleted in visit records exist for the client. Records can be effectively hidden and not deleted by using an IsArchived flag (on the client record for eg when they are no longer a client or on an animal record if the animal has died. The data can still be accessed for reporting but may not be visible for entry of data.
Some say that it is possible in wordpress? but i haven't tried it. i don't know other inexpensive commercial system available for database. Ofcourse big clinics use some logistic solutions which is expensive for just 1 clinic.Before you build this yourself. Is there not a reasonably inexpensive commercial system available you could use? Maybe a single user system would work, or one for a small number of users. That might be much more effective than doing it yourself.
An experienced developer might put something together in a few days, but learning and building a real system at the same time is going to be much more challenging.
i have termination check box, which gives me back label big red - DEAD. it is only termination option i have.Agree data should not be deleted but you will probably need a ‘termination’ field for when a client or vet leaves the practice, a pet dies, a vaccine is no longer available etc. usually a date field (where null means current) perhaps with a second text field to indicate why
What I meant is... I just googled "software for vets " and got a list of a number of packages. None of them are really saying how much their solution costs, but if you know any of them from other vet practices you might get some help. Doesn't your national vets association have some advice. It's probably going to be much easier this way than rolling your own.Some say that it is possible in wordpress? but i haven't tried it. i don't know other inexpensive commercial system available for database. Ofcourse big clinics use some logistic solutions which is expensive for just 1 clinic.
and i think MS ACCESS can bring the minimum and more just fine. because for our needs it really doesn't need to do much to make us happy and stop writing everything on paper.
It's better than a lot of demos but $100 would be a lot to pay for it given it's improper normalization and lack of treatment detailsand although it is not super expensive I could build something better than that in 20 minutes. That looked pretty bad, at least from the demo.
No need to apologize - you are doing well. If I can just review some things you have said:
For a veterinary clinic. - 1 only
Your clients (in the client table) I presume are people, but as a vet clinic it is the animals that are treated - so perhaps you need a separate table for Clients and Animals (a Client can have multiple Animals). A Visit occurs when a client brings an Animal to the clinic - no offsite visits? Do you want to allow for this or perhaps later another clinic? At a Visit, one or more treatments are applied (instanced through a TxApplied table) which identifies each Treatment (type) - it may be medication, vaccination, some other procedure, or investigation to diagnose or treat the animal (if it can be generalised to this level). The animal then may have one or more Conditions as diagnosed through TxApplied.
Initial thoughts - preliminary schema - that you might consider how it corresponds to yours:
View attachment 121218
Depending on generalisations Procedure/ Medication / Vax might able to be combined into Treatment, designated as types. and VaxApplied to TxApplied. It is difficult to comment on the attributes you have assigned to your tables. The process to review and assign these attributes is called database normalisation. A fully specified vet clinic schema would appear much more complex than above however I assume you are trying to keep it simple.
You do need to apply referential integrity constraints in your schema.
Not sure if you mean Aftermath - as the consequence of an action - or Outcomes - as the result or effect of a treatment.
Re deletions - whether normal use permits them or not, you will need to set the constraints up so that say a client record cannot be deleted in visit records exist for the client. Records can be effectively hidden and not deleted by using an IsArchived flag (on the client record for eg when they are no longer a client or on an animal record if the animal has died. The data can still be accessed for reporting but may not be visible for entry of data.
The template referred to shows nothing that relates to the animals treated or the treatment they received - just a generic appointment schedule - so pretty useless.
@FeelCore - The report to do with health inspections: is that a formal, regulated report that needs to be completed for certain diseases? You need to make sure all elements for the report are captured.
As you travel in the field to locations, the appointments have a location - where it might be at the practice, or at a client/ other location. This means the Appointment will need a flag to indicate - At Practice or in Field, and if the location is not at the client's address (or at the practice), then an ability to capture the location of the appointment.
Is an Appointment always for a single animal or perhaps a herd? Treatment applied will need to be specific to an animal I presume. But may be a mass vax might be applied to a herd at an appointment - but each animal in the herd needs that to be recorded as having been vaxed. Might be going too far for your initial foray into Access, but...
Hi, sorry for such delay!
I attached my view of how i see and made my database. in simple way.
i hope it makes more sense to what i have created.
i have made other version, where i added field in each table - client, visits, medication, vacination. made log_on table where it takes tempvars and store info, then this info, if created new record or is edited it fill this field with example Dr.name, and then you know wich doctor made that record or touched last!it manages problem if there is 2 doctors in clinic - for example!
HiThe locations is clinic and not somewhere else and yes animals is treated one by one. so no problem for location field in my clinic. ( but thank you for insight - i will think about that too, noted)
This clinic data holds more like an notebook type, useful only for Doctor and its work basis.
Not for clients. clients have only Report what is done in appointment so doctor doesn't have to write it down manually on paper.
For Health Inspection it holds info about [medication] and [for what client is used] and [how]. it shows [how much came in] and [how much it goes away], and [what is left on site]. There is No Report form for Health inspection, only Form with data, calculated data.
Vaxed info makes doctor to easy fill up form in Health Inspection excel sheet by period selected.
Other info is just history for doctor to see what is done in visits.
You can imagine - old time when all was on papers - so doctor went for clients card, which holds info about patient and if needed treatment doctor wrote on paper what needed to done to get healthy again. And made some note in clients card, so he can remember history of patient.
So my database does same job with some extra calculated fields so doctor can fill up forms for other companies if needed.
My concern is more about how it is done as programming - VBA, Security - how to lock my database and protect, for me and for clinic!
I tried on my other PC to set up. and it was quite circus. original ok - all language change, made it work, but when i made ACCDE file for locking my VBA it made some event errors. why? I don't know.
I have to think about [client and animal] separation in future, [Location change] if doctor is on road and if treating herd animals.