Schema for Table storing AIM objects is as follows :

Column NameDescriptionData Type
UNIQUE_IDextracted from ImageAnnotation/@uniqueIdentifier (Primary Key) varchar(64)
REVIEWERextracted from ImageAnnotation/user/User/@loginName varchar(64)
DATE_CREATED extracted from ImageAnnotation/@dateTime timestamp
PATIENT_ID extracted from ImageAnnotation/person/Person/@id varchar(64)
XMLCOLUMNEntire 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)

Guidelines for writing a delete query :

It must have a delete statement. Example : DELETE from XMLDS.AIMTABLE where UNIQUE_ID=$uid$