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 |