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

ADV_GROUPS

Columns

NameTypeNullableDefault valueComment
GROUP_KEYVARCHAR2(30.0)N  
PRETTY_NAMEVARCHAR2(50.0)Y  
ROTATION_METHODCHAR(35.0)Y'sequential'  

Primary key:

Constraint NameColumns
SYS_C002087699GROUP_KEY

Check Constraints:

Constraint NameCheck Condition
AD_GRP_ROTATION_METHODrotation_method in ('sequential','least-exposure-first', 'unseen-then-sequential', 'unseen-then-least-first', 'random', 'keyword')
SYS_C002087697"GROUP_KEY" IS NOT NULL

Options:

OptionSettings
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumns
SYS_C002087699NORMALUNIQUEGROUP_KEY

Referenced by:

TableConstraint
ADV_GROUP_MAP SYS_C002087703


Generated by OraSchemaDoc, (c) Aram Kananov, 2002