Schema for Table storing AIM objects is as follows :
| Column Name | Description | Data Type |
|---|---|---|
| UNIQUE_ID | extracted from ImageAnnotation/@uniqueIdentifier (Primary Key) | varchar(64) |
| REVIEWER | extracted from ImageAnnotation/user/User/@loginName | varchar(64) |
| DATE_CREATED | extracted from ImageAnnotation/@dateTime | timestamp |
| PATIENT_ID | extracted from ImageAnnotation/person/Person/@id | varchar(64) |
| XMLCOLUMN | Entire AIM object in XML format | xml |
| DATA_SOURCE | Contains source of AIM object. For example : bindaas, etc. | varchar(120) |
| IMAGE_UID | extracted from ImageAnnotation/imageReferenceCollection/ImageReference/imageStudy/ImageStudy/imageSeries/ImageSeries/imageCollection/Image/@sopInstanceUID | varchar(64) |
| STUDY_UID | extracted from ImageAnnotation/imageReferenceCollection/ImageReference/imageStudy/ImageStudy/@instanceUID | varchar(64) |
| SERIES_UID | extracted from ImageAnnotation/imageReferenceCollection/ImageReference/imageStudy/ImageStudy/imageSeries/ImageSeries/@instanceUID | varchar(64) |
Data submissions are accepted in following two formats :