Main Tables Views Indexes Constraints Triggers Procedures Functions Packages Sanity check Index

ACS3 Data Model

Description Columns Primary key Check Constraints Foreign keys Unique Keys Options Indexes Referenced by Triggers

APM_PACKAGE_VERSIONS

Columns

NameTypeNullableDefault valueComment
VERSION_IDNUMBER(38)N  
PACKAGE_IDNUMBER(38)N  
PACKAGE_NAMEVARCHAR2(500.0)N  
VERSION_NAMEVARCHAR2(100.0)N  
VERSION_URLVARCHAR2(1500.0)N  
SUMMARYVARCHAR2(3000.0)Y  
DESCRIPTION_FORMATVARCHAR2(100.0)Y  
DESCRIPTIONCLOBY  
DISTRIBUTIONVARCHAR2(500.0)Y  
RELEASE_DATEDATEY  
VENDORVARCHAR2(500.0)Y  
VENDOR_URLVARCHAR2(1500.0)Y  
PACKAGE_GROUPVARCHAR2(100.0)Y  
ENABLED_PCHAR(1.0)N'f'  
INSTALLED_PCHAR(1.0)N'f'  
TAGGED_PCHAR(1.0)N'f'  
IMPORTED_PCHAR(1.0)N'f'  
DATA_MODEL_LOADED_PCHAR(1.0)N'f'  
CVS_IMPORT_RESULTSCLOBY  
ACTIVATION_DATEDATEY  
DEACTIVATION_DATEDATEY  
DISTRIBUTION_TARBALLBLOBY  
DISTRIBUTION_URLVARCHAR2(1500.0)Y  
DISTRIBUTION_DATEDATEY  

Primary key:

Constraint NameColumns
APM_PACKAGE_VERS_ID_PKVERSION_ID

Check Constraints:

Constraint NameCheck Condition
APM_PACKAGE_VERS_DML_P_CKdata_model_loaded_p in ('t','f')
APM_PACKAGE_VERS_DML_P_NN"DATA_MODEL_LOADED_P" IS NOT NULL
APM_PACKAGE_VERS_ENABLED_P_CKenabled_p in ('t','f')
APM_PACKAGE_VERS_ENABLED_P_NN"ENABLED_P" IS NOT NULL
APM_PACKAGE_VERS_IMP_P_CKimported_p in ('t','f')
APM_PACKAGE_VERS_IMP_P_NN"IMPORTED_P" IS NOT NULL
APM_PACKAGE_VERS_INST_P_CKinstalled_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_CKtagged_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

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
APM_PACKAGE_VERS_PACKAGE_ID_FKPACKAGE_ID APM_PACKAGES APM_PACKAGES_PACKAGE_ID_PK NO ACTION

Unique Keys:

Constraint nameColumns
APM_PACKAGE_VERS_ID_NAME_UNPACKAGE_ID , VERSION_NAME
APM_PACKAGE_VERS_VER_URL_UNVERSION_URL

Options:

OptionSettings
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumns
APM_PACKAGE_VERS_ID_NAME_UNNORMALUNIQUEPACKAGE_ID , VERSION_NAME
APM_PACKAGE_VERS_ID_PKNORMALUNIQUEVERSION_ID
APM_PACKAGE_VERS_VER_URL_UNNORMALUNIQUEVERSION_URL
SYS_IL0001976221C00008$$LOBUNIQUE 
SYS_IL0001976221C00019$$LOBUNIQUE 
SYS_IL0001976221C00022$$LOBUNIQUE 

Referenced by:

TableConstraint
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


Generated by OraSchemaDoc, (c) Aram Kananov, 2002