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_SLIDES

Columns

NameTypeNullableDefault valueComment
SLIDE_IDNUMBER(38)N  
PRESENTATION_IDNUMBER(38)N  
ORIGINAL_SLIDE_IDNUMBER(38)Y  
MIN_CHECKPOINTNUMBER(38)N  
MAX_CHECKPOINTNUMBER(38)Y  
SORT_KEYNUMBER(38)N  
TITLEVARCHAR2(400.0)Y  
PREAMBLECLOBY  
BULLET_ITEMSCLOBY  
POSTAMBLECLOBY  
INCLUDE_IN_OUTLINE_PCHAR(1.0)Y't'  
CONTEXT_BREAK_AFTER_PCHAR(1.0)Y'f'  
MODIFICATION_DATEDATEN  
STYLENUMBER(38)Y  

Primary key:

Constraint NameColumns
SYS_C002088148SLIDE_ID

Check Constraints:

Constraint NameCheck Condition
SYS_C002088142"PRESENTATION_ID" IS NOT NULL
SYS_C002088143"MIN_CHECKPOINT" IS NOT NULL
SYS_C002088144"SORT_KEY" IS NOT NULL
SYS_C002088145"MODIFICATION_DATE" IS NOT NULL
SYS_C002088146include_in_outline_p in ('t','f')
SYS_C002088147context_break_after_p in ('t','f')

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
SYS_C002088149PRESENTATION_ID WP_PRESENTATIONS SYS_C002088133 CASCADE
SYS_C002088150ORIGINAL_SLIDE_ID WP_SLIDES SYS_C002088148 NO ACTION
SYS_C002088151STYLE WP_STYLES SYS_C002088117 NO ACTION
SYS_C002088152PRESENTATION_ID , MIN_CHECKPOINT WP_CHECKPOINTS SYS_C002088140 NO ACTION
SYS_C002088153PRESENTATION_ID , MAX_CHECKPOINT WP_CHECKPOINTS SYS_C002088140 NO ACTION

Options:

OptionSettings
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumns
SYS_C002088148NORMALUNIQUESLIDE_ID
SYS_IL0001976917C00008$$LOBUNIQUE 
SYS_IL0001976917C00009$$LOBUNIQUE 
SYS_IL0001976917C00010$$LOBUNIQUE 
WP_SORTED_SLIDESNORMALNONUNIQUEPRESENTATION_ID , MAX_CHECKPOINT , SORT_KEY

Referenced by:

TableConstraint
WP_SLIDES SYS_C002088150
WP_HISTORICAL_SORT SYS_C002088160
WP_ATTACHMENTS SYS_C002088169

Generated by OraSchemaDoc, (c) Aram Kananov, 2002