Document Handling
Default table
Section titled “Default table”By default, PDF Region Pro uses the default table UC_PDF_DEFAULT_FILES to store documents. The default table uses the sequence UC_PDF_DEFAULT_FILES_SEQ and trigger UC_PDF_DEFAULT_FILES_BUI. 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 |
| BLOB_OWNER | VARCHAR2(4000) | | | Column is used to store a document owner name |
| VERSION | NUMBER | | | Column is used to store a document current version |
| LAST_UPDATE_DATE | TIMESTAMP(6) | | | Column is used to store a document last modification time |
| CREATE_BY | VARCHAR2(255) | | | Audit field containing APEX username that created a file |
| CREATE_DATE | DATE | | | Audit field containing DATE value when a file was created |
| UPDATE_BY | VARCHAR2(255) | | | Audit field containing APEX username that modified a file |
| UPDATE_DATE | DATE | | | Audit field containing DATE value when a file was modified |