In the following database tables, all fields are varchar text unless otherwise stated.
Table 1. Results stores the results of policies which correspond to the columns in the raw data of the results.
| ID | Unique Row Identifier |
|---|---|
| Store | Name of the store the item was found in – this can be a mailbox, PST or public folder |
| Path | Path where the item is found |
| Subject | Subject of the item |
| Attachment | The names of the attachments on the item found |
| NumberOfAttachments | The number of the attachments on the item found |
| Sender | The sender of the item found |
| Recipients | The recipients of the item found |
| DeliveryTime | The delivery time of the item found |
| MessageSize | The size of the item found in bytes |
| DeleteTime | The time the item was deleted – only relevant if searching the dumpster |
| PolicyRunID | Identifier of the policy run the item was found on |
Table 2. PolicyRunDetails stores the details of the policies when they are run.
| ID | Unique Row Identifier |
|---|---|
| Name | Name of the policy that ran |
| Details | The details of the policy which was ran |
| RunTime | Time the policy ran |
Table 3. C2CVersion stores the version of the database format.
| Version | Stores the version of the database format |