Database Objects
The summary below describes all database objects created after installing the FlowForms sample application or after installing FlowForms as a standalone plug-in in an existing Oracle APEX application using a DDL script.
- column The plug-in indicates whether an object is required to run FlowForms outside the sample application
- column Supporting object indicates whether an object is required by the sample application
Tables
| Object Name | Supporting object | The plug-in | Description |
|---|---|---|---|
| UC_FLOWFORMS_NODE |  | | The table is used as the default source type for the most basic implementation of UC - FlowForms |
| UC_FLOWFORMS_FORM | | | The table is used to store form definitions |
| UC_FLOWFORMS_PUBLISHED | | | The table is used to store the published form schema, locales, and initial data |
| UC_FLOWFORMS_DATA | | | The table is used to store the submitted data of the forms |
| UC_FLOWFORMS_BLOBS | | | The table is used to store the blobs coming from file browse inputs inside the forms |
| UC_FLOWFORMS_LOVS | | | The table is used to store the list of values for the |
| UC_FLOWFORMS_LOV_ENTRIES | | | The table is used to store the list of value entries for the forms |
| UC_FLOWFORMS_LOV_CUSTOM | |  | The table is used as an example for the custom list of values structure |
Triggers
| Object Name | Supporting object | The plug-in | Description |
|---|---|---|---|
| BIU_UC_FLOWFORMS_NODE | | | Required by UC_FLOWFORMS_NODE |
| BIU_UC_FLOWFORMS_FORM | | | Required by UC_FLOWFORMS_FORM |
| BIU_UC_FLOWFORMS_PUBLISHED | | | Required by UC_FLOWFORMS_PUBLISHED |
| BIU_UC_FLOWFORMS_DATA | | | Required by UC_FLOWFORMS_DATA |
Packages
| Object Name | Supporting object | The plug-in | Description |
|---|---|---|---|
| PIP_CRYPTO | | | The package is used to secure the access token |
| UC_FLOWFORMS | | | The package implements a region-type plug-in for Oracle APEX |
| UC_FLOWFORMS_UTIL | | | The package is used as a help package to the main code in the UC_FLOWFORMS package |
| UC_FLOWFORMS_TREE | | | The package is used to create a tree-like structure |
| UC_FLOWFORMS_SCHEMA | | | The package is used to generate the schema, locales, and data JSONs for the Form Builder |
| UC_FLOWFORMS_EXAMPLES | | | The package is used to provide the developers with some examples for the initialization PL/SQL code and the custom PL/SQL package |
Other scripts
| Object Name | Type | Supporting object | The plug-in | Description |
|---|---|---|---|---|
| RESTful Service | Script | | | The script creates the UC - FlowForms RESTful Service Module, which handles fetching images for the form |