ADF_SB_LOG_RECORDS
Details
-
Schema: FUSION
-
Object owner: ADF
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
ADF_SB_LOG_RECORDS_PK |
LOG_ID, LOG_RECORD_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| LOG_ID | NUMBER | 18 | Yes | LOG_ID | |
| LOG_RECORD_ID | NUMBER | 18 | Yes | LOG_RECORD_ID | |
| PARENT_LOG_RECORD_ID | NUMBER | 18 | The key to the parent record. | ||
| LOG_RECORD_TYPE | VARCHAR2 | 240 | LOG_RECORD_TYPE | ||
| SUMMARY | VARCHAR2 | 4000 | SUMMARY | ||
| OBJECT_NAME | VARCHAR2 | 128 | Yes | OBJECT_NAME | |
| OBJECT_TYPE | VARCHAR2 | 64 | OBJECT_TYPE | ||
| OBJECT_ID | VARCHAR2 | 512 | OBJECT_ID | ||
| ELEMENT_NAME | VARCHAR2 | 128 | ELEMENT_NAME | ||
| ELEMENT_TYPE | VARCHAR2 | 64 | ELEMENT_TYPE | ||
| ELEMENT_ID | VARCHAR2 | 512 | ELEMENT_ID | ||
| ARTIFACT_PATH | VARCHAR2 | 1024 | ARTIFACT_PATH | ||
| CHANGE_DATE | TIMESTAMP | CHANGE_DATE | |||
| CHANGED_BY | VARCHAR2 | 64 | CHANGED_BY | ||
| CHANGE_TYPE | VARCHAR2 | 1 | CHANGE_TYPE | ||
| CONFLICT_FLAG | VARCHAR2 | 1 | CONFLICT_FLAG | ||
| MAINLINE_VALUE | VARCHAR2 | 2000 | MAINLINE_VALUE | ||
| SANDBOX_VALUE | VARCHAR2 | 2000 | SANDBOX_VALUE | ||
| RESULT | VARCHAR2 | 1 | RESULT | ||
| REPLACEMENT | VARCHAR2 | 2000 | REPLACEMENT | ||
| REPOSITORY_ID | VARCHAR2 | 240 | REPOSITORY_ID | ||
| REPORTED_BY | VARCHAR2 | 240 | REPORTED_BY | ||
| URL | VARCHAR2 | 2000 | URL | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ADF_SB_LOG_RECORDS_U1 | Unique | Default | LOG_ID, LOG_RECORD_ID |