PATCH_ARTIFACT
Details
-
Schema: FUSION
-
Object owner: APM
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PATCH_ARTIFACT_PK |
ID |
Columns
| Name | Datatype | Length | Not-null |
|---|---|---|---|
| ID | NUMBER | Yes | |
| APP_ID | VARCHAR2 | 512 | Yes |
| TYPE | VARCHAR2 | 256 | Yes |
| CHG_TYPE | VARCHAR2 | 256 | Yes |
| GUID | VARCHAR2 | 4000 | Yes |
| NAME | VARCHAR2 | 512 | |
| REASON | VARCHAR2 | 1024 | |
| DEFAULT_RESOLUTION | VARCHAR2 | 32 | |
| CHOOSEN_RESOLUTION | VARCHAR2 | 32 | |
| PATCH_RUN_ID | NUMBER | ||
| DEP_FLAG | CHAR | 1 | |
| CREATED_BY | VARCHAR2 | 4000 | |
| CREATED_ON | DATE | ||
| UPDATED_BY | VARCHAR2 | 4000 | |
| UPDATED_ON | DATE |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PATCH_ARTIFACT | patch_run | PATCH_RUN_ID |
| patch_artifact_dependency | patch_artifact | ARTIFACT_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| APP_ID_TYPE | Non Unique | FUSION_TS_TX_DATA | APP_ID, TYPE |
| APP_ID_TYPE_CHG_TYPE | Non Unique | FUSION_TS_TX_DATA | APP_ID, TYPE, CHG_TYPE |