Name | Type | Nullable | Default value | Comment |
---|---|---|---|---|
DEPENDENCY_ID | NUMBER(38) | N | ||
VERSION_ID | NUMBER(38) | N | ||
DEPENDENCY_TYPE | VARCHAR2(20.0) | N | ||
SERVICE_URL | VARCHAR2(1500.0) | N | ||
SERVICE_VERSION | VARCHAR2(100.0) | N |
Constraint Name | Columns |
---|---|
APM_PACKAGE_DEPS_ID_PK | DEPENDENCY_ID |
Constraint Name | Check Condition |
---|---|
APM_PACKAGE_DEPS_TYPE_CK | dependency_type in ('provides','requires') |
APM_PACKAGE_DEPS_TYPE_NN | "DEPENDENCY_TYPE" IS NOT NULL |
APM_PACKAGE_DEPS_URL_NN | "SERVICE_URL" IS NOT NULL |
APM_PACKAGE_DEPS_VERSION_ID_NN | "VERSION_ID" IS NOT NULL |
APM_PACKAGE_DEPS_VER_NAME_NN | "SERVICE_VERSION" IS NOT NULL |
Constraint Name | Columns | Referenced table | Referenced Constraint | On Delete Rule |
---|---|---|---|---|
APM_PACKAGE_DEPS_VERSION_ID_FK | VERSION_ID | APM_PACKAGE_VERSIONS | APM_PACKAGE_VERS_ID_PK | CASCADE |
Constraint name | Columns |
---|---|
APM_PACKAGE_DEPS_UN | VERSION_ID , SERVICE_URL |
Option | Settings |
---|---|
Index Organized | No |
Generated by Oracle | No |
Clustered | No |
Nested | No |
Temporary | No |
Index Name | Type | Unuqueness | Columns |
---|---|---|---|
APM_PACKAGE_DEPS_ID_PK | NORMAL | UNIQUE | DEPENDENCY_ID |
APM_PACKAGE_DEPS_UN | NORMAL | UNIQUE | VERSION_ID , SERVICE_URL |