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. |
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 |