Schema for Table storing AIM objects is as follows :
| Column Name | Description | Data Type |
|---|---|---|
| UNIQUE_ID | UniqueIdentifier for AnnotationCollection | varchar(64) |
| REVIEWER | Reviewer | varchar(64) |
| DATE_CREATED | Date Created | timestamp |
| PATIENT_ID | PatientID or Subject | varchar(64) |
| XMLCOLUMN | Entire 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$