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

WP_HISTORICAL_SORT

Columns

NameTypeNullableDefault valueComment
WP_HISTORICAL_SORT_IDNUMBER(38)N  
SLIDE_IDNUMBER(38)N  
PRESENTATION_IDNUMBER(38)N  
CHECKPOINTNUMBER(38)N  
SORT_KEYNUMBER(38)N  

Primary key:

Constraint NameColumns
SYS_C002088158WP_HISTORICAL_SORT_ID

Check Constraints:

Constraint NameCheck Condition
SYS_C002088154"SLIDE_ID" IS NOT NULL
SYS_C002088155"PRESENTATION_ID" IS NOT NULL
SYS_C002088156"CHECKPOINT" IS NOT NULL
SYS_C002088157"SORT_KEY" IS NOT NULL

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
SYS_C002088160SLIDE_ID WP_SLIDES SYS_C002088148 CASCADE
SYS_C002088161PRESENTATION_ID , CHECKPOINT WP_CHECKPOINTS SYS_C002088140 CASCADE

Unique Keys:

Constraint nameColumns
SYS_C002088159SLIDE_ID , CHECKPOINT

Options:

OptionSettings
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumns
SYS_C002088158NORMALUNIQUEWP_HISTORICAL_SORT_ID
SYS_C002088159NORMALUNIQUESLIDE_ID , CHECKPOINT
WP_SORTED_HISTORICAL_SLIDESNORMALNONUNIQUEPRESENTATION_ID , CHECKPOINT , SORT_KEY

Generated by OraSchemaDoc, (c) Aram Kananov, 2002