database ms-access

Forums > Onis operations > Database
Search the Forums
Keyword :
mulOMpUR
Hi, i want to know if u have a dictionary of terms of the fields of each table on database ms-access, there are a lots of fields unknows for me, for example, the field 'cmd' in "HISTORY" table, and what does minus symbol (-) mean in a integer type fields? i have a lots of questions like this, thanks for the attention for reading
 
7/10/2013 6:19:34 AM

mulOMpUR
One more question, why the tables in the database are not related to one another? please any answer will be good, thanks
 
7/11/2013 2:34:59 AM

mulOMpUR
Hello Alfredo,

Sorry, we don't have any technical documentation about the database available. Few tables exists and maybe only the history table is difficult to understand. It is used a lot in different version of ONIS that are not advertise on our website. We use this table to record the modification made on the database. For ONIS Ultimate and Professional, it is probably used only when an image is overwritten (send 2 times the same image). Other products use this table when we modify the patient information, merge or split series, etc... the cmd field for example tells the type of modification (overwrite an image, modification of patient, deletion of a series, etc). Since several modification can be done, some other field exist to recreate the history of modifications and the level (patient, study, series and image). Other fields are used to record the modification that was done.

There are no relation because the design is old and very simple. The next major version of ONIS will contain a much more complex database with many relationships.

I hope this help a bit,

Regards,

madric
 
7/11/2013 11:30:10 AM

mulOMpUR
Thank you very much!!, it helps so much
 
7/13/2013 12:41:14 AM
 
About us | Contact us | Terms and Conditions | Privacy policy | Copyright policy
Copyright © Digitalcore 2009-2022. All rights reserved.