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_PACKAGES

Columns

NameTypeNullableDefault valueComment
PACKAGE_IDNUMBER(38)N  
PACKAGE_KEYVARCHAR2(100.0)N  
PACKAGE_URLVARCHAR2(1500.0)N  
SPEC_FILE_PATHVARCHAR2(1500.0)Y  
SPEC_FILE_MTIMENUMBER(38)Y  

Primary key:

Constraint NameColumns
APM_PACKAGES_PACKAGE_ID_PKPACKAGE_ID

Check Constraints:

Constraint NameCheck Condition
APM_PACKAGES_PACKAGE_KEY_NN"PACKAGE_KEY" IS NOT NULL
APM_PACKAGES_PACKAGE_URL_NN"PACKAGE_URL" IS NOT NULL

Unique Keys:

Constraint nameColumns
APM_PACKAGES_PACKAGE_KEY_UNPACKAGE_KEY
APM_PACKAGES_PACKAGE_URL_UNPACKAGE_URL

Options:

OptionSettings
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumns
APM_PACKAGES_PACKAGE_ID_PKNORMALUNIQUEPACKAGE_ID
APM_PACKAGES_PACKAGE_KEY_UNNORMALUNIQUEPACKAGE_KEY
APM_PACKAGES_PACKAGE_URL_UNNORMALUNIQUEPACKAGE_URL

Referenced by:

TableConstraint
APM_PACKAGE_VERSIONS APM_PACKAGE_VERS_PACKAGE_ID_FK


Generated by OraSchemaDoc, (c) Aram Kananov, 2002