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

IM_EMP_CHECKPOINT_CHECKOFFS

Columns

NameTypeNullableDefault valueComment
CHECKPOINT_IDNUMBER(38)N  
CHECKEENUMBER(38)N  
CHECKERNUMBER(38)N  
CHECK_DATEDATEY  
CHECK_NOTEVARCHAR2(1000.0)Y  

Primary key:

Constraint NameColumns
SYS_C002088508CHECKEE , CHECKPOINT_ID

Check Constraints:

Constraint NameCheck Condition
SYS_C002088506"CHECKEE" IS NOT NULL
SYS_C002088507"CHECKER" IS NOT NULL

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
SYS_C002088509CHECKPOINT_ID IM_EMPLOYEE_CHECKPOINTS SYS_C002088505 NO ACTION
SYS_C002088510CHECKEE USERS SYS_C002087135 NO ACTION
SYS_C002088511CHECKER USERS SYS_C002087135 NO ACTION

Options:

OptionSettings
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumns
SYS_C002088508NORMALUNIQUECHECKEE , CHECKPOINT_ID

Generated by OraSchemaDoc, (c) Aram Kananov, 2002