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

DOWNLOAD_RULES

Columns

NameTypeNullableDefault valueComment
RULE_IDNUMBER(38)N  
VERSION_IDNUMBER(38)Y  
DOWNLOAD_IDNUMBER(38)Y  
VISIBILITYVARCHAR2(30.0)Y  
AVAILABILITYVARCHAR2(30.0)Y  
PRICENUMBER(38)Y  
CURRENCYCHAR(3.0)Y'USD'  

Primary key:

Constraint NameColumns
SYS_C002087669RULE_ID

Check Constraints:

Constraint NameCheck Condition
DOWNLOAD_VERSION_NULL_CHECKdownload_id is not null or version_id is not null
SYS_C002087666visibility in ('all', 'registered_users', 'purchasers', 'group_members', 'previous_purchasers')
SYS_C002087667availability in ('all', 'registered_users', 'purchasers', 'group_members', 'previous_purchasers')

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
SYS_C002087670VERSION_ID DOWNLOAD_VERSIONS SYS_C002087663 CASCADE
SYS_C002087671DOWNLOAD_ID DOWNLOADS SYS_C002087653 CASCADE
SYS_C002087672CURRENCY CURRENCY_CODES SYS_C002087051 NO ACTION

Options:

OptionSettings
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumns
SYS_C002087669NORMALUNIQUERULE_ID

Generated by OraSchemaDoc, (c) Aram Kananov, 2002