ACA_CLIPBOARD_ENTRIES
This table stores entries for Persistent Clipboard.
Details
-
Schema: FUSION
-
Object owner: ACA
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
ACA_CLIPBOARD_ENTRIES_PK |
CLIPBOARD_ENTRY_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CLIPBOARD_ENTRY_ID | NUMBER | 18 | Yes | Primary Key to uniquely identify clipboard entry. | |
| CLIPBOARD_ENTRY_SOURCE | VARCHAR2 | 250 | Name of the source page where the object was added from. | ||
| NAME | VARCHAR2 | 4000 | Yes | Name of the object added to clipboard. | |
| OBJECT_TYPE | VARCHAR2 | 80 | Yes | Type of the object added to clipboard. | |
| DESCRIPTION | VARCHAR2 | 4000 | Description of the object added to clipboard. | ||
| ORGANIZATION_CODE | VARCHAR2 | 18 | Code of the organization to which the object belongs. | ||
| IMAGE_URL | VARCHAR2 | 240 | URL where the objects's image is stored. | ||
| OBJECT_CONTEXT1 | VARCHAR2 | 4000 | Yes | 1st column which indicates the context of the object (For Item's object this is the Organization Name). | |
| OBJECT_CONTEXT2 | VARCHAR2 | 4000 | 2nd column which indicates the context of the object. | ||
| OBJECT_CONTEXT3 | VARCHAR2 | 4000 | 3rd column which indicates the context of the object. | ||
| OBJECT_CONTEXT4 | VARCHAR2 | 4000 | 4th column which indicates the context of the object. | ||
| OBJECT_CONTEXT5 | VARCHAR2 | 4000 | 5th column which indicates the context of the object. | ||
| PK1_VALUE | NUMBER | 18 | Yes | 1st column which stores a primary key for the object (for Item object, it is Inventory Item ID). | |
| PK2_VALUE | NUMBER | 18 | 2nd column which stores a primary key for the object (for Item object, it is Organization ID). | ||
| PK3_VALUE | NUMBER | 18 | 3rd column which stores a primary key for the object (for Item object, it is Revision ID). | ||
| PK4_VALUE | NUMBER | 18 | 4th column which stores a primary key for the object. | ||
| PK5_VALUE | NUMBER | 18 | 5th column which stores a primary key for the object. | ||
| PK6_VALUE | VARCHAR2 | 100 | 6th column which stores a primary key for the object. | ||
| PK7_VALUE | VARCHAR2 | 100 | 7th column which stores a primary key for the object. | ||
| 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. | ||
| PINNED | VARCHAR2 | 4 | Indicates wheter clipboard entry is pinned or not, Y/N. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ACA_CLIPBOARD_ENTRIES_U1 | Unique | Default | CLIPBOARD_ENTRY_ID |
| ACA_CLIPBOARD_ENTRIES_U2 | Unique | Default | OBJECT_TYPE, CREATED_BY, PK1_VALUE, PK2_VALUE, PK3_VALUE, PK4_VALUE, PK5_VALUE, PK6_VALUE, PK7_VALUE |