如何构建一个dicom数据库

Question

language: php database: mysql.

I have searched for some files about dicom database, but it just doesn't tell me a simple example.

Here are some I summarized: simple database 5 tables:

1. patient(patientid to be the major key)
2. study(study instance UID to be the major key)
3. series(series instance UID to be the major key)
4. image(image instance UID to be the major key)
5. link the four tables'major key and write into this table, and of course the .dcm files will be stored in the server folder

So do I need to modify somewhere if you think it's wrong? Are there some key data I've already missed? Thanks!

Answer 1

The patient id is not proper key, because it is not an unique identifier.

Study, Series, Image UID are unique and would work as key, but in view of performance it is may be not the best choice, because it is simply a too long string.

You should think about an internal assigned (auto-incremental) key.