| Name | Type | Nullable | Default value | Comment |
|---|---|---|---|---|
| VERSION_ID | NUMBER(38) | N | ||
| PACKAGE_ID | NUMBER(38) | N | ||
| PACKAGE_NAME | VARCHAR2(500.0) | N | ||
| VERSION_NAME | VARCHAR2(100.0) | N | ||
| VERSION_URL | VARCHAR2(1500.0) | N | ||
| SUMMARY | VARCHAR2(3000.0) | Y | ||
| DESCRIPTION_FORMAT | VARCHAR2(100.0) | Y | ||
| DESCRIPTION | CLOB | Y | ||
| DISTRIBUTION | VARCHAR2(500.0) | Y | ||
| RELEASE_DATE | DATE | Y | ||
| VENDOR | VARCHAR2(500.0) | Y | ||
| VENDOR_URL | VARCHAR2(1500.0) | Y | ||
| PACKAGE_GROUP | VARCHAR2(100.0) | Y | ||
| ENABLED_P | CHAR(1.0) | N | 'f' | |
| INSTALLED_P | CHAR(1.0) | N | 'f' | |
| TAGGED_P | CHAR(1.0) | N | 'f' | |
| IMPORTED_P | CHAR(1.0) | N | 'f' | |
| DATA_MODEL_LOADED_P | CHAR(1.0) | N | 'f' | |
| CVS_IMPORT_RESULTS | CLOB | Y | ||
| ACTIVATION_DATE | DATE | Y | ||
| DEACTIVATION_DATE | DATE | Y | ||
| DISTRIBUTION_TARBALL | BLOB | Y | ||
| DISTRIBUTION_URL | VARCHAR2(1500.0) | Y | ||
| DISTRIBUTION_DATE | DATE | Y |
| Constraint Name | Columns |
|---|---|
| APM_PACKAGE_VERS_ID_PK | VERSION_ID |
| Constraint Name | Check Condition |
|---|---|
| APM_PACKAGE_VERS_DML_P_CK | data_model_loaded_p in ('t','f') |
| APM_PACKAGE_VERS_DML_P_NN | "DATA_MODEL_LOADED_P" IS NOT NULL |
| APM_PACKAGE_VERS_ENABLED_P_CK | enabled_p in ('t','f') |
| APM_PACKAGE_VERS_ENABLED_P_NN | "ENABLED_P" IS NOT NULL |
| APM_PACKAGE_VERS_IMP_P_CK | imported_p in ('t','f') |
| APM_PACKAGE_VERS_IMP_P_NN | "IMPORTED_P" IS NOT NULL |
| APM_PACKAGE_VERS_INST_P_CK | installed_p in ('t','f') |
| APM_PACKAGE_VERS_INST_P_NN | "INSTALLED_P" IS NOT NULL |
| APM_PACKAGE_VERS_PACKAGE_ID_NN | "PACKAGE_ID" IS NOT NULL |
| APM_PACKAGE_VERS_PKG_NAME_NN | "PACKAGE_NAME" IS NOT NULL |
| APM_PACKAGE_VERS_TAGGED_P_CK | tagged_p in ('t','f') |
| APM_PACKAGE_VERS_TAGGED_P_NN | "TAGGED_P" IS NOT NULL |
| APM_PACKAGE_VERS_VER_NAME_NN | "VERSION_NAME" IS NOT NULL |
| APM_PACKAGE_VERS_VER_URL_NN | "VERSION_URL" IS NOT NULL |
| Constraint Name | Columns | Referenced table | Referenced Constraint | On Delete Rule |
|---|---|---|---|---|
| APM_PACKAGE_VERS_PACKAGE_ID_FK | PACKAGE_ID | APM_PACKAGES | APM_PACKAGES_PACKAGE_ID_PK | NO ACTION |
| Constraint name | Columns |
|---|---|
| APM_PACKAGE_VERS_ID_NAME_UN | PACKAGE_ID , VERSION_NAME |
| APM_PACKAGE_VERS_VER_URL_UN | VERSION_URL |
| Option | Settings |
|---|---|
| Index Organized | No |
| Generated by Oracle | No |
| Clustered | No |
| Nested | No |
| Temporary | No |
| Index Name | Type | Unuqueness | Columns |
|---|---|---|---|
| APM_PACKAGE_VERS_ID_NAME_UN | NORMAL | UNIQUE | PACKAGE_ID , VERSION_NAME |
| APM_PACKAGE_VERS_ID_PK | NORMAL | UNIQUE | VERSION_ID |
| APM_PACKAGE_VERS_VER_URL_UN | NORMAL | UNIQUE | VERSION_URL |
| SYS_IL0001976221C00008$$ | LOB | UNIQUE | |
| SYS_IL0001976221C00019$$ | LOB | UNIQUE | |
| SYS_IL0001976221C00022$$ | LOB | UNIQUE |
| Table | Constraint |
|---|---|
| AD_PARAMETER_ELEMENTS | AD_PARAM_ELTS_VERSION_ID_FK |
| APM_PACKAGE_DEPENDENCIES | APM_PACKAGE_DEPS_VERSION_ID_FK |
| APM_PACKAGE_FILES | APM_PACKAGE_FILES_VER_ID_FK |
| APM_PACKAGE_INCLUDES | APM_PACKAGE_INCLS_VER_ID_FK |
| APM_PACKAGE_OWNERS | APM_PACKAGE_OWNERS_VER_ID_FK |