FOLDER ------ OID VARCHAR(36) PK PARENT_OID VARCHAR(36) REF FOLDER PARENT_IDX INT FOLDER_NAME VARCHAR(1000) ENTITY ------ DISCRIMINATOR VARCHAR(40) OID VARCHAR(36) PK COMPOSITE_OID VARCHAR(36) REF BODY COMPOSITE_IDX INT FOLDER_OID VARCHAR(36) REF FOLDER FOLDER_IDX INT START_LINE BIGINT SEPARATOR_LINE BIGINT END_LINE BIGINT ADDRESS ------- DISCRIMINATOR VARCHAR(40) OID VARCHAR(36) PK FIELD_OID VARCHAR(36) REF FIELD FIELD_IDX INT GROUP_OID VARCHAR(36) REF ADDRESS GROUP_IDX INT ADDR_NAME VARCHAR(1000) MBX_LOCAL_PART VARCHAR(1000) MBX_DOMAIN VARCHAR(1000) MBX_ROUTE VARCHAR(10000) BODY ---- DISCRIMINATOR VARCHAR(40) OID VARCHAR(36) PK ENTITY_OID VARCHAR(36) REF ENTITY BODY_OFFSET BIGINT BODY_LENGTH BIGINT PREVIEW VARCHAR(10000) PREAMBLE VARCHAR(10000) EPILOGUE VARCHAR(10000) FIELD ----- DISCRIMINATOR VARCHAR(40) OID VARCHAR(36) PK ENTITY_OID VARCHAR(36) REF ENTITY ENTITY_IDX INT FIELD_NAME VARCHAR(1000) TEXT VARCHAR(10000) MEDIA_TYPE VARCHAR(100) SUB_TYPE VARCHAR(100) DISPOSITION_TYPE VARCHAR(100) DATE_TIME TIMESTAMP VALID BOOLEAN PARSE_EXCEPTION_STACK_TRACE VARCHAR(100000) PARAMETER --------- FIELD_OID VARCHAR(36) PK ATTR_NAME VARCHAR(100) PK ATTR_VALUE VARCHAR(1000) Discriminators: 1 -> Message 2 -> BodyPart 3 -> EmbeddedMessage -------- 101 -> Entity 102 -> BodyEntity Discriminators: 1 -> Unstructured 2 -> ContentType 3 -> ContentDisposition 4 -> DateTime 5 -> AddressList 6 -> MailboxList 7 -> Mailbox -------- 301 -> Field Discriminators: 1 -> Text 2 -> Binary 3 -> Multipart 4 -> Message -------- 201 -> Body 202 -> SingleBody Discriminators: 1 -> AddressListField Mailbox 2 -> MailboxListField Mailbox 3 -> MailboxField Mailbox 4 -> AddressListField Group Mailbox 5 -> AddressListField Group -------- 401 -> Address 402 -> FieldAddress 403 -> AddressListField Address Modelo Físico Relacional Meta Arquivamento * * * * * * SETTING --------- ATTR_NAME VARCHAR(100) PK ATTR_VALUE VARCHAR(1000) TAG --------- ENTITY_OID VARCHAR(36) PK TAG_VALUE VARCHAR(100) PK * * Mailbox to Group BodyEntity to Composite Parameter to ContentType or Parameter to ContentDisposition Message to Folder Folder to Parent Folder Mailbox to Mailbox or Mailbox to MailboxList or Address to AddressList Tag to Message