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_FILE_TYPES

Columns

NameTypeNullableDefault valueComment
FILE_TYPE_KEYVARCHAR2(50.0)N  
PRETTY_NAMEVARCHAR2(200.0)N  

Primary key:

Constraint NameColumns
APM_PACKAGE_FILE_TYPES_PKFILE_TYPE_KEY

Check Constraints:

Constraint NameCheck Condition
APM_PACKAGE_FILE_TYPES_NAME_NN"PRETTY_NAME" IS NOT NULL

Options:

OptionSettings
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumns
APM_PACKAGE_FILE_TYPES_PKNORMALUNIQUEFILE_TYPE_KEY

Referenced by:

TableConstraint
APM_PACKAGE_FILES APM_PACKAGE_FILES_TYPE_FK


Generated by OraSchemaDoc, (c) Aram Kananov, 2002