Document Handling
Default table
Section titled “Default table”By default, Email Viewer Pro uses the default table UC_EMAIL_DEFAULT_FILES to store documents. The default table uses the sequence UC_EMAIL_FILES_SEQ and trigger UC_EMAIL_FILES_BIU. The default table, trigger, and sequence are created with the sample application and the plug-in DDL installation script.
| Column Name | Data Type | Nullable | Primary Key | Description |
|---|---|---|---|---|
| ID | NUMBER |  |  | Column is used to uniquely identify a document |
| CONTENT | BLOB | | | Column is used to store a document contents |
| FILENAME | VARCHAR2(4000) | | | Column is used to store a document filename |
| MIME_TYPE | VARCHAR2(4000) | | | Column is used to store a document MIME-type |
| LAST_UPDATE_DATE | TIMESTAMP(6) | | | Column is used to store a document last modification time |
| CREATED_BY | VARCHAR2(255) | | | Audit field containing APEX username that created a file |
| CREATED | DATE | | | Audit field containing DATE value when a file was created |
| UPDATED_BY | VARCHAR2(255) | | | Audit field containing APEX username that modified a file |
| UPDATED | DATE | | | Audit field containing DATE value when a file was modified |