Database

The database that ships with the LEAD Medical Storage Server uses over 30 different tables to store all types of data, including configuration, logging, users, passwords, client communication information (application entities), options, presentation states, and so on.  This tutorial focuses on patient, study, series, and instance data (i.e. “medical data”.).

The shipping database uses the following tables to store the medical data:

For the sample database tutorial, we define a much simpler database schema with four tables:

It is logical to have a schema that contains at least these four tables, since there is a one-to-many relationship between patient, study, series, and instance data: 

Note that this basic structure is logical, but not required.  If you choose to do so, you could have a single table containing all the information.  

Below is a graphical representation of the sample schema used in this tutorial: 

sampleschema

The shipping database schema uses the following primary keys:

Table

Primary Key

Patient

PatientID

Study

StudyInstanceUID

Series

SeriesInstanceUID

Instance

SOPInstanceUID

For the tutorial schema, the primary key of each table will be an identity key that is automatically created for each record.   For example, the first patient record that is added to table MyPatientTable will have the primary key PatientId automatically generated, and will have a value of ‘1’.  The next patient record added will have a PatientId of ‘2’ automatically generated.  The same holds for MyStudyTable and the primary key StudyId, MySeriesTable and SeriesId, and MyInstanceTable and ImageId.

Help Version 20.0.2020.4.3
Products | Support | Contact Us | Intellectual Property Notices
© 1991-2020 LEAD Technologies, Inc. All Rights Reserved.

LEADTOOLS Imaging, Medical, and Document