ADF_SB_SANDBOXES
Details
-
Schema: FUSION
-
Object owner: ADF
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
ADF_SB_SANDBOXES_PK |
SANDBOX_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SANDBOX_ID | VARCHAR2 | 60 | Yes | SANDBOX_ID | |
| SANDBOX_STATE | VARCHAR2 | 30 | Yes | SANDBOX_STATE | |
| NAME | VARCHAR2 | 80 | NAME | ||
| DESCRIPTION | VARCHAR2 | 1024 | DESCRIPTION | ||
| PRIVATE_FLAG | VARCHAR2 | 1 | PRIVATE_FLAG | ||
| PUBLISH_FLAG | VARCHAR2 | 1 | PUBLISH_FLAG | ||
| ARCHIVE_FLAG | VARCHAR2 | 1 | ARCHIVE_FLAG | ||
| OP_CONFLICT_FLAG | VARCHAR2 | 1 | OP_CONFLICT_FLAG | ||
| OP_LOCK | VARCHAR2 | 64 | OP_LOCK | ||
| OP_LOCK_DATE | TIMESTAMP | OP_LOCK_DATE | |||
| OP_LOCKED_BY | VARCHAR2 | 64 | OP_LOCKED_BY | ||
| OP_LOG_ID | NUMBER | 18 | OP_LOG_ID | ||
| OP_PROGRESS | VARCHAR2 | 4000 | OP_PROGRESS | ||
| REFRESH_DATE | TIMESTAMP | REFRESH_DATE | |||
| REFRESHED_BY | VARCHAR2 | 64 | REFRESHED_BY | ||
| REFRESH_FLAG | VARCHAR2 | 1 | REFRESH_FLAG | ||
| PUBLISH_DATE | TIMESTAMP | PUBLISH_DATE | |||
| PUBLISHED_BY | VARCHAR2 | 64 | PUBLISHED_BY | ||
| SUSPENDED_FLAG | VARCHAR2 | 1 | A flag indicating whether a sandbox is suspended. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| ARCHIVE_PROPERTIES | VARCHAR2 | 4000 | ARCHIVE_PROPERTIES | ||
| CONSTRAINTS | VARCHAR2 | 4000 | CONSTRAINTS | ||
| PROPERTIES | VARCHAR2 | 4000 | Stores additional properties of Sandbox. | ||
| ARCHIVE_PROPERTIES_CLOB | CLOB | ARCHIVE_PROPERTIES_CLOB | |||
| CONSTRAINTS_CLOB | CLOB | CONSTRAINTS_CLOB | |||
| PROPERTIES_CLOB | CLOB | PROPERTIES_CLOB |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ADF_SB_SANDBOXES_U1 | Non Unique | Default | NAME |
| ADF_SB_SANDBOXES_U2 | Unique | Default | SANDBOX_ID |