Schema for Table storing AIM objects is as follows :

Column NameDescriptionData Type
UNIQUE_IDUniqueIdentifier for AnnotationCollection varchar(64)
REVIEWER Reviewervarchar(64)
DATE_CREATED Date Created timestamp
PATIENT_ID PatientID or Subject varchar(64)
XMLCOLUMNEntire AIM object in XML format xml
DATA_SOURCE Contains source of AIM object. For example : bindaas, etc. varchar(120)

Guidelines for writing a delete query :

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