ADF_SB_SANDBOXES_B
Sanboxes: Sandbox Registration (_B) Table
Details
-
Schema: FUSION
-
Object owner: ADF
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
ADF_SB_SANBOXES_B_PK |
SANDBOX_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SANDBOX_ID | VARCHAR2 | 32 | Yes | SANDBOX_ID | |
| CONFLICT_FLAG | VARCHAR2 | 1 | Yes | CONFLICT_FLAG | |
| SANDBOX_STATUS | VARCHAR2 | 30 | Yes | SANDBOX_STATUS | |
| PUBLISHED_ON | TIMESTAMP | PUBLISHED_ON | |||
| PUBLISHED_BY | VARCHAR2 | 64 | PUBLISHED_BY | ||
| LAST_REFRESH_DATE | TIMESTAMP | LAST_REFRESH_DATE | |||
| LAST_REFRESH_BY | VARCHAR2 | 64 | LAST_REFRESH_BY | ||
| ERROR_MESSAGE | VARCHAR2 | 4000 | ERROR_MESSAGE | ||
| BRANCH_FLAG | VARCHAR2 | 1 | BRANCH_FLAG | ||
| PROGRESS | VARCHAR2 | 4000 | PROGRESS | ||
| FEATURES | VARCHAR2 | 4000 | FEATURES | ||
| ARCHIVE_FLAG | VARCHAR2 | 1 | ARCHIVE_FLAG | ||
| CONFIGURATION | VARCHAR2 | 4000 | CONFIGURATION | ||
| CONSTRAINTS | VARCHAR2 | 4000 | Stores Customization layers associated with the sandbox. | ||
| PROPERTIES | VARCHAR2 | 4000 | PROPERTIES | ||
| OP_LOG_ID | NUMBER | 18 | Log Id. Key to ADF_SB_LOGS. | ||
| REFRESH_FLAG | VARCHAR2 | 1 | Flag indicates if the sandbox needs to be refreshed to pick up latest changes on Mainline. | ||
| 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_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 |
|---|---|---|---|
| ADF_SB_SANBOXES_B_U1 | Unique | Default | SANDBOX_ID |