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_CHECKPOINTS

Columns

NameTypeNullableDefault valueComment
WP_CHECKPOINTS_IDNUMBER(38)N  
PRESENTATION_IDNUMBER(38)N  
CHECKPOINTNUMBER(38)N  
DESCRIPTIONVARCHAR2(200.0)Y  
CHECKPOINT_DATEDATEY  

Primary key:

Constraint NameColumns
SYS_C002088139WP_CHECKPOINTS_ID

Check Constraints:

Constraint NameCheck Condition
SYS_C002088137"PRESENTATION_ID" IS NOT NULL
SYS_C002088138"CHECKPOINT" IS NOT NULL

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
SYS_C002088141PRESENTATION_ID WP_PRESENTATIONS SYS_C002088133 CASCADE

Unique Keys:

Constraint nameColumns
SYS_C002088140PRESENTATION_ID , CHECKPOINT

Options:

OptionSettings
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumns
SYS_C002088139NORMALUNIQUEWP_CHECKPOINTS_ID
SYS_C002088140NORMALUNIQUEPRESENTATION_ID , CHECKPOINT

Referenced by:

TableConstraint
WP_SLIDES SYS_C002088152
WP_SLIDES SYS_C002088153
WP_HISTORICAL_SORT SYS_C002088161

Generated by OraSchemaDoc, (c) Aram Kananov, 2002