FFS_PLUGIN_HOSTED_VERSION
Contains versioned data related to configured hosted plugins.
Details
-
Schema: FUSION
-
Object owner: FFS
-
Object type: TABLE
-
Tablespace: DATA
Primary Key
| Name | Columns |
|---|---|
|
FFS_PLUGIN_HOSTED_VERSION_PK |
PLUGIN_HOSTED_VER_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PLUGIN_HOSTED_VER_ID | NUMBER | 5 | Yes | Unique Identifier of Hosted Plugin (Plugin Archive) Archive Version, automatically populated by the system. | |
| PLUGIN_HOSTED_ID | NUMBER | 5 | Yes | Relation to FFS_PLUGIN_HOSTED.PLUGIN_HOSTED_ID value. | |
| ACTION_ID | NUMBER | 19 | Yes | Relation to FFS_CONFIG_LOG.ACTION_ID value. | |
| CONTENT_HASH | VARCHAR2 | 256 | SHA256 hash of archive content. | ||
| CONTENT | CLOB | Content of plugin archive file (zip). | |||
| CREATION_TIME | TIMESTAMP | Yes | Hosted plugin creation date and time. | ||
| USER_ID | NUMBER | 18 | Yes | Relation to FFS_USER.USER_ID value. User ID that uploaded the version of the Plugin. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FFS_PLUGIN_HOSTED_VERSION_PK | Unique | DATA | PLUGIN_HOSTED_VER_ID |